Search results

This must either be exceptionally easy and I am looking past the solution or it is impossible to do. I want to write a macro that opens an application using a file that I specify. My goal is to open MS-Word to work on a specific file while in the db. The db keeps track of other activities for...

I want to use a form to aid in document preparation. The document, itself, is complex. It also gets reviewed by many people in many organizations. I plan to track sections by revision and by who has reviewed them. The various sections are broken into various MS-Word files (about 300, I said...

Phantom Form 2 I knew it was in there some place and you were right, it was in the startup routine. Thanks for the tip.

Give HFCS a Break Just read your note and thought I would add my two cents worth. First, look at the ingerdients list. If high fructose corn syrup is present, there are no other sugars added since it is about 60 times sweeter than dextrose, the usual sweetener. That means I can make a...

When I open my db, I get a pop-up that says: "The form name "frm Complete List" is misspelled or refers to a form that doesn't exist." This was the name of a form I did have in the db but have since deleted. Any ideas what is generating this nuisance message. I cannot find a reference to...

My database has two primary forms. The first form has a group of command buttons that allows me to select a plant. Clicking on one of the command button opens the second form, which contains information about that specific plant. I achieved this selection by writing a macro for each CB on the...

SC, Thanks but please understand that, for me, a superuser only describes a couple of ex-wives so we'll need to go slow. Alternatively, this has the potential of becoming a great learning experience for me. The code your requested is: Private Sub All_Fuel_Types_Click() On Error GoTo...

Re: ExamplePlantDB John, Thanks for responding. I guess I must be dense but don't I need some information to re-create the workgroup file? When I try to open the *.mdb file, I am prompted to join one. Also the attachment to your response indicated two views and I do not know what that means...

My database contains information on many different power plants. I have created a form to retrieve data about a specific plant but there is more information than I can get onto a single page. So I added a command button to the form to retrieve a subset of data using a query. Clicking the...

I read a lot for work and the material is from many different disciplines. To keep track of all this information, I set up a simple db to keep track of all my references and have fields containing various bits of information for each record. In the beginning, I assigned one keyword to each...

Well, I guess I need to learn all my lessons the hard way. My previous supposition was correct: the error was in the table, not in the implementation of DLookup(). I got the section code into the comments table by means of a lookup. When I replaced the lookup with a manual entry, then...

Liv, Sure, I could use a query but then, I don’t learn anything. On the other hand, if I can’t get this to work soon, I’ll be taking your advice. Thanks for responding. Wayne, Thanks for taking the time to respond. Made the change you suggested and obtained the same performance I have...

Implementation of the DLookup() function is still giving me fits. The syntax I use is: =DLookUp("SecText","tblDocSections","tblDocSections!SecCode =” & forms!frmTestA!SecCode) The function returns a null except for certain values of SecCode. The value of SecCode ranges from 0 to 99999999...

Paul, Thanks for the tip. The webpage provided additional information on use and formatting that I lacked.

I am still struggling with the implementation of the Dlookup() function. Maybe someone can help me with a couple of basis questions. Based on a few of the tests that I have done, it seems as if the criteria need to match numeric data. The one simplistic example I have gotten to work uses...

G. H. Thanks for your response. I followed your link and found that it offers nothing new that the help pages haven't already presented (I nearly always go there first). I am using MS-Access 2000 on a MS 2000 Professional (who am I kidding?) OS. My next stop before posting a question is to...

I am trying to implement a DLookUp() as the control source in a text box and not having much success. The syntax I have is: =DLookUp("[tbl Doc Sections]![SecText]", "[tbl Doc Sections]", "[form]![SectionsID-1] = [tbl Doc Sections]![SecNumber]") The function returns a strange value that I...

Guys, Thanks for your response. Doc Man, You gave me a lot to digest but I can promise you that I shall work my way through it. It will take some time so don't hold your breath. On the other hand, I'll probably need you to hold mine as I navigate through this. Thanks, again.

I just encountered an interesting problem while testing the portability of my database. I have built a database using MS Access 2000 and it is fully functional as far as I can tell. It is not complicated but the queries do contain some simple expressions. When I load the database on a...

Because I have never used an Append Query before. Just haven't had occasion. Looks like I am about to broaden my horizons. Thanks for the suggestion.