I have a procedure tracker database I am working on. We have a list of
procedures that are completed and some that need to be completed. I have a
cbo named Completed with Yes/No option and a field named ProcNumber (for
procedure number) and this field is a hyperlink so the user ...

I have a text field that has a field size of 11.  The values in this field
vary from 0 to 7 characters.  I need to export this field to a text file and
the entire field MUST be used.  For example, if the field has a value of
123456, then the exported field needs to have a value ...

Can anybody think of a reason that a query's IIF statement would
evaluate incorrectly when comparing a quotient to a  value on a form?
If I hard-code a number like .05 in place of the ref to the form's
field, it works as expected.

I have a number field in my form (amt billed)- whenever I try to enter a
value with cents (e.g. 1252.50) and hit enter it rounds my number down to
1251.00) and it rounds up also (e.g. 1252.75 changes to 1253.00)
How can I fix this ?

I have an external application that is going to connect to an access
database and insert a record into a table. Can my access database detect a
record insertion and call a subroutine?
I appreciate the help.

hello, i have a combobox in form. the data display is text.
the combobox based on table(1).
the combobox be fed another table(2).
the datadisplay in table2(2) is number (the id number of the text).

I am developing a MS-Access stand alone application using MS-Access 2003,
which requires chart to be displayed. I can see chart control (
'MSCHRT20.OCX') available in MS-Access. I have used it sucessfully and
displayed the chart. Now, I want to distribute this application.

I am creating a serial number table.  User will enter prefix, I need to make
a table entry incremented by 1 for a specified number of entries.
Example:
791456-01

I created a database that has 8 different macros to email a report in
snapshot format when a user has completed filling out a form and clicks a
button.  The database is saved in a shared folder on our network that all
users have rights to.  Everything works fine from my computer, ...

Hello experts,
Using Access ’03…
I’m trying to perform a query that’s rather complicated (at least to
me).

Here is the challenge I'm having. I have 3 columns of data (A, B, C for
example) and what I need to do is search column B to see if there is a match
for a cell in column A and then display the corresponding data from column C.
Below is hopefully a clearer example:

I have an access database that has a field (type memo) that keeps very
long strings. When the value of this field is very long, my Visual
Basic 6.0 code does not return the whole value and truncates it. I
just read it using standard code like this:

I am trying to find books (or even one!) that would give a good
overview of using MS SQL Server for the backend of a database
application, using MS Access as the frontend.  I've found a few
things, but it all appears to be years old.

Where do I post ODBC questions?
I can insert a new row, but cannot modify an existing row, or delete a row.
It's Access 2003 frontend with linked SQL Server 2000 tables. And it's just
1 out of 20 tables that has the problem. The table has a PK index and its

I want to create a calculated field in my database.  The current field is as
follows:
Days Since Test: [Date Completed]-[Date Test Conducted]
But, I want to substitute the [Date Completed] field with the current date