Search results

  1. A

    Run Coomand as a macro

    reply I am using a Db developed by someone else. When the command button is clicked a file is exported and I want an auto e-mail to notify someone of the export. I thought a macro would work? thanks,
  2. A

    Run Coomand as a macro

    I have a button that will run command5 when cliked. How do I create a macro for this. I cannot seem to get it to work? thanks,.
  3. A

    Parsing and reporting

    Parsing and reporting I have a file in Access that will need to go to excel. Here are my two issues. 1. It is a keyword file which needs to list SKU with each keyword following it in the same row and each keyword in its own cell. Current: A1 B1 AA1 toys AA1 plastic Desired: A1 B1 C1...
  4. A

    create lookup table

    I would like to create a table, which contains keywords that may be contained in a SKU description field. Example: Product 1 - Description - A tool by magic that will enhance your business. I would like to create a query that would perform a lookup based on a table that will look for any of...
  5. A

    schedule a macro to run

    I cannot get this to run in the scheduler: "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE\network\Mrk04\MrktDB\brian.mdb\x mrcDaily Run" network = a location on the network thanks,
  6. A

    crystal reports 8.0 help needed!!

    I have never used this program. My help function does not install? I added a GM% formula field to a report, but it does not format the result as a percent?? How do I perform this? thanks,
  7. A

    schedule a macro to run

    response every morning at 8:00am (only once a day) I want a macro to automatically run. it imports a file renames files updates records runs queries and send reports via outlook right now I have to actually be at the PC and click my button to run the macro every day we need it to be...
  8. A

    schedule a macro to run

    form The docommand on my form does not work because it does not allow the buutons on my form to work. I believe auto exec works when the database is opened and I do not want this to run every time it opens. Only one time a day. thanks,
  9. A

    schedule a macro to run

    what about? my auto exec contains an 5 e-mails, I will not be in too prompt them? is there a way around this
  10. A

    schedule a macro to run

    something small my switchboard form never maximizes so I run an auto-exec
  11. A

    schedule a macro to run

    response I use autoexec for opening the DB. other thoughts?
  12. A

    schedule a macro to run

    I want a macro to run every day at 7:30am with no manual intervention. Can this be completed n Access?
  13. A

    formatting

    thanks so much worked great!
  14. A

    formatting

    03 Sq Inch: IIf(IsError(([03 Pg%]*71.25)),"",(([03 Pg%]*71.25))) Access will not let the output be formatted to two decimal places. any thoughts? thanks
  15. A

    nth selects

    help how do you do this in access - my files is email
  16. A

    nth selects

    help, I have a list of e-mails in an access database and I need to split up every other record into nth selects, can Access handle this? Example: List 1 List 2 Record Record 1 2 3 4...
  17. A

    Highlighting and keeping chmghes in a form

    help any other ideas are welcomed
  18. A

    Highlighting and keeping chmghes in a form

    Hello, I have a database where the user enters in data and then sends this data via e-mail as an excel attachment. This data can change up to thirty times and this results in thirty different versions of the data. I would like any data that is "changed" by the user to display in the Excel...
  19. A

    sharing access over a newtwork

    Yes I had that too. thanks though
  20. A

    sharing access over a newtwork

    that is what I did I did that already. Any other thoughts?
Back
Top Bottom