Recent content by jason_lee

Hi, you may have to create a group of complex VBA code in your forms to get the "Undo" you need. The record will be updated automatically when the focus move to another record in table, so if the subform is a continuous form or a datasheet, the above Undo code will not be able to work, even...

Hi, I have two questions about your sample, can each student have only one project? what the relation between "Judge Name" and "Project Name", one to one, one to many, many to many or nothing? regards

Hi, I tried to creat another sample according to your explanation, it is similar as the earlier one. actually it not a good sample, Because I don't know what real case you faced, there are a few design flaws. you did not answer the questions I asked. if you are able to post or email a sample...

Hi, I am not sure the design of your tables, is "JobID" a field (OR ONE OF PRI KEYS) in the table "Contract creation sheetID", or in the table "Contract update sheetID"? what are the relations between these tables? About "staff using and printing the documents", do you need a report about the...

Hi, Paul Almost everything can be done with VBA code in Access, but for this case, I think Pat is right, the design "each task ideally needs it's own table rather than have a table per team. " looks like a flaw, and then it leads to the problem you posted. So talking about why you choose that...

Hi, SmogTheCat You may have to creat something on the "on close" event in the detailed form. if the name of the "parent form" is "CustomerList", the code could be "forms!CustomerList.requery".

Hi, I don't know how you save the information about which customers a specific job has, there could be the third table in your case, which has two primary keys, job number ID and customer ID. Pls check the sample I posted.

Hi,Tommy By I know, this is not your wrong, crosstab query doesn't support the parameters (except viaing the dialog form you said), it's a limit of Access.