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!

  • Congratulations bkrike 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: *

  • Users: NC1977
  • Content: Threads
  • Order by date
  1. NC1977

    How to set focus on a field list

    I have a form with a field list. Once the user selects from that list, he can then proceed to another form to enter additional information. I would like for it to be impossible to continue to the other form without having selected from my field list. How can I do this?? Thank you
  2. NC1977

    Error Handlers on a form

    Hello, Here is my script to handle a few errors on my form before the user can print: If De > A Then Msgbox "Your FROM date cannot be bigger than your TO date" ElseIf IsNull(Mandat) Then Msgbox "Please enter the file number!" ElseIf IsNull(De) Then...
  3. NC1977

    Subject line of an email message through code

    Good morning, I have a form, with a command button that once clicked sends my report directly to the users email so that he or she can email this report. The following is my code: DoCmd.SendObject acSendReport, "Requete Lawson", , "xxxx.xxxx@lakdsjfl.com", , , Forms![Requete...
  4. NC1977

    Field selection on a form for a report

    Hi! I've got a form, where the user can select a division or Group or region and it runs my query "Pivot Table by Division" with these parameters. Now I have 30 columns in my QRY and I want the user to be able to select up to 5 of these colums (the capital ones, I only put 3 as an example)...
  5. NC1977

    Picture to change on report depending on the query

    Hi, i have a report with a map on it. This report is run when the user selects a location. I would like that on my report, whatever location the user selects, theirs a picture of the map.. The picture would change everytime their is a location change. Can this be done?
  6. NC1977

    Syntax Error

    I keep getting this stupid stupid stupid error everytime I try to query this table: Syntax error (missing Operator) in query expression. Here is my query. The thins is I actually created this query with the wizard..... SELECT [Matrix Query].Division, [Matrix Query].[Succession plan], [Matrix...
  7. NC1977

    Switchboard form doesn't open to full window

    Hi, My db is complete and have selected a form to open on startup(switchboard). For some reason, it doesn't open to full view on the screen...Where can I change this view problem??? Thank you
  8. NC1977

    Microsoft Access Forms

    Hello all, I've got a list box on a form. When the user selects an item on the list, i wan't my other form to open with whatever was selected in my list box to appear in a text box.. I can get the form to open obviously, I just can't get it to show the item select in the text box...
  9. NC1977

    Need to open a form based on combo box selection

    Hi everyone, I have a combo box on my switchboard with a list of forms that can be opened. Once the user selects the form they need, I have a command button that opens the form. I've tried adding the if statement to my code, It doesn't seem to work: Private Sub Command134_Click() On Error...

Part and Inventory Search

Back
Top