Search results

sub ClearAllTextBoxes() dim ctl as control for each ctl in controls if Typename(ctl) = "TextBox" then ctl.value = "" next end sub

you didnt. Lcase should not erase the data in the field: MLINK3

make a form that has the text boxes to set your date range: txtStartDate, txtEndDate. and txtPrevStartDate, txtPrevEndDate. make 2 queries to pull the source data range, qsDataDateRng & qsDataPrevDateRng qsDataDateRng= select * from table where [dateFld] between forms!fMyForm!txtStartDate...

I have a tFee table: FeeName, Amt, Interval Rent , 400, M (monthly) this then supplies the tRecurringFee table for client charges: clientID, FeeName 1234, Rent every time period,(monthly,yearly, or 1 time only) a macro is run to add the fees to the tClientFeesCharged table.

you cannot shut a dialog from another form BECAUSE its in dialog. Just close it from the dialog.

We use MANY databases daily. It is the workhorse for our company. We will not be abandoning it.

put IIF statements in the query, not the report. then you can inspect the data returned.

In a SELECT query, take 2 tables,join them, bring down the fields onto the grid, then click MAKE table button. write to the new table.

ISNULL is for query criteria in vb code / formulas: IsNull(field) iif(IsNull([FY S&S].[Report]![S&S#Commitments]),0,[FY S&S].[Report]![S&S#Commitments]))+[TotalCommitments]

Run the query (not the form) with known criteria that will return a result. make sure the joins are correct.

dont really need vba. Link in the target tables to copy to, as external linked tables. make append queries to add the local data to their target tables, put all these queries in a macro. put the macro in the button click event.

sometimes opening a different version can cause problems in the REFERENCES. Enter VBE (alt-F11), tools, references, see if anything checkmarked says MISSING. uncheck it, and scroll down to load the correct version. then compile it (in VBE): menu, debug, compile. any errors show?

i actually do wire db. I have a tWire table, holds the WireID, gauge, color, etc. a tCut table holds the compound wire result: CutID, Wire1, wire2, wire3, wire4, CutDate, etc the parallel cut will fill 1 thru3 or sometimes 4. these fields are filled with the key from tWire table.

I have a tUsers table with their login I’d, and their ‘level’. userID,Level bsmith, M tJones, U normal user, manager, admin when the app opens, the main menu grabs the ID ,then looks up the level, then disables buttons some users cant get to. sub Form_Load() txtUser = Environ("Username")...

the chkbox event would show or hide the field sub chkBox1_Afterupdate() txtBox1.visible - chkBox1.value end sub

Make sure the Afterupdate is Public ,not Private, the use the full path to call it: forms!fMyForm!cboBox.AfterUpdate

what about: if [sc_main] is numeric: dcount("*","t_rec","[sc_main] =" & Forms![TR jours par Service]![sc_cbo]) or if [sc_main] is text: dcount("*","t_rec","[sc_main] ='" & Forms![TR jours par Service]![sc_cbo] & "'") the form path is outside the quotes.

You MUST save the master record 1st. This generates the autonum ID. THEN you can enter subform data.

I have a list of user IPs. when I click a button, the code copies the new FE to their folders. at another site, each user has a personal network folder to copy to. Everyone gets updated.

1. make Q1 that pulls data in a date range you need. use a form for the start , end dates. ie: forms!fMyForm!txtStartDate 2. use query wizard to make a crosstab query using Q1 to create tbl1,tbl2 data. in this xtab qry ,add the 2 date params in the query design, click PARAMETERS ,enter...