Recent content by bri822

  1. B

    Send email

    You may want to check your email settings. I have been playing around with sendobject, and I know when I don't have an email account set up that it would take me to a wizard. When I exited the wizard, it would give me the same error. So check your email settings. As for the information...
  2. B

    Storing a PDF in an access database

    Right now I am storing a pdf in a database by creating a link to the file. My problem is that my boss went to a presentation and looked stupid when none of these links worked since the files that were link were not there. He requested that I store the pdfs IN the database and not link them. I...
  3. B

    Compacting database not working

    I set my database to compact on close orginally, but it was taking a lot time since it was being run off a network and users start to complain. So I was looking at trying to compact the database by checking the file size when a user clicked exit. I have the checking down, just need to figure...
  4. B

    finding if certains keys are held down on click

    granted, that is an event. But the event I want to check on is the "on_click" event. So when someone clicks a button it checks to see if someone is holding down a key. I don't want to check is someone hit a key, until they actually click the button. sorry for being ambigous. Any information...
  5. B

    need some guidence

    1. The best place to find VBA/Access information is the library. This dicussion board also is a tremendous tool. I have learned alot from just reading other people's posts. And the WHERE statement you are talking about is more of an SQL statement, not a VB command. I know there is alittle...
  6. B

    saving record

    If you are closing your form, another way to save is: DoCmd.Close , , acSaveYes Upon closing your form it saves the data you entered, therefore you don't need to have a button
  7. B

    Storing images in Access?

    I can not say that I have had too much experience in this area, but what I would try would be this... Try stroing all your pictures in a certain directory on your computer. Store the location path to the corresponding photo in the table. Then, when you open up a record, have your "photo"...
  8. B

    finding if certains keys are held down on click

    I have tried to search the message board for this problem but I am not finding any information. My problem is relatively simple. When a user click and button, I want it to exit the application. If the user is holding down a certain key (almost any key would work) I want it to open up an...
  9. B

    Timing and controls on subform

    Thank you Mr. Morrison, Thank you so much for that information. That was exactly what I needed!! I had been looking all over and could not find anything that would solve my problem till now. Thank you very much, you are a life saver. Brian
  10. B

    Timing and controls on subform

    I have two problems right now that I have no idea how to solve. My project works like this... You fill in required information on NewJob form. This form is a continous subform. And then you click in AddWorkOrder button on the subform. This opens up a new form to add a work order. On the...
  11. B

    Changing a record in a table

    Thank you for explaining the error. I know that it definitely fits under the first one. I do have the record open in another form at the same time I am trying to update it. That makes sense. I guess I was thinking I could update the record and then maybe update the form. I guess my new...
  12. B

    Changing a record in a table

    I thought it would normally be a multi user issue. The only copy of the program is on my local computer. I am sure that no one else is using it or is logged in since no one else has a copy. I figured that it considered "someone else changing data" when I checked the check box after returning...
  13. B

    Changing a record in a table

    Right now I have two forms. One if a job information form that is really a continous subform on the main form, and I also have a seperate work order form. One the job form, there is a button to click to bring up the work order form. Also on the job form, there is a check box that is checked...
  14. B

    Updating Specific field in specific record

    Thank you very much for that idea. I never though about it. The only thing is that now I have a new problem. The subform with the check box is continous, and could have many copies contained within the form. I have been trying to play around with how to check just one of those subforms...
  15. B

    Updating Specific field in specific record

    Sorry I was not as descriptive as I should have been. The check box is more for the program knowing there is a work order. The user should never be allowed to click on it, infact right now it is disabled. I just don't want to have a work order, then have a user click it off or vice cersa...
Back
Top Bottom