Search results

The combobox is bounded to a field "Carrier" from a query. Once the user clicks on a carrier, the "On click" event is set to filter out the form to show only those records with that selected carrier. & so there is a column of "device prices" and "mo. charges". In the form footer I take in the...

Hello! I have this form set up. At the bottom of the form, there are "totals" fields. "Total charges" which the source is "=Sum([TOTAL MO CHARGES])". "Total prices" which the source is "=Sum(Nz(([TOTAL DEVICE CHARGES])))". Then "Profit" which just does =([Total prices] - [Total charges]). And it...

I can’t pull up the database up right now. I have an append query that adds one record to the table after each run the batadbase makes. So it’s on both tables right now. The allthedata table is all the data over the months. Now every month you can edit any record within it.the edit takes place...

Youd have to create a select query and add those two tables, then make a joint relationship between the 2 fields you want connected(to make join just grab click and drag field from one table to whichever field on other table) and then select which fields from what table youd want to display in...

Hey ya'll! So i have multiple tables,queries, and forms, in this form i search a record, then edit it on this recordsource table. then i have this editquery that has that recordsource table and "allthedata" table jointing and getting the "allthedata" table to update(edit) its record/data with...

Well yes VariableName is a name field & that field is short text actually. & yes when i execute it i've recieved "Syntax error(missing operator)in query expression 'VariableName ='."

The FULLOG table gets imported first and later appended to the Table2, so once i delete the record on FULLOG, it doesnt get deleted from Table2 bc its automatically appended when it gets imported...So no it doesnt delete the record on both tables...

Hello! So I have this form. You can search records and this one btn is to delete it. the recordsource of where it searches records is "FULLOG". I have vba where once you click the delete btn. I have DoCmd.RunCommand acCmdDeleteRecord and it deletes it off the recordsource table(yay). But I want...

Yea I got it to work with those cmds, it was all about the placement of it in the code.

I think i've tried those but lemme see at work tmrw morn. ill get back to you round 8:30 then !

Right. Thats what i was thinking... how would you implement that in vba?

No the table is the recordsouce of that saveform. then that query is a select query which then goes to an append query and a couple other object down the line. So i would need all the other objects to rerun/refresh their data to include the new one.

So I have this database with tables, queries and forms. On this form you'd save a new record. In vba i have it as the "if me.dirty...etc" format and it saves to the table correctly. But then i have this query that gets its data from that table and goes to a couple more tables and queries...

Maybe you can try DSum function. And if you have any zero or blank values in those fields use Nz() around your function

Actually Vlad, I just created a select query from that main table and set unique values to yes and changed the record source of the form to that query and it works. Thank you so much seriously !

Thank youuuu. So simple ugh ! Okay hopefully this simple as well: since that record occurs every month, in the main table that the form is looking at, there’s multiple instances of that constant record(once a month). How do I just single it out to show once ?

How would I say that on the macro builder ? Right now I have [Date] Like “*” & [Forms]![Searchmonthreports]![combobox] & “*”

June7: so I have the combo box grabbing the dates from a table. Then a search button that goes to macro builder to apply filter with a where condition to grab the specified records. The or parameter does sound well but how would I put that bc the constant record does not have a date. Ridders...

Gotcha ridders. okay I can see that as mud haha. So I see the two queries together and union them. Yet how would I bring that constant record to show up if it still doesn’t meet the search criteria ?

That sounds real good. How would I do that union method ridders? Once I select the filter I click a button to search. If that helps at all. Thanks