I created a new table in the be of my split database and I cant get it to show on the front end... what's up with that?

Gentlemen, I would be forever grateful if you could help me. I use a HP Pavilion 7850 with Windows XP Professional. For several years I've been using a...

Access 2000 I cannot Import Excel Spreadsheets into my Database. I can select the file I wish to import but after that nothing happens and the wizard does not...

Hi, I have an access table that is a linked excel table. I want to make changes (ie, add columns) to this linked table in access but I can't. I can't make...

I would like to programically create a table just before opening a form and populate the table with an existing, non updatable recordset. When the form is...

I am installing a database for a customer on their server next week. I set up the backend of the database and I know the path to the file. Is there a way to...

Hello, I have a big table that contains details of prosecutions. It has the name of the player that sued, his details, date and there are 5 types of...

Hi, I've been using access for years already. In MS Access 2000, if you deleted the last record in a table and you want to reset the autonumber to the next...

I am trying to save a table in design view but get the message "too many fields defined" if I try and close the table down. This is then followed by the...

Hello, I've been trying to import an Excel spreadsheet and I keep getting the message that there is no data in the spreadsheet. I think that's because the is a...

Hi I have two tables. The first has fields: Employee_ID, Employee_name, Employee_Job_Title, Manager_ID. The second has fields: Manager_ID,...

I have a database recording bookings for flights from a website.To establish a primary key in each table, i've had to use multiple fields. e.g. In the table...

I am a new user in need of guidance. I have a db set to monitor recoveries of past due accounts. I have been instructed to set it up so the counter people...

Hello, In my design, i have two dates which will stand for date of credit request received and date for credit request done.Is there a way in either query or...

Hello, I am about to split my database for two users on a shared folder on the network.I would like to confirm that once i split it and link the front end...

In 10 years with Access, I've never run into this before. The relationships in my database disappear! If I create a relationship between 2 tables on the...

I have a database that manages hot ait balloon flights. I have a pilots table, a passengers table, and a flights table to tie the info together. I had the...

Hi All: I am setting up an invoiceing table with a form/subform. My invoice numbers start with KI-then a number (I.E. KI- 100). I want to set up an...

I am creating a report and need to set a criteria that the information needs to be within a specific fiscal year from the table I am taking the information. ...

Hi, I am a sales rep and am trying to track Demonstrations, Expenses, Miles, and Receipts. Without recreating all four tables, the thing they all have in...