Search results

I've created a report which groups on a court date by month I would like to create a running total for each court date by month, but when I create a footer for the court date and add the count(*) it totals by the actual date rather than month! Any help would be appreciated (again) Lorraine

I have the following code in a report. Private Sub Report_Close() Dim Msg, Style, Title, Response Msg = "Did you want to save this document to word?" Style = vbYesNo + vbExclamation Title = "Save to Word?" Response = MsgBox(Msg, Style, Title) If Response = vbYes Then DoCmd.CancelEvent Else...

This is the code I am using on the exit event in a control Forms![frmNewRecord]![frmNewSubRecord].Form![frmRecord/ProposalLink].Form![Code].SetFocus I want to tab through subforms. I have a main form - frmNewRecord Subform - frmnewsubrecord then on the subform I have 2 further subforms -...

The answer to this is probably staring me in the face! I have a main form which opens a subform through a cmd button. I would like the subform to open in datasheet view if it has any data and in normal view if there is no data. I've tried numerous differnet ways but A2K keeps chucking them...

I have 4 sub forms (frmPartC1, 2 etc) which basically hold the same data, all the fields are the same but default values are different depending upon which Main form opens the subform. Is there anyway I can write some code that would set a default value in the subform dependant upon which...

Hi I have a form with five subforms. If the user tries to enter any data in the subform without having created a record in the main form the error "Index or Primary key can't contain a Null Value" appears. How can I set up a user friendly message to stop this from happening and sen the user...

Hopefully someone can help me with this small problem I have an unbound text box on a form. I want it to show either 'Junior', 'Adult' or 'Retired' depending on the dob of the client. I've tried different solutions but nothing seems to work properly. Any help woulr be appreciated Thanx in...

I have a table which contains details of contacts with clients, ie letter/emails. If it is possible I would like to be able to click on the record of contact which is viewed in a subform, and for Access2000 to open this letter which corresponds Also, the user requires this to be done...

I have a from which shows details of a client It contains 2 unique fields ClientId and Account Id. I need to open a new form with details of an order based on these particualar fields. I've tried a form based on a query which will work but only if you input the ClientId and AccountId through a...

Can any body tell me if I'm wasting my time? I want to create a form linking 5 tables, can I do this using the wizard, so far every time I've tried the form just comes up blank!! Ta

In my previous dealings with access, whenever I have amended a table, ie added an input mask, the form I have previously created based on that table does not recognise the new change. How do I get the form to recognise the changes without having to create a new form? I hope I have made myself...