I have upgraded from A97 to A2002 recently. There are some new features which really drive me crazy. "Live" subforms/subreports is one of these new...

Hi everyone, I am creating a variable start up form where I store the Primary Company information to tbl_Primary_Company. This form will hold several test...

Hello all, I hope you can help me! I'm reasonably new to Access having learnt how to use it and VB mostly through trial and error! I'm now trying to set up a...

When in design view, if I place controls right up against the right and bottom edges of a form, when in form view there is a margin between those controls and...

I would like to create a form that gets it data from two different tables. The tables are very basic and table1 has a one to many relationships with...

I have very large database( almost 500,000 ) that contains road characteristic readings in two columns taken by a highly sophisticated instrument . I would...

I've been experiencing some strange behavior in Access 2007 Trial when trying to get some new forms sized the way I want them. I did not have this problem...

I have a database invoice that I have spent over a year creating. So far I can use it but not the way I want to. I have the following fields that I manually...

I have a table with the field name like F1, F2, F3 and so on. I create a vba recordset to the table and loop through each record in the table. I also have...

Hello I have a button on a form that runs a macro to open up another form to display details against a selection that was made in the 1st form. For example...

I've got a form "Frm_Logbook" that has a sub form "Frm_LogbookEntry". The form gathers information about the client, who took the order, instructions, total...

I am using access 2003 I have a form, with approx 75 records, that is used by several people. I want to be able to open the form with a drop down list, in...

I would like to design a rating scheme for employee evaluations. I created a table with the Employee SSN as the Primary Key. I then created fields for rater,...

In the join below, all fields from tblPMHlookUP are populated with data (it is a lookup table after all). When I run the query I get the info I want from...

I have on a form an option group with two check boxes. On occasion, I may want to clear both check boxes. Is there a way to do this? Ivor

Hi Somebody, thanks if you could help me generate an expression to caculate values from two fields whose answer will determine a value in another field. an...

Is there a way to add If-Then statements to the Access Query SQL? My code below is taking way to long to run, and I would like to have Access not search for...

I have set up a form using three db's linked as two sub forms. The are opened from a single pc by a single user. When attemping to delete the master and the...

I have a table that has columns setup with 3 decimals, however when I export the file to a .txt it is only exporting out two decimals and I'm losing the 3rd...

I have a database invoice that I have spent over a year creating. So far I can use it but not the way I want to. I have the following fields that I manually...