Search results

Format(ID,”00000”)

Those lines are commented out - so implies the issue is in your rename sub

I presume you do have the bullzip printer installed and works with 64bit? There are a number of things which could be simpler. For example you can outputTo a report to pdf Rather than opening the report in design view to change the recordsource you can name the query in the filter name...

Just as an aside, I have a db where I experiment with code, forms, sql etc. must be over 20 years old (or at least old code etc) as it was upgraded from 2003 to 2010 15 years ago. Now I have moved to 64bit access, if I create a simple test form with a bit of code behind an event and try to...

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...