Search results

Ah HAH! I THOUGHT it would be something as simple as that. I KNEW I had a page break as the only control in my footer (one of the group footers) because I wanted a new page after each group. However, I experimented with closing the other groups around it and then it did not work at all, as if...

Thanks! That 1st part worked great! How can I get it to put in my username instead of Admin? I will try the Audit Trail later, after I finish a few other things with the database. Probably next week or so.

I have a report that prints is set to go to a new page at the footer of each item in a group. Is there a better way to do this so that I don't end up with that blank page with only the header & footer at the bottom of every report? I only want the report to start with a new page with every...

We have a database that we are sharing on a network How can I set up a table (or other method) that will automatically log when the database was last updated and who did it (the username). I would like to be able to run a report based on the modification dates of a particular user. Thanks in...

IIf over all records in group I have a report that is based on a query that generates multiple records for each individual, one for each training they have participated in. The data is normalized...there is only one record for each individual in the "name list" table, and one record for each...

Thanks! Thank you. I'll try that.

I have a database for which I would like to disguise a social security number (123-45-6789) with stars (***-**-****) in my form, but only for a group of people for whom "Employee status" is "Staff". The SSN will not be entered in this particular form, only viewed to double check for all...

Does anyone have any ideas? I am really down to the wire timewise. Thanks!

It is a calculated field whose name is unique to the report. [AdmissionDate] is a field in the table, and [txtAdmissionDate] is a field a grouper in the report that references [AdmissionDate] in the table. Thanks.

Can anyone offer any assistance? Thanks!

I am trying to write a report that graphs percentages over time. There are 6 required elements for each case, and I would like to graph the percentage of each element completed over all the admissions each day. I am able to do this one of two ways. 1. (Preferable, but I am not sure if it...

Each time I do a little more research and my statement gets simpler, but it STILL does not work. Now I have in my Date Footer: =Sum(IIf([indvSum]=1,1,0)) ([indvSum] is a field in the detail area) But it KEEPS prompting for [indvSum] when I run it. Why does it not recognize a field from...

Iif did not work either... On a whim, I tried =IIf([AdmissionDate]=[txtAdmissionDate] And [indvSum]=1,Count([txtCounter]),0) (txtCounter being a control that counts each line in the Detail section) However, it keeps asking me to enter "txtCounter" when I run the report. Please help!

I am trying to create a slightly complicated report from some very simple data. I have a database where we are documenting the date that each of 6 mandatory elements were completed on each patient admission. In my report, I am trying to display the number of cases that were missing x elements...

I have a form with a subform. I would like to make a field on the subform not visible if a field on the primary field is null. Can anyone help? Thanks.

I have a survey form that has the questions on a subform based on the response to one of the survey demographic questions (via a query based on that response). The answers to the questions are on a sub-sub form. How can I get the program to delete the answers that were entered (they are...

I don't mind saving it as text, I just want five leading 0s on every one. Actually, what I *really* want to do is just copy the darn rows directly into the correct table in my database, but my SSN field (000-00-0000) errors out every time I paste into it. I am trying to "cheat", by pasting it...

I have a table that I copy into daily from a shared Excel spreadsheet. I am trying to minimize the amount of touching up the data needs. What input mask should I use so that a field with four numbers...1234 (for example) will be converted to a nine-digit number with leading zeros (000001234)...

Works great. Thanks!

I have a form with a search box based on a Last Name field. How can I alter it to search by last name only: Jones OR last name AND first name with a comma in between: Jones, John Thanks for any suggestions!