Search results

I've always set opened objects to nothing in every procedure. You do that in your code but not consistently eg rstJobs in Sub Illinois_Split() I have all my Dim statements at the start of procedures and set all objects to nothing at the end. Makes it easier not to miss anything. Can't say...

The syntax is docmd.OpenReport ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs Filtername is the name of a query Try DoCmd.OpenReport "rPolicyComplete", acViewReport, , ,"[tPlcydpt]=" & tPlcydpt or if tPlcydpt is a string DoCmd.OpenReport "rPolicyComplete", acViewReport, ...

I was referring to the code in #49. If you used my code, it does not have a problem with names containing single quotes.

What's the chance of someone putting a bullet in his head before he gets too extreme.

As some have already noted, Cronk is inclined to make statements that exaggerate to the extremely ridiculous. But then a French queen did make reference that if the masses could not get bread they should eat cake not too long before her head separated from her body.

That's fine until you are searching for a surname such as O'Connor when a run time error will occur.

Reminds me of something I saw the other day Someone asked the other day, 'What was your favorite 'fast food' when you were growing up?' 'We didn't have fast food when I was growing up,' I informed him. 'All the food was slow.' 'C'mon, seriously.. Where did you eat?' 'It was a place called...

@dbGuy Yes, just a long shot for the OP @cambonner Make a copy of your FE and replace the code in Sub SearchFor_Change() with the following 'Create a string (text) variable Dim vSearchString As String 'Populate the string variable with the text entered in the Text Box SearchFor...

I also cannot replicate your problem. I wonder though if it's spell checking. Try turning off Capitalize first letter File | Options | Proofing |Autocorrect Options

Zip the files and attach the zip to a message to this thread. I'm not saying I will have the time then to look but someone is sure to.

I can't replicate your issue using the code you have supplied. Perhaps it's time to provide a copy of your database. Remove any confidential data first.

Market is down given the uncertainty with the war, so I bought some more stock. Either things get resolved eventually and my stock goes up or everything turns nuclear and I will beyond caring. I know that is seeming very cynical and uncaring. I do recognize the pain and suffering of those...

I thought the needy people queued up outside Buckingham Palace and the Queen gave out bread.

Preumably that was an affirmative that the filter string was changed.

Did you ever change the filter string as suggested in #5? What is your filter string now?

Can you clarify? If the report is giving up to 15 records, you want the records to be displayed on page 1 with blank records shown for any record number less than 15 eg 9 records will have 6 blank records following If the report has more than 15 records, you want page 1 to display 18 records...

Re #9 to #11 ? instr("abxxcd","xx") = true False

Solar panels are rated as being Tier 1 (the better ones), Tier 2 (cheaper but also lower performance), less than Tier 2 (rubbish). I went for Maxeon SunPower panels, up at the top end of Tier 1 if not the top one. Top dollar but best performance and warranty. This site writes At this rate...

Did the sales rep have a carpet bag? Or are the panel frames in solid gold?

I have several applications running where there are temporary data tables but in a separate db in the same folder as the FE. I don't worry about compacting the temporary db. It's easier to blow it away and every so often create a new temporary db with empty tables .