I have a tbllocation which has records A1a, A1b, A1C. I also have a tblarchive with records and I select the location. When adding a new record in a form I...

i am using two tables on one form, one table being a subform of the main form. i need to be able to fill in a record on the subform from a record on the...

Hi All, I have a back-end database that needs to be refreshed every hour. However, when users are using the database, it creates a lot of problems. Is...

Hi I am new to Access. I have a key field and have it as "Required = yes" when a user adds a record this works fine and will not allow the record to be...

I have a table named Bank transaction field deposit (currency) " withdraw(currency) i want to have the validation @ the table properties like ...

I try to create menu item to list all currently open Forms, Reports and etc similar to standard Windows menu used in all office application. By enumeration...

Hi, folks ! I need a though for my creation a table. I nearly completed all the work for using a database. But I stucked when create our company...

My OLE and Objects do not function and I get an invalid field report when designing a table. How do I resolve this problem

please tell me how do i sort data in which the most frequent name appears last in the datasheet

I am having trouble figuring something out and hoping someone out there might be able to help. I have built an Access database for a hospital education...

Hi, Using Access 2000. I have an Aces database with 20 or so tables, several linked with each other, this is shown by the black arrow pointing to the...

Hello. I am designing a database, and I want to add some navigations buttons with a XP or Vista style. However, when I download some sample images from de...

I am trying to import a text file using the Import Text Wizard. These are fixed width fields. The Import/Export Specifications are already entered in the...

I read somewhere that *ALL* tables should have a primary key, but no explanation was given as to why or what benefit it serves. After looking around for an...

I recently created a 2003 Access database and have placed it on a shared network folder for multiple users to have access to it. However, when users attempt...

I have...or had...a one-to-many relationshiop between 2 tables that no longer is shown by join lines in the relationship window. When I try to add...

I am trying to put together a database that will collect nonconformance data, analyze the data, and generate reports. This database currently is set up with...

My son needs to create a crossword puzzle or word search. I'm not sure how to do it- we have windows, our computer is about 4 years old(gateway). We need to...

I'm working on a ticket writer database. Currently, it has about 10-15 ticket agents using it simultaneously. There is also a read-only 'ticket portal' which...

Various companies with data. Need to send to Excel. But in Excel, how can I do this so that if I pull the company name, data would autopopulate (this data...