Search results

Thanks, Wayne! Big Jim totally agrees about limiting the amount of data that comes over from SQL Server. I found that moving one record at a time takes less than a second. Perhaps I can set my form to a query that returns only one record at a time and then rerun the query with different...

Hi, Big Jim here: I have done some searching and found lots of interesting little tidbits of information on this topic, but I thought I would ask here and see if there was something major I was missing... I have sql 7.0 tables \ views linked into Access 97. They are linked over a network from...

pbaldy! Thanks for the response, I will have to try that. Pat: I think the added rows not being recognized by the refresh was what was happening to me. Sometimes I run requery and refresh though (both of them), and it doesn't seem to catch all the changes I made. My solution as of now is to...

Hi, Big Jim here: I was wondering which was the better way to add or delete a record from a table in this situation: I have recordset A and recordset B. Both recordsets pull records from Table1. I make a change to data that was in recordset A, and that change should be reflected in recordet...

Big Jim sends his many thanks to both of you! Mile, I think that is what I was getting at. The variable is stored in cache while the reference to the object is not? So in the end, I guess storing the value in a variable, say looping through a bit of code 1,000 times, would speed things up...

Hi, Big Jim here: Can anyone tell me the difference between these two pieces of code? *********************** Dim rst as recordset Set rst = currentdb.OpenRecordset("SELECT * FROM MyTable") Label.Caption = rst!Field *********************** Dim rst as Recordset Dim strField as String Set rst =...

hmmmm, jt! This sounds like a class project, but Big Jim is always happy to help someone squeeze by.... First off, I think you are trying to use COUNT the wrong way. COUNT returns an aggregate count, or total, number of records in each grouping. To determine who the first 10 to enroll were...

Igor, Is that the same thing as creating a .mde file? Thanks, Big Jim

Wow! Let me say that again......Wow! Big Jim loves the easy answers! Thanks, Pat! There will be many people at my company quite relieved that they can see their entire lists at one time. Thanks again! Big Jim Slade

Thanks, Pat. I will take a look at it first thing in the morning. I must admit that I am scared when there is something in Access that you "barely understand". That means the rest of us should stop trying. ;) Thanks again! Big Jim

Thanks Pat. I always appreciate when you spell out the limitations of Access. It helps Big Jim design better in the future. I do think it is interesting however that in VB, you can populate listboxes row by row as opposed to using a Table\Query Rowsource, and the listbox will show all appended...

Hi Fuga, Yes, the query is a functional query, I have tested it. Also, if I click the mouse on the scrollbar inbetween the down arrow and the bar itself (the part that moves up and down the scrollbar) I am able to eventually populate all records. Otherwise, the records do not populate. Thanks...

Hey, Big Jim here: I have a listbox whose RowSource is set to a query. When I press a button on the form, the RowSource changes and the listbox should fill with thousands (7,000+) rows. However, it only populates the first 20 to 30 rows. Is there anyway to force the listbox to populate with...

THANKS! :) Gracious Big Jim

Hey hout, I actually have tried a function, but since I am putting it in the SELECT statement, it runs only once as opposed to on each row. Any thoughts on how to create a row-level function? Thanks again for your help. Big Jim

Hi, Big Jim here: I am trying to find a way to create an incremental counter for a query which will be appended to a table. For example: Rank Name 1 Bob 2 Kevin 3 Mary Where Name is all of the data I have. I cannot use an autonumber, because I have multiple queries...

Chewey, you have been a bigger help than you think, giving me many ideas. I put a small .exe in the startup, and it worked great! Thanks again! Big Jim Slade

Still no success. I created the link test and then tried test.txt. File Not Found for both of them, but if I create a File named test.txt, it finds it and copies it. I am using Windows NT, could this be something that has been fixed for Windows 2000? Thanks, Big Jim

No such luck. I changed the name of the link to Test.txt, and it still told me file not found. Can .exe run directly from the Startup folder? I could just create a tiny app there that runs my other executeable. Thanks again, Big Jim

Yes, good clarification. The link had been created. I copied the file and pasted as shortcut. It is that shortcut that I am trying to copy. thanks! Big Jim