Search results

Hey Dave, Thanks for your response! I don't know how to do this so it isn't likely that this lock exists. I have compared all the property sheet line items for this one to a subform that works and can't see any difference. Would the problem be with the form or the combo box? I have looked...

Good morning, Good suggestion. I did that then clicked on the button that opens an existing record. It gave me a Cannot Return without GoSub (or something like that). So I opened VB and ran the compile (which is what has worked in the past to fix that error). When I open an existing record...

I am working in Access 2007. I have a main form that has a tabbed page with several subforms. On the first tab is one subform that has a combo box and a text field. When the user enters data into this subform, a record is written to tblActivities. tblActivities has 4 fields: AID (PK) ~~...

LOL! You are right :D. I am off on another project right now but wanted to let you know that I got your post. I will try it as soon as I am able and post a reply. Have a good weekend! ~RLG

I am using Access 2007. I have the following table created by a query: ProgramName Territory PatientName PatientID Date Ethnicity Race I need to create a report that is grouped by ProgramName, then Territory (which is either 'rural' or 'urban'). Something like this: Race...

Thanks, John for your reply. I had changed that property. But I found where the problem was. The person who wrote this put requerys for all the subforms on the On Current event of the first subform in the tab list. Of course none of those automatically changed when I re-named the subforms...

I am using Access 2007. I am reorganizing a db giving the subforms more descriptive names. I renamed sfrmPartnerActivity to sfrmEventPartner. Now I get this message when ever I open the main form: I have looked everywhere I can think of and can't find where this reference is being made. I...

Thank you both! The double ampersand works (of course!). And yes, I was seeing the underscore in place of the '&' when I was just using one. Thanks!! ~RLG

I am using Access 2007. I would like to put an '&' in the Form Header of my subform. Something like this: Fundraising & Offsetting Revenue But I keep getting this error: I have tried double quotes around it, single quotes around it and preceding it with a '\' and nothing works. Is there...

I had a similar question (if I understand your question correctly) and found this link in another post. Maybe it will help your situation: http://www.baldyweb.com/Autofill.htm ~RLG

I can't speak for the one who posted the question but it was exactly what I was looking for! Thanks. ~RLG

I am working in Access 2007. I have a Main Switchboard form that lists all the records in an Event table. The purpose of this form is to show, at a glance, all the events. The only fields it shows is the EventName, startDate, endDate, and City. There is a command button that can be clicked to...

Hi John, This is exactly what I am looking for! I followed the link (making the necessary changes for my situation). When I ran it, I got an Error 3071: I am new to Access and don't know how to debug the code. How can I find out what command is wrong and what is in it? TIA! ~RLG

I think I found the answer to my question - List Box! I am reading up on it now and will be back if I get stuck. Thanks! ~RLG

I am using Access 2007. Is there a way to choose multiple values from one combo box? I am working on a report and the user wants to be able to select one disease or several diseases and see the patients that have the disease selected (the multiple disease selection is an -OR- situation). I...

I am very thankful for this forum also. I am sure I will be back with more questions in the future! ~RLG

Perfect!!!! This is just what I was looking for. Thank you so much! ~RLG

I am working in Access 2007. I have a splash form that allows users to identify themselves and select a program (type of cancer); each user defaults to a particular program but can select a different one. When they press OK, a Menu form displays. This form contains many buttons - mostly to...

Thank you, Lightwave. Yes, I understand that. This was a split database that I was updating with a split database :D.

Hi John, Yes, it's just the front-end that was larger before than after. I don't do anything with images and I don't "compact on exit". I assumed that GinaWhipp meant that the FE can increase in size due to queries and such. I'll keep an eye on it and see if I notice any growth as days go...