I've converted a database from 97 to 2000 and the =date() function will not work. It just doesn't work at all! I get the following error message: Unknown...

Hi, I get following message: The database has been placed in a state by user name on machine name that prevents it from being opened or locked. (Error...

The following will work in T-SQL: DELETE FROM orders FROM orders o INNER JOIN orderdetail od ON o.orderid=od.orderid WHERE od.billitem='a2220' But I get an...

What is the equivalent code in Access SQL for the following T-SQL block: IF EXISTS (SELECT * FROM orders WHERE amt 10) BEGIN ...do something END

I have a table with 150 names address's etc what I need is to have a query? that will enable me to search the database for a particular name or other variables...

I need to update a field in one table as the product of two fields in another table. If I create a DSN called "test" and a linked server in SQL Server,...

Hello, I need to replace multiple characters in a Replace statement and can't figure out how to do more than one. Any advice? My starting statement is below...

Hi, Does anyone know how to write a line of code to change the background colour per line of infomation by 2 different text boxes in Report. I have a report...

I have a small donation tracking database with a tblDonors and a related tblDonations. Among other display/edit forms, it has a data entry type form to...

Hi, I tried to compile this: Sub Test() strFilter = ahtAddFilterItem(strFilter, "Excel Files (*.XLS)", "*.XLS") strInputFileName = ahtCommonFileOpenSave(...

Are there any plan for a version of Access for Mac?

Hi. I have a database in access 2000. But my program that is installed on my computor is from office xp.(I think this is the same as 2002). How do I go about...

I need help! I have a DB with 5 tables (Program, Director,Alt contact,Private Practice, hospital,and Paytype) These are the relationships between them. There...

While experimenting with security settings (I generally work alone and don't use them) I managed to set a database logon password. I thought I was just working...

Generally in the progression of database building, should one creat forms based on the tables, then create a switchboard based on those forms, or.. should one...

I have created a relativly simple DB using acess 2003 (file format is 2000) and have put a copy up on our LAN server. When I open and use the DB from different...

I have a string that I need to split out into its original components. The string will appear in one of 2 formats either 0:11:22:33 or as 11:22:33 I now need...

Hi, I'm having trouble and have been trying to create this database for over a week now. I'm not very up to speed with creating databases and have been trying...

I have installed office 97 on my system (running windows XP). When I try to run MSACCESS, I receive the following message:"Microsoft acces can't start because ...

Hi - I'm trying to truncate a field using the update query - but can't get it to work correctly. I'm trying to go from M12345 to 12345 - eliminating the...