Search:

Thank you again.

I have a form set to show multiple records and would like to change the background color of the detail section for the record that is currently active. What is the best approach for this?
Thank you...

Hi,
Also make sure the .mdb is not READ ONLY....

DP

Hans,
thank you for the reply. I've been away from Access for a while, and forgot the simple things. I got it done by docmd.next rec / previous rec...

dp

On a form showing multiple records, does someone have code to scroll down or up that I could put behind a button in the form footer?
Thank you in advance,
DP

Hans,
Thanks for the suggestion. It solved the problem. Your expertise is greatly appreciated...

Dave

Dear Jezza and HansV,
While scaling down the db so I could post it I found that if a record has a null value in a field being criteriad (?!) by a value in a combo box, the record is not returned....

Thanks for the response.
All of the fields are text, as well as the stored combo values. The inconsistent results occur if (for instance) only filter 1 and 3 are used. The form filtering is not a...

Hi,
I have 5 combo boxes(cmbFilter1, cmbFilter2,etc) on a form (frmListBuild). I want to build a query as a recordsource for a report and enter criteria to match one or more of the combo box...

Hi All,
On a machine running xp pro, and using the fax component, the auto answer is set to pick up after 2 rings, but does not accomplish this monumental task ; ) I can manually send and receive...

Thanks. It seems that the fax is sent to Outlook as an email with an attachment. I thought this a bit odd as well, however, if it works, I'll take it. And, it seems to work rather well. The local...

Hello,
I am faxing from an Access app through a shared fax on a server. Outlook warns me another program is attempting to send an email and has me confirms it is OK. How can I disable this, so the...

Hi Folks,
I've found that to fax an Access report via a remote VPN through a shared fax on a server (sbs2000), the local machine needs Outlook configured for faxing through the shared fax by...

Thanks for all, Hans. I'm sure I'll figure it out, or get to work on a workaround....

Dave

Thanks for the reply. When setting the report to print to the shared fax and using PrintOut, it starts the fax wizard. I am looking to pass the fax number from a combo box where the user chooses the...

Hi,
I'm trying to fax a report through a shared fax on a server running SBS2000, using the DoCmd.SendObject line from a form button. The document (.rtf) ends up in the LOCAL Outlook outbox. The only...

I've automated emails as well, but this seems to be a new beast. I'm spending a good deal of time on it this week, and will let you know. Thank you,
Dave P.

Gotta love clients! If it weren't for them, I'd have to only work 40 hrs a week....

Faxing - my current project is 7 local workstations hitting on a server (sbs2000) and 1 remote station doing a...

Thanks Chris,

I'll use these ideas to clean things up in the code. these files are as ugly as it gets, of course. Another issue I have is batch faxing with MS SBServer 2000. Have you any...

Thank you, JS...
I have used Split(), and some serious string manipulation to accomplish what I needed. (sloppy, but it works)

Thanks again,
Dave P.

Hi,
I have some textfiles to pick apart, and I could use a little help. After cleaning out the garbage characters, I am inserting a delimiter ( ` ) at the beginning of each string of text I want to...

Sorry Hans,
This label sheet will only print for one person at a time, so I was experimenting with data in headers and such. I'll try to group the tests in a level of their own, force a new page,...

Hello all,

I need help with a report that prints onto labels. In the attached sample db, a report named "rptfltest1" prints on a custom cut 8.5 x 11 sheet of labels of varying sizes.

At the...

Wendell,
Thanks for the reply, and I have a solution to this error ! I needed to add the IP address of the server router to the "Trusted Sites" list in Internet Explorer. I had toyed with this at...

I have a client running a db on a server (sbs2000). There is a remote office that needs to connect, as well. I have set up routers on both ends over a cable modem and VPN. I can move files and...