I have a form with a combo box that allows a user to choose from a list of agencies. The combo box is not connected to anything, i.e., it is not bound to a...

Ok i have managed to find the following code: Private Sub Form_Open(Cancel As Integer) If DCount("*", "Junior Students without Child Protection Query") = 0...

I have been working in Access 2007 on a database that was created in Access 2003 and everything seemed to be going fine until now. One of the forms on the...

I have an aplication in Access 2000 and install in a PC with Office 2007. The aplication is a Access project (ADE) and runs with the runtime access 2000. The...

I would like to use combo boxes to set the criteria from a parameter query (I can do that part) on the top of a form and then display the information in a...

Not sure if this is a form question or a report question or something else. A couple of weeks ago I set up Lebans' Report to PDF, and it worked in a test...

I have a form called Log Detail and a subform called Service Numbers Detail with a linked field called Service Provider. Service Provider is the primary key...

I'm creating a vendor contact list using a standard Access contact template and revising one of the forms. I have several people from one company, and I'd...

Okay, I found that this code and if I’ve understood it can help with performance. It currently takes over a minute to open my form (have lots of...

I have created a form in design view. I wish to have a drop-down box linked to the "Insurer" field on my database. When the user clicks the drop down box I...

We just switched from A2002 to A2003. I want to change the autocorrect property of field text boxes to no with code. If anyone has a sample to share, it...

Hi I'm having a problem with form (frmGoodsIn) and subform (frmGoodsInItems) My rowsource property for the subform combo is: (text is all 1 line) SELECT...

I don't know what happened, but when I'm in design form and click on the command button, I drop it onto my form, & it just inserts the image. No dialog box...

I have two tables: tblCard: CardNumber (number type) tblRibbon: RibbonNumber (number type) These two tables are not related. I want total of CardNumber and...

why does my tab index on my textbox properties keep messing around? no matter how much i order my textboxes, it always changes on its own. -- Message posted...

I have two queries that I would like to make forms from. 777’s 900’s The only difference between the two is a Criteria that shows one cycle or the other....

Hi, I deleted a field from a table, and then went to the form and deleted the same field. Now, whenever I open the form, it asks me to "enter parameter...

I know this may be pretty basic and has been covered before, but I can't remember how to get this to work. Right now I have 2 combo boxes set up with 2...

We are using the '=DateDiff' formula from Access and it is working fine (Acces 2003; XP Service Pack 2). However, it now populates ALL the fields with the...

I have a strMsg line in a message box leading to a yes/no response. Is there anyway I can jazz up the strMsg line so it is bold and in a colour, for example...