I have Dim InitialHSDate as Date, and do various calcs as I loop thru a table. At each new record I want to set InitialHSDate to null and start the calcs...

i have set AllowEdith property in my form as "No", now i want to change it to "Yes" again, how should i do this

I have a historical table with a JOB#'s field in it. the numbers for this field were entered somewhat randomly and go up to about the number 7700. I would like...

I want to use the autonumber as a serial number, but need it to start at 1005. is this possible please? Thanks A

How can I set an autonumber to start at 500, rather than with 1? Thanks! -- Vandy

I am working on a form for data entry where the user enters many records that may have similar information, i am trying to create a tab that would have all...

How do I set a default print preview and Print settings for a individual Query or Report. For instance, I have a specific query. When I click on print...

I have been wondering if there is a reason to favor either the table, a bound control, or VBA (the form's Current event, for instance) for setting the default...

I have 2 functions that find the user name and machine name. I want to set these functions as the default value for the respective fields in the Table design...

Hi! I am trying to create / change the DisplayControl property of a yes/no field in Access 2003 to display a CheckBox (property.value= 106) from vba code. I'm...

I wrote in Dec. 07 regarding a consultant with suspect programming skills (majority of programming done with macros and multiple examples of empty code) . I...

I have a form when ever it is reopened form showing the first record but insted i want the form to set for new record as it opened how to do this please ...

Help, I am not much of a programmer, but I have managed to build a fairly good tool. The original code was written in 2003 but upon the conversion to...

My form frmUniformOrders has a sub form frmUniformTrans. frmUniformOrders is set to tblUniformOders and places the OrderID, and EmpNo in the...

Here's the code to create a table "tblTest" and create two fields (ID and Name). I want to set the first field "ID" as Primairykey and also set it as...

Is thier anyway to set the primary Key of a table with VBA? I have a make table query that runs, however when it creats the table it does not set a primary...

I have a table that is created and updated through the import of Excel files. There is a field that is necessary in the table that are not contained in the...

I have set up 5 different queries to calculate one specific total each. I have also set up 5 accompaning forms. They work great. When I try to produce a...

-- jjgstyle

I have created a db w/ a form to allow the user to input in fields and select through combo boxes & list boxes certain info pertaining to a physical job they...