Search results for query: *

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

Hello List, I have developed an Access application for viewing image files. I created a form to input the desired characteristics of the file. At this point users have to manually key in the path and file name. Is there a way that they could click a button and navigate to the file? Once...

Hello List - I hope I'm making myself clear in this question, I'm having a problem determining what type of a query to use for returning records from my two related tables. I'm trying to query table one for a record. The record is in table two in at most two fields. Once I retrieve the record...

Hello List, I am trying to develop a query that populates itself with variables. I am trying to determine a start variable and an end variable with the query finding everything in between. Example: I will select C2:1-75 (first variable to start the query) and C2:300-500 (last variable to...

Hi, Does anyone know how to edit an attached Access database through Access forms in AutoCAD Map2000. I wish to digitize a block on the drawing and have a MS Access form pop-up to populate the attached database. The form will have a series of drop down boxes with default values in it -...

Hi, I created a small VB program to start some related programs. One of these programs uses run-time .dbf as the background database. Is there a way to automatically convert these *.dbf's into a table in Access for updating with a form and then automatically exporting back into *.dbf? The...