Hi All, I have a table that contains clients, another that contains transactions. Linked by clientID. Within the transaction table, amoung many other...

I am trying to use the code below for a different mouse when i move over a label. This is a post I found the code on. They say place the code on the mouse over...

When number is calculated in Excel or by using a calculator the answer is 3.25% in a calculated field on my form the answer is 3.36% calculation in field...

qwe

Hello, This is difficult for me to explain, but I'll try my best. I have a form that is filled in to track project status. In the form I have severl fields...

I attempt to generate a report in an Access 2007 database using Send Object. The database is shared, and I have no problems generating a PDF on some...

Here is my connection string and it returns COMException error: {"Not a valid file name."} db =...

Howdy! I am trying to figure out how to pull up a record based on the autonumber primary key. Mine is a database for tracking orders with each order having...

Hi I have created a query where i m calculating two dates A1 and A2 Now i have a form Premium Paid, where i m inputting the premiums paid by users. The...

I am currently developing a database for 2 users. It is a very simple database with 1 table, and 1 form that users will use to enter data into the table. The...

DIS MOI SI TU RECOIS CE MESSAGE MERCI GROS BISOUS ANNIE

After placing a command button using wizard on a form, when i look CODE VIEW, I found its code. But suddenly the code generation is not happening now. ...

I split my DB and now it is extremely slow in opening any of the forms. I then copied the whole original DB and put it on the same server. It is not...

Hi All, I have a query called DataSum. In this query I am summing all the hours that a peice of equipment is used. In my report, it displays a summary of...

I design a lot of queries by connecting to our ERP system thru an ODBC connection. I have always been able to link at least 2 tables together and retrieve...

Hey, I've run into the fairly common "SQL too complex" error but I'm not sure qhat I'm doing wrong. My SQL is the following: SELECT SUBMISSIONS.title,...

Hi I have inherited a web site with an Access database in it. My host requires that I move the .mdb to an external folder...

Hi all I'm hoping some of the experts out there might be able to help me out. I've been asked to develop an audit database. I've got all the questions in,...

I have the formula Left(Mid(,InStr(,".1"),25),4) in a query some rows return what I want and some return #error. How do I get it to return a null if it is...