Search results for query: *

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!

I have written code for a barcode in a Report. The barcode has to end with a single parameter a Check Sum. Instructions read(it is a sum of byte codes, starting with the first byte and including the tab delimiter right before the Check Sum parameter). This is where I am stuck at the moment...

Hello. I have been called into a company that has a Delphi based program and the programmer is no longer around (out of Country). There are changes that are needed. I am an Access and/or Paradox programmer. There seems to be an executable and other files (.dfm files etc.) Is there a way...

Going to try the recreation of the form suggestion now. I have done similar in the past with reports.

Did that first. Created a blank and inserted. Same thing. Just updated the code with your suggestion and no go. This has me stumped, appreciate the help!

I have pinpointed the module. Thanks for answering. They are willing to use Access 97 on this machine. But the person that set up the machine said they had installed 97 into a separate directory and it did not work. So now I'm wondering if there is an issue using Access 97 on a Windows 2000...