Is it a good idea to place a command button to compact if your splitting the DB and placing on network drive?

I have a form where, at first glance, only 1 field in automatically editable.. What I want is a button that releases all fields to editable mode. If anyone...

Hi, I have several options buttons in an option group which each relate to a report. If a report is selected how do I set a single command button on a form to...

I have a main form (frm1) with six tabs, each tab with a subform (fsub1-fsub6). Each subform is a child of the frm1. I want to synch fsub2-fsub6 with fsub1...

INSERT INTO TTEMP_CampaignRun06 SELECT TTEMP_CampaignRun05.PK_Contact, TTEMP_CampaignRun05.AcNo, ' ' AS InvoiceDate, ' ' AS...

Hi My database has suddenly locked up. I keep getting this message when I try to add a new module: The database has been placed in a state by user name on...

Hello, So, I've got a form that's linked to many tables. I'm trying to make a couple filtering controls. So far, I've got a combo box that lists the...

Can somebody help me on this please,am a beginner to programming. I have two multiselect listbox for filtering report and printing it.After printing it i want...

How to add combobox to multi-select listbox in Forms

Hi, I have main form (Employee) linked to a subform (Email). That subform (Email) is the parent of another subform (Order). An employee can have many emails...

Hello, I have a Mainform with a Subform with details. In the subform I have a control name 'Amount ' and in the Form footer I have TotAmt using Sum to get the...

I have a table with among other fields, Provider Name, Tax ID Number. How do I get the tax ID number to auto populate in the tax ID field when I select the...

Hello Everyone, I have a lookup column in my database with two parts. One part lists the supplier's name with the supplier's ID number directly accross in...

Is there a way to locate the cursor at the beginning of a field automatically when you click in a field. Right now, the cursor jumps into the middle of the...

I want to filter the drop down menu of with the value of . It will be like show only the items in the drop down menu of if the value of in matches the...

Dear friends, I have developed a database in Access 2003 and now I am facing the following problem with Access 2007. I have 2 unbound text boxes in a form,...

Hello, I use tabcontrol on my select form, in order to preview report as follows: 1. Tab1 or page 1 is to use combobox in order to produce all transactions...

I have a data entry form. I want to disable the enter key so that if it is pressed, the insertion point does not move/go to a new record. I do not want to...

Hi, I use the following code to open and print reports in the AfterUpdate event. Works well, now users want to be able to use same report with any entry for...

I have a form that displays prospective customer information. Sometimes we will get inquiries from customers that are already in the system. We have 2 separate...