Recent content by joanl

I was just told that this was probably a terminal server problem... not Citrix. (that's all I could get from the person I checked with) I'm still at a loss as where to pinpoint the problem. I'm supposed to receive a machine with Windows 2000 and Citrix for testing purposes. Any more ideas...

There's also been another person involved in this who used to maintain the database at one time. He has Citrix and XP, but he couldn't replicate the error.

Thanks. Unfortunately, I don't have access to shadowing. I just maintain the database. It's a long story, but the IT person who can shadow is no longer part of our agency (he just hasn't been relocated yet), and a lot of red tape is involved in order to try and get him to help anyone here.

Is there a way to tell from my machine? I can't replicate the error from my computer. The users with the problem have Runtime. It works for the other users that aren't on Citrix and have W2k or XP. I apologize if I seem dense... I've been beating my head over this for a couple of weeks now.

Thank you for your response. Here's the code behind the problem button: Private Sub cmdGetDocket_Click() On Error GoTo Err_cmdGetDocket_Click Dim db As DAO.Database, rs As DAO.Recordset, crit As String Set db = CurrentDb() Set rs = db.OpenRecordset("SELECT * FROM SROMainTable...

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...

Hi Aaron, I don't know if I'll be much help, but I'll try. You can follow Steve's instructions, but I use a variation on step (c). I'll steal part of Steve's post and tell you how I get a label (or text box) to flash. (a) Add a Label control to your Form and call it lblFlash. Set the caption...

Hi dz, After some manipulating with the code, it's finally works. I had tried the nz function earlier, but I guess I wasn't phrasing things right. This is what I finally used: If Nz(sduNAME.Value <> &quot;&quot;) Then If Nz(SOCIAL_SECURITY.OldValue) <> &quot;&quot; Then...

Hi DZ, Thanks for your quick response. I'll try to put a little background on this. This is based on existing records in the database, so a name must be in that field. The SSN field can be blank or already have a SSN in the field. If the user receives a SSN to enter, 1. It will be new...

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 all! Can I join the crowd? I was wondering if this code will work with Windows 95? I have Windows 2000, but some users in another building have Windows 95. I've tried the Environ(&quot;UserName&quot;) Function and the name will display on machines with 2000, but not on the users with 95...

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 &quot;UserName&quot; function). I am using Windows 2000, but the users in another building have...

Hi there, Can I put in my two cents worth? I've found that I can display the parameter dates in the report heading by following these instructions that are found in Access Help. 1) Create the criteria parameters in the report's underlying query. How? 2) Open the report in Design view...

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...