Search results

Hey, I just tried your code but it didn't seem to work. Are you sure that is right. Here is what I have: Private Sub cb1_Click() DoCmd.SetWarnings False Docmd.openquery "DateWellPrevious" End Sub My Query's name is "DateWellPrevious" -Chris

I'm somewhat new to VB so please hang with me. I am trying to run a query using VB when I click a command button, then close the query so the user doesn't see it happening but it doesn't seem to be working. This is what I have for code so far: (My Query is named "DateWellPrevious") Private...

Cool, so do you know how to close and save it in VB code? Only asking since my macro also closed the query after it ran (and I am pretty sure it saves it also in a macro as it closes). -Chris

I just found that in the options menu, all you have to do to turn off messages 1 & 3 is to uncheck the confirm Action Queries box. So that eliminated two of the three messages but I am still left with number 2 (as shown above). This is what my macro looks like: OpenQuery SetWarnings(No) Close...

No, that didn't really work. I added a SetWarnings action inbetween OpenQuery and Close and set the parameter to 'No', but it didn't seem to work, I still saw exactly what I saw before. -Chris

I have a form based on a table called "WellData". I want to have a text box on this form that shows the first value in a field that is in a different table called "DateWellPrevious". The field is called "Oil". I tried this as my textbox control source, but it didn't work...

Hey thanks yellow, That worked! -Chris

I have a make table query that is run through a macro right now. This is what I have in my macro action section so far: OpenQuery Close I don't want the user to see anything when the query runs, and they don't see the actual query, but they see three popup boxes like this First One: You are...

Is it possible for a macro to autofill in the parameter of a parameter query? I have a parameter query, and when it runs it prompts the user for "Name" and "Date". I want to make a macro do this automatically by retrieving the values for the parameters from text boxes on a separate form...

OK, I'll research it a bit and then talk to my boss, and see if I can somehow get it changed over, but for now can you help me solve my original question so as it gets changed over, the users can still have a working database? Your help would be greatly appreciated. -Chris

I don't think I'm storing any calculated values, or at least none of my fields are calculated, unless I am misunderstanding what you mean when you say 'calculated'. I'm sure that it really would be better in the long run, and I'd give it a try if I had time, but I'm a Senior in H.S. and School...

If I was going to try to use the way shown on the ACC2000 webpage (link in earlier post by RuralGuy), would my control source of my text box look something like this (Assuming I'm first going to get the previous "Oil" value): *Note: My form's name is "Daily"...

Yep, you were right, it did work when I put the Well field to the left of the Date field. So why do you say that I should be using a query instead of a table directly? -Chris

For some reason, my table won't let me sort by well AND date at the same time, it either does one or the other. -Chris

Will that work for me? On my form, the user will be looking at the new record they are entering, and I will need to find the record from the same well on the previous day. But records in the table could be mixed up and not sorted by well and date. In other words, the record I want to get...

Hi everyone, What I wan't to do seems very hard, and am wondering if anyone would be able to help out. Here is what I am trying to do: First of all, so you somewhat understand my field headers and table, I work for an oil company. I have a form that is based off a table and some of the...

That is excactly what I'm going for except I want the two weeks displayed in separate tables. One table for the current week, and another for the previous week. -Chris

Thanks, I wouldn't have done it without you! -Chris

It worked!!! Thank you for helping me along in that process. I just have one more quick question for you now that it works. If I want to use a third column of the combo box along with the one we just made would I just put that code right under the current code in the code editor? Like this...

Still problems; First of all, I did rename my combo box to 'cboGetInfo', thanks for the tip. And second, my new problem is this: When I build the expression with the expression builder it puts this text into the After Update box: =Me.State=Me.cboGetInfo.Column(1) Then when I try to run it...