Search results

add a textbox called say txtSum to the subform footer with =sum(calculation) as the controlsource where calculation is however you are calculating the value (e..g =sum([quantity]*[price]) on the mainform, you reference it with =salesdetails.form.txtSum

Ironically, on my smartphone that link is considered unsafe

May help - if you right click on the word icon on the task bar you should see a list of recently opened word files. Click to open, or hover over to see the path

It’s optional for csv files. For text files with tab or other delimiters you either need a specification or create a schema.ini file

Just to clarify further the date number is the number of days since 1900/01/01

Any reason for using two objects? Why not one? You can simulate a checkbox with a character to appear in a label caption or an image on a button. Simple code required to change from true to false If they have to be separate for some reason, associate the checkbox with the label by relative...

Use the control top and left properties. You can use code to drag the control to where it is required in the control mouse move event. Then in the mouse up event update a table with the control name, top and left values Alternatively select a control by clicking on it, get the control name...

Think it was vhung’s way of showing their appreciation

Well I’m dropping off this thread, you believe one thing, I believe another and I see little point in continuing this discussion.

I'm only going by the evidence as shown. Explain why if using the docmd WHERE parameter a) the form filter property is populated and b) consequently if it is removed by the user, all records (per the original recordsource) are displayed - you seem to imply it does another fetch from the source...

that equates to Where False - so no records returned and no iteration through the recordset since there is nothing to compare - it returns an empty recordset, useful as an alternative to data entry mode or iterating through the fields to get field properties rather than referencing tabledef Not...

please provide an example - my understanding is that filters works on the (in memory) downloaded recordset, it does not requery the underlying source. Just asked chatGPT who responded with 🔍 Quick Answer: ✅ Comparison: Filter vs. Requery ActionApplies ToRequeries Data Source?Notes .Filter...

responses are so cryptic, I'm not sure who is saying what or agreeing with who. This is what I am saying: If you use the WHERE parameter of docmd.openform it is actually a filter, not a criteria, which if the user has access to the filter button at the bottom of the form or the use of shortcut...

Does😀 - try it That is what I was saying

It loads the entire recordset but prioritises the records to display. Click the filter button at the bottom of the form to show all records Not good if you are a sales person reviewing their sales based on their id as a filter - click the filter button and they can see everyone’s sales

Which way really depends on the circumstances. To reduce network loads and to limit what the user can see, use the sql string with criteria and sorts. Allow filters and sort if relevant to the task. Personally I never use the where parameter of docmd since it is actually a filter You can use...

per post #5 AppointmentDate between date()-weekday(date(),1) and date()-weekday(date(),1)+7 you could of course just apply that as a criteria to the form's recordsource

easiest way is in the form design, data tab change the recordset type to snapshot - that will only make the data read only but any unbound controls can still be changed (such as one used for the user to indicate what they want to filter) You need to get your terminology right - in a query you...

per post#2 the action would need to be in the button on the main form subform.sourceobject="" querydef.SQL="SELECT....." subform.sourceobject=report.myreport

A report is not a form and cannot be made dynamic in the way you want. You can do things like change the sub report source to display a different report and use the subform link properties to display a different set of data - but this is not a true filter Opening as a report (ie not in a...