Search results

Ok. Tables sound right. To avoid entering the room number on your expense entry form, you can use a combo control that looks up and allows you to select the room number. Go through the wizard and have it look up the room numbers from the room table and enter the picked value into the expense...

I know this isn't the solution you're looking for, but you could close the "intermediate" form with the other form's closing, or maybe close it from a timer.

You should probably do a bit of reading on normalizing databases. Your situation calls for a one to many relationship between a table that has a record for each of your rooms and a table that contains the records pertaining to each room. With this relationship, you should be able to devise a...

No problem, David. Glad to help!

Is FILE_CUST referring to the Navigation form? I don't have a solution, but I think the problem is that the Navigation form isn't passing values. I tried using one to pass date values for a query but Access acted as if the form was not open. I wound up using the navigation form to open...

With regard to the subforms, you are making them invisible, not closing them. A command button can do more than one thing. Just add multiple lines of code. Your command button to make a subform visible should also hide all the others: Me.fsubSomeSubform.Visible=True...

In the code you posted, you can't hide the Incident Main Form because it contains your subform. I envisioned that on the main form you have a series of buttons that each opens a separate subform. The code for each of them will make ONE subform visible and hide the rest. Regarding the user...

Re: response I'm not sure where the reports you mentioned fit in. Your original post talked about selecting something on a form and receiving follow-on questions. In any event, whatever you select should run a query which selects your follow-on yes/no picks. Use that query to populate a...

I don't think you've posted enough information to elicit a good response. How many questions are there? What is their source? If you have a limited amount of questions, you could place the follow-on check box choices in a subform and then make the appropriate on visible after the question is...

Are you trying to parse the data in a field so that you can split it into several pieces? (sorry, but I have no idea what you mean by lines and columns.) If that is the case, take that data out to Excel and use it to parse the column.

You are very close . . . there are just a couple things to clean up. Let's start this button from the beginning just so you understand what's going on. Delete the code in screen shots 1 and 3 by highlighting those lines and hitting delete. Then delete your existing button. Add a new...

Great! You're welcome!

Re your first issue, one way to get the subform to link with the combo box pick is to use the following code in the After Update event of the combo: ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[FieldYouAreLinkingOn] = '" &...

If I'm understanding what you need, try this. Add all of the subforms you need to your main form and set Visible to No. Make sure the Master Child relationships look ok. If only one subform needs to be visible at a time, you can overlap them to save on screen real estate. Add command buttons...

The subform is still embedded in your form, right? It almost sounds from your description that it isn't any more. If that's the case, it's not a subform. Are you making the subform not visible when the main form opens and then opening it with code? Simply changing the visibility of a subform...

EDIT: I think I duplicated Recyan :banghead: I think this is what you want. Adjust your expression according to your table, fields and grade ranges. SELECT tblGrades.Grade, IIf([grade]>=90,"A", IIf([grade]>=80 AND [grade]<90,"B", IIF([grade]>=70 AND [grade]<80,"C", IIF([grade]>=60 AND...

I didn't get an extra record importing into 2010, but I did notice that you have about 30 CR/LF's in your file. Try opening in notepad, move the cursor to the bottom of the file and then backspace bringing the cursor to the end of line one. You should, however, have something like a required...

Have you tried starting Access and then doing a File, Open? Also, can you temporarily move the new back end and put the old back end back where it originally was?

I guess that's a personal request for a response!!! :D

I can't tell for sure, but it sounds like you may be calculating the age and storing it in a table, and then you are running a query that you want to display the age. I'm guessing that because you say your are able to derive the age but then run into problems with the query. If that's the...