Search results for query: *

Hi all, I'd inherited an Access 97 database. Our IT dept. will no longer support 97, so we were required to convert 97 databases to Access 2000, and this is done. There is one database giving problems. I have users spread around the state, thus making it harder to see what the problem is...

Hi... Please bear with my long explanation. %-) I have a .txt file that was sent to us by an outside entity. I'm trying to import, but with problems. The delimiters it appears they've used is the optional hyphen symbol. When I try to import the file into Access 97, the delimiters then...

I have a form with a name field and social security field and checkoxes that are to be checked if the social security number is corrected or added on an existing record. I have some code that places a check into the SSN Corrected checkbox whenever the SSN is changed. However, I'm unable to...

Hi, I was wondering if this is a Windows 95 and Access 97 compatibility problem. I have an Access 97 database where I had a textbox set to display the person entering the data (using the Eviron "UserName" function). I am using Windows 2000, but the users in another building have...

Hi All, Hopefully I can explain so this isn't too confusing. I have a database where the user(s) need to e-mail a report of the current record. I created a button using the wizard to send the report via e-mail. I can e-mail the report; however, if the users attempt to e-mail, they receive...

Greetings from the dark side, ::-) I am maintaining a database and need to know if or how I can tell a user (who has full Access) is changing forms, or code, etc. It appears that someone else is revising designs, sort orders, etc. Since these other folks aren't authorized to do changes, is...

Hi, I have a database that I've "inherited" from another creator who's no longer here. The database has over 45,000 records. It contains fields called DateOfFile, and AcctNumber (per client). A client can have several records in the database with different DateOfFile and the same...

I've checked the searches for my particular dilemma, but can only find how to calculate ages. One of my fields in the table is the DOB (date of birth). My report has an unbound textbox called CurrentAge with this code in the control source: =IIf(Not IsNull([DOB]),Fix((Now()-[DOB])/365.25))...

Hi, I've "inherited" this database from someone that has departed our office. I've been brain-dead and am in need of help...please. I have a database with a Main table where RecordID is the primary key - autonumber. I have another table called DMC where RecordID is set up in a...