Search results for query: *

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

Thankyou Eupher and Greely, This will save me alot of time :) Mike

Hello, As of now, to make custom reports from XXXX Year to XXXX Year and a selected option I have VB code that changes the query to match what is entered in the year textboxes, then opens the report. I then remembered that I can set the years directly to the textboxes in the query itself...

Little more info.. If I remove the where clause in the query for the combobox the answers are shown as you go from one customer to the next...but when you go to add a new one, the combobox shows all the doors in the database (sinse i took out the where clause..) Thanks Mike

After thinking about this, The OnEnter event technically worked but it still leaves me with the same problem of it not updating by itself. Any other suggestions? Thankyou

Thanks for the reply. The onEnter event worked great. The rowsource of the combobox is a query that selects info from the doors table. I have the datasource for the combobox = the Door_ID. Now when i go to the next customer the combobox(es) are empty. Eventhough i have selected the door...