Can someone please tell me how to code for the following? I have to date fields. Date field 1 is red/bolded when Date field 1 is less than Date(). Date...

I have a search facility using the following in the after update event of a combo box: Dim rstClone As Object Set rstClone = Me.RecordsetClone ...

I'm currently working on the following form (from a Field List): (these are in form header section) TECHNICIAN-START DATE-START TIME-FINISH...

Need to multiply the quantity times the input cost and retail on a form is this possible. So the table can reflect the quantity recieved, total cost of the...

I have a preprinted paper form with 2 customer order blocks on it. I need a query that will provide me with 2 records at a time until all records in the...

Hi all, Does anyone have a good ZipCode db they dont mind sharing? If so please send em a copy at Thanks!

Hi Everyone, I have a form, listing Invoice Header data. One Invoice per line. On each line is a button "Select". When the user presses that button, I want...

Hi, I had to upgrade from OffXP Developer to Off2007 because of SQLExpress2005. Now I have 2 Access Databases which have forms with command buttons on them...

I have an active employee Yes/No field in a table. If my employee has a checkmark in the active field he shows up on a form called Batch Cover Sheet and...

I have a subform and at the botom of the form I have a field called subtotal which is the sum of the extprice. I have just installed the database on a system...

Hi Currently I have a form where staff members can search for clients. It shows Surname, First and Phone. It also has the client ID and Active Status of...

I have built a database who's analogy is similar to MS' Forms II How to use Subforms. My problem is that in the two part form I can add a new Order record,...

Hi, this is probably something really simple. I have a drop-down box that gets its selections from a table, all I want to do is set it up so that it...

Hey guys I have placed a combo box on my form header which gives me a drop down menu from my keywords field on my form. I click on that combo box and...

Hi, I have created a Tabular form, I would like to show just 15 records at a time, I already change scrolls bars to neither, Records selector = NO and...

Okay, I keep running into problems on this database here and there. The problem is that I have a table with Employee Number, Date, Job Type, Training code,...

I am fairly new to vb coding fo Access so forgive me if this seems obvious. How do I create a form to allow the user to enter new data thereby creating a new...

I am building an Access system that was originally developed in Excel. It is primarily a data storage system (hence the conversion to Access) but its...

Access 2003. I copied a form from another database to my current database. I changed the forms Record Source to reflect the current database. I went...

I have this code (see below) in a form that is to write an audit record. I have sample database that this code runs just fine in, but when I import the same...