Search results

Hi, Is it possible to run query Asynchronous in Access, like in C# or Java?? I've a parameter selection form of 15 fields represented by 15 combo boxes. If one parameter is selected from any of the combo's, then all the other combos should have to re-run the query to show only narrowed down...

Hi, I've form with a sub form. Sub form has two tabs. lblFName1 is a control on tab1, while lblFName2 is a control tab2. Now I know you don't need to use the tab name while accessing the control, but here first line of code works fine... Me.NavigationSubform.Form.lblFName1.Caption =...

Hi, How could i capture Enter and Esc on a KeyPress event on an open form please? Thanks

How possibly I'm gonna use OLE Object field to attach files like Word, Excel or PDF documents please?? I've tried to search over the internet but only thing I could find is to attach an image file using OLE Object, but I could not find decent source to demonstrate how to attach other file types...

Hi, How could I get the return value from back-end SQL Server procedure?? How should I call the procedure using DAO to achieve this please? Regards, K

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...

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...

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...

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...

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

Hi n Happy New Year to all!! I'm getting Error: 438, Message: Object doesn't support this property or method. I'm getting this error while using LASsie from PetersSoftware for permissions and this happens when I try to put restriction on some Control on the Form. It works fine if i put...

Hi, I've an Access DB with SQL Server back end. In fact I had an issue that every second time when try to I edit the same record on the form i get error as: 'The data has been changed. Another user edited the record and saved the changes before you attempted to save your changes. Re-edit the...

Hi, I'm looking to add search functionality on form using a text box and button, attaching screenshot. I'm using DoCmd.SearchForRecord command for that and it works fine if I used it to search, but when I try to use '* Criteria *' wildcard it doesn't search as expected and stays on the...

Hi, What is the best place to log data into history/audit table before record is deleted please?? If I do this in Before_Delete event, then I've to delete the record from history/audit table if user presses Cancel on delete confirmation box. If I use After_Delete, then it'll be too late. In...

Hi, Need your guys help once again. I'm facing a very slow report which is basically derived from multiple queries feeding each other. I tried indexing certain fields in criteria, cut certain table sizes at least 100 times shorter by reducing data which is required in production database...

howdy, How could I schedule in Access, sending a email report with an attachment everyday? let's say, 4 o'clock every morning? Regards, K

Hi, I want to Sum values from qryWeeklySE_WorkPackEmployee_GroupBy where Activity Date in this query lies between Start and End Date from query qryWeekly_Verified_Report. This is too complex for me. I've tried full day trying lot of different stuff but nothing has worked for me yet...

Hi, I could not load ‘Microsoft DAO 3.x Object Library’ for Access x64. I can see the required DLL file, but when I try to load it gives me ‘Error in loading DLL’!! I need to get this fixed to work with some older DAO code. Could not get enough help from internet to sort this out. Jet...