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

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

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

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

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

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

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

I created a make table query that selects between two memo fields and places the result in a third field. In the resulting table the selected field has the data type text rather than memo. This causes a truncation of the information in the selected memo field. Is there a means to instruct the...

It seems like this ought to be very simple but its not working for me. I've written a document and received many comment from reviewers, all of which I have entered into a table. For some comments, I made an initial response and for others, there is a second response (after cooler heads have...

Isn't there a way to hide the little record counter/selector thingy on the bottom left of a form? How do I set up a command button to do next and previous forms?

I would like to use a command button to open a selected MS-Word document from a group of possibilities. I have a form that displays information about various generating plants. By previously selecting the plant, the form opens with data for the selected plant. Because there is a large amount...

I am working on unknown ground, here, so there is much that I do not know. I want to invoke a query from a command button on a form and Wayne Ryan suggested I learn more about queryDefs and use that approach. After a little study, it seems to be the way to go. When I searched the Query Forum...

How do I pass a parameter to a query using a command button?

I have a form with several command buttons on it. Clicking on the command button runs a macro that opens a second form which takes its data from a query. I put a condition in the macro that one of the fields have a specific value corresponding to a specific plant. When I click on the command...

SLR Question to Ukraine82 re: tab control and combo box: I read your post of 26 Aug 04 and it sounds like I have a similar problem. I thought I would ask for your help directly because I do not understand the solution you found. First, the problem: I have a database containing a large amount...

I use a form with control buttons to branch to a second form. A double click on the button takes the user to a second form. I now would like to replace the second form with a third form that has different attributes. It seems to me that all I should have to do is to replace the name "second...

What causes an indeterminate join type? I use the lookup wizard link tbl-A to tbl-B to give me a drop-down pick-list for entering data in a table but when I look at the relationships window, it is labeled as an indeterminate join. Is that a problem or can it be ignored? If it is a problem, I...