Search results

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...

Firstly only administrators can view this form (have that all sorted), The idea is to make it so that it reduces the chance of a user entering their information in incorrectly (using double entry - hence the two password fields), so long as those fields are identical when the update button is...

I have attached a screenshot of my table and my form. Hopefully it will make things clearer So, the user is able to edit the first and last names as well as the password field on the form. However, as soon as they have changed one piece of information on the form, this is updated in the table...

Is there anyway to update all of the information after the update button has been pressed? So for example, using your idea of the BeforeUpdate feature, is it possible to tell ms access to store the inputted value in the text box on the form but not in the table?

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"...

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...

The [Number Of Counties] field is derived from the [Operating County Name] field which is a text field consisting of multiple lookup values (all UK county names). Therefore if the [Operating County Name] field had "Cumbria, Essex, Hertfordshire" in it, the [Number Of Counties] field would...

Hi thank you for your reply, I will name my field with the expression I intend to insert: [County Cost] for example CompanyID, Company Name, Profile Cost, Operating County Name, Number Of Counties, County Cost 1, Company1, £20.00, [Cumbria, Essex], 2, £0.00 2, Company2, £60.00, [Berkshire...

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...