Search results

I should have said that access can't find the new Query I made off the new table. I did try just the table earlier but got the same type error message, it couldn't find the table.

Sorry I can be confusing sometimes, Yes, I looked at arnelgp's usage. I have gotten some good advice there. The article was using OutputTo. I haven't had any success there. Only TransferSpreadsheet. I guess its because I'm passing the data to a macro enabled Excel book. I used some...

Thank You for your help. I pulled the data straight off the open form and put it into a table. sort of recreating what the query was supposed to do but shouldn't have any trace of where they came from so it should solve the issue as a work around. so far so good until Access can't find the...

Or is it possible to just pluck these off the open form, put them in a string with seperators then export the string to Excel?

Or can you directly export the result of a Query then just copy that 'query view' from above directly into the code??

Here is what Query View gives: SELECT tblDocsIssued.Title, tblDocsIssued.PartNum, tblDocsIssued.AssignedVendor, tblDocsIssued.SQEName, tblDocsIssued.NewLBTrackNo FROM tblDocsIssued WHERE (((tblDocsIssued.NewLBTrackNo)=[Forms]![frmDocDetail]![NewLBTrackNo]));

OK Some progress (??). On the query that I am trying to export there is a criteria that is equal to a control on the form. Now the control is the 'Document Number' which is just a string variable, nothing multi-valued about it. But I deleted that Criteria and I worked. Of course I dumped...

Thank You for the help. I remember getting this while I was originally trying to do it all in Access. Part of what drove me to try to do it in Excel. Since I am referencing a qry instead of a table for the output I am not sure what it means. there are no multi-valued fields in the Query...

Private Sub cmdSendDev_Click() is Access Code and Private Sub Workbook_Open() is the Excel Code I would like to move it all to Access and then launch the Excel after the data is exported to the Excel wkbook, if that is possible. I certainly seems feasible and there is no benefit to trying to...

Adding to my previous. Maybe useful: I believe the excel file has to be open for that line to work. The file that the data is coming from and the one the data is going to is (was) opened in the Access Code. Application.FollowHyperlink "C:\Users\gkissick\Desktop\DeviationFormData.xlsx"...

the error is here: Workbooks("C:\Users\gkissick\Desktop\DeviationFormData.xlsx").Worksheets("qryDEV").Range("A2:E2").Copy _ ThisWorkbook.Worksheets("Engine").Range("K1:O1") the previous line to unprotect the sheet is likely not needed. Its just something I tried in case that was it. the...

I want to send some data from a query to a macro enabled (.xlsm) Excel workbook and then open it (the excel workbook) from access. I have had to do some work arounds that don't make sense just to get as far as I have gotten so I would be happy to hear the 'right' way to do it so I don't need...

Thank you. A) I didn't know click events could be Public and B) I would have said Call DocType_AfterUpdate. I didn't know you could call it that way. Working great now and on to the rest of the process.

I've tried a couple of things including setfocus. The first tab position is the DocType combo so the cursor starts there anyway This new button doesn't behave any differently except (thanks to your guidance) the DocType is prepopulated with 'Deviation Authorization'. I had thought that when...

Minor Glitch. I rely on the 'After_Update' on that DocType combo to launch the next part of the procedure. Quickly, I tried to add a line to refresh frmDocDetail to the procedure and that didnt' work. I am looking for a solution but would appreciate any idea on how to fix, Tab to next field?

bob fitz pointed me to just setting the first column value and that worked great. But thank you, I think your solution would work great. I had already started to think about skipping the button on the front page entirely since I am going to have to put together some procedures on frmDocDetail...

Thank You very much, that worked like a charm. I guess I got hung up trying to set the .column(1).

I have a form which contains a combo box named DocType. In usual operation it works fine. user selects from a list coming off a table. real simple, must be from list. I added a button on my 'Front Page' form called NewSwitchboard . I want the button to launch the above form in Add mode and...

Yes it does skip the first record, got lucky as it didn't have an attachment. I do understand some of what went wrong with using DLookup. Ultimately it was the wrong tool for the job anyway. Thanks for all your help.

Thank You. I got it working. Now philosophizing: If you took all the 'work' we supposedly 'saved' using MS Access Attachment field and doubled and doubled and doubled it, it doesn't feel like that would come close to the work I had to do to get us out from under the all the problems those...