Search results

Hi Guys I'm quite interested in this process of converting from Access to vb.NET. I App I wrote in Access some 5 years ago has evolved over time with lots if updates and few redesign phases but I'm a couple of years from retiring and I fear there will be no one to look after the Access App I...

Hi Folks Thank you all for your help :) I did manage to get a function working to test the ODBC connection is usable. I have listed it below, I think its a bit clunky but it does appear to return dependable results. It fetches a value from the SQL Server 'sysobjects' table. which is placed in...

Hi Issac/David. Thank you for that nudge and info. I did change the query as suggested by David to strSQL = "SELECT TOP 1 [NAME] FROM sysobjects" I do have access to the database through SSMS and I ran that query and I get a result " 1 | sysrcols " which is great. :) So I now know I need to...

Hi All, thanks for your input. I implemented your suggestion with the With .OpenRecordset(strSQL) But I'm still getting some sort of data type conversion error 3421 Any thoughts Many Thanks Jerry

Hi Guys My Access App connects to an SQL Server to collect product data that we print 2D matrix barcodes for. In general that all works really well. However, currently if the ODBC link is down for any reason the App Errors out and crashes. I have put trapping code in now to check the Internet...

Hi Guys Thank you for your comments and suggestions. I'm not really clear on how I want to handle this, I thought about using scripts, but there's the added issue of managing the deployment environment and making sure every install is setup correctly, I think the scheduler idea falls into the...

Hi I used Access to develop a 2D label printing App connected to my clients ERP system. We use Bartender Label Printing to automate the Barcode printing and this all, in general works really well, over 3 millions labels printed from in WW. This requires Bartender automation system to be ready...

Hiya yes I have seen them the problem I have is that controlling windows services isn't running a program like an .exe. its VBA For Each svc In GetObject("winmgmts:{impersonationLevel=impersonate}!\\.\root\cimv2") _ .ExecQuery("SELECT * FROM Win32_Service WHERE Name='" service & "'")...

Hi Guys I have built an Access app that uses Bartender to print labels. Bartender requires some windows processes to be running. I have been able to read the status of the processes and run commands to stop/start the required windows services. However, this running the app in Administrator...

Hi Guys Well thank you all for your help, I discovered the problem quickly after your posts. Was a typo really - got the format wrong. Offending Dlookup: DLookup("ProcessLock", "TblRendesvous", ID = 1) Correct Dlookup: DLookup("ProcessLock", "TblRendesvous", "ID = 1") Thank You all once...

Hi Thank you all for your suggestions I shall look into these when I get to work tomorrow. Thank You Jerry

Hi Guys This has confused me a lot. I want to read the value of yes/no value in a table. This value is set (ticked) when I do the dlookup of the value it always returns NULL. I was sort of expecting 0 or -1, Or true or false. I just want to reflect the value of the Yes/no data in the table...

Hi Guys I think I have it sorted out now, I had two macros for button events. I changed them to procedural and my error seem to have gone away. Cheers Jerry

Hi Guys… back again with a similar problem although I have managed to progress since Minty offered his help. Thank you again. I have the SAP auto update working on a single PC client with the help of a table based semaphore system that was suggested. And I can even shutdown the product search...

Hi Minty I agree your processlock is great, I seem to remember it being called a rendezvous back in the day :) Sorry I wasn't suggesting that they would run at the same time. they cant, but as they are timed events triggered from when the form starts, it could be that each form has the...

Hi Minty, Thank You. for your thoughts and reply. After some thought I'm not sure it would work that well as it would still allow both instances to run the request. if they get a chance of the collect a ProcessLock. Id like to just stop one of the instances running the event completely...

Hi The_Doc_Man, thank you for your response. Yes, I'm sorry I didn't explain it very well forgive me :) The Access db is a unified single file not split. A bit of background; The company has a SAP ERP product with the SQL Server backend in the USA. This is used by order processing, accounts...

Hi Guys I've been having a hunt around the web and not been able to put together a solution for this maybe you can help me please? I have an Access db which is stored on a server on a network and used on multiple computers, mostly with few issues. in the UK. But I have been recently been...

Awesome Thank You. I see you reverted to your initial idea with the count - I appreciate your advise and effort, your a star Thank You Regards Jerry

Hiya I have uploaded it - many Thanks jerry