Search results

Hi, I'm trying to create a tool logging database where tools are logged out from and to stores to different locations. I would be looking to enable new tools to be entered in the system, tools to be booked out and reports generated. I've attached the problem child for your consideration...

Evening Ridders, curious as to why DAO is better than ADO but I think I'm going to take a different approach:-)

Apparently you can http://www.accessforums.net/showthread.php?t=32865

I'm trying to generate a recordset and use it to populate a subform. My SQL is good because I have run it in the Access query builder and it returns the expected result I just can't get anything to appear in the subform! I used a loop to fill the subform but nothing is showing. If anyone could...

Hi Mark, I managed to master the syntax thank you. Cheers, Lol

Hi Mark it's possible. I'm going to try it tonight and let you know if I continue struggling. Thanks, Lol

Thanks Mark, a bit late now I'll post something tomorrow night if I'm still struggling.

Hi, hoping someone could help me with this one as I'm having a brain melt at the moment. Just what is the correct syntax for creating an ADO connection and a recordset therein? I know it involves declaring variables to hold strings and using the SET command but I would just like to know the...

It works for now so it's good, thanks for your help.

Currency format worked but then I tried the following in Access: Data Type: Number Field size: Double Format: Fixed and it seems to work! Thanks, Lol

Not quite sure where to put this one so I settled for "General". I've got a spreadsheet exporting data to an Access table. The spreadsheet is formatted to display 2 decimal places, i.e. 38.50 When it's copied via vba into an Access table though it is rounding down to 38.00 I've tried various...

All done and dusted, returning a correct value. It would be really useful if I could find the values of the records that are returned from the recordset as not meeting criteria but I can't find a method or property that will allow that. many thanks arnelgp

I saw the duplication in the creation connection and recordsets. I'll delete the "create" ones and report back. Thank you.

got it working! The latest error was caused (after your modifications) by me leaving a line of code in trying to close an already closed recordset. The code is now displaying I believe meaningful numbers for the data. I will check data and report back. many thanks.

Okay I enabled 6.1 and got the attached image

got the error picture attached

Hi arnelgp this is the offending line: .CursorLocation = adUseClient

With adoRs2 .CursorType = adOpenStatic .CursorLocation = adUseClient .LockType = adLockPessimistic .Open strSQL4, adoCon2 If Not (.BOF And .EOF) Then 'used on ridders count() 'Debug.Print .Fields(0) 'total = .Fields(0) 'used on my...

Evening Ridders :-) As I said in one of my posts this is being run from an Excel sheet and I need a value to place in a message box to display to the numpties inputting data where they are going wrong. I don't know of a method of taking the value from the query and assigning it to a variable but...

Well I tried the code supplied kindly by Arnelgp and I keep getting error 3001 "arguments are of the wrong type, out of acceptable range or in conflict with one another" The problem seems to lie with the cursor location and locktype since they are the lines highlighted when debugged. Commenting...