Search results

  1. A

    Appointment Scheduler

    hi ive just started something like this and i was wondering where u guys got to? the thing i want to do is something similar to the sample appointment but i would like it looking more like a journal in outlook. To prevent double booking all you need to do is make sure the time entered doesnt...
  2. A

    Creating Diaries/journal in Access?

    has anyone created a diary in microsoft access or heard of anyone who has? I want to make a diary of appointments for certain people so when someone is making an appointment they can assign whatever rep is free for whatever time. Is this possible to have it layed out like a journal in say...
  3. A

    Multiply Users using same database?

    hI i was wondering if anyone can tell me if its possible to have several users accessing the same database, adding records, deleting them all at once? Ive never tried this before because ive only ever created databases for one user?
  4. A

    RegEx on TextField?

    Ah you are checking the first character to see if its W or C. Thanks i will test it when i get back home!
  5. A

    RegEx on TextField?

    regular expression they are ideal for checking strings/text
  6. A

    RegEx on TextField?

    Is it possible to use a regex in Access on a text field? i want to allow... L000000 A letter and 6 numbers the letter can ONLY be W or C then any numbers after? How would i do that in access? would i need to use substring? even so regex in access would be fine ;)
  7. A

    Row Counter?

    much appreciated thanks
  8. A

    Row Counter?

    How do i count the number of rows in a report?
  9. A

    Execute another procedure

    How do i execute another procedure inside a procedure? Cheers
  10. A

    Filter Results based on input?

    here is the test i just want it to create a query based on employee name in the SALES table. You see atm im using full name
  11. A

    Filter Results based on input?

    i will create you a sample table. But atm my two tables are NOT using a relationship, i'm using a query to lookup information, could that be a problem?
  12. A

    Filter Results based on input?

    I tried the combo box idea but the query doesnt pick up the value of the combo box. Same goes for start date and end date. is it possible to provide a database example?
  13. A

    returning strange values?

    I was playing around with that then i thought scrap it and try the ms access wizard. I think it auto joined them for me and the query works fine now :)
  14. A

    Filter Results based on input?

    Atm i have a Query which will display all values in a table within a given date range. I was wondering instead of displaying all values how do i filter the results to ONLY show the ones i want them to show. For example: Filter them by Rep called bill Jones? (user inputts whatever bill jones was...
  15. A

    returning strange values?

    How would i get a simple display everything in sales? when i tried to display * it gave me 6840 records when there are only 3 enteries in the sales table
  16. A

    saving data just like control source?

    woohoo it works cheers
  17. A

    returning strange values?

    I am having a problem with one of my queries, the problem i'm having it seems to be returning the same value 3 times and other values overwrite themselves. Ive attatched a image because i cant really explain it. Can anyone help? Here is the SQL: SELECT Customers.FirstName...
  18. A

    Reports based on start and end date?

    managed to get it working Between [Start Date] And [End Date] thats what was needed :)
  19. A

    Reports based on start and end date?

    Between #[Start Date?]# and #[End Date?]# Doesnt work
  20. A

    Reset Auto Number?

    Does anyone know how to reset auto number?
    • A|ex
    • Thread
    • Replies: 0
    • Forum: Tables
Back
Top Bottom