Search results

  1. A

    Using a Checkbox In A Query

    Thanks. It now works!
  2. A

    Using a Checkbox In A Query

    I have created a query which search all fields in my database from one text box. Is it possible to search only records which have checkboxes ticked by ticking a checkbox on the search form/in the query. Thanks in advance
  3. A

    Problem With Creating Snapshot Files

    Access displays the message box saying it is printing the report. It completes, but no file is made and there are no error messages either!
  4. A

    Problem With Creating Snapshot Files

    Okay then. Thanks
  5. A

    Problem With Creating Snapshot Files

    For some reason, I can no longer create snapshot files of my Access reports. I used to be able to do it on my computer. I have downloaded the recent snapshot download from microsoft.com but have had no luck. Can anyone help? Thanks
  6. A

    Useful Links To Access Websites And Forums

    Thanks Bat17. I have added the links to the links page http://pcnnn.co.uk/portal/links_showall.asp?cat_id=4&parent_id=3&parent_name=Microsoft+Access&sub_name=Access Aden
  7. A

    Exporting Certian Fields

    Great, that worked. Thanks. Is there a way the export method can be done via a macro. I mean to open the export window??? :D
  8. A

    Report for Sales Invoice

    Sales Invoice Report Have you tried creating a query and in the Invoice Number field enter [Enter Invoice Number] in the criteria. Then base your report on the query. When you run the query a box should popup. Enter an invoice number and you should get the inoive for that number only.
  9. A

    Exporting Certian Fields

    This does work but it exports all fields in the table, where as i only want the first two.
  10. A

    Useful Links To Access Websites And Forums

    I am starting to add a list of useful Microsoft Access sites and forums to help beginners to Microsoft Access find what they need. If you have any useful links, then either post them below or send them to me via PM. I thought this would be a good place to ask as many people here know quite a...
  11. A

    Exporting Certian Fields

    I have tried the above but still get "" marks around the text. I need the text without these. Thanks
  12. A

    Exporting Certian Fields

    I have tried the output but it outputs the data as "USERNAME1|PASSWORD1" "USERNAME2|PASSWORD2" But i need it as USERNAME1|PASSWORD1 USERNAME2|PASSWORD2 I'm a bit stuck!
  13. A

    Exporting Certian Fields

    How do i do that then!!!
  14. A

    Exporting Certian Fields

    I have a table with the fields username, password, userlevel, blocked, name. I want to be able to export the fields username and password to a text file in the format of: USERNAME1|PASSWORD1 USERNAME2|PASSWORD2 USERNAME3|PASSWORD3 USERNAME4|PASSWORD4 Can anybody help me as i am not sure on...
  15. A

    Automatically Create Snapshot Reports

    Great. thanks. It works too!!!
  16. A

    Automatically Create Snapshot Reports

    Is there a way via code in a module to automatically create a snapshot of a report, save it in a specifed folder location in the code and save it as the current date as the file name when a button is clicked. I'm looking on how to do this as I have many reports to create, move to an intranet...
  17. A

    Help With Searching Database

    I have built a basic database to hold details on all my computer books and software as i hundereds of them. I have built a table with text, number and memo fields which i want to be able to search. What i would like is a form where you can enter details into various fields (eg Title, Author, a...
  18. A

    Help find related records.

    Hi I'm have created a video database with a genre field. Is there a way that when i click a button a list is displayed of all the records which are the same genre? Thanks Aden
  19. A

    Calaculations Two Weeks Before

    it doesn't seem to work. It finds the date two weeks from today but nothing inbetween.
  20. A

    Calaculations Two Weeks Before

    Hi, I have a table which contains many fields of which one is a date field. How would i create a query so that it shows every record which is between the date the query is run and two weeks from the day the query is run? Thanks
Back
Top Bottom