Hi there Im a novice Access user, so apologies if this question is a little basic. My database is relatively simple, one table and one form. Many users will...

I have created a database w/4 tables, all relational to 1 table. Basically, I have a firm info table, a contact info table, a disciplines table (which has...

Hi all, I do not understand why this is so complicated for me? I am a novice but this should be extremely simple. I have a form "Projects" which is built on a...

Hi Using A2003, SQL 2005. I have a strange problem referencing a combo box column. The combo box is simple, just two columns (Debtor No and Debtor Name). I...

Using Access 2000 I created a database that had a subforms. About 2 months ago that database was moved to 2003, and in 2003 I created another subform. Until...

I am working with and existing table (Table1) with 11,000 records of parts, their specifications, and other information. The table includes about 60 fields....

I figured out where I should start the loop in order to keep the excel work open and still be able to add more sheets, but I can't figure out how to add code...

I have created two separate DB's and wish to access the seccond db via a command button/switchbord command from the first (main), and i am currently not able...

Yes you can, but assuming by yur example you should use DSum =DSum("","") For DlookUp =DlookUp("","") Now, the question what are trying to do? Do you need...

When I print a form containing a pivot chart to a color printer, there is a large rectangular area, within the page background area, that contains the...

Hi All, I have 2 tabs (Order and Parts) in my form. I have it set up as a 1 order with many parts relationship. When I fill out the info in my order tab (1...

I am trying to create a sub form that allows me to enter the number of products we have recived for an audit. My tables a tbl: Audit Data Audit ID (PK)...

I have an Access 2000 database with a form in it that appears to be corrupt. It has been working for some time, several years, and it is only recently that...

Can some one tell me how to excess safe mode in windows vista. it is different than win xp, by booting and tapping the F8 key a screen comes up with option...

I have the following code in the Before Update even of a form which I have take from the threads on this site: Private Sub Form_BeforeUpdate(Cancel As...

I have been battling this problem all night... very confused. I have a form based on a query called . In this query i have a field called Extendedprice. The...

I have been receiving a new form of spam. Spammers are using my guest book feature in FrontPage, selecting only the state and dropping their links in my...

Can anyone help me with this one please? I want to use conditional formatting on a text box using Access 2002. This is something that I have done many times...

I have a db that makes reference to restaurants, hotels, retail shops, etc. and I want to produce a one page report that shows these items using icons...

Use the code you have in the double click event of each of your other controls and change the referenced control. Forms!MasterReports!NameOfEachControl =...