Search results

Sorry site is blocked by my company.... I thought it would be like: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "strSQL", outputFileName, True

I have a continuous form that's a search form and I need to export the data/criteria it populates in the detail section. I pieced together what I thought would work but im getting an error 3075 and debug takes me to DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9...

@Josef P. that worked perfectly.... Thanks!

I tried Select Top (@Rows) in my query and that works but my functions message box counts number of records and if I set the # of records to say 30 and I'm actually missing 74 records then my message box would say I'm missing 30 records and that's not correct.

Is it possible to limit the number of rows in a message box? I have a loop that displays data in a message box and the max rows it can accumulate from data is 74 rows which is way to long, the Yes/No button is off the screen it's so long... Is there a way to limit the number of rows of data so...

@theDBguy That worked perfect, Thanks! Set rs = fDAOGenericRst("qry_FindNullRecords", dbOpenSnapshot)

Sorry Fellas I was off for a few days... I'll try your examples and suggestions today!

@MarkK I did check the names previously and they all were correct. If I have the form open and run the query in datasheet view then the query runs fine and show results. BUT if I open the form and close the form thats when it checks the Function/Query and thats when I get the error.

Hello, I have a function that's giving me the error 3061 and it worked fine until I needed to add a field to the query that's a date field and a criteria for that field to a date text box on the form that I'm running the function from. Errors and Degug to: Set rs =...

@Pat Hartman, there is a reason for the pop up and this is sorta a validation for my subform to let you know there is data still. I have validation in place for the main form but i cant validate on the sub because it might take 2-3 days to enter data being the application is opened and a little...

@theDBguy it does work somewhat. The result is if it's a new record with no data entered then (MsgBox "TEST 1 CLOSE FORM") Then it supposed to run through the query to look for null records and if there is some its displayed in the message box pop up but after that I need to stop or exit the...

I have the function below on my forms Unload Event and all I want it to do is when I close the form, if there isn't a record created then just close the form. If frm.NewRecord Then MsgBox "TEST 1 CLOSE FORM" If a record was created, then it runs through qry_FindNullRecords and...

@MajP, thanks so much! ... Unfortunately Ill have to mess with it Monday when I get back... The reason I wanted something like this is because when entering data into a list of 20ish different products who wouldn't want each row visibly show that it had changed to another product. I just...

I am leaving it the way I have it which IS editable, and the sections are highlighted, the only thing is I have the product name on each line which is fine... Thanks you guys for giving it a go, Sorry I didn't see the.... (Not being editable is also mentioned in the original thread you got the...

Sorry I didnt see your post before adding files to above post... Yes its a data entry form and the only data entry in the subform is the Count text box.

Ok, @June7 this is a data entry form that needs a "Count" for each Product(s)/Length(s). This database is a monthly label count for inventory. Summing the count for each Product isnt what I needed I just need to enter a count each month for inventory. Example: Product1 8' the count is 3...

@June7 I created the 3 Querys from your SQLs above and ran the Query3 and it seperates like I wanted BUT now im missing my count that I needed. I tried adding the tbl_InventoryDetails to Query3 and the field "Count" and "InventoryOverviewID" but then all the format changed when I ran the form...

@June7 and @CJ_London here is a stripped-down version of what I have so far.

Thanks for explaining @June7 and @CJ_London but I'm so confused on how to do this.... attached is an image of my query and I wanted to do this with Product which is the column I want only the first name like their "Customer Name" can you explain how I can do this with mine? Thanks!

@MajP im having a bit of trouble. I get everything working like in their example under the example I'm looking for frmFormReportSimple and the qryFormReportSimple BUT if you see in their example, they have one company name under table C and it only shows on the first line and the same company...