Search results

  1. H

    If Statement is true but the code in it is NOT running, please help!

    Thanks. Out of curiousity can you explain why my original why doesnt work a little more? I made another database that I basically had the same kind of code for and it worked. It looked like this: Code: If cboPSuct.Value = Null Then intPSuct = 0 Else intPSuct =...
  2. H

    If Statement is true but the code in it is NOT running, please help!

    I have a form that people often forget to select their name and area before submitting. So I'm trying to add code to just pop up a window saying you forgot to enter your info and exit the sub before submitting. But for some reason the code in my if statement is NOT running. I ran the break...
  3. H

    Switchboard to run code

    I did have the function as a seperate module but it wasnt working for whatever reason. You were right on with me using 2007 which didnt list the SetWarnings action in the macro design. I thought I even tried typing it in but must not of. I ended up going this route. Thanks a bunch
  4. H

    Switchboard to run code

    I'm having problems getting my switchboard button to run a function I created. I'm guessing its something in the way my code is written, the name or something I'm leaving out, but I'm not seeing it. If you have any idea please help me. I went through the switchboard manager and set the...
  5. H

    Selecting combo box values by the arrow keys

    I apologize if this has been asked before, I tried searching the forum but didnt see this particular issue. I have a number of combo boxes on a form and have set the tab indexes to tap through them in the order I want, but when I try to hit the down arrow to select a value in the list it moves...
  6. H

    Automatically list values from lookup list

    Yep, thats exactly what I was talking about. Thanks I have it workings like i want now.
  7. H

    Automatically list values from lookup list

    Is there a way to answer all the pop up questions before they actually get asked so it just runs through it without asking?
  8. H

    Automatically list values from lookup list

    I have 2 tables, one that stores contestant numbers (tblContestants, and Contestant Number is the PK) and one for an event the contestants participate in and get judged (tblCooling). tblCooling gets the contestant #'s from tblContestants but through a lookup combo box which I have to manually...
  9. H

    Multiple records with different values

    Whats the proper way to requery the recordsource? Everything I've tried has not worked.
  10. H

    Multiple records with different values

    Thanks guys, I thought it might be something related to bound/unbound but wasnt sure. I fixed it so everything is bound and its all working like I want. But now I'm trying to add a reset button to reset all the records to a default value. Is there something that selects all the records on a...
  11. H

    Multiple records with different values

    no, I dont have a subform. I attached a pic of what my form looks like maybe thatll help.
  12. H

    Multiple records with different values

    I'm making a database for a judging event and I've made a form that pulls all the contestants #'s from the table then has a bunch of combo boxes for each element of the event for the scoring. My problem is when I change the combo box for one element it changes it for all the contestants. How...
  13. H

    Make a hyperlink in a VBA created email

    With the message variable set to what I have above I keep getting a "Compile Error: Expected: End of Statement" error and the cursor goes to the M which is the directory I'm using. In case that means anything to you.
  14. H

    Make a hyperlink in a VBA created email

    I changed to the HTML email like hbrems suggested but my hyperlink still isnt working. I used your code and set the message variable to: message = "<HTML><BODY><P>irrelevant words<a href="M:\Engineering\Cooling Dev\ACE\Cooling Lab ACE\Cooling Lab New 5S\New 5S\5S Self-Scorecard.mdb"> Click...
  15. H

    Multiple recipients in same Access created email

    Thanks that worked great.
  16. H

    Multiple recipients in same Access created email

    I have this reminder form so when I run it it tells me who hasnt done thier monthly assessment then I click a button to send an reminder by email. But it does everyone seperately and I'd rather just send one email. Is there an easy way to put multiple recipients in a email created by Access...
  17. H

    Make a hyperlink in a VBA created email

    I have some code setup to send an email to people as a reminder to do do their monthly assessment, and in it I list the location of the database but I would like to make it a hyperlink instead. Below is an example of what I have, any easy ways to change it to a hyperlink? link =...
  18. H

    Make button accessible to users

    Thanks guys. Yea, I had the property of the actual report set to open in Report View but when using the switchboard to open it, it still open in Preview mode. I found that the switchboard had code in it to open the report in preview mode, I changed that to Report View and it works fine now...
  19. H

    Make button accessible to users

    I'm managing a database at work that has many users. When the users first open the database it opens to a switchboard, then they have some options of where they can go and what they can do. One of the options is viewing some reports. I want to have a button available to export the data to a...
  20. H

    Exporting to Excel issues

    Thanks vbaInet, I was able to get the transferspreadsheet method to work.
Back
Top Bottom