I have the following query generated by an application as :
INSERT INTO tblExpense (eno, entrydate, contractedserviceexpense,
travelexpense, personnelexpense) VALUES('1', '04/26/2005', 11, 11, 11)
When I am pasting this code on sql window of a new query in access and run

I have put together a Questionnaire database that can accommodate double
entries, where the user must make 2 entries for each value. The first entry
will go to one table and the second will go to a twin copy of the same table.
Entries do not have necessarily be entered in the ...

Refering to the frontend application, do you use compact on close and does
it function after converting it to an mde?

I have a form (frmshelflife) that uses a query (qrysearchshelflife) for its
datasource.  The query gets the criteria from a dialog box.  When the user
enters a code in the dialog box and clicks the 'OK' button, frmshelflife
opens and displays the code, description, and shelflife of ...

Has anyone ever heard of a corrupted link?
This morning I opened a query and the data was corrupted. I opened the table
and it looked fine.
I deleted the links and relinked them and every thing was fine.

I am having an issue with Access nav buttons, events and a filter.
I have a form that filters a subform using Form_Current() as the user
scrolls through the main form using the Access nav buttons. Inside the same
event I call a subroutine to update an unbound field to display some

I have created a form where one of the buttons prompts the user to enter
information.  I would like this form to behave as follows:
1.  The user types in the required information (This works)
2.  The user can either enter in part of the information or hit enter to get

Is there any way to resolve concurrency issues with bound forms in a
multi-user setting?  I have a bound form that sometimes spawns a write
conflict dialog box that prompts the user to either save the record,
copy it to the clipboard or drop changes; however, when the user clicks ...

I'm using an ADODB.Command object to send a programatically built sql
command to the server from and Access .adp project.
The command that I generate is...
select * from vwLBFlagSearchResults where LineID in (select distinct LineID

I'm trying to build a form that allows the same security as the Security
Wizard, but without going through the wizard.  For example, there would be a
ID Field and a Password field, linked to a table; I know I can do it by
putting in all the IDs in the Validation Rule for the ...

How to get the below date difference code in VB working for Access
Private Sub Command1_Click()
Dim y, w As Integer
y = (Date - CDate(Text1.Text)) \ 365

Hi, I have a report that is based on a very complex query. At the moment
every record is printed and I'm looking for a solution that would filter the
records via a multiselect listbox.
I've seen various methods to achieve this including:-

Is there an easy way to set the "locked" and "enabled" properties of multiple
fields on a form:
Me.HouseID.Locked=True
Me.HouseName.Locked=True

I wrote a piece of code to update the property "RowSource" of a comboBox,
as a consequence of a "NotInList" event. The property "record source" is
"list of value".
Unfortunately, as soon as the form (where the comboBox is placed) is closed,

I am bordering on beginner and intermediate user in Access.  I have to
create a linked survey in Access.  There are  four parts, the Counsellor
login, Client details, Client Assessment and Outcome.  I have decided to
use a tab control form and put each of the above on four different ...