Search results

As shown in the attached photos, I have a table where a user enters meter readings for each fuel truck after each day. Each truck has two meters. The user wants to see the difference between the previous day and the current day's readings for each truck. How would I go about making this happen?

Thanks! That did it. So even though Im calling this command from the main form itself, I still have to reference it?

That didnt work. Actually the main form always seems to be going to record #11 after every delete. Which doesnt make sense even if it was sorted some weird way that i can tell. you should be able to use the existing database above for testing if you want to see it.

How would this work for the Delete button? If I apply the same logic by deleting the current record then moving to a new record, the form is showing the next record instead of a new one.. On Error Resume Next RunCommand acCmdDeleteRecord DoCmd.GoToRecord , , acNewRec...

I had setup a similar DB setup a while back which also used subforms because i didnt want the user to be able to edit the subform directly. This is why I have the edit button by each row/record on the subform which moves that record to the main form for editing.

thanks i will definitely look into this.

Thanks for the explanation; i was not aware of the difference between the image control vs an actual command button.

This was going to be my failsafe option. Thanks for clarifying

Update on above; I saw the comments on my other post regarding the command button and that it would normally take focus. Understood!! :cool:

I'm not sure what you mean by 'intrinsic' model but thank you, this worked. I was not aware there was a difference between command buttons vs image control; I figured both were controlled by a macro or VBA? What if the code was the same? Regarding the lookup field in a table; are you referring...

I have a mainform with a continuous subform. The main form is used for data entry using bound controls. I have a save button on the main form with the following code. When I try to clear the main form for a new record, it says 'You can't go to the specified record. and points to the line...

Sample attached.

Actually I was typing in the date. The date does update in the control as I type but I noticed it does not “align” (format) itself as short date in the control if I hit the button before clicking off the text control. If that makes sense. I can upload a copy of it when I get back to the house.

I believe what is happening is, since the text box defaults to Date(), the new date is not accepted until focus is lost in that text box.

I'm using Allen Browne's method #2 which filters a report based on two dates entered in a form. Its a simple form with only 2 unbound textbox controls and the one command button to open the report. The two controls have a default value of =Date(). Limiting a Report to a Date Range The code...

Disregard; I've also spoken with the users and was able to remove the calculated controls. So, I've got this working now using one main form and one subform. Thanks for your help

Try this one; this is back to the way I had it yesterday except using one main form and one subform in the header. The combobox correctly populates the controls in the header and saves. However I'm back to the original issue which I never resolved which is: After any data is entered, or you hit...

Nice, thank you I was just working on that. Except im not really needing to filter the continuous form below. The combobox is for two reasons: 1. Choose a truck for new data entry. 2. To populate the unbound controls labeled as "previous" in the header. The other idea of the form is to be able...

I suppose I could also just use one main form and a separate continuous form in the main form's detail section? I just couldnt get that working (couldn't figure out the references). I'm asking because I actually have a separate unbound text box on my header form (which is a sub form) which links...

Where would I find those link fields/which would be the proper form? The main for, header form or detail form?