Search results

Mile-o-phile and Pat Hartman, I just wanted to say thanks for the sample and the help. I am beginning work on this task now, as I was working on something else earlier. Jim

BJackson, My database seems to not like something which is not very apparent. I've decided to use the Select Case code, but remove the variable, as I'll keep the 9 queries and the 9 reports and use the Group Option to Run the query and Preview the report in the same Select statement. This may...

BJackson, Almost, but not quite. I think I have a clue as to why it still is not working. Your example (thank you very much by the way) works as I imagine it should. On mine however, I have a slight difference. On my report, I just want to return an estimate for service charge report for the...

BJackson, I modified my code as you descrobed, but now I get a compile error. I got the error after I removed the Public ChargeEstimate as String statement from my declarations, since you said to create a new module called Globals, which I did, an put the statement in there. Until I got the...

BJackson, I believe I followed your instructions, but likely I coded something wrong, so I've included my button's code for your review. My Select routine is only returning the error message: Microsoft Access Can't find the object 'ChargeEstimate'. I think I understand that "ChargeEstimate"...

Oops. Sorry, this problem is NOT solved. I don't know why I thought it worked, but apparently I was mistaken. For the benefit of those new to this thread, the following is what I tried and I thought it solved my problem, but it didn't: ~~~~~~~~~~~~~~~ Though I did what Fizzio suggested, at...

Hi. I have a pop up form with a value I need to pass to a report. Upon double-clicking int he heading area of the pop-up form, causes the Report to open in Preview mode (that all works). Then, I thoght I'd go in to the open event, in report design and put a close statement to close the pop up...

Hi, I'm looking to use the ActiveX Calendar control, and haven't a clue as to how to begin using it. Specifically, I want to embed it on my form and use it as a scheduling tool. I'd like for the user to be able to click on a date button, and then set the focus to a note field on the form, for...

Hi, I have a pop up form that displays the result of a query. That pop up form shares the CustomerNumber field with the main form. The pop up form works properly in that whatever record is displayed on the main form, the pop up form goes to the correct one. But, when I scroll forward or...

Thank You, yes, that will do it for me. I don't know what happened. My brain froze or something. I wasn't even finished reading the first sentence of your reply when I said "oh wait a minute . . . ". I was stuck on the fact that that there are 5 or so different queries - not that I could use...

Hi, I'm not sure about the cycle record property, but this thread is along the lines of what I'm looking for. I have a form, and a subform within a subform. When I click on the last record button on the main form and then click the next record button, it goes to the Autonumber field, as it's...

Yes, me too. But I would like to be able to do the following with it: When it is exported, have its file name to reflect the date, minute and second of the day, to keep it unique. Can this be done as simply as is hitting the prt scr key to save an image into the clipboard, for example? Jim

BJackson, It would seem to work, except for one detail which I'm not sure would work, if not directly addressed: How would the individual fields of my report layout become populated with <u>any</u>, let alone the correct data from the desired query result ? It seems in the example you gave...

GHudson, Thanks too for that info., but instead of the "invisible button", I would like to do it with a set of key strokes. Is that even possible? If so, how would I even begin to assign any sort of "On 3 key stroke" event, for example ? Thanks, Jim

Hi, I have a report based on a query. That query makes a calculation. I have added 3 more queries. I want to add an option group to my form. Then, I'd like to be able to run my report based on that particular query. I believe I would add Select Case to the Open Event in my report. But...

Hello again. I'm back with my database. I have hacked out the portions I didnt want to disclose, and then verified that it gave me the same exact errors, at the same exact events. Please see the zipped atchmtn. and know that the first thing that should happen is the form CustomerData should...

Thanks for you instant reply. I suppose that would be the best way to do it, but I will first have to hack off information from the database that I don't wish shared, as you can understand. And I will need a few minutes to enter some dummy data. Finally, I need to see if it does the same...

Hi, I'm a newbie here. I did a search and this thread is the closest thing that addresses mycurrent problem. Having followed the thread, I see that the expert is telling the visitor to enter certain code. Please someone tell me how I can enter that code to work together with my current button...