Search results

I've attached a screenshot - the highlighted fields are the ones I need to import. The spreadsheet is always in this format and the information pertains to only one record. The names of the cells do not change. Thanks.

Here's a new question - if I use TransferSpreadsheet to import one named cell at a time into a bunch of temp tables, how can I go about moving the data in those fields in the temp table to the actual table I need to update? This spreadsheet only has one record in it at a time but there are...

I'm still stuck on this - does anybody have any suggestions about how to import non-contiguous cells?

Thanks for the function. So do I need to plug this code into a module and call the function from the button click subroutine? Also, I've not used OLE automation. Can anybody point me to a good source so I can learn about it? Thanks

[SOLVED] Importing non-contiguous ranges from Excel This is actually a two part question - I need to import several fields from an Excel spreadsheet that is generated from another program. The spreadsheet is always on the user's personal mapped drive - call it the U: drive, since all the...

Thanks, Colin! I'll keep you posted.

Mark - I see your point and in fact, was thinking I might ought to check out the other method. Batch files can be wonky sometimes - as wonky as end users. :D Colin - would you be willing to a share yours with me so I can check it out? Thanks, Diana

That's what I was looking for! I'll give it a try. Many thanks! Quick update - that worked exactly how I needed it to. Thanks again.

I was able to make it run successfully from my local drive - there is no batch file DOS window displayed. I would be more than happy to use an updater db - I'm not married to the batch file idea. Can somebody point me to a working example? Thanks.

The Form_Load code is already in the opening form. The UpdateFrontEnd code is in a separate module and is called by the Form_Load code. The question is how to make this code write the batch file and run it from %TEMP%. The group policy has been modified to allow the batch file to run from there.

I am trying to implement the Front End AutoUpdating Utility that has been so graciously made available by Bob Larson. I am trying to run it on a network with a fairly strict group policy. Every time the code gets to the point of running the batch file, it stops. The batch file is created and...

Thanks so much for all of your help. I have learned a good deal from this exercise and I appreciate it.

This does make a lot of sense. I do have a couple of questions, though, to make sure I understand. Am I correct that the public routines go in the module for the second form and the private GoToRow function goes in the On Click property for the calling form? So, I'm thinking I need to do...

That does make sense and it works great! I appreciate it so much! Now, just to complicate it a little bit, I would actually like to give them the option on the first form to search by [job#] or [NCR#]. I'm sure I can add an if statement to the calling form but how would I handle it on the...

MarkK - I should have never doubted you. :D However, it only loads the one record in the 2nd form. I want to go to that record but allow the users to scroll through the others in the table as well. That's why I thought I needed a recordset.

Mark, I don't just want to know if the record exists, I want to find it and move to it when the second form opens.

Now I'm getting a different compile error, landing on this line Dim rs As DAO.Recordset The error is: User-defined type not defined.

Sorry - getting the same error.

Making progress - thanks for pointing that out. Now I am getting a compile error - Method or data member not found on this line: rs.FindFirst "[NCR#] =" & lngNCR [NCR#] is the field in the Non Conformance table that I am searching on.

Ok - I fixed that part but I'm still getting "Sub or function not defined". The debugger is landing on this: Private Sub CmdNCRContinue_Click() here's the whole bit of code again: Private Sub CmdNCRContinue_Click() Set db = CurrentDb Dim rs As Recordset Set rs = dbOpenRecordSet("Non...