Recent content by FuzzyBear9

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

Also, you may wish for the form to be maximised once opened. To do this: 1) Go to design view on the form that you have chosen to open on startup. 2) Double-click on the small black square located on the top-left corner. 3) Select the 'event' tab. 4) Click in the 'On Load' event box...

Sure. Select 'StartUp' from 'TOOLS' within Access 97. Then choose the form you want to appear on startup from the drop-down box 'Display Form'. Hope this helps.

Both the CONSULTANT and ENDDATE fields are filled automatically by using a query-based form (where the query is an AUTOLOOKUP query). Any ideas?

The End Date varies according to the Survey selected: Example: Survey End Date TCM 12/08/02 PIP 11/09/02 ACU 06/05/02 MME 23/11/02 As far as I am aware I can only specify one default value, unless there is a way to write conditions...

Thanks for responding so quickly. What you say makes sense. The need to include a button to update records only came about because the query failed to update one particular field in the underlying table. PROBLEM: The query-based form is based on an auto-lookup query where information about 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, Sorry! I was not clear in my post! The title, initial(s) and surname appear in ONE field. Example: Mr D Bolton I would like to run an update query to give me just: Bolton Is this possible?

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

Hi, Assuming you are making your query using SQL, then: SELECT Table1.Name, Table1.[Active?] FROM Table1 WHERE (((Table1.[Active?])=Yes)); Where you have a table named: Table1 With fields: ID AutoNumber Name Text Active? Yes/No Specifying 'Yes' or 'No' will...

Sorry, Access returns the following when I change a text column to a hyperlink column: Q:\01056\WPDATAQ:\01056\WPDATA01056crt.031

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

Thanks guys! Especially tlbroadbent!

Hi, Have a look at RickSpr's faq on: "How do I limit the contents of one combo box based on the selection in another." (Go to advance search, select FAQs, then type 'Combo boxes' in the KEYWORD SEARCH box and click enter). Combo boxes have a setting called 'AutoExpand' (found under...