Search results for query: *

Clarification I am using DoCmd.SendObject in Access 2007 (with Outlook) for email follows: DoCmd.SendObject acSendReport, "rptmyreport", acFormatPDF, [EMAILADR] , ,"myself", "New Report", "Go Perform This Action", False [EMAILADR] is a field in the active form and has a NOTDAT field to...

I have a field EMAILADR as part of a continuous form. I need to loop through the email addresses and send the same message to each recipient until all recipients with a null date notified field NOTDAT have been emailed. I know I can do this with a loop but have not the first idea how to write...

After uninstalling PostFix and reinstalling sendmail, my cron jobs stopped running. Now they are running again but the logwatch and arpwatch files are not being mailed to root. My logwatch.conf file is as follows: LogDir = /var/log MailTo = root Print = No Range = yesterday Detail = 10...

Running RH9 with multiple name-based virtual domains and need some help! If more info is needed, I will be happy to provide it, but I am frustrated from trying to get Sendmail up and running: 1. Sendmail generates the following message on restart after updating the m4: > service sendmail...

Did you ever get an answer because I need exactly that information myself!

Once again, many thanks. This worked out very well without having to run a query at all, and a good thing! The project has expanded from a single department label generator to a plantwide FIFO system including the label generator. The generator form is so easily adapted to any count parameter a...

Thanks to both of you for your assistance - still working on this due to some monkeywrenches thrown in the works by the database requestor! Both codes work; the count update seems to be one step behind but I think it's a minor issue.

-I have a form with fields "monthreceived", "lotnumber" and "count" that are my targets of interest. -My table has fields "lotnumber" and "monthreceived" that need to be grouped then counted via query. (The query for grouping by lotnumber and monthreceived produces accurate counts) -I want to...

Let me answer my own question (which somehow threw the switch after reading it in vivid color!): I have to add the formulas to my VB code rather than to the form control source, and change the form control source back to the related table field. All is well (duh!); I should sleep more?

I have a table with a number of fields that update based on the initial and secondary value selections. The updated values work as designed, except when the form is closed, those fields are not updated in the underlying table. Example: Selection #1 = "CaseSize" Selection #2 = "Shifts" Code is...

One thing my clerk found was that turning off all the reviewers in the "Reviewing" toolbar prevented other users from viewing markup formatting. We just switched to Office 2003 sans documentation! It's been interesting albeit frustrating at times; however, I work in Access most of the time and...

Got it! I used a macro with a SetValue and DLookup expression. Went back and looked at an old post and the lightbulb finally came on [thumbsup2]

I have a form with 2 fields that are dependent on the combination of values in 2 other fields. I would like to update the fields using a DLookup or SQL Select query. Details as follows: Variable Field 1: Size Variable Field 2: Value Field 1 to update: Elec Field 2 to update: Tot For example...

Janetlyn: You have a few ways to do this but this is what I've done: If you want a permanent link between the cells on your Excel spreadsheet and an Access table, from Access you can do a File, Get External Data, Link Tables, and change the file type option at the bottom of the Link window to...

Thanks RhythmAce - I will also look at Fedora and see how I like that. With the practice server I can pretty much do some or all OS's and find what the easiest transition will be.

I was able to link to the AS400 from Access, but now the AS400 asks me to log in 3 separate times - any ideas??

Thanks! Off to do some research on both!

In addition to my 'real' server, I have a practice server at home. Maybe I'll try FreeBSD and see how it works out. Any words of advice?

My server is co-located about 300 miles away, so if/when I have to switch, I need to do it quickly and without unnecessary fanfare to minimize downtime. I'm still running RH 7.3, patched to date. What do you think would be the fastest, easiest switch?

RhythmAce - What are your plans when RH pulls out of RH Linux on the freebie end?