I created a simple form for a group to track members in their interior design society. The problem is the data in the table and form is in the order the data...

Hi, I have 2 tables; 1. Demo: ID, LastName, FirstName (fields in the table Demo) ID is the Primary key. 2. Orders: Last Name, First Name, NoOfOrders...

I would like to know if there is a way that when after having finished entering the data on your form and that when you create a new record that the data...

I'm trying to use the "&" symbol in a label and I keep getting an underscore in its place when I click off. I know that this is because this is part of the...

I have a form that goes a few levels deep, down to a sub- sub-sub form. I'm having trouble with keyboard navigation (I hate mousing around DBs) across the...

Hi I'm still learning access and am trying some of the native coding. The snippet below is the code behind a command button on a form. All the database, table...

HI, How to manipulate records of 2 different tables on a form. Can anyone help me in the correct syntax? for eg: 23 is in table 1 and 75 is in table 2 how...

How to update an open form and list box after add new records in another form and close it? Thanks Joao

I would like to open a text editor like Word or Notepad, inside an window in a form. How to do this? Thanks Joao

cannot save form after creating based on a specific table and unable to do so likewise for queries and reports '

Can anyone tell me what the Instancing options for a Class module mean ? 1 - Private 2 - PublicNotCreatable Thanks

I have an Access database linked to a couple of different SQL Server database via ODBC linked tables. What's the best way to protect users from having to...

Hello, I have two forms. The first is , fields: companyID (primary), CompanyName, Website. The second is , fields: ContactID (primary), Company ID, Title,...

Hello, I have some code who put event catchers on a control to do some AfterUpdate stuffs like this : Dim WithEvents myTrigger1 as CheckBox .... set...

I'm a non programmer so I need someone that can give me very detailed help. I have created a button on my form that will close and save the form. I would...

Once selecting and storing a company name from a dropdown box on a form, how can I have only the purchase orders connected to that selected company display for...

I have two text label fields in a form. One is for the start date and one is for the end date. I want the default values for these fields to be now()-1,...

If I have a ZIP code database, including lat and lon, how can I write a script of "find a dealer near you"? I would guess that I will need one database of...

It seems that by default, Access automatically highlights the contents of first visible field in the tab order. Is it possible to avoid this so that when a...

I was wondering if there is a way to add a new entry to a list in a drop down box if it is not in the list when you type it. The list is in the row source...