Search results for query: *

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...

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...

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...

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...

Hi, Does anyone know where I might be able to purchase MS Pocket Access for Windows CE ?? Also, what is the approximate cost ?? Can it be customized using VB ?? Thank-you Doug Culbert

Is it possible to change the background color of individual tabs within one form. The single form contains 6 tabs, and I would like to make each tab a unique color. Thank-you Doug

Hi, I know it is possible to start auto-numbering at a defined number (ie. start numbering from 1000). Is it possible to auto-number starting from the auto-number in another table? For example: I have some Owners which own many Apartment Buildings which have many Apartments in each building...

I wish to populate a list box based on the variable declared in the previous list box. Which will in turn provide the variable for the search to provide the data for the next list box. I have tried using DLookup and haven't had any success. ie. Owner - Apartment Buildings - Apartments. I wish...