How to use Access object library in my Windows application
dear friends , how to use docmd.opencurrentdatabse command to open an access application database please advise

Answer Question   |  November 25, 2008  10:09 AM
Database programming, Microsoft Access, OpenCurrentDatabase, VBA, Visual Basic for Applications

Microsoft Access query window
I use an Access program to record student records. The program has built in queries, but when I try to start one the popup window is tiny; all you see is border, no text, no restore or exit buttons. I can’t catch an edge with the mouse to enlarge it. Also, the program opens without [...]

Answer Question   |  October 28, 2008  11:02 PM
Access 2007, Microsoft Access

Cannot open second copy of Access 2003 database
I have created several databases that we use it the office. They are kept on a server. Recently, we started getting a security warning window everytime we open Access. It asks DO YOU WANT TO OPEN THIS FILE? and points out that the publisher is UNKNOWN PUBLISHER. If you click yes, it opens normally. However, [...]

Answer Question   |  October 16, 2008  4:48 PM
Access 2003, Microsoft Access

Deleting out partial data from a field
I need to delete out partial data from a field in Access. I have a field of numbers that begin with ’1NF’ ex.(1NF123424). This needs to be deleted, but leaving the number alone ’123424′. How can I do this with out manualy deleting it out myself?

Answer Question   |  October 17, 2008  12:39 PM
Microsoft Access

Multiple codes in a field
Hi there, I’m a complete Access noob, but I need to figure something out! Is it possible to put more than one code in one field? For example I need to answer 500 letters. Each letter has a code say 01-500. In each letter there are 3 questions that need to be answered, but half [...]

Answer Question   |  October 21, 2008  8:09 AM
Database programming, Microsoft Access

MS Access IIF Statement
I am pulling options from a table of “1″, “2″ or “3″ and cannot get the Iif statement to produce the results that I need. Please find the Iif statement below: =IIf([lepamtpaid]=1, “Your premium bill will reflect this new premium amount.)”,(lepamtpaid = 2, “This lump sum amount will be deducted from your Social Security check. [...]

Answer Question   |  October 10, 2008  2:49 PM
IIF function, Microsoft Access

Accessing an SQL 2005 Synonym with ODBC
Is there a way to link to a synonym in SQL 2005 using ODBC and MS Access?

Answer Question   |  October 7, 2008  5:54 PM
Microsoft Access, ODBC, SQL 2005

Using Dlookup to populate form fields
I have a simple database with one table(Issue log). What I want is a form that allows for creating a new “issue” within the table or updating the status of an existing issue. I want the form (Issue log) that will update an issues’ status to auto-populate based on which issue number you enter. Example: [...]

Answer Question   |  December 2, 2008  3:12 PM
DLookup, Microsoft Access

How to connect Access database to a Visual Studio 2005?
i use the following code to connect and i created DSN but its not getting connected… whats my fault can anyone help me?? Dim X As ADODB.Connection Dim RS As ADODB.Recordset Dim RS1 As ADODB.Recordset i am getting underlined error in adodb.connection, adodb.recordset i think there is some error in the DSN creation. so anyone [...]

Answer Question   |  June 30, 2011  6:38 AM
ADO, ADODB DSN, Database connectivity, DataSource, DSN, Microsoft Access, VB 2005, Visual Basic, Visual Basic 2005

Justified alignment in Microsoft Access
Dear Sir, I have put one memo field in Ms-Accees report. I want it to be printed like this : |……………………………….| |……………………………….| |……………………………….| |………………| Please reply, Thanks, Sandip

Answer Question   |  October 1, 2008  3:15 AM
Access reports, Microsoft Access

Automated data entry for some controls based on data in other controls in Access 2003
Hi: I am creating a bilingual (english/french) database wherein I need to have the french controls automatically filled when I choose an english term from a dropdown list in the correspopnding english control. Example: I have a list of terms in a combo box control (named ‘domain’) containing the term ‘knowledge’. When I select this [...]

Answer Question   |  October 6, 2008  12:53 AM
Access 2003, Bilingual database, ComboBox, DataPropagator, DropDownList, Localization, Microsoft Access

Microsoft Access printing
I had developed an application using MS Access 2003 and have no problem whether viewing or printing it in one page from my PC or Notebook. Also no problem when I opened this application in MS Access 2007 and printing it via MS Access 2007. By the way my printer is HP Laser Jet 1022. [...]

Answer Question   |  September 26, 2008  8:05 AM
Access 2003, Access 2007, HP LaserJet 1022, HP LaserJet P2014, Microsoft Access, Printing

Decimal places rounding to whole number
In my Access 2003 form values with decimal places are rounding to whole number. I’ve set the property to fixed formal with 2 decimal places and the problem continues.

Answer Question   |  October 2, 2008  9:08 PM
Access 2003, Access forms, Microsoft Access

email query recordset
“I have a query (emailnotifytest) based on 2 tables . One table (shipmentdata) filters on new records. the other table (contact) filters which contains the email address filters whether the address is not null. The tables are joined by the companyname. the code below works as far as sending the recordset to each different email [...]

Answer Question   |  September 25, 2008  4:34 PM
Microsoft Access, VBA

Transferring a database from Microsoft Access to SQL Server 2000
How would I transfer a database from Microsoft Access to SQL Server 2000?

Answer Question   |  September 23, 2008  6:09 PM
Access Database, Microsoft Access, SQL Server 2000, SQL Server database

Creating a Form
I’m creating a form and have an dropdown combo field on my form. (dz, each, Bag, case etc.) I want to use the dropdown on each line independantly. What ever is selected on the first line goes on all the lines. How do i get each line to have different selections based on a new [...]

Answer Question   |  September 23, 2008  5:51 PM
Access 2007, Access forms, Microsoft Access

display data item which is start from Perticular leter from database table in c# .net
in c# .net (SELECT * FROM [tablename] where fristname LIKE ‘k*’) this query is not work with MSaccess database

Answer Question   |  September 23, 2008  6:27 AM
Access Database, C#, Microsoft Access

Microsoft Access in a Server
Hi I am using Vb6 as front-end which is installed in the client machines and MS access 2003 in my server as back-end. Can I create local copies in each client system and at a particular time I need to update the server database with the local databases

Answer Question   |  September 20, 2008  7:24 AM
Access 2003, Client-server, Microsoft Access, VB, Visual Basic 6

Importing Data GAL entries into Access 2007
Need to import outlook GAL entries into Access 2007 & have the database updated when I change a field in the GAL entry.

Answer Question   |  September 18, 2008  5:09 PM
Access 2007, GAL, Global Address Lists, Microsoft Access

securing sql server database object
I connect my access project to sql server. Is there as simple way to secure sql server object such as table, view, stored proc from editing or deletion since access let us to edit sql server object directly

Answer Question   |  September 15, 2008  8:23 PM
Microsoft Access, SQL Server database, SQL Server security