Search results

Using doCmd.transferSpreadsheet is a little over my head. Can you please give me a little more info?

it still gave me the same error. db.QueryDefs.Delete strTempQryDef ' I changed it to' DoCmd.DeleteObject acQuery, strTempQryDef was that correct?

I'm trying to write some vba to export filtered records from a subform. I've found a number of post related to this issue and I've cobbled the code below from those post. When I run it I get a run-time error saying the Object '__temp' already exist. When I click debug it highlights the line...

I have a form that has two subforms that are in data sheet view. is there a way to synchronize the horizontal bars on both subforms? So when the user scroll to the right both Subform1 and Subform2 stay insync.

I had a moment where my sample db worked but my main did not. But I recreated the form and it worked. Thanks for the help.

Sorry for the delay on uploading my database. I had to make a sample db where I recreated the issue.

When I use the master and child, the ID is given for the NIIN field.

NIIN is declared as a short text. The combo box format is number.

No, I'm not working with nato stock numbers. the values of niin is like these: 0000000046 0055668355 0090206281

The data type in the combo box is number while in the table it's text. It's part number, some start with zero and I have to keep them that way. Is there a way to change the combo box data type? I'm not getting an error now, but it's not returning any values. Just to cover all bases, I check...

have a combo box on a form that I want to filter a subform (SubSearchMaster_frm). I getting a runtime error 3464: data type mismatch in expression. the code is below. Private Sub CboNIIN_AfterUpdate() Me.SubSearchMaster_frm.Form.Filter = "[NIIN] = " & Me.CboNIIN...

Something weird is happening. Instead of having a line between linked items, it's only showing a dot beside each item. Thanks for your help. I'll do a work around, make two queries and go from there.

I think I should know this... I'm trying to find duplicates records on two table and blanks. I've linked two tables and it shows all the records that are in both tables. But I can't get it to include all the records that are empty in the ecp effectivity column. SELECT REV1Val_WP_Tracking.*...

The queries are not editable.

It's not very clean but doing a loop is above my head right now.

That's a little bit above my ability, can you give me some sample code? Or point me in the direction where i can figure it out?

i ended up using the code below for each checkbox. I hoped there was an little bit simpler code than having a code for each checkbox. But oh well thanks for help. If (DCount("*", "SearchToolValidationDate_Bt_qry") < 1) And (Forms![2ndfrm_AddEditView]![CbCATracker1] = True) Then MsgBox...

Before when i would search for different types of data and I would get a message for every query that had <1 records. I have five queries. I would like to get a message if the DCount is <1. One message, not a message for each query. Looking at the problem another way, if the...

Sorry for the confusion. If there are records a query will open but if there are none then it will not open. If a query does not open the user might think the button is broken. So i would like to have a message if none of the queries opened.

Then how would I get a message when there is no records?