Hello, I have a form frmVWI and a subform named frmVWISubfor. I have a button on my form that deletes the record but not my subforms record. there is a field...

1. I have a form with the field ClientName and want to open frmClientDetails by doublclicking it. What code do I have to put in the DblClick Event of...

Hello, I have written the following code to cancel a load event under certain circumstances. The code will fire the MsgBox but I can't figure out how...

I have a report group by month, where on the query I have a expxression:Expr1: Format(,"mmmm/yyyy"). My question is: can I have a list box with month...

Please can you help me as I am trying to run a query by clicking in a combi box drop down. For example in the combi box I have a List Available, In stock,...

Hi All, Can't quite seem to get my arms around this one! I have two forms in my database. The first is to track the inspection of PCB boards as they...

I need to make one field required on my form only if the user checks the box as complete. I would like to have something pop up and ask for the RO# that they...

Hi, Need a little help with VBA. I have written the below and what i want it to do, is from the main form if i pick a cylinder (Drop down box) then it goes...

Using access 2003 Have a status form when staff enters their progress into a memo field I need the user to be able to enter the date and time of his entry...

I have a report (Certificate) which I would like the date to convert from say 2.2.10 to 2nd February 2010. The Field on the Report is Could someone kindly...

Okay, I was trying to design a single table but ran into that pesky 255 column limit, so now I have multiple tables with multiple forms used for entering the...

I use Access 2003 and when on a new computer with Vista I tried to run it, everything works except reports. They are not generated nor printed. My printer is...

Hi! I am trying to create database of customers and market areas they have reserved. Now I have made a list of areas, as list of numbers. Problem is that I...

My VERY BASIC understanding of good database design tells me that I should always try to avoid entering duplicate information...I assume this is to avoid...

Hi everyone - I hope this is an appropriate request. If not I apologize. I have a small "Contacts" database (the one that comes with MSOffice2000)that is 90%...

Is there any easy way to create an INSERT statement for a table with hundreds of columns? I need to append the data in one table to another table. There are...

I have 6 values (S1 - S6). Some of these fields have values, and some contain 0 (zero). I need to average these values... NOT including any zero values. In...

Hello, I have some questions: I need to develop something in which many users can complete data entry and the information can be stored and queried. Most...

I am trying to design a database which will store events which occur on the same days every month for 6 months of the year and this obviously will not be the...

DB consists of TblMachine Ondays with Machine Onday ID (primary), Machine ID(foriegn), Onday date. tblMachine ID with Machine ID(primary) , PM No,...