I have a form which represents an incoming truck.  On this form I have a
subform which represents the items on that truck, which can give me several
subforms for each form.  On that subform I have a tab control with four tabs
(Bulk Corn, Bulk Oil, Bulk Flour and Bulk Masa).  My ...

Hopefully someone can help me please.
Ok heres the problem I have a start date and time and need to add hours to
this to display a projected finish time.
I have done this with (start date + hours) and this works, but if i need to

Please could someone let me know the correct syntax for adding a text string
requirement for the sql statement below.  Or am I going about this the wrong
way?  This is a button on a form so that the user can click it to show all
the records with the stated.

Why is it that when I create a text box and a toggle button of the same
height and place in them the same size font, on the button the text is at the
bottom whereas in the text box it's in the middle. Is there any way to center
the caption on the toggle button? Thanks.

Helle there ,
Let me first explain the form's layout.
On a form i have a tabcontrol with several pages.
I have a form FrmDestinations that i placed on Page2 as a

Hi I type those instructions for a command button, I created the recordset
the recordcount tell me that there are 26 records, that is right but I dont
know how to get access to the information, 2 of the fields are AssetTag (key)
and manufacturerID, my question is how can I see ...

I have a listview control on one of my access (2003) forms.
Currently I am populating the control with all the file and sub-folder names
in my templates directory - using a recursive bit of code that utilises the
fso.

Form isn't closing when I hit the X button on the form.  It’s prompting to
save, I select yes- then it doesn't close the form nor save. The last thing I
done to maybe cause this problem is use the access analyzer, but I don't
believe it made any changes.  I'm running on Access 2000 ...

I was able to set the format on the form.   I am creating inbound box
like:   ="Total Average Headcount: " & [Count]
I'm getting the result.   "Total Average Headcount:  3222.87777".
Is there a way to change like this  "Total Average Headcount:  3223"

I get errors when I try to create tabpages on a tabcontrol on the fly.   The
error says that I can only do this in design mode - and the access help
appears to confirm this.
Does anyone know of a workaround?

I have created a form depending on a query.
The form lets me read the data contained in the query, but not update data.
I don´t know how to do it, but it is possible.
How can I do it? Must I change any property?  From where? The properties of

I would like to be able to control the Complition Date on the form according
to the Status field, that meens that: when the Status is "Completed",
Completed Date Field will uptade the corrent date Or else leave blank.
I have tried to put the calculation on the control source on ...

I tried searching, but didn't find anything to help, so here goes...
Access 2003.
I have a form for data entry.  I also have a button on this form to pop up
another form to add in new values.  When I click the button, I am unable to

i created table and queries, but i have trouble with create forms and reports.
when i create forms and tried to save, but it was not saved at all. i typed
file name then i tried to exit. dialog box keep asking me "save as".  What is
problem with this?

Is it possible to do a lot of restrictions in MS Access tables? If it
is, where can i do these restrictions?