Recent content by robina

Okay, I got it to work. this is what I have in the load event of the subform: If Me.RecordsetClone.RecordCount = 0 Then Me.Visible = False

I appreciate the quick response. I need to make the entire subform invisible, not any certain control.

bob, I agree, that would be great. I tried but believe I had the wrong syntax to refer to the actual subform vs. a control. Can you tell me the code?

Hi, I have already read this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=13864 It was helpful and closes the form if the query returns no records. My problem is when i use this form as a sub form, it makes the main form close as well. How can I make the main form stay...

plog, Thank you for your help. I created a UNION ALL query and it works beautifully. I appreciate your time.

I have a query that is based on three queries. 2 of those queries have the same fields but return data for different dates. The 3rd query returns the dates needed. In other words, I am trying to return all results from both queries. these are the results I want: Report_ID...

I figured it out. The module name cannot be the same as the function name. It works now. thank you.

I put it in a general module. I've attached a screen shot. thank you.

I get the "Undefiend function in expression error when the query runs.

Instead of using a subform I would keep everything on one form. Put the comboboxes in the header. I am assuming the combo boxes are unbound. The record source for this form should be the query you are using to return records. In the query the criteria row for the userName field should have...

I have read through all the date threads I could find but didn't see a solution. I need my query criteria to be >the last tues of next month. How would I write this? Thank you.

I would get a message stating that every record would be updated. I've since then been able to have the input on the subform automatically save to the data_tbl by using the table in the query for the form. This made the controls bound. I would still appreciate knowing the correct syntax. You...

I have a navigation form, a navigation subform, and then a subform. When I click the save button on the navigation subform, i need the data entered in two fields on the subform to save in a table. the subform is based on a query. This is what I currently have on the the button's onClick event...

The thing is There are records to display. There is a Year to date query that has records to return on the right of the form. I added data for june so the form would show. The screenshot and a copy of the dbase with the form showing up are attached. I need at least the YTD data to display...

Sure. ID Item billing date count approved. 1 Midrange Critical Apr/2013 200 Yes 2 Midrange Critical May/2013 200 3 Intel High Apr/2013 526 Yes 4 Intel High May/2013 300 This...