Search results

I am having trouble working out how to change the row source of a combo box based on the value of a text box. I have 2 controls - txtCurrentStatus is a text box and cboNewStatus is a combo box. I would like to change the row source of cboNewStatus based on the value of txtCurrentStatus, for...

Hi I have a main form (frmIncidentLog) which holds details of all incident calls raised to our system providers. Within this form I have a subform (frmIncidentUpdates) which holds incident call status updates which are added to every 3 days. The subform contains the fields UpdateDate and...

Hi I have a listbox with 5 options and 5 controls which are enabled/disabled based on the selection from this listbox. What I need to do is clear any data entered into the 5 controls for a record each time the selection from the listbox is changed. Sounds simple, but I am having difficulty...

Right. I have finally got around to writing a module to automatically update a user's Front End each time the Database is opened - this was the best approach for me as new queries are requested on a regular basis. When the Database is opened, an AutoExec macro is run, which runs an...

Hi I have a Command Button in my Database that when pressed runs a macro that runs a set of queries and then a number of automated emails to different recipients based on the results of the queries. With a team of only a few people that perform this action, you would think that we would be...

Hi I have macros attached to command buttons that run a selection of Delete and Append queries before an export is performed. I was wondering if there is a way to bypass the Access warning messages while selecting the positive action 'Yes'? I also have another command button that sends...

Hi Is there any way to export the results of two Crosstab queries into a single Excel Worksheet, specifying destinations for each fields result using VBA? I am looking at placing the code in a buttons On_Click event so that the user doesn't have to manually copy the results into the...

Hi I am having some difficulty adding some validation rules to a few fields in a form and would be very grateful for any help/advice. Here is what I am trying to achieve:- Test Start Date >= Project Start Date AND <= Project Finish Date AND Cannot be Null when Test Status (list box)...