Search results

Don't know what that is or how that would work. This is what is in the control source of the TextBox that is calculating the tips: =[sbfrm_qryDeliveries].[Form].[TipAmountTotal] TipAmountTotal comes from a hidden totals field on the subform which is on the mainform where this textbox resides...

Please excuse me as I try to make my request clear. I'm not an access guru of any sort. I have a db I've created to track jobs I complete for customers. Each job could possible result in a tip from the customer. Tips are tracked in a table: tblTips which has the fields: TipID, TipDate...

well, I feel like an idiot... lol, for some reason I didn't understand that's where it meant to put it. Thank you, worked like a charm.

I apologize for my ignorance, but where do I put that statement into the code that is already there?

Okay, sorry for making it confusing. this is the code for the filter button: Private Sub btnDateRange_Click() Dim Filter As String Filter = "[WageDate] Between #" & Format(Me!TxtStartDate.Value, "yyyy\/mm\/dd") & "# And #" & Format(Me!txtEndDate.Value, "yyyy\/mm\/dd") & "#"...

so I have a filter set up on my main page to filter the results in a subform datasheet. I have a button to open another form to do some stuff, and when that form is closed I would like it to refresh the filter if it was already filtered before opening the secondary form up, essentially so the...

The link between tblTips and tblWages is tblDeliveries The reason for different dates in the same record is each job has a wage paid by the company for ding the job and a tip by by the customer at some point when the job is completed. The two are paid out depending on the day they were...

Thank you, that worked perfectly as far as the filtering goes. Now I will attempt to figure out how to work out the second half of this.

There would be no nulls as all records have a default date set, but of those five all should show.

As written, My form filters perfectly, but only for the one criteria, that is, it is set to filter only WageDate that come in range. What I'm trying to find out is what I need to add to this code to ALSO have it filter TipDate at the same time. But, I'm not sure this is possible, since doing...

I have a form, with a data sheet subform. This subform has rows with WageDate and TipDate. I have the follwing bit of code to filter the the records to display the records with the WageDate that falls in the range: Private Sub btnDateRange_Click() Dim Filter As String Filter...

Okay, thank you. This is used in a one to many relationship, but I'm using the CustomerID as the primary key for that relationship. I googled how to set up the multiple field index and was able to accomplish that, at the same time I will try to lookup how to set up the onchange event as...

If I say no duplicates, how would that work as there IS the potential for duplicates. More than one address could have the same AddressLine1 or AddressLine2. It is only a combination of the two which makes it unique.

I have a table, its just tblInfo its not in any relationships or anything its just used to store information that might be needed in other areas. one of the fields in this table is "wage" In another table, tblWages, there is a field "Wage" which tracks the wages earned in a particular job...

So in my tblCustomers there are two fields. AddressLine1 and AddressLine2. There are more fields than just those two, such as CustomerID, which is curently the Primary key, but I think those two are the relevant ones to this quesiton. I'm unsure as to how to set this up so that when it comes to...

This may be more complex then I think. I'm no expert and have just recently started learning how some of this stuff work. I'm building a fairly simple DB to keep track of my work and pay. I'm a gig worker and jobs I complete Tu-Sa pay out on the following Monday, and Jobs worked Su and Mo pay...

Yes, I did that in a button on the subform, and that works just fine. It if a user clicks a button to add a new order which brings visible the subform, I don’t want them to then have to click another button to make the new record. I want them to hit the one button, at which point the subform...

Yes, I did that in a button on the subform, and that works just fine. It if a user clicks a button to add a new order which brings visible the subform, I don’t want them to then have to click another button to make the new record. I want them to hit the one button, at which point the subform...

I have a form with a subform. Both are built off of the same query. Search box at top finds customer, parent form displace all the customer data, subform displays order data. Subform is set to visible false until button is pressed on parent from to add a new order. When subform becomes visible...