I have a database which was developed originally on Access 97 which is to be converted to 2003. The conversion has worked successfully and the application...

In a table, Access 2000 is rounding my number so that 12.4 appears as 12.0. How can I override the rounding whilst keeping an accurate decimal place? I have...

Experts, Can someone please tell me the proper SQL code to get the following result: All records from this table (EMPLOYEE) where (status is not 9 or 2...

I'm new to Access. I'm developing a school directory. I have fields that contain some data and some of those same fields that do not. When generating my...

Hello, I am so new to using access 2003 that it still has the new car smell to it... My situation is this: I have a table that has several field names that...

Hello everybody, I am not sure that many people have been playing with new Access2007. Probably someone has seen and fixed the same problem. The problem is...

I have 6 fields that may have a null in them. I don't want to see them Here is the order of my fields Invoice Month Family Member Family Auth Verify Family...

I have a table that contains about 10% blank entries in a text field but are only selected about 2% of the time in a combobox. Is there a way to make the...

Rookie question - I have converted a copy of our DB in Access 97 to Access 2003 and don't see any problems so far at all. It's probably not very...

I have seen this now on two databases. when i try to compact/repair the database it goes for awhile and then it pops up this error, with an 'ok' and 'help'...

I have an application that uses the following format statement AttendWeek & Year: Format(,"yy") & Format(Format(,"ww"),"00") That works beautifully most of...

Does anyone know how to use VBA / Access to copy data to a table in an .mdb file that is located on a web server? Also, is it possible to copy/replace a...

Hi, I have just successfuly converted our main company databases from Access 97 to 2003, but I have one casualty. It is a replicated database which I...

Hi there, I have a general problem with MS Access and this is how to work with data displayed on a continouos form view (or datasheed view). Many times I...

Hi all I want different values displayed in a combo box dependant upon user. I have two queries which select the right data and I tried switching between...

I created a form with 3 option buttons. Whenever I select option 2 or 3 the first option button always comes up first. I have to exit out that that option...

I have been trying and trying to I update a database. It just doesnt seem to work the way I think it is suppose to. Im not using any sql code just the tools...

UPDATE T1 SET T1.F1 = (SELECT T2.FA from T2 where T1.F2=T2.FB+1 AND T1.F3= T2.FC

I have a form that has a control source of "table1". I also have a combo box that is pulling data from another table (table2) through a query. That table has...

Hi all, I'm trying to find a way to change the sentece of the sql inside the query via vba code for now no clue