Recent content by khurram7x

Thanks for the helpful posts. I picked up quite of new concepts from this thread.

Thanks, I've converted all my queries to PT. Really appreciate your help. Although I'm interested just for academic purposes and any future use, I'm interested to know how Async queries perform. I mean, they either perform like normal Access query where it pulls all data to the desktop and...

Ridders, I did post on another forum on this occasion to get a couple of different ideas because this was quite complicated for me. I did get a message across from other forum to use PT Queries which is not working well when used with multiple combos. It is here I got more ideas and suggestions...

I'm using most of the time PT Queries and using Indexes on server side to return only the smallest set. I still intent to use it at least for a first table run. Thanks for the references. Will go through them. There are simply huge number of records, Supervisors does not remember all options...

Thanks to your guys for very fine details. I understand you're all trying to help me. Just to be clear, this is an unbounded form and Record Source is not available. This forms opens in response to a selection of a combo on another form. I've not used .RecordSet anywhere in the code yet for this...

Thanks. I'm uploading a sample code @ google here https://drive.google.com/open?id=15MTzVgUeVPqQQQ9RXRUNWUyiX2qVXUYc I get correct results when I use CurrentDB.Execute, but Row Source is not filled with PT Queries. Thanks guys for such details, but RecordSet, RecordSource and RowSet does...

I tried and got error on function name as: 'User-defined type not defined'. I added Reference to 'Microsoft ActiveX Data Objects 6.1 Library' that fixed it. Next, I setup the connection string as per my server configuration and tried to open the connection... failed. Error I'm getting is: Data...

How do I convert my above Query to ADO and use it as Async? As a reminder, I've a SQL Server backend.

...and don't fight guys please... peace and patience :)))))))))))

It worked, thank you :)

Ok I'm trying a sample Main form with Tab control but i still get same error. By the way, by main form i meant that i created a Form Design and put a Tab control on it. Let me know if i'm wrong please?

Thanks guys. For clarification, it is not cascading combos. In my case, you're allowed to select any of the 15 options right from the start. Once you select first option, other 14 options should re-query and show only options available based on first selection. There's no sequence as in...

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

Thanks. Is it possible please to refer to Tab2 somehow in code and then refer to the control on the form on Tab2? Actually the code above I was using for testing. In production, I've two tabs on a form each having a sub-form. My requirement is, when I fill SignedOut time field in the form on...

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