Search results

Stopher, the link you provided doesn't seem to work. I try again, in case the problem is temporary, but would you know an alternative source for the same information? thanks.

Thanks to both of you. I'll check it out--and I will change the grouping to the ID.

Greetings, all-- I am running a report that is grouped by a field (in this case, patient name). Data for multiple patients will be printed at a time, with each new patient starting on a new page and a patient possibly filling 2 or 3 pages or more. I would like to use page numbers specific to...

Thanks for your response. It was a permissioning issue. Paul

Greetings, all- I am getting a 2467 runtime error when opening a form with a subform (multple subforms, in fact) with dynamic Record Source properties. I am using Acess 2003 opened in 2007 as I am using user-level security. When I log in as myself (with administrative privileges) I don't...

Thank you both for your responses which were both helpful. I was able to get it to work.

Hi, all-- I am wanting to have the RowSource property of a subform control change based on the currentuser so that the use can only select one item in a control box. I thought I could use the following code: If Application.CurrentUser = "JSmith" Then...

Thank you all for your replies. Galaxiom, it seems we are in sync with what we are trying to do here. Thank you very much with what you provided. It was very helpful and I'll explore it for providing a solution to my situation. Happy holidays to all! paul

Thanks for your responses. The security certificate may be the way to go although this wouldn't be for code. This is for a database that stores medical records, such as progress notes and we would want to authenticate and secure the information. I know PDF forms has a digital id feature...

Greetings, all-- Is there a way in Access 2007 where one can had a field used to contain a digital signature or ID that will authenticate a record? I'm not talking about having a pgf of a signature that could be contained in the field, but a system that allows for the authenticity of the...

Yes--the form is a series of buttons that open queries that utilize one or both of the form parameter fields.

Thanks for your post, although I'm not sure what you mean. I found, though, that if upon opening the form, I have an event that clears the fields (txtField = ""), the problem seems to be solved. Thanks.

I'm using A2007. I created a menu form to generate multiple queries that includes start date and end date parameter fields. Twice now, I have found that when running a query from the menu, I get a pop-up window as if no dates had been entered in the parameter fields, even though they had been...

Hi, all-- I see a similar problem to mine has been discussed but the specifics are different. A user of my database is getting the "Readonly: This database has been opened read only." and then goes on about only being able to change data to linked tables and saving new copy to do more. I am...

Thanks for your modifications. It is what I want. Paul

The third combobox isn't relevent to the problem so I didn't include it or mention it. It's just the two initial comboboxes. Sorry for any confusion. I made this quickly to include in this thread so I didn't cross all the "t"s or dot all the "i"s. The issues you mention aren't relevent to...

Attached is the components of the database (A2K) in question. I have it that the refreshing occurs in the second (Dose per Unit) field in the "enter" event. Thanks.

I have a form with two comboboxs where I want the value of the first to indicate the list options of the second. This form is viewed as a datasheet. I have found that if doing an "after update" refresh event in the first field, any values in the second field for previously entered records...

When trying to use functions that calculate the median (which I found through this forum), I was getting a "Too Few Parameters. Expected 1" error. As the query which is to use the median function itself queries a parameter query, I thought that was the problem so I tried declaring that query...

This has been a very helpful post--thanks! I'm getting a "Too Few Parameters.Expected 1" error when I run the code on my own database. I am using a parameter for a query that my current query (used to calculate the median) is based on. The field in question itself is a calculated field...