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

...--------------------------- My crontab file is as follows: SHELL=/bin/bash PATH=/sbin:/bin:/usr/sbin:/usr/bin MAILTO=root HOME=/ # run-parts 01 * * * * root run-parts /etc/cron.hourly 02 4 * * * root run-parts /etc/cron.daily 22 4 * * 0 root run-parts /etc/cron.weekly 42 4 1 * * root...

...envelope as well Other dnl # Other dnl FEATURE(masquerade_envelope)dnl Other dnl # Other dnl # masquerade not just @mydomainalias.com, but @*.mydomainalias.com as well Other dnl # Other dnl FEATURE(masquerade_entire_domain)dnl Other dnl # Other dnl...

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?

...After that it just doesn't work. Next field is "Shift1PerStationUnitsPerShift" and the control source is "=([CastingShift1PerStationUnitsPerShift]*7)" The math works but the table is never updated from this field or any others like it. I have no idea what I've done wrong since I'm...

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?