Search results

Thank you! I was able to figure this out with the help of some other Access developers, but I appriciate your help nonetheless! Thanks again!

I have a report on which I am printing the criteria for the report. The criteria is two dates; an early date and a later date. The idea is that the report finds all records between the specified dates. When viewed on the screen, my dates are showing. When printed (on a Xerox Document Centre...

Also, when would be the best time to run something of this nature? I have some code in the OnExit event, but this might even be in the wrong place. (It works, but is this the most ideal time to run it?) Thanks.

Oh! Can you tell me where I can find information on the Format() function? I looked in Access' VB help, but I couldn't find any good information... Thanks.

No - at first glance, it seems that this would work for piecing together the number... In your opinion, is this a good (or bad) way of doing things? Should I just make the user enter the number himself (and risk mistakes)? I am getting recommendations from every direction, as I have posted...

Yeah - the numbers will be input separately anyway. I probably didn't explain this as well as I could have... I am just looking to display this data to the user as if it were in NCR5100000001-001 format; I do not want to store this information in this format. I would like to store it as the...

I am exploring the possibility of storing a key value in multiple fields, but presenting it to the user as one single value. The reason for this is that the information used as the primary key contains the value of a foreign key field plus some additional data. I would like to limit the number...

Well, I wanted to use either a Combo box or an Option Group; whichever was most beneficial to the project. (By this I mean functions correctly, operates quickly, etc.) I have actually figured this one out with the help of another user on another forum. What we did was create a Combo Box for...

Dynamic Option Group problem... How does this work? Hello! I am trying to create a form under which users can select criteria for a report. My end result should be a report that lists the invoices (just some data about the invoices, that is) from a specified company where the date_paid field...

OK - I got it to work with the help of some other people. You were right... I thought you were talking about the BeforeUpdate of the form, not the control. I understand what you meant now, and you were exactly right. Thank you... I appriciate your help!

Do I have any idea what I am talking about?

Wait... the BeforeUpdate event fired immediately before a record is updated... That isn't going to work (and actually does not produce the desired result once it is run). You have, however, provided me with valuable advice with DLookup. I do want this to happen in the LostFocus event, that...

Oh... That seems easy enough. Thanks. I'll give it a try and post the results! Thanks again!

I am at a stand still; PLEASE HELP ME! I have been researching this problem and trying many different things, but I cannot get it to work! Here is what I want to happen: When I move my cursor from a text box (On Lost Focus), I would like the corresponding table to be checked for the value (a...

I would seem that this is the case, but it is not. There is no code in the Close event of the form, or any other event for that matter. The only code in the form's scope is on the buttons: One button (labeled "Run Report!") launches the report and the other (labeled "Cancel") closes the form...

I am trying to launch a report based on the values in a form, then close the form. Unfortunately, I am running into a very serious problem (from a user's point of view): Focus (of the report) is lost to the Main Menu form. That is, each time I launch the report ("rpt_assignments_created")...