Search results for query: *

Can someone explain to me why this code works, but it does not work when I uncomment Function GetCountOfRecs() As Integer On Error GoTo err_GetCount Dim strSQL As String Dim intCount As Integer intCount = ReturnSingleFieldData("qryCountOfMyDataAggregated", "CountOfID") 'intCount =...

I'm running a query that calls a function. SELECT MyDataAggregated.ID, PutAppealsToNotes1([Appeal_Not_Heard_1],[Appeal_Not_Heard_2],[Exemption_Description]) AS Notes1, PutAppealsToNotes1([Appeal_Not_Heard_1],[Appeal_Not_Heard_2]) AS Notes2, [Notes1] & [Notes2] AS Notes FROM MyDataAggregated...

Hello, I am using Access 2002 and I have about 5,000 forms that were created using Adobe Life Cycle. When someone fills out the form it creates an XML file like this: <?xml version="1.0" encoding="UTF-8" ?> - <topmostSubform> <Name_of_Petitioner>Alan</Name_of_Petitioner>...

A program that I am writing works from Extracts from several Excel Worksheets. I can import the data but because the Excel worksheets require manual input of the names of companies. Therefore, there are errors like this A J MULLINS AJ MULLINS BARRICK GOLDSTRIKE MINE INC BARRICK GOLDSTRIKE...

This code works, but I want to populate an array at a modular level so that other routines can take advantage of it. Sub FindBDFieldNames(strTableName As String) 'By convention the last two digits of tables that have balances due are "BD". 'We want to loop through a table and discover each of...

I'm designing an application, and I'm not sure of the best way to implement one aspect of it. Suggestions will be most appreciated. Background: I work for the Taxation Department of a state. One of the taxes assessed is a property tax. Sometimes, taxpayers do not pay on time and are subject...

Please look at this sub Sub DropUnwantedColumns(strTableName As String) Dim rs As ADODB.Recordset Dim fld As ADODB.Field Dim strColumnName As String Set rs = CurrentProject.Connection.OpenSchema _ (adSchemaColumns, Array(Empty, Empty, strTableName)) With rs Do While Not .EOF strColumnName =...

I expected this code to trigger when a user decided to navigate to another record. Instead, it triggers as soon as the text box is entered. Is there an event that will not trigger as soon as a user enters a text box? Private Sub Form_BeforeUpdate(Cancel As Integer) On Error GoTo err_B4Update...

This is a follow up to another thread, http://tek-tips.com/viewthread.cfm?qid=1394644&page=1. I am trying to eliminate Rich text formatting. I tried to copy-and-paste to a clipboard, to simulate Notepad's stripping capabilities without success. Another approach is to use regular expressions...

Hello, I need to strip out the RTF code in a text box and place the resulting plain text in to another text box. I have two approaches that might work. The first is to use a regular expression to take out the RTF. The second is to use Ole Automation to paste the text into Notepad, and then...

Displaying a message box causes a difference in the execution of the following code. See '@ When I run the code with the message box, it properly displays the number of occurrences of the string "ID=", and only writes a line to a table when the condition of the test is met. When I take out the...

I have developed, but not rolled out, an Access application. Everything appears to be working fine. This will be my first time working with replicated databases. Is the following like a good strategy? Is there a better way? The app is split between the front end and the back end. The...

I want to add a hyperlink by taking a value from an access form and passing it to a routine. I started by copying some code, then I wrote a macro in a Word App and copied and pasted. It worked until I tried to add the hyperlink. Help, please. Option Compare Database Option Explicit Sub...

I need to search a number of bills that have been passed by the Nevada legislature for the occurrence of keywords. The bills are posted on a public website in .pdf format. Can anyone provide any advice on the best way to automate the search i.e. 1) Open a web page such as...