Search results

Do I need to declare a variable in the general module if I want to access it in different modules / forms? ~RLG

It worked - yea!!! (I had to also move the declaration for the gloProgID to the general module.) Thanks so much for your help! ~RLG

Hi Bob, Thanks for taking a look at this. Not knowing the best place to put the function, I put it in the UserIdentification code but I created it as Public so I thought it would be ok. When I ran it, the following error occurred: Undefined function 'RetGlobal' in expression So then I...

I am using Access 2007. I am also a very new Access programmer. I have a UserIdentification form that saves in a global variable the users' programID. I would like to use that global variable in the Select statement on the next form to select only those patients involved in the same program...

Hi~ No, I don't need to store the concatenated fields, I just want to display the whole name in the combobox once it is selected. But your questions got me to thinking and experimenting. Since I put the concatenated field in my query, I changed the number in Column Count and the Column Widths...

I need to do this too. My combobox is based on an SQL statement (not a stored query). I added the FullName field as you outlined to my SQL statement. Where do I add the FullName in the Property Sheet? I tried putting it in the Control Source but then the combobox quit qorking. It drops...

Cool! I'll chew on that for a while and see what I come up with. If I get stuck, I'll start another thread. Thanks again!! ~RLG

Oh, be assured, I'll be back. I am an extreme newbie to Access and this project is very complex. But I am learning a lot and having fun, thanks to forums like this that help me work through my ignorance. The next step is to take the ProgramID and have it drive what forms are displayed. That...

Awesome, awesome. awesome!!!!! It worked. And it was so simple. I added the ProgramUserXRef table to the User table in the SQL stmt on the combobox so that I had available to me the programID. Put in the after Update event a variation of your code: Me!optProgramID.DefaultValue =...

I am working in Access 2007. And I am an extreme newbie to Access. I have 3 tables: User ID FirstName LastName Program ID ProgramName ProgramUserXRef ID UserID ProgID My form consists of an unbound ComboBox whose Row Source is the User table. I added an Option group that displays the...

Hello to you too! I am not doing too much Access at the moment but yes, this has been a very helpful forum and I expect to be using it again in the very near future.

Thank you. And to you too!

Oh brother!!! :o That's it. I changed the % to a @ and it works. I took out the InStr and it still works. {@Results 2} = " "; There is also a SQL Expression Field called Results 2 and I got them mixed up (the SQL Expressions Fields are referenced with a %). I am rusty on my Crystal too...

Hi Bob, I totally agree with you about not creating objects with spaces in the name. I inherited this report :rolleyes:. At this point I am still figuring out how it works and I don't want to take the chance of breaking it by renaming the formula. That being said, I tried the InStr function...

I am trying to suppress the detail line on my report but nothing I have tried has worked. There is a field on my report called @Results 2 which looks like this: If {Observe.Obs_Float} <> 0 Then CStr ({Observe.Obs_Float}) Else If {Observe.Obs_Choice} <> 0 Then CStr...

Hey khalakmu ~ That was perfect! Thank you for answering my question. Have a great day.

I figured it out: I added another detail line, put my subreport in that detail line then in the Section Expert, on the Detail section, I clicked on the Keep Together (I also clicked on the Keep Together on both the detail a and detail b section but I'm not sure it was needed). Works like a...

In my report I have a detail section that includes a subreport. The data in the detail is patient info such as patient id, name, doctor, etc. In the subreport are the diagnosis which could be 1 to many. Is there a way to keep the detail and subreport together at the end of page? Right now, when...

Is there a way to manually control how the legend appears? I have a chart that appears on every page of the report. On some pages the legend is larger than on other pages. See the attached images. I've tried pulling and pushing but nothing seems to work. In fact if I play with it too much...

I don't know if you figured out a solution to your problem or not but here is a suggestion: Go into the Section Expert on the detail line. Click the x+2 button next to the Suppress option. Choose a field that would have data in it and write a formula something like this: {employee} <> ' ' Save...