Search results

  1. Z

    Open Word Document from Form

    I would like a button on my form to open an already existing word document... How do i do this? In either VBA or Macro? Thank you
  2. Z

    Exporting Query inform

    How do you export query results to outlook for processing?
  3. Z

    Rounding Calculations with dates

    LengthDaysOverDue: Now()-[DueDate] Hello I'm trying to round this up to full numbers in my query however i cannot get it work, Can any one shed any light on how to round this calculation to whole numbers? Thank you
  4. Z

    Suggestions need for best way to Mail Merge

    Hello, I wish to create a button on a form that will link to data in a table and create mail merge, or link to an existing mail merge document, what is the best way to do this? Thank you
  5. Z

    Correct IIF statement needed please

    Hello, What is the correct way to state an IIF statement for this.. (in a query) I have a field called "DueDate" (i.e. the duedate return of rental) And i want to say if todays (now()) is greater than due date then ... Yes I cant seem to figure it out, any help would be more than great at always
  6. Z

    Format Query

    Hello, Am trying to do a simple Format summing query to calculate yearly, (then monthy and weekly) sales totals. I seem to have failed, can someone please check the pictures to see where ive gone wrong please? Pic 1 is my query and i am trying to run and pic 2 is the outcome. Thank you very much
  7. Z

    Help needed

    Hello, This may be an odd question, but can anyone help me with a simple access database, its for uni. I have 6 books infront of me and time after time I am getting wrong. Or it works then it comes up with an error out of the blue. I was wondering if anyone knew of a service or someone i can...
  8. Z

    ComboBox wont populate rest of fields in Form when viewing on Data Entry

    Hello, I wish to ask another question of you if i may. I have a combobox that is used to "find a value on a form" (created through wizard). Now with Data Entry mode off this works, changes and updates, however, with entry mode on (as i need it to be) it doesnt work.. Anyone have any ideas for...
  9. Z

    Hello!

    I am new here and looking for some help on a simple Database! If anyone can help i'll be incredibly thankful
  10. Z

    Error 3341 - please help

    Hello, I have three tables StockList CustomerDetails HireHistory Of which i have created a query based form to issue the rental i.e. to select customer number and to select rental code and therefore issue rental however i have a error code come up saying "The current field must match the...
  11. Z

    Calculated fields created in form view to update a table

    Hello, How do I get calculated fields created in a form to update a table? Any help would be great Thank you
  12. Z

    DLookUp problem (new to Access)

    New to Access, and ran into an issue when I tried to create a DLookUp for an Issue form I've made. I am trying to get it so that when the RentalCode for a product is updated all of the other information on the form will be filled in accordingly (in this case, stock rental table information). My...
Top Bottom