Recent content by charcurley

I do refresh the screen after every search. They find a record. Go to it. Go about their business. Search another record. The form refreshes then they go on. I have tried and tried to reproduce this on a few machines to no avail. Appreciate the responses!

Well we have upgraded a bit since 1996 :) but not past 2000. I put this in the Access forum 2 days ago but no help and thought I would try the SQL forum. There are hundreds of reports/forms that have accumulated since 1996 and this has happened only since the upgrade (3 weeks ago) and only a...

The Access 2000 database that is in place has been in place for 12 years. The backend was just updated from Sybase SQL to Microsoft SQL server. It was just noticed that a document that pulls in information depending on the file that is opened in a screen is referencing the incorrect data when...

The Access 2000 database that is in place has been in place for 12 years. The backend was just updated from Sybase SQL to Microsoft SQL server. It was just noticed that a document that pulls in information depending on the file that is opened in a screen is referencing the incorrect data when...

I placed the dll's in the system32 directory and the smtphost went thru but I get the same error when I send an email that has an attachment. The error is on the mymail.attachment line?

It does not run at all not only with schedule tasks. If I go into the module to run one email I get the same error.

Sorry last post was not what I was looking for. Createobject failed. error #429 - ActiveX Component can't create object.

Thanks I did this. Createobject failed. error #424 Object Required?

Hello. I have been using vbsendmail.dll (I have the latest version of this file as well) in my Access 2000 VB Module for years and it works great. I have a scheduled task that runs every morning and sends out about 20 different emails using the smtphost. We have upgraded to Access 2003. When...

DZ, Thanks! Exactly what I was looking for my mind just went blank. Regards, C

I have a Main Screen with many sub forms. When it prints the text boxes are all gray and the print out uses quite a bit of ink. I want to change the backcolor for the print out. I am now using code: PreviousColor = 12632256 Me.Section(acDetail).BackColor = vbWhite Me.Label322.BackColor =...

Any ideas here would be appreciated. I have been using PCAnywere for years and really no problems. I have used it at home and at the office (on the same laptop). One has Verizon DSL and the other a cable modem. I use my laptop wirelessly around the house and office. It has stopped working...

I would like some help on a report I am trying to create: Here is what I would like to do: I have a list of Employees. and there is a list of Jobs to be Completed. I want to Generate a Report that randomly matches an Employee with a Job. (there are about 10 jobs and 10 employees and over the...

Thanks. First I need it to check to see if there is a file with that particular number in the directory and if it is I need it to appear. The number will change as the file does. I can do this with an RTF file but wanted to do something similar with a snapshot.

Hello. At the moment I create a snapshot document from a report and save it to a directory with a unique number related to the particular file. Now what I would like to do is place a button on a form and open this .snp file when needed? Any help greatly appreciated!