Hi guys I have been pulling my hair out with this issue!!! I have a form with a number of bound and unbound fields on it. I use the SUM function via the...

How do I connect a command button on an access page to a report

I want to build an expression in my table so that when I type a particular City name, the zip code of that city will automaticall fill-in in the "zip code"...

I would like to change my web page but I can't get into page editor

1) How do I build a form that shows 5 levels of many to many relationships? 1st level-client names. 2nd level- questions. 3rd-recommendations. 4th-client...

tblArea AreaID area tblHeadEnd HeadEndID AreaID headend

Let me simply explain what I'm trying to do and maybe it will make sense. I think it's a fairly easy thing, but I've been looking at the DB too long. Any...

I've noticed when I double click a line in my listbox, that if one of the fields has a blank value, my INSERT INTO statement bombs out when I double-click...

Hi, everybody: I am now using Access 2007, and I have one table and its fields as followings: Product_Num (Text, no duplicate) Customer_Num (Text) I...

Ok so I am creating a Database for a homeless shelter here in my town. What they are trying to acheive is something that will track the guests that come in...

Hi All, I have 2 similar databases the table1 in each is slightly different with the addition of extra colums. let me explain, Database 1 (db1) is older...

I have added a new field to my SQL table. I need to update the Access database to reflect this change. When I use Tool/Database utilities/ Linked table...

Hi folks, My laptop is set to go into hybernation/standby mode if I there has been no activity for a set period of time. To "wake" the computer, I have to...

I have been using Access for some number of years but I just noticed that when I create a new text field and set the Default Value to Null (with no quotes) and...

At the moment I have simple Access DB with 3 tables Companies, Contacts and Activities. In the Company table we have stored the address...

is there a way to use multiple validation rules in table's properties that would return a unique message depending on which rule was violated as data is...

Im trying to figure out if I should create two forms, one for inputing/editing data using drop-down menu's, and one for displaying/deleting data not using...

I'd like to add a "datasource" attribute to all my tables. Is there an easier way to do this rather than physically editing each table one at a time?

Is there any set order for creating tables, I want to create the following tables Labour, Products, Customers, Orders, Confirmation, Deposits, Invoice,...

I am trying to create a way to "rate performance" on specific criteria. I am trying to modify an "Order" form to fit this project. It all can be modified...