I have a form with two subforms on it which are both continous forms.
The subform on the left shows the tasks that the employee was assigned
to accomplish (each as a seperate record) while the one on the right is
where they put what tasks they actually did. It is important that I

I am trying to move some of our large VBA Access front-end file into
ActiveX DLL files. I created two DLL files so far, one was a module
that contains code to integrate into the QuickBooks accounting
software. Another has general utilities.

       I'm having trouble reading from a table directly into an
array using Access 2000.
   Dim db As Database
   Dim rsTime As Recordset

I am creating a form that needs to read information from another table.
The user selects a single value from a drop-down box that is linked to
the first column of data in the table I want to read from.  I then have
two other objects that need to take the data from the corresponding

I am working with a Microsoft Data Page where the records are filtered
by two dates the user selects prior to any records being loaded.  After
selecting dates they click on a button (BtnGo) to fire the filter
event.  Currently if no records are found that match criteria, the page

In a query I have put the following criteria in a field:
[enter last name]
Now I would like the query to use this user input to search with wildcards.
So, if he enters john, in fact the query should search like:

I have a table that I need to import into access.  The table is monthly
data where the month is the column header.  I need to transform that
data so that location code, month and number are the only columns.
EX:

My programming grammar might be a little off but I have a pretty good
idea of what I need to convey.
I am making an Access database with a form that pops up and lets you
choose to select an existing exercise or a new one.  I want to focus on

I'm setting up a resolutions database where each resolution will be
copied from Word documents and pasted into a memo field. The resolution
will be in the form:
Resolution title <cr>

Hi heros,
I have a text field that stores numbers like 06-1234.  I created a combo box
to look up values on a form based on the number.  However, I can't get it
formatted correctly.  It is formatted @@-@@@@.  

I am trying to setup a default value for a field in a form. The field
is a text box. I need to setup the default value to: 0.000. And
whenever the user is trying to enter a value for this field, using the
form, he ONLY can enter a value with that structure (0.000). eg. 1.234,

I am working as an intern at a place using Access 2003 code builder.
Looking at the cold of the old project t(hat we are redoing), I see
Chr(39)
Chr(91)

My database has 2 tables: Table1 & Table2. If a field is not null on a
record in table2, then the not null fields in table1 that correspond to
the records in table1 needs to be updated to match the field in table2.
What I have is a form that is linked to Table2. If the users want to

All
I have a listbox in a form footer. When the form footer is visible the
listbox requeries fine but when I turn the form footer visible=false
the listbox does not requery at all. What I am trying to achieve is to

For the last couple of days I have been trying to learn how to solve this
problem.
I'm using Access 2000
I am posting it again and maybe I will be mofe successful.