My app contains data on projects.  I've recently added functionality to allow
for markups on a base cost.  The code currently applies any markup to the
base cost only.  However, in reality, some markups are on top of the base
cost + other markups.  I have about 10 markups that can ...

I have a main form with a text box on it "txtSearch"  onlost focus it
updates another text box "txtSearchString" to include a quote and
asterik before and after the value of txtSeach.
I then have a query set to use forms!frmMain!txtSearchString as the

Please help!
I am trying to sort a query by a field calculated as e.g.
[hoursabsent]/[hoursworked]
I keep getting an error about subqueries not allowed for this type of

Firstly my apologies. I am not really an access user so if this
question seems fundamental I am sorry.
I am trying to replicate this query using another programming language.
Want I am in need to assistance with is merely clarification that it is

I have a report that has a query as its record source.
The query picks up records from a table that meet certain criterion.
The report then counts how many records there are for each key (room
number) - but does some calculating by date to see whether to increment

I am a bit stumped with this. I have checked the archive but I can't
seem to find a problem like this.  I have a form for entering a new
record.  I am trying to envisage the user deciding to delete the record
part way through when some linked fields are not populated yet.  When I

I have a subform in continuous form style that I use to populate 3
fields (textboxes) on my main form with a double-click of the key-field
textbox of the sub:
Private Sub TextBattID_DblClick(Cancel As Integer)

hi friends i need help in this sql query
i have table like,
id                      fid
__                      _____

Dear reader,
One table in database A...mdb is linked to a table in database B..mdb.
As A..mdb is open and in B...mdb starts an excel import procedure the
progress bar shows that the import procedure stops. After the A...mdb is

I have a multi user database that I would like to be able to track user
actions.  Ex Whenever a user creates a new employee record, I would
like to "stamp" their id on the record as the one that created it.
Also, whenever they run a report, I would like their id automatically

I have a button PutDate on a form "Company" that put the current date
in the Notes field:
Private Sub PutDate_Click()
Me!ModDate = Date

I have a table with about 80 fields.  I'm using an import process to populate
the table.  It works fine, except for the following:
Users generally don't specify values for a lot of numerical fields on the
spreadsheet.  I set the Access table up so that all the numerical values

What's a good approach to documenting changes made
in a multi-user database. Take the generic example of a
table tblSalesProspects used by a dozen sales persons in
a company's Sales Department. Perhaps its been discussed

in a module in a function the following STRING is created:
CommandBars('OK Revisie').Controls(8).Enabled=False
Does anyone know how to execute this string as if it were a command?
TIA!!!

Hello guru's!
I have the following code that generates an error. The error occures at
the line
CommandBars("OK Revisie").Controls(vLaag1).Controls(vLaag2).vAction =