Search results for query: *

Hi, I am newbie to VBA across MS Office applications. I have used some VBA with Access 97. What I would like to do is source data from a column in Excel 97 and allow a user to select that data from a List box in Word 97. Has anyone ever done anything like that before. Any help at all would...

Hi, I am implementing a database in Access 97 and have a problem. The database holds contact information for different companies. Each company has more than one contact. Is it possible to maintain a counter for the number of contacts in a given company? If a contact record is deleted from a...

Hi, I am relatively new to Access 97. I have created a button on a query-based form that updates specific values for ALL records stored in the query to the underyling table. I have used the database splitter and have placed the tables on a shared network, with users running the front-end...

Hi, I have some single field data that consists of a names in the following format: Example: Title Initials/First Name Surname Mr D David Bolton There are about 12,000 names. Some that have just titles, some with just initials and so on. PROBLEM: I want to run an...

How can I take a text file consisting of a list of file names and convert them into hyperlinks in Access 97?! I can use an update query to specify both drive and folder of the files, eg: 01056.doc to Q\Client\01056.doc but can I update them as hyperlinks? When I try to modify the column...

Hi, I have used an expression in a query in Access 97 to join two fields: FirstName and Surname together to produce one field, eg. FirstName: Michael Surname: Page Contact: Michael Page PROBLEM: How can I REVERSE the process!!! I want to take a field and split it into FirstName and...

Hi, I am trying to write some VB code in Access 97. I want to filter information depending on the user's selection. I have successfully created an options group, but it does not account for two types of scenarios: I have a two forms, one called frmSurvey and the other frmTracking. On...

Hi, I am having difficulty with combo boxes in Access 97. I have followed some of the examples on Tek-Tips for limiting data displayed in one combo box based on the selection made in a previous combo box. These work fine with sample databases. I have tried to use the same setup for a...

Hi, I want to export data (using the 'analyze this' feature)from a query into Excel. The data is needed for mass e-mailer program under Lotus Notes R.5, but have encountered two problems: 1) When I export the hyperlink field to Excel, its properties are retained. The hyperlink field contains...

Help! I am a newbie to Access 97 and am stuck!!! Access allows me to use the toolbox wizard to open a form to display specific records. This is fine if you are matching one field in the current form to a field in the form that you wish to open. My problem is I want to match more than one...

Hi, I am a newbie to Access 97 and would appreciate any guidance you can offer on this problem. I have two tables: 1) tblSurvey 2) tblTracking They are JOINed: tblSurvey >one-to-many> tblTracking. tblTracking is used to track individual companies that participate in different surveys. To...

Hi, I am a newbie trying to implement a database using Acces 97 and I would be grateful for any suggestions to the following problem: I have three tables: tblSponsor tblSurvey tblTracking tblTracking has two Lookup Columns, one joined to tblSponsor and one joined to tblSurvey. I then...

Hi, I am newbie to Access and would appreciate any guidance to resolving the problem below. I am currently trying to implement a contact management database. I have two tables. Table 1: tblCompany Table 2: tblContact Table 1 contains two fields: CompanyID (AutoNumber - Primary Key)...