Hi, I am trying to locate the expressions: IIF, Count, Sum, in the Expression Builder window opened through Validation Rule in TableDesign. (Access 2002...

I have what I believe to be a very simple problem for all of you who know Access better than me. I am using Access 2007 and have a field in my table where an...

I am hoping someone can help me, I am trying to create a relationship in a database and I am having a lot of trouble. I am trying to make is so in my database...

I have a field with NUMBER datatype, SINGLE field size, Fixed format and 0 Decimals. When I enter the value 100317090407 the number rewrites itself as...

I have a database that I want to share over my network (total of 9 computers on network). I split the database to have a FE and a BE. However, once split,...

Hi there, hopefully somebody will be able to offer me some words of advice. I am creating a database for a firm that deals with property insurance claims....

i have a form with a subform and on the main form i have a toggle button that locks the subform.. with this code !!.Locked = bLock this worked fine until i...

We have an access database on our server. We recently installed a new server. The links in the split database from the front end to the back end all reference...

I'm just curious if it makes sense to use junction tables in this instance: student - studentID, studentfirst, studentlast, gender, age (adult, teen, or...

Hi, I have a job list form with basic info on it. I want to be able to click on the job number text box which then opens up a more detailed form and applies...

I need to design a database that will track the supplies ordered from a supplier as well as track these supplies when they a shipped to investigator sites. I...

I am using the lookup wizard to create a lookup column using an existing table within my database however I get an "automation error". I can get as far as...

Hello again :) I should have bookmarked my last thread so I could add to it :P Here goes again ;) Ok this is what I have so far :) How's it look? address...

Hi, What if you have two organizations and you plan to design a database to do the same task but within that task, the defined tables will vary because of...

I have Access 2000 on the job. I have two tables (CDCR#, Last Name, First Name, and DOB are the only fields) and with many medical related fields. ...

I have a table with a Gross Sales field and a Total Costs field, there is a third field called Net Sales. How can I create a function to take Gross Sales...

I am trying to create a membership database for a church. I need to have all members entered into the database, then for the members I need to have their...

I was just finalizing a good and working database so i tried using the startup option directing it to startup on the switchboard manager form i created.I must...

I have made a drop down box, but now want to make when I select a specific word it will change back ground color in whole row. Say I pick UT for Utah in my...

Simple question, hope I can get an answer.... Ok, I have created a table and form for our company to keep track of incoming inventory. Being that we work...