Search results

I have a subform that contains two fields, date visited, # members in family I can add a new date visited and # in family entries, if I have the enough space defined for the subfrom, on the main form. When I reach the end of the defined subform space on the main form, I can't add any more data...

Alan, Thank you so much for your help. Your fix did the trick. I am still learning Access, could you please tell me where you found nz. How do you specify the format for a calculated field ie Length of 5 with 2 decimal places. Do you attach after name Total: (5,2) Do you know syntax. Thanks...

I did try that and even prefaced it with table name to be sure it new what table it came from no luck still error Thanks still trying to figure this out very weird.

I am trying to add 4 fields and get their TOTAL. The individual fields display the correct number, but the TOTAL of the fields is blank. Example Total: w + b + O + NA which is the expression in my query. One time the Total field showed #error W,B,O,NA are all defined as number fields in the...

Pat, Thanks so much for you help, I really appreciate it. I am new to Access and I am reading my manual as I go along. The system I wrote is for my church, which runs a Food Pantry, so a lot of people will be helped, thanks to your kindness. Thanks again, Jim

I split my database, putting the tables, backend, on a server and put a frontend, for each user, on their laptops to access the data. A glitch came up that requires a change to one of the table spec. I want to be able to prohibit a blank ClientId field from being written to a table. I...

The form opened is an update subform opened by a navigation tab. The subform has a combo box to select the client you wish to update. Changing the data entry to "yes" did not allow the client's fields to be filled by the record selected to be updated. When the update Client form is first...

It is very confusing to my users when they open a form and the fields have data in them from the first record of the database. Can this be suppressed as if it was a form for data entry? Any help will be greatly appreciated. Thanks, Jim

Paul, Thanks again. You are a very special person to be so helpful to a perfect stranger. My best wishes to you and your family. Email jimcb8 aol com

Paul, You are the best. It did worked just fine. I am so appreciative I can't begin to tell you. I really do wish we meet some day. I mean that sincerely. Either here in Asheville or Vegas. My offer still stands. I wonder if there is a way to exchange emails so we can keep in touch. I tried to...

Attached DB The query that uses to data in frmmonth and frmyear is Distinctfamiliesinmonth/year. MannaReport is the form that the user enters enters the month and year in the control frmmonth and frmyear which is on MannaReport Form. Hold the shift key down to open the db and bypass options...

Paul, In the following situation which format do I use? HomePage is the name of the Navagation form The tab called MannaReport point a form called MannaReport which has the two control text boxes where I enter the Month and Year. FRMMonth and FRMYear are the text box control names. I also...

Paul, Sorry to bother you again. I created a form like you instructed. Entered the Month and Year parameters Created a button in the form to run open the report The report ran great, the parameters where passed to the queries that are subreports to the main report.. The result were correct...

Paul, Thanks again for your help. You always seem to bail me out. I'm so grateful for your help. Being new to Access I can't tell you the stress I'm under. I am writing ths app for the Calvary Episcopal Food Pantry which feeds over 300 people each Saturday. All of my time is donated. Just...

Let me explain my problem further. I created a query that returns DISTINCT CLIENTID's for a given MONTH and YEAR. The 4 queries use these CLIENTID's to do calculatons. Since each of the four queries use this file in a join, Access generates the prompt for the MONTH and YEAR parameters. I'm...

I created 4 queries to supply the data for the report. Each query prompts for the same parameters MONTH and the YEAR desired, I did this so I could test each query individual. They work fine. Now the problem. Each of the above queries is a subreport so the user can see all of the answers...

Thank you so much for this solution pbaldy. I can't thank you enough. What does Count(*) do? When I looked it up in my testing it did not make sense. :) Jim

I have a field in a table called Race. I am trying to Count the number of record for each race in this field. It works fine for the first Race. Example Race Tablename COUNT "Latino" Then I run it and all is ok If I add another race next to the column above now my query has two columns):confused...