Search results

I agree with ritchieroo, provided that you won't be changing the value in textbox2, which would subsequently be changing the value of textbox3. Having the code in the "on Form Current" event is causing the textbox3 to be automatically updated when you change records, even after you manually set...

BAzZ, When is you code that auto fills the textbox3 triggered to run? Is it when you exit textbox2, or do you have it set elsewhere as well? If I am understanding you correctly, then the [Event Procedure] should be set "On Exit" of textbox2.

fmm, Thank you for your help. Now I want to pull two pieces of information from the 'open' record set [tempNew] & [tempIG] I am currently using the DLookup Function, but am running into a sorting problem. Can I pull the information directly from the 'active' record in the open recordset...

What is the [Control Source] set to for your three text boxes????

I have run into a wall, as far as the number of 'options' I can have in a critera option. I am in a loop, pulling information out of a table, and I want to insure that I do not pull information for the same record twice, so I am adding the Key Field to the Criteria after each pass (see code...

Can you be a little more descriptive in what you are trying to do? What type of form do you want to print (Continuous / Single)? Do you want to print the current record, or all records?

What I have is more of an annoyance than a problem. I have successfully added/edited a chart to my report. The annoying part, is that when I go to format the chart (Using Microsoft Graph), it doesn't reflect the data that my chart is based off. In order to preview my changes, I need to...

Chenn - You are awsome! Thank you, it worked perfectly. Pat - Thank you for your earlier help too....

I am using the DLookup Function to pull data from a table (see below), and now I want to put that data into another table. tempCompletionDt(z) = DLookup("[Mfg Completion Date]", "[Project Status - Tbl]", criteria(x)) I am able to do it using a Form as an interface, but I am sure that there is...

Accessing Queries Pat, Thank you for letting me know about the DLookup function in your last posting. I am a self taught Access programmer, and have not come across this on yet. Also, I understand that data is stored in tables (not forms). I was just using the form to access data in the...

Now I am really confused. I used the "docmd.echo false" at the beginning of my code to prevent the screen from updating while the code is running. However, when the window is maximized, the screen still updates (i.e. the "docmd.echo false" is ignored). Any Ideas why?????:confused:

I have some code that is opening a form, getting date, closing the form, opening another form, pasting the data, and then closing that form as well. This step is repeated about 12 times, and watching the screen flash can give a person a head ache. Can the code be set up, so when opening &...

I am opening a form based on given criteria (the form is based on a query). There will be either one record for the given criteria, or no record. When there is no record, I get an error "You entered an expression that has no value." Can I check to see if the form/query will be empty before...

I have a chart in a report, where the data in the query that the chart is based from is currency with 0 decimal places. I have selected the 'Show Data Table' for the chart, and when I Preview the report, the data is not formatted properly. I have verified my data source, but am getting nowhere...

I have a chart in a report, where the data in the query that the chart is based from is currency with 0 decimal places. I have selected the 'Show Data Table' for the chart, and when I Preview the report, the data is not formatted properly. I have verified my data source, but am getting...

I have run into this same 'challange' several times, and here is how I worked around it. When you are in the Design View of your report, right click on the chart and select properties. Go to the Data tab and use this window to verify your data source. As far as getting the formatting to...