Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Krullms

    Automated printing to pdf creater help

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

    Automated printing to pdf creater help

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

    Automated printing to pdf creater help

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

    Printer List

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

    changing multiselect type with radio buttons

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

    Don't allow mouse scroll wheel to navigate records

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

    Startup different form for different users

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

    Startup different form for different users

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

    Query data into a semicolon deliminated string

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

    Radio Button, 3 phases

    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?
  11. Krullms

    Radio Button, 3 phases

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

    Radio Button, 3 phases

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

    Radio Button, 3 phases

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

    Instant Export to excel

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

    Instant Export to excel

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

    Between clause = form textboxes?

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

    Between clause = form textboxes?

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

    1 main 2 subforms, 2nd subform query of first subform...

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

    1 main 2 subforms, 2nd subform query of first subform...

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

    1 main 2 subforms, 2nd subform query of first subform...

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

Part and Inventory Search

Back
Top