Recent content by Krullms

I tried copying my code from an older version and that didn't work, BUT I ended up replacing my form and reports from a backup, and now it works... Thanks for the help -mike

Thank you for the response. That is pretty close to what I already have. Maybe i'm setting the printer to the pdf printer wrong? That is what I have which works when the database is on the local machine, but not a network shared drive any ideas? Thanks Mike

I have a database that when on my local pc when you click a button it will open a report and print it to a pdf creator and close the report. When I moved the database to a network drive it prints. Any ideas how I can keep this automated instead of just opening the report and having the user do...

Can someone tell me the easiest way to populate a combobox with a list of installed printers? thanks -mike

What I am trying to do is have 2 radio buttons below a list box which lets you select what selection type you want, either simple =1 or extended =2. In the help files it says to just assign the value to the form item. "To set the MultiSelect property, you can use the following: Forms("Order...

I was just wondering if there is a way to not allow the mouse scroll wheel to change records on a certain form. If its not possible by form, then is there a way to stop this through access? thanks mike

Thanks for the tips, I ended up copying my switchboard form and table and editing one to only have the buttons that the read only user can use. I then just have a splash screen which looks at user then loads the right switchboard. Thankyou Mike

I was just wondering if there is a way to open a form for the Read user and a different form for the Fulldata user. This way the read only user can't see the options or goto the options that the fulldata user has. Thanks, Mike

Hello, What I am doing is selecting emails by certain criteria those emails are then in a list box, then the afterupdate of the listbox adds it to a textbox (semicolon deliminated) then I open a new email and add the textbox data to the To: field. I was just wondering if there is an easier way...

Sinse this form is going to be printed out maybe if the value of the frame is 0 i can just have a dummy set of buttons that are unselected with a default value shown instead of the greyed out ones? any suggestions that would be quicker than that?

Some of the radio button values are negative also... I just wasn't sure if there was just a simple setting that I have missed to get them to be unselected and not grey. Thankyou for the help though Mike

The problem with setting the default value is that i use the data value of each option to compute statistics. Hence, I can't set default values nor can I use a default value of 0 because some radio buttons have a data value of 0. I think i might have to have a default value then have my...

Hello everyone, My question has to do with the 3 different phases of the radio button. To me they are: one button selected, none selected and all radio buttons with a gray area in them. I am wondering how to make it so they are never gray. I want them to always be none selected or one...

Thanks for taking the time to read my question. I found something that worked. the OutputTo command, works perfect to export the report/query/... right away Example: DoCmd.OutputTo acOutputReport, "rptContactCatEmail", acFormatXLS, , True This command exports the report rptContactCatEmail as...

Hello, Quick question... I was wondering if there is a way to instantly go to the save as screen to export a report to excel? Instead of opening the report the doing file - export - .... Thanks for the help! Mike