Can anyone suggest a good website to find basic access training (for free) where I could find out things like change the name of an object by clciking on a...

I want to have my form set to sort by a particular field each time it opens. My reference book says to use Order by property in the table and OrderByProperty...

If suggestons made from the community don't solve the issue, is it generally preferred in the community that I press the "No" button when asked if the reply...

Hi I'm fairly new to access and have set up the structure of a database, but want to know if there is a design flaw before i enter data for over 500+ football...

Hi, this is a little bit confusing but I hope somebody can help me! I have a database tracking specimens from a research project. One of the fields is...

hi, Thanks in advance.. I am having trouble with composit key.. is it wise to use composit key .. ? If I want to use composit key of one table as foreign key...

I am trying to create a database based off of a medical department charge sheet. The physical charge sheet is 3 pages long and contains 152 possible items...

I am adding to the auto correct list and would like to have the list saved to file and/or printed. Can that be done/how? Regards, Geb

I have a user who is running queries to update Access databases. She keeps getting the popup box that asks: " Are you sure you want to delete these records? ...

I have developed several tables and associated forms to input the data into the tables. In each table I have both a Creation Timestamp and a Modify Timestamp...

I have a table with a SkillID and an Applicant ID. How do I create a field that combines these two fields? I want to set this new field a the key to avoid...

I have set up a form which has a 'date on hire' and 'date off hire' field. I want to be able to say to the form, look at this record (hire no) if the date of...

Hello, I am having trouble calculating the number of days an account is outstanding (still in process, has not been completed). I consider an account...

Is there a way to use Access, or Excel, to create a database, that I can use a command to update it in alphabetical order?

G'day, Being a very inexperienced user of MS Access, I am hoping I can get some help on here. I have a databsae that is used to enter all in and...

How do I make sure a table is noramlized? I have one table with a project name, number, and funding; I have another table with each project (some list twice...

I have a large(ish) one table database of names and addresses and there is a large number of duplicates - I know because I ran the find duplicates wizard. My...

I am new to Access and curious if it would be helpful to our business. However, there are many software programs that are tailored to our type of business but...

We can do the following to open a query as recordset: Set rs = dbs.OpenRecordset("MyQueryName") Can we do the following to sort a field inside the...

I have a form to edit multiple records by using Recordset on the basis of a query, I don't want to show the status bar which there is no actual link between...