Search results

Thanks arnelgp. I will use your code.

Problem is i don't know how many spaces are in the string. I don't want to loop the replace command until the length doesn't change anymore. And i found that \s{2,} as a regular expression selects all consecutive spaces (2 or more). Next step would be to replace it with a single space...

Fake it! Remove the caption bar and replace it with a label. Program the label onclick event to do what you want. HTH:D

Looking for a way to delete consecutive spaces. Preferably a one-liner The replace command doesn't cut it. ?replace("Dim intI as Integer"," "," ") results in Dim intI as Integer I was thinking of a regular expression but i need some help there. Thanks.

Q. How do you milk a sheep? A. Bring out a new iPhone and charge £900 for it. One thing you don't want to hear when having fantastic sex? "Honey, i'm home!"

Even when i call a function of which i dont use the return value i use a dummy variable instead. Typing a simple Call prefix would be faster. Thanks for your input everyone!

I see it in a lot of programs. I never use it. Do we need it and why? What i am talking about is the "Call" keyword. Public Sub SomeRoutine() ... End sub Public Sub Doit() Call SomeRoutine End sub Public sub WhatIDo() SomeRoutine End Sub Which is better? Thanks, Guus

Hi Colin, There is no thick vertical line for me to click and hold on to. I have tried the three possible solutions you suggested. They all failed. The Nav Pane settings were set to hide the nav pane. They are now set to show the nav pane and still it doesn't matter. I'm leaning to the...

Seems that the database is corrupt according to the thread below. https://www.accessforums.net/showthread.php?t=45512 Copying all objects to a new database might fix it. I must have some code lying around to do just that... Open to any other suggestions. Thanks!

Hi Colin, Yes the navigation pane. It is a pain. It still is. I tried the three options you suggested. The problem is not showing the navigation pane but resizing it. But thanks for the suggestion! In a new database the nav pane shows a rather thick line indicating it is resizable

Can't seem to get a grip on the left pane. I want to resize it so i can actually view its contents but the cursor doesn't change and i can't seem to get a grip on the left pane. How is this possible and how can i restore this functionality? Thanks! btw: Using Access 2016

Thanks PLOG for taking over. Couldn't have said it better. Kudos!

You are still comparing a count to a table field PCL_ID. Three times now. That doesn't seem right. ...((Count(PressCallLog.PCL_ID))="dbo_ICEp_vwEmpBasic")... The count (int or long) is compared to a string. This can not produce any records. If it does, it is a miracle. With this kind of...

HAVING (((Format([PCL_Date],"yyyy-mm"))>(Year(Now())-2)) AND ((Count(PressCallLog.PCL_ID)) In (SELECT PressCallLog.PCL_ID This seems a bit strange. This construction in the HAVING clause. Where you count the number of PCL_ID and use the IN keyword for the subquery...

Hi Colin, I used MZTools and when i couldn't install it because of the restricted security on my computer at the time i created these functions. MZTools was changed and improved to circumvent this restriction and it is running perfectly now. So no need to create an add-in. However, i still want...

You may want to install a tool like Rick Fisher's Find and Replace tool and/or MZTools. The F&R tool can find what you are looking for in your application. MZTools gives you handy tools when you are working your code. And decompile once in a while. It will show you many more glitches in your...

next time, please send me the link...

Nifty little piece of code. I like it. What i don't like is the extensive use of goto, other than for error handling. In the early days in GWBasic or BasicA there was some enhancement called GOSUB. You can still use it in your VBA code: Public Sub Strobe(ByRef ctl As Control, intDuration As...

Count me in. Thanks!

a few observations 1 - Apparently you have posted this question somewhere else? Given the odd font. It is what a simple copy and paste does. 2 - You want to update a table with process data. You dont store process data. 3 - i don't know what you want and it seems to me that you haven't tried...