Search results

I have a form (HappyForm) which opens up another form (VeryHappyForm): DoCmd.OpenForm VeryHappyForm Before closing, VeryHappyForm updates some controls on HappyForm: [Forms]![HappyForm]![HappyControl] = [Forms]![VeryHappyForm]![VeryHappyControl] Everything works and everyone is happy. I now...

I've encountered this error in the past. The last time I ran into it, I recall that I had the name of a column wrong that I was referencing in Form_Current... Something along the lines of Forms![MainForm]![Ooops] instead of Forms![MainForm]![Great Job] The odd thing about this error is that...

Good point - What I mean when I say that the subform works independently is that if I open it as a regular form, all the unbound items are displayed and it waits for an event - there are no runtime errors. The point of this test (in my mind) is to make sure that there are no errors on the form...

I have a form with two subforms. One of the two subforms works perfectly. The other just gives me a grey screen (like there's no recordset). The two forms are very similar and I've checked everything I can think of... Here's what I've done. If you can think of anything else to try, please...

I'm still having trouble with this one - No matter what I try, it keeps asking for a parameter value. Assuming I refer to the subform, should I be using it's "real" name (the source object property) or the name used on the main form (the name property). Thanks in advance for any help!

Fofa, Let's say that some user tries to open Form2 without going through Form1. The user will never actually press a button on form1. They may try to open it directly from the "forms" tab. If this happens, I want to be able to gracefully close Form2. Ghudson, This is similar to code...

I have a form that I want only to be opened from another form (i.e. the user presses a button from form1 and form2 is magically displayed). My solution: In form2, I check to see if form1 is open in "use" mode. If not, I display a message and close form2. The problem: The close code...

When I try this, it asks for a parameter value. For clarification, I'm using the following: SELECT [LAB],[COAT] FROM [University] WHERE [COLOR]=[Forms]![SomeForm]![tbColor] AND [TYPE]=[Forms]![SomeForm]![tbType]; It should probably be noted that SomeForm is a subform. I've tried a few other...

I have a combo box which has a table/query row source type. For the row source, I want to use a query that contains some data from text boxes on the form. I'm currently trying: SELECT [LAB],[COAT] FROM [University] WHERE [COLOR]=tbColor.value AND [TYPE]=tbType.value; Although this is a valid...

Hi Pat, I hadn't really thought about attending the AUG. However, considering the amount of time that I am currently spending and will be spending in the near future, it might be a good idea. Do you have any information that you can send me or can you point me in the right direction to...

Ok, Let's say I go into File->Database Properties from the "main" Access screen. This brings up a window with the title "<database name> Properties" where <database name> is the same as currentproject.name. This window has several tabs including "Summary" and "Custom." It looks like this...

I'm going to make up names and values -- I'm interested in the structure. Table ALPHA: COLA DAT1 DAT2 DAT3 1 5 7 9 2 4 14 8 Table BETA: COLA_IND DAT1 DAT2 DATN 1 a b c Table CHARLIE: COLA_IND DAT1...

Let's say that I have two tables: Table Numbers: ID VALUE -- ------ 1 123 2 456 3 789 Table Letters ID VALUE NUM_LOOKUP -- ------ ------------- 1 ABC 1 2 DEF 3 Now, I'd like to use the lookup feature so that NUM_LOOKUP is a...

You're right - It does look quite ugly. Especially without the real names. As I was studying this problem today, it occurred to me that it may be a flaw with the design of the tables. I imported from Excel and the Access Wizard seemed to do a pretty good job normalizing it so I didn't really...

Thanks, Ken! It figures that I was missing something obvious!!

Ok, this query is driving me crazy. I'd like to get it so that there are no duplicate values in the [T1].Data1 column. Here's what I have: SELECT [T1].DATA1, [T1].DATA2, [T1].DATA3, [T2].DATA1, [T2].DATA2, [T2].DATA4 FROM [T2] INNER JOIN ([T1] INNER JOIN [T3] ON [T1].DATA3 =...

I have a subform on my main form. Note that there is no relationship between the recordset of the main form and the recordset of the subform. I need to be able to change the filter on the subform dynamically during run-time. I know this sounds a little odd because in theory I should be able...

Thanks for the response. However, I need to be able to display both columns... Does Access by any chance have a drop-down Listbox type? Thanks

I'm sure this is simple and I'm just missing something... I have a combo with two columns and the row source set up as a query which returns two columns. When I click the drop-down arrow for the combo box, I get exactly what I expect. What I want to do is initialize the combo box so that the...

The problem isn't the left hand side, but the right hand side. There doesn't seem to be a way in code to bind data from a query to a text box. I'd expect there would be something like: Query![Query Name].Field ... but I haven't had any luck finding anything.