My 1st version of Access was 1.0 upgraded to 2.0, (both on floppies) My newest computer does not have a floppy and I'm not sure Access 2.0 will even run on XP....
I have an upgrade CD for Access 97 but it needs to see proof that I have an old version in order to load. I have versions 1.0 & 2.0 but no floppy drive in the...
I am afraid I only know enough about Access to be dangerous, but have a question about a replicated database. How would be the best way to limit access to a...
OK! I used the USB floppy drive I bought and put in the #1 floppy of my version 2.0 of Access. Then I ran the upgrade CD. I had to also download & run a new...
I have an idea that I am not sure how to begin developing. I have a spreadsheet that has the pay period ending date, Sick and Vacation column headers. at the...
Jim Assuming it's an access table i suggest you include a date field which should be populated with the current date when importing the data from the...
This is an update to my dilmena... The program was created using MSO2007 (MS Ofice) and down versioned to MSO2003... had some issues so I installed MSA2003 and...
Hi, Well, there are few custom settings like date format which can make this happen. The date format is taken based on what is set in the control panel and...
Hi all. I have a form from which I click a button to import data into a new table. then I want to click another button to cause that data to be appended to...
Hello, I remember someone on the list who once made a perfect and pedagogic explanation of the difference between a database (Access) and a spread sheet...
I live in the Northern New Jersey area, and have done database developing. However I am working on a database for my music hymnals and songs. I have two tables...
Ihave a database that has been "upgraded" to access 2007, and it has jpeg photos in a form that display as and when they are updated.... Ican not link a jpeg...
I'd like to have an Uneditible form displayed - (I've got a combo box to select the record for viewing) but to Edit the record - I'd like the user to hit a...
Hello everyone, I'm pretty new to Access. I've created a form, but I realized that I needed 2 additional tables. I've created the tables, but the fields are...
Dawn If you want fields from the other table to show up in the FieldList you need to create a query that combines the fields from all the tables you need. This...
Hi again all...I'm going to post another question even though I never got even one response on my previous one! #21591 I think perhaps that one was just too...
Hello!I am trying to make a database in Access but I want to be special.In what way?I am want to use another programs to make the interface,to write Sql...
Visual Basic 6.0 and ADO is how I've done it in the past. The MDB will contain just the tables. Many off the shelf commercial software programs use Access...
Hello everyone, I have two Combo Boxes that I've made required. When the user goes into the form to populate the two fields and save, they are told that the...
Dawn Can you check the Control Source of the combo box if it is really set to the required field? Sometimes it is possible to set a wrong control source when...
Hello Liveson, I've gone into the table and added the year without problem. The Required field is yes. I'm just not sure why this is not working. Thank you...
Dawn How about checking the Control Source property of the combo box? Is it really set to the correct field with the property "Required" set to "Yes"? Just try...
Hello, I'm not sure what is wrong with this. I think I'm going to have them just populate this field themselves. LOL. I'm so frustrated. Thank you so much...
Dawn You seem to be getting quite weird problems with your database. If the formula is in the control footer or the report footer and the control source is...
I am having some trouble to just to populate two list boxes vendors and products I generate the code, the computer don't like it. Me.Products.RowSource =...
I am struggling to import a three column list of data,less than 100 records from Excel into a three field table in Access. I'm sure I've done this in the past....