Search results

Hi, Access 2007 now displays all the records in Continuous Forms in white and grey records. Does anyone knows how to set the display of all the records in white? Thanks...

Hi Roy-Vidar, Thank you for your detailed explanation. Lazy matching is just what I needed. For the project I'm working on now, besides removing the html codes from a webpage content, with the new clean Content, the aim now is to insert into it snippets of text from another table. Let me...

Hi RoyVidar, Thank you for the code, it works fine! Just curious... what is the purpose of (.|\n)+? within the "<div(.|\n)+?/div>"? Thanks...

Hi, I've been able to run the function but intermittently it will show error "Out of string space (Error 14)", sometimes Error 7. Function ClearTextCount(a, startCode, endCode) As String Dim strLeft As String Dim strRight As String Dim startPOS As Long Dim endPOS As Long...

Thank you very much for your help Bodisathva.

Hi, Just realised there are two issues the function does not address: 1. When the startCode "<DIV" appears as the very first character in the input string, it will fail. 2. I need the function to process text in a memo field which contain thousands of letters. When running it on such string...

Got the solution now... Function testString(a, startCode, endCode) As String ' Dim a As String Dim strLeft As String Dim strRight As String Dim startPOS As Integer Dim endPOS As Integer startPOS = InStr(1, a, startCode) - 1 While startPOS > 0 endPOS...

Hi Bodisathva, Thank you for your reply. I've incorporated your code as a function as shown below: Function testString(a) As String ' Dim a As String Dim strLeft As String Dim strRight As String Dim startPOS As Integer Dim endPOS As Integer startPOS = InStr(1...

Hi, I have a need to remove html codes from a text (memo) string. For eg: Here is the string: This is part one of the string <DIV style="padding:5px; FLOAT: middle; MARGIN: 5px; WIDTH: 88; BACKGROUND-COLOR: #cccccc; height:8"> <font color="#CC0000">don't care what's the text enclosed...

Hi, I create a form that has an Event Procedure which dynamically modifies the qry that is used as the source of a report and then is used to preview the report. When I use the form all is well. However, when a user (non admin) tries to use it return an error stating that they don't have the...

Thank you Stephen. Here is the code that works for report: stDocName = "rptSubscriptionCost" If CurrentProject.AllReports(stDocName).IsLoaded Then DoCmd.Close acReport, stDocName DoCmd.OpenReport stDocName, acPreview Else DoCmd.OpenReport stDocName, acPreview End If

Hi Stephen, How can I detect whether the report is already open?

Hi There, I have a dialog popup window that allows me to choose from a list of selections, upon clicking on the Proceed button, a report based on the selection is displayed. The popup remains on top of the report, when the user chooses a different selection and then click on the Proceed...

Do you remember the names of those tools? Perhaps they have new versions with improved capabilities. Thanks...

Hi, I was looking for a tool on the Net to web-enabled my MS Access applications when I came across this: http://www.microtools.us/default.htm Has anyone had any experience to share on such a tool or other similar tools? Thanks.

Thank you Pat for your insight.

Hi, I've found the answers in the link below: http://www.microsoft.com/sql/msde/techinfo/workloadgov.asp The slow performance is caused by workload governor

Hi Pat, Thank you for your reply. Does the 4 users being referred to accessing the database concurrently? Will it be slower than the full-fledge papa-SQL Server? Will it be as slow with the SQL Server if the number of concurrent user is 4? Thanks...

Hi, I've three questions: 1. I'd like to know how to go about upsizing mdb be to MSDE. Should I use the same Upsizing Tool for this purpose? 2. How is security taken care of when data is upsized to MSDE. I presume the FE will continue to use the mdw file, how about the MSDE? 3. Has anyone...

Thank you Pat, the last link seems to be the closest to what I've done. I'll spend some time on the sample code and update here should I have anything to share.