Search results

Thanks for the link...so the correct version is: ODBC;DRIVER=ODBC Driver 13 for SQL Server;SERVER=tcp:127.0.0.1,1433;DATABASE=myDatabaseName;Trusted_Connection=Yes;TABLE=dbo.Customers Can I just add that it's very important to get the lastest ODBC driver for the clients using Windows 10...

Hi, Does anyone know the correct syntax to create a TCP connection to a default instance of a Sql Server. I've tried: ODBC;DRIVER=SQL Server Native Client 11.0;SERVER=127.0.0.1,1433;DATABASE=myDatabaseName;Trusted_Connection=Yes;;TABLE=dbo.Customers That doesn't work. Regards

I rebooted the server and that seems to have resolved it. Thanks for your input Minty. Regards Melt

It opens up as normal, and I'm using Access 2016 locally. Regards

Hi Minty, The thing is, I've tried clicking the mdb file, not the shortcut, it doesn't open the db file, just the container window. Regards Melt

Hi all, Using Access 2016 installed on a Terminal Server - I have one user where the shortcut I created no longer opens the database, it just opens the Access Container window. The apps opens for other logged in users. No error messages, I can't even Shift+ Click into the database. Anyone got...

Thanks sneuberg, that does work. I just wanted to check if it could be done without parsing. Thanks for your help Regards Melt

No, I want to remove all the sub code from my navigation buttons and replace with the single GoToRecord function which is called from the OnClick event of the button using =GoToRecord("acLast"). The purpose is to clean up my code for simple navigation tasks. I can remove 5 subs for First...

Sorry, no, that doesn't work. The problem seems to be Access adding quotes or brackets around the argument, like this =GoToRecord([acLast]) or =GoToRecord("acLast") which are not the same as the Access constant. I know I could write an if statement to check the passed value, but I was hoping...

Hi all, Is it possible to pass an access constant as a argument to a function? I have a button called Last with a sub on the click event that runs DoCmd.GoToRecord , , acLast I want to replace that with a call to a Function like this =GoToRecord("acLast") -- passing in the access constant...

Thanks for the replies. So, if I have Form with 10 subs, is the recommendation to add an error handler to each sub, or just add one and let the error event bubble-up? Regards Melt

Below is a simple error handler that I usually wrap most of my sub code in. Is it possible to have this error handler called without hard-coding it into every sub? - so all my sub code runs in an error-handling wrapper automatically. Thanks Melt On Error GoTo Error_Handler 'Run code here...

Thanks Paul, I'll look into using the ADO recordset. Regards Melt

Paul, will it work for a continuous Form, not just a single record? Regards Melt

Hi all, Is it possible to retrieve a dataset from a Sql Server database using code only? -- there can be no table or query in the navigation pane as they can be opened and data copied. So, a Form is opened and its OnLoad/OnOpen event goes and gets the data? Thanks Melt

Thanks a lot arnelgp, that'll work. Reagrds Melt

I have an old database I need to clean up and I want to see what Forms are still being actively used. So, I'm going to create a log table and, if a Form is opened, log that event. I could write a public procedure -- open every Form and call the procedure in the OnOpen() event -- but, I was...

Does your company have a web site? Have you considered using the mail server of your web host to send the emails and bypass all the Outlook shenanigans. You would have to register a dll on each machine. Regards Melt

You need OrderId in the recordsource of the subform. Edit the query in the subform and add OrderId from tblOrderItems -- then the subform will synch with the main form. Regards Melt

The easiest solution is to add the line numbers control to your reports then make txtLineNums invisible under properties -- the event code will still work. Regards Melt