Search results

Beautiful. Thanks for the insight. Eric

Is this possible to do? For example my form name is frmBogus Field name is fldBogus. So normally I would reference its properties like this: [Forms]![frmBogus]![fldBogus].SetFocus Would it be possible to reference these properties with varibles? Example: Dim stFormName As String Dim...

Thank you for the reply. The problem however isn't with the report, It's with the chart. I'm trying to get the chart to filter in the way that you said above. Maybe you're meaning this and I just missed it. Is this possible? Eric

I'm trying to get the criteria for a chart to come from a form. In a form the user can select the report they won't to run and the other parameters. Instead of doing this through a parameter query I won't it to pass via string criteria (example: strItems = Me.AFENumber.Value 'Use the value...

Would a smaller font work here? Maybe I'm missing the idea of what you want. Eric

Try this...

OK...Sorry I'm not understanding fully what you're wanting then. What is the purpose of this textbox? Are you just wanting a pop up that when the user opens the report they can type something in and whatever they type appears on the report header, but doesn't filter the report?

Did you get it to work? It is an A2K version. If you did what problems are you having with it? If the user types something in it will put what they typed in the box on the report header. Eric

Try this see if it's what you want. Clicking "OK" without typing any text will return all records. Eric

Haha! Thanks Pat, that was the trick. I'm grateful for your hard work on that. Not that it was hard for YOU. I'll start using non-spaced names from here on out as well. Thanks, Eric

Query not working... First Mark on the database you sent me...I appreciate the attempt, I don't want to just push that aside, but it seems like I would have to enter everyone's name in the attendance list for each event. The way I want to do it, is enter the people who showed up only and check...

Uh Oh! I was working in one of my forms and I closed it and said I didn't won't to save it. Well I lost all the code for that form. Is there any way to get it back? Oh well if not, right. Pat, yes everyone is invited to each event, but not everyone will come. What you are saying with the...

Excellent...Almost Thanks for the quick reply, sorry it took so long to re-reply. My members list is in tblMembers, tblAttendance records the people that attended an event by having an Event ID field which relates to tblEvents. Example: Eric, Pat, and Mark are members. Pat has a Barbeque...

I have several tables in this database 3 of which relate to this issue. tblMembers has several fields, but these are the relevant ones: Member ID, First Name, Last Name. tblEvents has all my events with fields Event ID, Event Name, Location, Date. tblAttendance has Member ID, First Name, Last...

Thanks for the replies Jack I thought of trying that if I couldn't get the variable method to work. Thanks Casey I'll give it a swing when I get a chance. I'll let you guys know what I come up with. Thanks Eric

I have frmCalendar form that opens when I click a picture on frmMembers. I pass the name of the form that opened the frmCalendars form to a textbox on frmCalendars. Now what I'm wanting to do is when I select a certain date it puts the name of the text from txtFormName into a variable and then I...

I'm wanting to be able to select multiple items in a listbox and then filter a report by what is selected. I have the report's rowsource as a query, the criteria of the query points to a text box on my form. I have code that puts all the selected items in a string with each selected item...

Is it possible to move controls on a form? If certain controls are hidden then, these other controls move up to where the hidden controls are located. If it is impractical to do it this way, what would you suggest? Also can you group controls on a form so that you can move them all at once? Eric

Thanks, you got me on the right path. Thanks for that tidbit DES. If anyone's interested, this is what I did. Added this to the criteria of the AFENumber field in my row source query. [Forms]![AFENumber]![VarianceLogInput Subform].[Form]![AFENumber] Then in the got focus event I put this...

Is it possible to filter the values that are displayed or available to select from in a combo box? What I'm looking to do is on a form have a combo box that looksup data from a PO table; however, only display the PO's that have an AFE Number that is the same as the AFE Number on this form...