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

    How to use attachments with Access

    Hi, Got the code, only problem is, I dont want to send any emails, just add attachments to a form within Access. I'll see what I can figure out... Thanks, ~Clark
  2. cavery

    How to use attachments with Access

    So I would need to use Outlook, in order to make this happen? Hmmm, that will be tough, since we are only using Notes and Access 98. ~Clark
  3. cavery

    How to use attachments with Access

    Good Morning/Afternoon, Does anyone know how I can use the attachment feature, within a form in Access? I would like to give users a command button (similar to the paper clip in word) that would allow users the ability to attach documents ( such as word, excel etc.) to a form within Access...
  4. cavery

    @iserror and @dbcolumn, how to use both?

    Thank you, I'll see how that works! Clark ~Clark
  5. cavery

    @iserror and @dbcolumn, how to use both?

    Greetings, How can I use @iserror with @dbcolumn? Thanks for your help! ~Clark
  6. cavery

    How can I trap errors and write them to a file?

    HI, I'm using Access 97 and I want to trap errors (any standard error message) and write those error messages to a file (.ext or notepad in a specific shared drive). This would help me track and record the number of errors that occur in our business enviornment. In addition, read errors that...
  7. cavery

    How to backup database in Access automatically...

    Hello folks, Does anyone have software that can automatically backup files on a daily basis? Besides using the scheduler, there is a neat and most importantly free application that does exist, but I've lost the internet address. Thanks, Clark ~Clark
  8. cavery

    Help with creating auto stamp "confidential" on reports

    Mike, We have hundreds of reports and that would take days....I was trying to think of a short cut method for management. But we might just have to simply use a stamp on anything that is printed. Thanks, Clark ~Clark
  9. cavery

    Help with creating auto stamp "confidential" on reports

    Hello, Just as my subject stated, I am in the process of generating reports on Access 97 and I need to have the word "Confidential" stamped on any and all reports that are printed. Does anyone know of a program or code that can enable me to have this "confidential" stamp on...
  10. cavery

    Help with creating Error Trapping method.....

    Well I'm sort of lost on the last line, but here is what I have so far as code: Private Sub cmdappend_Click() On Error GoTo Err_cmdappend_Click (I have a few things here obviously, but didnt want to copy the entire cod) Exit_cmdappend_Click: Exit Sub Err_cmdappend_Click: MsgBox...
  11. cavery

    Help with creating Error Trapping method.....

    Hello, Does anyone know of a easy and simple method with creating a program that will capture errors and store them in a file? (either word, notepad, etc.) Currently my group is using Access 97... Thanks for your help, Clark ~Clark
  12. cavery

    Fed up with Access97! What are my options????

    Hello all, I'm a frustrated Access application developer and I'm now in the process of upgrading to a new, more powerful system. I currently have about 80,000 records with queries, forms, reports, etc. What are my options for upgrading to a new system, which can hold more volume and be more...
  13. cavery

    Need help/assistance with combo boxes remembering values....

    Actually I found my problem, I was resetting the values based on a duplicate dlookup....it works fine now. Thanks for all the help and suggestions! Clark ~Clark
  14. cavery

    Need help/assistance with combo boxes remembering values....

    I'm still having trouble with seeing the same model# appear after I change forms. I thought I would use the public variable before, so that was a simliar idea. But I wasnt using the bang (!) operator, thought that was the problem but it wasnt. I did place the code in the afterupdate property...
  15. cavery

    Need help/assistance with combo boxes remembering values....

    I have a combo box (cbomodel) that stores values of model names. When I toggle in between forms, I want the combo box to remember the last value that was selected, in order to maintain consistency with my users. So far I've used: If statement... strmodelold = me.cbomodelname else...
  16. cavery

    How does a form remember values in cbo box when new form is selected?

    Thanks for the reply, I tried to do something like this: Private Sub cboModelName_AfterUpdate() Forms.frmProbUpdate.cboModel = Me.cboModelName.OldValue But still receiving errors...I dont think I use the Docmd.Openform because I'm actually accessing the same form. Any suggestions? Thanks...
  17. cavery

    How does a form remember values in cbo box when new form is selected?

    Hello, Basically, I have a form (frmTest) that has a combo box with model names. If I select for example model A from the combo box, then push a command button to view another form, when I return back to my original form (frmtest), I would like the same model A to be displayed, so the user wont...
  18. cavery

    Hello, I have an Access database in

    Hello, I have an Access database in which upon logging in I have a pic (jpeg)displayed, this pic also changes to a new pic upon a user selecting a different model/picture. This pic is an OLE object that is converted from photo to picture to help reduce size of database. Is there an easier...
  19. cavery

    Does anyone know what's the fastest way to reference jpeg files??

    Hello, I have an Access database in which upon logging in I have a pic (jpeg)displayed, this pic also changes to a new pic upon a user selecting a different model. This pic is an OLE object that is converted from photo to picture to help reduce size of database. I have tried several different...

Part and Inventory Search

Back
Top