Search results

  1. X

    Deleting file based on date

    So I currently have a module which automatically backs up my database to a separate file everyday on open of my database. If is it possible to create a function which will allow me to delete these backups after a certain amount of days (eg 30 days). They all have different file names based on...
  2. X

    Update table data with a button

    Hi, I have had a search of the forums and cant find exactly what I need. I may have just missed it? So, I have a form [frmmembers] which will enable the table [tblmembers] to be updated when a button is pressed. When the button is pressed, it will enable the fields "First Name", "Last Name"...
  3. X

    Equate input with table value

    Hi, I have a problem, At the moment, I cant get past the first step of my macro. Is this syntax correct please? If [txtmemberID2] = [tblmembers]![MemberID] Then txtmemberID2 = the box which the user will enter their data MemberID = the field in the table I wish to check the inputted data...
  4. X

    Using the COUNT with an iif statement

    Hi, im new here and this is my first post, Im having trouble trying to get a part of my query to work. So far, I have 5 working fields. These are: CompanyID, Company Name, Profile Costs, Operating County Name, and Number of Counties The 'Operating County Name' field uses "Expression" in the...
Top Bottom