Search results

I used your code and worked well. Thanks a bunch! ;)

Excuse my ignorance, but then how do I pass the value to the query? I will give it a try but still I was looking for a solution where I don't have to add too many steps for simplicity sake.

Hi all, I am creating a query where the criteria for one of the fields can come from either one of two forms depending on the form that is open. Both forms have a similar text box with a reference number so I want the query to grab that number from eiter form1 or form2. The problem I'm having is...

Will try them out and post my finds. Thanks all for your help. George Too

Thanks all for your replies, I was looking for something less complicated than what The_Doc_Man proposes, though I can give it a try. As for dcx693's question, each record contains, among other fields, the press and roll number. Each roll increment is in a separe record with the appropriate...

I have read a couple of posts that are close to what I need but not exactly. I have a table that contains press number and roll number. There are 7 presses. Each press might have rolls numbered 1 to 100, but not always, sometimes some numbers are skipped. Ex. Press 1 rolls 1, 2, 4, 8, 9, 10...

Thanks Pat, I had done that already. I was looking at all the forms in the wizards and I couldn't find the print wizard so I suppose it is not one of them. With regard to building my own wizard, I would be up to the challenge but time won't let me, so that's out of the question. Now, I will be...

I see and agree with your point Pat, how then do you suggest I should go about it? I'm using the wizzard just as a means of printing the report and not storing it. Hence my question of whether it is possible to restrict the wizard programmatically, or creating a wizard myself, which I have the...

Thanks Mile-O-Phile for your reply. Basicaly, what I want to accomplish is to have Access create the report on the fly based on a query that the user creates by selecting fields at run-time. Now, I've been toying with the Access create report wizard by calling it with VBA, which works...

Any takers on this? George

Is it possible to programmatically change the source of a report at run-time? I have a procedure that allows the user to create a query at run-time based on the fields selected from a list box. The query changes depending on what the user has selected. I want that query to be the source for the...

Ok, now I have this next code that I can put behind the After Update event of the subform (which actually works), but I don't know how I can lure the user out of the subform to trigger the event. This is the code: 'see if this is a new record Dim strMsg As String strMsg = "Data has...

Ooops! It sits behind an On Click event of a button. The bound form sits on a tab control on an unbound "main" form. This makes sense? I hope. Thanks, George

Can anyone tell me why this code is not detecting the changes made in the bound subform? If Me.ChildEditData.Form.Dirty Then DoCmd.RunCommand acCmdUndo Else MsgBox "There were no modifications made to the current record.", vbInformation, "Invalid Undo" End If Thanks, George

That's what I had in mind before but I thought there would be an easier way. I guess I got to listen to the pros. Thanks, George

Any other takers for this question? I have the same situation I want a working solution for. Thanks, George

Hello Wayne, Ah, yes, the code is behind a command button which aside from doing other things it assignes the "Add &New Recipient" to the button, or "Add &Visit". Exactly as shown. I even separated the code into 2 different hiden buttons with the appropriate code behind it. Depending on the...

Thanks for the speedy response. 1. The first IF statement works but not the second. The code just doesnt execute at all. 2. The caption is changed from a separate procedure in the after update in a combo box. It is dependent on whether the record id founf or not. 3. That's the funny part, the...

Hello all, I have an unbound form with an unbound subform. Users enter the record they want desplayed in the subform by entering the records id# and pressing a button. If the record is found it is displayed in the subform, if it's not found then the user is prompted to enter data for it using...

Thanks Jon K, I'm at work but I'll try it later on. Thanks for your time. George