Search results

  1. W

    Code to save record Help

    I placed this code in the before event property for most of my forms. Before i close the form this code prompts whether you wish to save the new record. Private Sub Form_BeforeUpdate(Cancel As Integer) Dim Msg, Style, Title, MyString, Response If Not Confirm Then Beep Msg = "Do you wish to...
  2. W

    Module to delete record

    I would like to create a module which will run a delete query and when the query is run i would like to show the message "Are you sure you would like to delete this record" and options Yes/No This module will then be put on a macro so when i click on the button "OK" the module will be run Any...
  3. W

    open mail merge document

    With my macro how do i get it to open my mail merge document and then automatically print it out If it cannot be done with a macro then VB would be fine THANK YOU
  4. W

    Make sure record is not added when the MoneyOwed value in another table is not 0

    i am currently working on a video rental database How do i make sure that no member who owes money makes a loan Below are the fields in my 2 tables. A loan is made through the form "frmAddNewLoan". The two table are related via the field MemberId. The field MoneyOwed is a currency field, not a...
  5. W

    VB to automate a procedure

    I would like to use some VB to automate a certain procedure. I am currently working on a movie rental database. In the table tblTitleCopy I have the fields CopyId, TitleId, DatePurchased and Damaged Below pic is example of some data in the table As you can see there are 6 different CopyId...
  6. W

    Display only last record in a certain table

    With this query i would like only to display the last record in a certain table. How would i do that. I have tried to use the totals to show the last record but it doesn't work because i have calculations in my query. Any suggestions THANK YOU
  7. W

    How to requery data on a form automatically

    I am having trouble with forms When i change data in a form and run an update query, the query does not recognise these changes and updates the wrong number of fields because of this. How do i resolve this problem so that when i update any data on the form it refreshs itself and so the query can...
  8. W

    Password protecting a single form

    i have placed a password on a number of forms. How it works is i have a sort of main menu with a number of buttons on them to open a number of forms. When i click on the button it asks me for a password then opens the form Here is the code for my form "frmEditMemberDetails". On the form...
  9. W

    Help with message boxes

    I have a macro which runs four update queries, which means that when it is run four update messages appear (you are about to update ... rows etc. etc.). How do i stop access from displaying these prompts and just update the records. Any suggestion such as VB would be appreciated. If there are no...
  10. W

    Find data not found in another table

    How do you find data that is not found in another table, for example, a video rental shop, a member that has not made a loan, the member's details not found on the loan table. How do i find those members using a query. I thought it had something to do with Null searches but it didn't work...
Back
Top Bottom