Search results

Ya, it is. Value is stored like this in column 2/6/2017 12:37:42 PM ... I've figured out that it was the format because because SQL Server back-end is generating different date format with - instead of /. So i've changed the query as below and compare it as a string in Where clause of string...

Hi, I've tried both. In fact it was # earlier, and i changed it to ' to see if where condition is going to SQL Server.

hi, I'm looking to use Access Pass-Through queries as a Record Source for reports. There's no Where clause in query. Now in Docmd.OpenReport Where condition, using the query above, I want to search for records only for specific date. I've created this query in order to avoid passing SQL from...

Yea, i'm using SQL Server backend. Sometimes the solution is in front of you, but you can't see. Thanks DocMan for reminding me that I could do that in BeforeUpdate event on the form. Although I'm also updating couple of other fields in BeforeUpdate, but don't know for some reasons, thing...

I try to concatenate first and last name together after inputting from the Access form and then put results into the same table Employee table using trigger or stored procedure. When next time i try to edit the same record a popup appears say 'Another user edited this record and save the...

Thank you, solved. It was a permission issue. Your suggestion helped me get the proper error.

Pass-Through always has issues i can't figure out. Now I'm trying to pass stored procedure in SQL Server by calling procedure from Access 2010 VBA as: Call RunPassThroughACTION("EXEC acc_UpdateUserName") i'm getting error '3146, ODBC --Call failed' when turning .ReturnRecords = False, and...

I'm now using connection-less Pass-Through queries, advice from previous post. Now I can see another issue appearing, i.e. I've a boundless search form with about 7-10 selections and each previous selection provides a Row Source for next combo box. Logically this seems to me that each...

Thanks Minty, yes i know about it but with this, as per our Commercial Director, software will be vulnerable enough to take on any computer and run easily without any additional setup (manually creating DSN connection) from Admin... that's why i'm stuck to use DSN unfortunately! ... another...

Ok, if i want to use my application in several different offices in various regions, each with its own back-end database. Each site will have a copy of MS Access front-end and SQL Server back-end with same database structure. I am looking to dynamically set MS Access application in such a...

Seems like ADO and Pass-Through queries is a decent go if ADO is getting less attention. I also feel that to go through ADO is another learning path, but I do look to migrate some programs to .NET and instead put my efforts on learning .NET instead of ADO? Thanks for suggestions and all the...

Apparently, DAO, because i used it once in some code. More confusion, how would i define ADO object? Thanks for explanation. This what i'm trying to do. I'm connecting to back-end SQL Server and want to use ADO with Pass-Through queries. Though Pass-Through is also working with with DAO...

Hi, Which Reference Library should I select for ADO commands please?? I'm using code below in reference the answer from the link: https://access-programmers.co.uk/forums/showthread.php?t=230610#post1176746 ...and is there any advantage of using ADO (which i don't know anything about yet) vs...

Sorry DocMan, just realized it's an SQL Server issue at this point. I'll have another look and see if i could find and add a unique key from the table into the view. Thank you.

I have tried using derived tables to generate a unique value for Schema-bounded Unique Index but Derived Tables are not acceptable for Schema-bounded Unique Indexes. I've tried to use NEWID() and generated a unique ID for every field, but it doesn't work either telling that only...

Thanks for the advice DocMan about table>query, will keep in mind. I'm using below script to import and rename tables. I understand if i select OK on the popup first time, it does not appear back but whole process need to execute silently so that management has one copy of Access that they could...

Hi... i have a problem when during linking Views as Tables from SQL Server to Access front-end using Docmd.TransferDatabase, system pops up the box where it asks for selecting the Primary Key. I don't want to select primary keys for Views and want to complete whole process quietly without any...

I want to save password as Binary data type in SQL Server using Access VBA please? I'm using front-end Access 2010 and back-end SQL Server 2014. SQL Server itself uses HASHBYTES function to achieve this, but using VBA! Thanks

Thank you Sneuberg and Doc Man for detailed discussion. It indeed helped to clear quite of concepts. In my case OnOpen do have calculations but I could not say that they're very lengthy and the whole process, once 'OK' button is pressed and switchboard form is opened, takes less than a second...

Thanks. Yes the object was not the correct form. I was using onLoad event, but I should have used onOpen. Though I'm not clear why destination form is losing focus when it moves from onOpen to onLoad. Shouldn't it keep the focus theoretically between onOpen and onLoad events? Thank you.