Recent content by DugyWugy

Hi EasyIT, Sorry for all the confusion. I found the source of my problem. Rookie mistake (I had the module name and function name the same). I changed the function name and the macro executed properly. Sorry for wasting your time. Thanks again, Doug

I haven't tried debugging the code because it runs fine if executed within the vba window on both machines. The issue is trying to run it from the macro. When I run the macro is says that it can't find the function on the client's machine; but, runs fine on mine (within the vba window and by...

Here is the Function: '****************************** Public Function CheckForData() Dim OneCallData As Object Dim stDocName As String Dim Name As String stDocName = "Print_Locates" Set OneCallData = Application.CurrentDb.OpenRecordset("SELECT * FROM tblOneCall WHERE JobStatus = 'Incomplete'...

Yes. Both of us are running Office 2003 with XP Professional (Service packs are all up-to-date on both). Thanks, Doug

Hi EasyIT, The function is stored in a module. The VBA module is on the client's machine. Everything is within the same database (forms, modules, macros, queries). There is one table that is linked to another database. The strange thing is that it works on my machine and does not on the...

Thanks Eupher and IGPCS, Sorry I've been tardy in replying. I've been out of the office for a couple days. Here is a clip of my code: Private Sub cmdNext_Click() DoCmd.RunCommand acCmdSaveRecord Dim qryJobPckgUpdate As String Dim UpdateJobPckg As String UpdateJobPckg =...

Hello List, I've done some searching and can't seem to find the solution to my problem. I have created a Public Function that will successfully execute in the VBA window. I created a macro and have the RunCode command calling my function. It runs perfectly on my machine. However, I...

Hello List, I think I've hit a wall. Here is the scenario: I have two tables (1 storing the main information and the second storing some of the values from the first (via an update query). I have a form that populates the first table, a button on that form that updates records in the second...

Hi rjoubert, Thanks for the tip! No, the Time To Call is actually part way through the memo. I've used your example and it's getting the results I want for the section I need to update. However, it deletes the rest of the data after the section we replace. Is there a way to avoid deleting...

Hello, I'm wondering if anyone has some insight to this issue: I would like to replace some characters in the text within a memo field. Here is an example of the data: Call Date: 08/01/2006 Call Recorded: 07:31:25 AM Contact Name: John Doe Time to Call: 07:00-08:00 I would like to replace...

Thanks CautionMP, This great - I'll start working on this right away. I'll also review the information from PHV regarding InStr, Mid, and Trim. I know this kind of functionality will be invaluable in the future. Regards, DugyWugy

Hello List, I have been looking at the threads for a couple days now - trying to piece together some code to perform the following task: I have a memo field that contains some semi-normalized data, I would like to query this field and extract the required data into separate fields. Example...

Hello List, I'm hoping you can help me with defining a 'tree' view of my data. I'd like the user to click on a plus (+) sign beside a record in a form or report and have other associated/related records from other queries/tables display. This way they can 'drill down' to view as much or...

Hello List, I have created a form with a button that opens the file menu. I select a file. The file path and name are then populated in a text box. This text box is bound to a hyperlink field in my table. The problem is: The local file names (hyperlinks) are populating as such...

Bill Thank-you for your help - this is working exactly the way I wanted. Thanks again, Doug