Search results

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

Montemontgo, If you think it will help, I will send you a more detailed description of my ugly solution.

ansentry, Yes to both. I must confess that I was in too much of a hurry to read the options on hte first menu and selected Form Operations. It seemed to me to be a logical place to go. Some day I'll learn to slow down. Thanks much for your help.

Trucktime, Thanks. I knew there was an easy solution but could not find it in my reference books. Once again, you have come to my resque. Note to the other guy: You are right; I meant previous nad next records.

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?

To trucktime and Reclusive Monkey, I worked out a solution to the problem I was describing yesterday. It is ugly and goes against some of the advice I received. It does have one virtue: it works. I wrote a macro and in the macro list set the condition to be equal to the plant ID number...

trucktime, Thanks for the advice. As you can see, ideas are coming faster than I can try them. I downloaded the sample and will spend time analyzing it.

RM, Thanks for the tip. It sounds much easier than my approach. I'll give it a try.

RM, Well, you’re right about the ouch part but I do not get to make all the decisions. My generating stations are U.S. nuclear power plants; the last one came on line in the 90’s and no new ones are on order so the data is not very dynamic to say the least. I have several tables with details...

RM, Thanks for your note. Tell me what else you need to know. The basic scheme is there are only two form in my database. The first form has 125 command buttons, one for each plant. Clicking on any one of the cmd btns branches the user to the second form by invoking a macro specific for that...

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?

Alexei, Thanks for your interest. The db now contains some senstive information and I cannot really post it. The problem turned out to be a broken reference to another table. I had renamed the table and I should know better than to do that at this stage of development. Thanks, again.

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

New Agents zip file Michael, I have reviewed the database you shared with me so generously and it has exactly the behavior I am looking for. Thank you. I need to work backward through your setup but I believe I know enough to do that profitably. My wife had a baby girl last week and she...

What about the tab control? Michael, I did get your message and thanks for that. I think I understand what you have told me but I do not understand how this works with the tab control. I must not have provided enough detail. My idea was to have a combo box from which the user chooses the...

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