Search results

I have create a Form with two combo boxes in it to update a table... I have two fields both are combo boxes... the first combo box sets the high level value... the second is based on a query that filters from the high level value and re-queries the form... my problem is the second combo box...

I would like to check that a record exists in a table when a user enters data into 2 fields on a form... it is travel database, it has a table called "travel_places" which has 3 fields called "travel_from", "travel_to" and "distance" on the from the user has 2 drop down combo boxes, the user...

I want to be able to create a table that contains all the database objects by name, created date and modify date... is there a way of doing this... or is there another way to achieve what I am trying to do... I have tried to use the following code my it does not pick up all objects or names...

I am trying to find out when a user enters an account number and account name into a from, I want to be able to see if these details are held against and old table called old account number or old account name, if it does I what to flag a record to indicate that this is the case. Does anyone...

I am trying to stop an excel process after working excel through access 2003... it does not seem to matter what I try to do an instace of excel stays running... canyone suggest what I maybe doing wrong here is my code: >>>code start>>>> Function transfer_aga_corps_data() On Error GoTo...

I am trying to update a field when a user select a record from a combo box... but I do think I have over complicated it... I want to update the date when the record = two types of members and any other it has a null date... I have but this on the after update property of the control...

I have some code that does the following: kills a spreadsheet if it exists, opens a template, save as a worksheet, transfer data to it, opens the spreadseet, runs a macro then I save it... I am using the following to save the spreadsheet: xlBook.SaveAs DirPath & xlsfname xlBook.Close I...

Link Outlook contacts to an Access database with User Define Fields Office 2003... Does anyone know how to include user define fields from outlook appointments into Access... Regards

I have a form with a check box control on it and a pick list text box. What I looking for is when the user checks the check box, I want to display a message or tool tip to inform the user to ensure that the correct membeship type has been selected from the pick list, (this has a default...

I want to disable a tab control page when a form is open, and enable some of the fields if a check box is checked, and some others if another check box is enabled Can anyone help. Paul R

I would like to add to my form the ability to right mouse click to print a report, is it possible to achive this and if how can I. Regards - Paul

I want to run a macro without opening a database: I have a Back-end and Front-end database, I want a macro in the backend to run to collect data from a number of sources, so that data is refresh daily is there a way of achieving this, or can I create a procedure when the Front-end opens that a...

I have a membership database with over 1700 records held in it, I want to print a membership card for each member each year here is my problem: I want to print a selection of records i.e. abc, def etc. I want to mark records that have had the card printed for this year. I want to be able to...

I am trying to delete records from a temp table using the following code. CurrentDb().Execute "Delete * From tbl_temp_bank_statement Where [Original_Member_Number]= '" & Me![ListBoxGarther] & "'" This does not work I get the following error. Data type mismatch in criteria expression. (Error...

I have a form with two list boxes in it. When a user double clicks a name in the left hand list box, that name is then place in the right hand box. I am trying to allow the user to remove that name if a mistake has been made. The code I am using is below. Private Sub...

I have a form with a combo box that list membership numbers, once a user has selected a member details are displayed. Once the user has updated the record I would like to reset the combo box back to null. How do I do this? :confused:

I am trying to update a table after a form is printed for members of a club. The Table I am trying to update has two fields, 1 is membership card printed, and is a yes/no field. The other is membership card printed date, which is a date field. I have a criteria that I have set to stOption...