Search results

AB was being sarcastic. Don't take everything literally, specially when it doesn't make logical sense.

I'm surprised that nobody has commented on the flaw in the code in #2. The loop should be For iVal = iValX - 1 to 0 step -1 not For iVal = 0 To iValX - 1 For newer users, the issue can be demo'd by the example of 3 open forms, frmA, frmB and frmC opened in that order. Forms(0) will be...

Many years ago, on forums (not this site) where if anyone wrote in capitals, it was criticized as being seen as shouting. The OP in this thread had all capitals apart from one post. There was no comment made by contributors. Is all CAPS not an issue any more? Just wondering and not that I...

A good while back I went along to a public speaking group in order to improve my dismal presentation abilities. There was woman there who's name was Gay and she bemoaned that her name used to be just a name. She died some time back. I'm sure Gay has dropped from the list of female names for...

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