Search results

Thanks. I had another go at this last night, and after a couple of hours got the parameters to be recognised. The change came when I specified the changed the name of the referenced query to just (pstrTableOrQueryName) without the " & etc: Set qdf = dbs.QueryDefs(pstrTableOrQueryName) '(" &...

Thanks for your message. I've spent hours and hours and hours on this for the fifth night in a row, and I d'ont seem to be making any progress..... I wonder if I might do better to run the query as SQL standalone and dim and refernece the variables directly in the VBA..... What debug.print...

Thanks Sneuberg for your reply - that is interesting to know, and I will pursue it. Matt

I am using a utility put up on line here : http://www.peterssoftware.com/mlm.htm to represent spatial data using Googlemaps from within an Access database. I am using the mapping function with app. 2000 pieces of project data, that has OSGB coordinates, that are converted on the fly to lat lng...

You're a star - appreciated, thanks - this is most of the work done. Kudos!

For anyone else who might just get the same problem in the future, a quick fix is for the user sending the data from Excel to Access using SQL like this, to Open the target database. This has sorted the problem for the time being. Not elegant, but it works.

I have a form where Conditional Formatting has been used. I want to run a routine to show me on which Controls the Conditional Formatting has been used, and what expressions were used in the Formatting. Having Run Database Documenter, I was hoping to identify all the Conditional Formatting used...

Well this would mean a total change in system which will take a lot of effort to sort out, and meet much resistance. My SQL solution joining Excel to Access was elegant and efficient - I'm not going to abandon it just yet! thanks for your help

OK will try - thanks. I wrote a piece of SQL to pick up individual values, and with an Insert statement, append to a back end table. This code is repeated for 6 buttons/rows. Ideally the code would scroll through rows until values were null, but that is too clever for me! thanks again Matt...

Hi. Yes, the Excel file is stored on a network share. Personnel have a timesheet each which they fill in. An admin person then opens each time-sheet, does some validating and totalling/editing, and then performs the upload. So the sheet needs to be modifiable to be useful. Are you suggesting I...

Hi folks. In the interim this has continued to be erratic in success - perhaps 40% failure, which can be overcome by closing and opening the Excel file. After ensuring that all other users had closed any front end connections to the target backend, so ensuring that the shared front end...

1. Excel spreadsheet with VBA code triggered by button click to run SQL 2. This uploads data from Excel spredsheet to Access mdb back end on shared network drive. 3. The front end that is used to access the back end is (shame on me) a single front end that is used by multiple users. I *know*...

I now have the error - So sometimes, the back end table can't be located - perhaps due to a network error. The procedure has been working for 6 months with a few hundred successful runs per week, and has only raised an error now. thanks again Matt

Thanks very much for this, I have now adapted my code regards Matt

Hi all, I have some SQL code I wrote last year that helps us transfer data from Excel timesheet spreadsheets into a backend access database. Recently the code has started to stop working, but quite erratically (i.e. for one user the code fails to run, but for another it will, despite Permissions...

Thanks for reply. The Error Code bit is left over from me grafting together other examples and not cleaning up after myself. thanks again

I have put this code together to delete linked tables if they exist, so that tables from a different back-end can be linked in, as required. I know my understanding of error handling is poor. Would anyone please have a look at what i have written and comment on where I need to improve? If the...

Aha. thanks!

So I ended up with the code in this thread http://www.access-programmers.co.uk/forums/showthread.php?p=1438371#post1438371 The code fires form a button in Excel

for anyone interested, this is my code which works: Private Sub CommandRow29_Click() Dim strSQL As String Dim dbs As DAO.Database, iCount As Integer, weektxt As Date, usertxt As String, nametxt As String weektxt = Format(Range("B27"), "mm\/dd\/yyyy") usertxt = Range("D27") nametxt =...