Recent content by lucybelle

SkipVought, I'm exporting a text file from Access so that I can ftp the file in the format that is required. Below are the instructions given to me . ProgramCode must be a 5-digit alphanumeric code such as ‘ Z’. All program codes currently are only 1 to 3 digits and must have leading...

I'm working in a query in Access 2003 and I need the "ProgramCode" field to return a 5 digit alphanumeric code with leading spaces. The program codes are actually 1 to 3 character alphanumeric codes. I can get it to work with numeric codes only, but I'm having a problem with alphanumeric. I'd...

I have a query with a Trip table & Appointment table There can be many appointments in a trip. I only need 1 field, “Destination”, in the appointment table to show in my query which gives me duplicate records for all the trips that have more than 1 appointment. Is there a way to add a field...

Yes for all

Hi Everyone, We have an Access 2003 database with the BE located on a shared network, the FE is on each PC. Sporatically, the users are locked and cannot close and save. We thought the problem may be a new Windows7 computer, but it continues to happen when it's not in use. This has been...

I opened the backend exclusively and cannot delete. I deleted the link and linked it back and still the same. This is a database that I converted the FE from Access 97 to Access 2003 last year and had no problems, until I just converted the BE in November and having problems. To fix this...

I have a spit Access 2003 database and in one of the tables there is a record that has "#ERROR" in every field. When I try to delete the record, I get this message, "Invalid Argument". The database will not function unless the record is deleted. Can anyone tell me the easiest way to get rid...

I found the problem in the data in the table. All the fields in one of the records had #error. It would not let me delete the record, so I created another table and copied all the records except the bad record to the new table. It's working fine now. I've seen this before. Anyone know what...

The is the only query that I have found with this problem. The database is 39MG. I compacted it before and after I converted it to 2003

I have a split database, the FE is in 2003 and the BE is in 97. A week ago, I converted the BE to 2003 and it's been working fine until today. I'm getting the message, "Invalid Argument" when I try to run a specific query. This query is used often and has been running fine since last week...

I think we found the problem. The antivirus was the culprit. The server is running a different av than the computers and there was a conflict. We just changed a setting on the computers.

I have installed MS Office 2003 on some new IBM ThinkCentres, model# 8215-22u, and am having a problem saving existing Excel files on our network. When the file is on the hard drive, I don’t get the message. This is the message: "The file may have been changed by another user since you last...

My network is Novell. Could that possibly be the reason I'm getting the error message when I use the shortcut with the command line? Any Novell users out there using Access 2003 and using the shortcut without problems?

This is what I am trying to accomplish: To look up a client, I double click on the name field in the client form, to open the search form. On the Search form, I click on the client from the list in the combo box and click on the Search button. The client name selected should come up in the...

I'm using Access 2003 and having a problem with a macro running on the IBM X41 ThinkPads. It runs fine on the PC's. The macro has a couple of sendkeys actions and I was thinking maybe the problem was the users with ThinkPads are using a wireless keyboard and not the ThinkPad keyboard. Anyone...