Conditional Formatting In a Datasheet Form 1 1020 (3/1/2007 6:34:06 PM)
Hi All, I am trying to “Condition Format” a column on my form so it will highlight the individual cell if another cell in the same column has the same value. The form is in Datasheet view and it can not be ...
Utf

Count records 4 123 (2/28/2007 9:01:16 PM)
Hi - I am building a database to manage corporate jets. My form has flight information and a field for "Number of Passengers". There is a subform for each form that has a row for each passenger with passenger...
jefferysf

Help with a module 2 108 (3/1/2007 8:07:34 PM)
Hi, A few months ago I posted this question: > I am trying to make the default value the date of the first monday in > the month in an unbound box. Is there a way to do this? I used the following solution by...
hotplate

Delete rows in table from Module or Form 0 162 (3/1/2007 6:07:50 PM)
Hi fols I've been trying to delete som rows from a table: in a form - wont work in a module - wont work either in a query that's called from a module - and ofcoursre , wont work --- tried this in the module Set...
michelle

Running Queries in Another Access DB 2 126 (3/1/2007 3:14:40 PM)
Hi I have an application (MDB1) which sources data from another Access DB (MDB2) and I was wondering if it is possible to execute a 'Make-Table' query located in MDB2 through VBA code in MDB1? Kind regards R...
ricky

replace zero when null 2 535 (3/1/2007 1:50:29 PM)
I have what should be a simple problem to solve. So far I have only been annoyed not being able to solve it. I have a numeric field on a form. I don't want a popup message if a value is not valid (null or al...
Lisa

Subform not displaying properly 0 144 (3/1/2007 1:58:26 PM)
Good morning everyone, I had a simple order database setup exactly like Northwinds in Access 2003. Everything works fine. I decided that I wanted to add a command button to my main form. This command butto...
funguy_007

Displaying related records in a subform ... 4 281 (2/28/2007 5:30:49 PM)
Hi all Hopefully I can explain this in enough detail to make sense! I am creating a contact database and am just starting to create the main form. On the main form it shows a particular contacts details (eg n...
Mikey

GoToRecord .... 0 319 (3/1/2007 12:50:24 PM)
Hi all I have a main form which displays contact details for a particular person, and then a subform which currently displays the name and position of all other contacts for the same organisation. What I am ...
Mikey

Using a Form to Archive Old Data 1 183 (2/28/2007 9:49:02 PM)
Hello all: I have a table that contains some data, including a EmpDate field. I have a query that will bring up the last 90 days worth of data, based on that date field. What I need is to be able to bring up...
Zeunasc