Search results

Greetings all - Are there any macro commands that fill in prompts from a query / report? I want one report to be automatically e-mailed to a few different distributions. The report prompts for a Client, Channel, and Format, among other things. How can I tell the macro which specific Client...

Ah ha! Now I got it. Thank you very much. It worked.

Reply Not sure (Microsot Office 2000 SR-1 Professional) and yes, its Windows XP (2000 professional). Thanks.

Hello all, Whenever I copy results of an Access query into Excel, it always wraps my text. Then I have to format and unwrap. Is there a way to change the default to not wrap the text? I tried to ask the Excel forum and got no help there. Sorry if this question is not meant for this forum...

Read only...why? Greetings all, I've been working with this db for a few years now, and just in the last few weeks it will go into a "Read-Only" status. No one else is in the db, yet still I can't do what I need to in there. Would anyone know why it would randomly become read-only and how I...

Hello all, In the Access specs it says that the file size limit is 2 gigabytes. Do linked tables from other dbs add to the overall size? Great thanks in advance. Peace, Roach

Greetings all, There are times when I'm running a certian macro (to update tables and spreadsheets) and the message "Numeric field overflow" pops up. After that the macro cancels and I can't update what I need. Does anyone know why this happens and if there is a way to prevent it? Any...

Hello all, My problem is this....I have 2 fields, "Yes" and "No". Some of these fields are null and others are populated. I'm trying to build a relatively simple query which adds yes' and no's. The problem is that IF I have 3 yes' and null (zero) no's the addition expression gives me a null...

Hello all, Would anyone know why I get an illegal error message after I run a macro? What the macro does is e-mail 2 different reports to different sets of people. After the message is sent I get the illegal message and Access closes out. Any ideas will be greatly appreciated. Thank you...

SetWarnings This may work....the first action to set up in the macro is "SetWarnings". Then on the bottom of the screen it will say "Warnings On" and change that to "No". Hope that works for you. Peace, Roach

How can I get a macro to e-mail (SendObject) 2 reports at once? Great thanks!! Peace, Roach

Hello all, I can't figure out how to copy only the structure of a table using a macro. I know a macro can copy a table then delete the records within, but that is very time consuming for large tables. Great thanks in advance to all. Peace, Roach