I just moved my command button click action to my shortcut menu to
make screen nice.
All the code action are for command button and command buttons are on
the form which like mess in the code and design mode.

I am getting "Syntax error in the order by clause" on the following sql
statment. the statment is in the code behind a button. the sql works without
a problem if I take out the Order By.
ssql = "SELECT RevCommID, RevCommentDate, ProjCode, Proj_Name,

I have a Master/Dtail Form that works just fine that is NOT based on a query.
On the other hand I tried to create the exact M/D form using a query but it
does not work (sort of). In the non-query version the record pointer for the
master table (one record) moves from record to ...

I am working on a database for a client.  They only have the .mde
version of a database created by a former employee.  I am recreating
it as a .mdb so they can create new reports, forms, etc.
I am having a problem with one of the forms.  The first screen has a

I'm tired, it's the last thing I have to do, and I can't think!
I want to check a table when a combo box value is selected, and if the
record already exists in that table, I want a message box to pop up
and delay further action (which I can code quite happily!)

I am trying to have a list box on the left hand side that has a list of
names and when one of these names are selected and with the use of <, <<, >,

I know that I have seen this somewhere but I cannot find it!!

I have an Access 2003 database on a network.  There is a form with a text box
'TotalCost' derived from the sum of three totals on subforms on the main
form.  The visibility of the total cost text box is set to Yes\Always.
When I open the database on network computer PW1, Total ...

Dear Sir,
I want to duplicate a invoice entry
In my invoice entry form there is one sub form for items (item log)
Main table bill & bill log are linked with Bill ID which is promery key in

I'm giving the users of my Access 2000 database the ability to delete records
via a command button having the following code behind it:
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

I have two forms open and must save the active record on form-A by hitting a
button on form-B.
Do you have some idea how this can be done?
Thank you all.

I am trying to debug my code and I placed a break point at one line but my
code did not break. I tried to place the break point at the start of the
code, nothing happened. I placed a msg box saying " I Was Here" and then
place breaking point on the msg box line. The msg ran ...

I have a [Form1] and a [Sub Form2]. This sub form contains the lines of the
[Form1].
I want to put automatically in each line of the sub form a sequential ID [1,
2, 3, …]. And this ID restarts of the zero for each new record in [Form1].

This should be fairly simple, but as always I make it hard to do.  I have two
control source fields that are bound to a helpdesk table.  The field names
are AssetNo and DeviceType.  I need the DeviceType field to autopopulate
based on the AssetNo that matches it.  I created a qry ...

Is there a way of placing a timer on a form that, when the start button is
clicked it will start counting down from a specified time?
Example:
Say I click the button and it starts to count down, I want the timer

Hello, on my [BookingDetails] subform I have the following comboboxes:
[Country]   which filters
[Schools]  which in turn filters
[Course]   and [Accom].