I have a char field which I check the "allow null" property and when I tried to input an empty string that field, it always give me the following msg: "You...

Hello, all. Thanks in advance for any assistance you might offer. As instructed by the various articles and posts regarding how to add a 'All' item to the...

I created a form using the wizard. Some of the fields require more than one line. In some instances, I must return to get to the second line in the same...

Hi, I’m trying to use Leszynski/Reddick naming conventions for all objects but have come unstuck on the following: 1) Naming the different sections of a...

I'm trying to use conditional formatting in a listbox but the option is greyed out. I'm using Access 2003. What I have is a listbox containing many dates. Some...

When I set the subform's Allow Additions = No, the subform is not visible unless there a records. Is it possible to set a subform to NOT allow changes,...

I have a membership form based on two queries. The membership query provides the fixed information about the member and the history query provides the history...

I am trying to create a subform with several email groups in it... is this possible? I created one with individuals but....Ultimately, I want the user to be...

my forms on tab control are not requerying using the following code on the change tab event, can some one please help. Private Sub TabCtl5_Change() Select...

I have a batch file called transfer.bat which zips a few files together to create one zip file. How can I launch transfer.bat from within Access VBA? -rick

I am new to access and I cannot figure this out on my own. I first created a table, then used autoform to create a form bound to that table. I have...

I'm using a form very similar to Northwind's Order form. When I try to select the product on the subform I get "Compile error: Sub or Function not...

MainForm: "frmLeads" SubForm: "frmHistory" I've read other posts wanting to tab from the last record in the subform back to the main form, but the subform is...

OK, I've been playing around with this control hoping it would be good for my purposes. If the Calendar pops up, then I decide to go to another XP window,...

I have a main form with tab control subforms. When I click on my dropdown box in the main form to pick "companies" the first one comes up fine. So I check...

I have defined the tab sort for both the header and detail section of my form. However, the form starts with the detail section - it won't start in the header...

I have a form that contains client information, including the client's main address. I have a subform that contains alternate billing address for the client. ...

Hi I have a field in a table that is set to L-0000. I have over a thousand records. I want to be able to when adding a new record have this field add 1 to the...

I have a Subform and all the records come when I run it alone. But when I run a one of my Forms, wich calls the subform, a message comes: Data out of...

hello my name is José Urban I want to elaborate a manner in order to protect the placing protection and keys of access they could help me thank you