Microsoft has an "Access 97 Relationship Print Wizard"...

When I first started working in Access, I would set relationships for all the tables. THen when I got "clever" and began writing lots of queries, I noticed...

I decided to repost this question because the response i got didnt work, it was giving me this error" Syntax error in the FROM clause". Lynn Trap,...

Lynn Trapp asked me to post the actual SQL code so that it can be checked for error. The error is "Syntax error in FROM clause." SELECT Stock.Item,...

I have two SQL statements, one is giving me the total Quantity available(from Stock table) and the other one is giving me the total number of Quantity sold...

I am trying to build a one to many relationship where the One is a normal field named 'UserID' within the first table while the Many is a Primary Key named...

Try this test open any simple form and close again ,eventually MSAccess will bring up message not enough memory. eg try Northwind database opening categories...

Not sure if this is possible, but would like to automatically add new data from Field1 into Field2, but keep data currently in Field2 as a history. Field1 =...

I'm building a database in which I would like to have checkboxes automatically checked on a summary form once certain other information has been entered into...

I have tried using the current formula online ...namely... =DateDiff("yyyy", , Now())+ Int( Format(now(), "mmdd") Format( , "mmdd") ) but the program ...

Hi, I'm helping a local county office with a fairly big project. This county office does Assessment, Taxation, Survey, etc. We're just at the beginning stages...

Does anyone know of an existing template for Access which I can use as a base for a club membership system. The 'Contact Database' template which comes with...

I don't know too much about access but all that I know I am learning from mistakes. I have built a database that will help all administrative types in my...

There is some information regarding a disease for which the number of cases and case rates are stored for each year and for all the counties in a state. When...

Hello All: I know how I have my access application right now that isnt quite right, but it works. But I would like to know the proper way to do this. I have...

I'm creating a form and while going and back and forth I can no longer view my form!

hi how i could know teh size of my tables ? also my forms

Hi to all, I work on an insurance project.I have a table, tblPolicies, which has a triple primary key: BranchID, CompanyID, PolicyN. To this table I want to...

My industry require results to be to a preciscion of 6 decimal places. Access handles 1.012345 but returns 1. if there is no moderator ie result is 1.000000...

I have a table here that will store currency values. I've been reading up on the differences between the datatypes available and there seem to be 2 viable...