Search results

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

I have a table that contains the following fields: ID (autonumber), Item, billing date(mmm/yyyy), count, and approved. My first query returns records where the approved field is null. My second query returns returns all records for 2 months ago where the approved field is not null. This is...

i used [tab1frm] as a generic name. the form navigation form is called Navigationfrm. The form that comes up blank is called KI_Dashboard. You access it by clicking on the tab that says "Mainframe KI". If there is no form up automatically, then under forms double click KI_Dashboard. It will...

Thank you. The attached the dbase is in access 2010 because its features wouldn't allow me to save to an earlier version. Notice that the form is blank but if you add a june record to the kI_data table it will show up. ONe field is a graphic, It doesn't show in the trimmed version, but that ok.

I have a tabbed navigation form. I have a form on one of the tabs, [tab1frm] that a query that consists of 6 fields that are each from a different query.as the record source. This shows a percentage field, an image field, and a count field for current month and then then the same fields for...

hi, i have a query that returns records in datasheet view. I need a field to accept the user selection from a drop down, then save that to a table. The query is based on a couple queries and one of those queries is based on the table i need to save the user input into. When i make a selection...