Search results

Sometimes I'll create a form, attach VBA code to it and then decide not to use VBA code with that form. Yet the form stays listed in the Project Window even though it no longer contains any VBA code. Is there a way to eliminate the form from the Project Window? [I realize this is just...

That's a shame. Guess I'll just have to make sure that he MsgBox question is worded carefully.

Is it possible to modify the Yes / No buttons in the standard MsgBox? Say you wanted to replace the standard "Yes" with something more specific. For example, "Proceed with saving new record". Is there an easy way to do this?

I'm taking an ACCESS course right now and we've just covered the topic of Self-Joins. (We're using ACCESS 2003.) The examples in the class text show the Self-Joins being established within the Query window of query design. My question is: Should Self-Joins (and, of course, duplicate copies...

Thanks, dK. If I'm reading the code properly, I think I still need to "tweak" it a bit to allow the user to save the new name/record if the new employee truly is a different person. eg. say there are 2 John Smiths.

Still trying to get my head around vba code. Perhaps one of you has some sample code that will help. I have a form to enter new employee names. Before saving the new entry, I would like ACCESS to check the existing table records to see if the new name already exists. If so, then the user...

I have a hypothetical question. Let's say that a DB has 5 tables and that all the tables are connected to each other through 4 relationship lines in the E-R Diagram. What if there are other possible relationship lines that could be established between the 5 tables. Is it recommended that...

Thanks, David. I'll give that a try.

Thanks, Bob. I'll try the stacking method. - - Robert

I have created a form that includes a number of text boxes. Half of these text boxes are unbound. They are visible to the end user for inputting data. The other half of the text boxes are bound, but invisible. Through the use of VBA code, the data input into the unbound text boxes is later...

Bob & Paul - Many thanks. Over the last year, I have definitely learned a lot from you two. No doubt, I will have further questions in the coming months. Much appreciated, Robert

Thanks, Paul. Thanks, Bob. Now I understand. I didn't realize I had to be within the form module first. Bob used an AfterUpdate event to avoid the need for a command button to run the query. I may toy around with deleting the AfterUpdate event and replacing it with an explicit Command...

David: Thanks for the suggestion. It helps. But I'm still wondering if there's a way to see the possible entries in something akin to a combo box without leaving the query module. I know I could go into forms, look at the combo box there and then go back to the query. But that's...

Hi, Bob. I tried the revised file which you posted. I see that the form reference now appears as a criteria under the EmployeeID column in the query. When I click on the query, it still prompts me for a response with no guidance as to what the possible entries might be. I must be missing...

Hi, Paul. I've created a form with a combo box (frmSelectEmployeeName within the attached zip file). I'm not sure where I'm supposed to place the reference to the combo box within the query. I assume I'm supposed to have the query open in design view, but where to place the combo box...

I have created a simple select query to list employees and their various jobs / positions. I thought it might be useful to have the query prompt users to specify which employee was of interest (rather than show the entire list of employees and their various jobs). So I went into design view to...

I have a form with a combo box on it. The combo box is based on a query which selects 3 fields from a table: primary key (autonumber) FirstName LastName The column width property for the combo box is set up so that only the FirstName and LastName are visible to the user when the user...

RossWindows - Thanks for the re-working of my zip file. I have a few questions which I hoped you could answer: Why do we need additional text boxes that are unbound? Wouldn't it be easier to have the textboxes bound to the "real" fields in the tables? I noticed that the Query for the...

Alan - If the parent & sub forms can be made to "look" like they are 1 single form, then I think that might be okay. The only drawback I see is that the list of forms would include a sub form which I would not expect or want the end user to open directly. Ross - I will try your method to...

This question has come up before, but I have not completely understood the answers given. QUESTION: Can I use 1 form (avoiding sub-forms, if possible) to enter the following info? First Name Last Name Join Date (date hired basically) going into one table; with the Job Description...