Search results

Thnks but I tried this before I asked for more help and it didn't work. Itried sorting the data and ading verious things to it but it still didn't work. I will give it a few ours of my time and if it doesn't work, then I will forget it. I don't think it is possible neither, but nothing beats...

Hi IMO, I tried what you suggested but DMin and DMax returns the same values on all pages. DMin returns 19 for the first and every other page and DMax return 19 on the first and every other page. However when I make the count textbox visible to check that is is working, everythiny is fine...

I have tried the following to get e.g. 1 to 30 of 200 Records but it does not work. Any sggestions =(DMin("[Count]","ClientContacttbl")) & “ “ & “of” & (DMax("[Count]","ClientContacttbl")) & (DCount("[ClientID]","ClientContacttbl") & " " & "Records")) to

I do not understand what you mean from the create min/max function part of your instructions. Greatly appreciated if you could simplify. Thanks very much

Thanks, Thanks, Thanks, IMO that worked fine. However is it possible to put Record X to Y of Z per report page. Thank you ever so much your help is greatly appreciated.

I have created a diary in Access but I need some assistance. I created a form called frmDiaryPlanner which consist of 24 fields named 0700, 0730, 0800, 0830...1930 respectively. On DOUBLECLICK on any of the fields, a form called frmDiary opens. I want the subject field on this form to equal...

Thanks, I tried that but it did not work. I tried =Count(*) =Count([ClientID]) =Count[ClientID] But none of the above worked

I have created several reports, but I am faced with what may be a difficult task. I need the report to return the number of records in the "clients list report" footer, like you return the number of pages. Can anyone help, it this possible?

Thanks, in the mean time I am still working on it. I have made a little progres. At present I am trying to insert a clock that will activate the timer and hence implement the reminder.

Please find attached a copy of what I have done so far. What I am trying to achieve is a system that reminds you of an appointment 5 minutes before the time. I am not sure if I can achieve this but I am trying. Any help is greatly appreciated. If you click into the time on the daily...

I think I may have placed the code in the wrong place. Did you see the form i attached? I want the reminder popup form to open on double click (per times). the control for each time span will have the subject and the popup form (which will also be used as the reminder form) will have details...

I have tried what you suggested but it's not working. EventStatus on your sample refers to what exactly? Please find attached a sample of what i want my form to look like.

Does anyone know how to grey out a selected date if you have the field index set to Yes (No Duplicates)? I need an already selected date to be greyed out so users can't select it. Any help would be greatly appreciated.

Is it possible to create a diary to log all appointments, thus creating reminders in MSAccess? something similar to the claendar in MsOutlook.

I got it to work. I simply changed my record source and rebuilt the forms. It works a charm.

I am dealing with 3 forms. How do I make JobNo on the master form = JobNoon the passwordDialog form and then to make JobNo on the paswordDialog = JobNo on the PaymentUpdate form. I have tried it in everyway possible but it just wont'word. I get a name error on the passworddailog form for JobNo.

I do not understand what you are asking. I have a form called jobsheet and on that form I have a command button, which when pressed opens a password dialog form. I think what I need is to make jobNo on the Jobsheet form = Jobno on the password dialog so that the ok will check that the JobNo on...

I am trying to open a subform/popup form to allow only a manage to update payment mistakes. I am using a command button to open the popup form. I can successfully open the popup form showing the current job being dealt with if I have no password dialog. However, if I password protest the...