Search results

Leigh: That did it, though I don't understand why explicitly setting the cursor location would reorder the recordset fields. If you feel like explaining that, I'm all ears. Otherwise, thanks very much for the help. Duluter

Yes, it's entirely unbound, and the listbox control is also unbound. I have two comboboxes that the user can make some selections in, and then some data gets displayed for them in the listbox. Here's the routine that populates the 5-column listbox. The routine runs when the comboboxes' change...

Leigh: 1. My form is not bound. Not sure if this is relevant, but I am working in a front end/back end paradigm--both .mdb's. 2. I get the same disordering if I use a keyset or static cursor. Duluter

Two more related questions. 1. If I populate the listbox by setting the listbox's recordset property to the ADO recordset, does that create a persistent connection to the data as long as the form is open? I'd rather not have a persistent data connection. 2. I am populating a multi-column...

Leigh, I think you hit the nail on the head. I changed the row source type to Table/Query and set the listbox's recordset to the ADO recordset and the listbox populated just fine. What a relief! I did not know about the 32K character limit. Pretty sneaky--there was no indication from Access...

I am trying to populate a listbox with an ADO recordset that contains data with internal commas. Normally, I just double-double quote these and everything is fine: Do Until rs.EOF Me.MyList.AddItem ("""" & rs!MyField & """") rs.MoveNext Loop But this time, the listbox is not getting...

Hi, all. I have a text file that I want to import into an existing table in my Access 2003 database (via Access 2007). I used the import wizard to import the data once and saved the steps as an import specification. I want to use that specification in some code to automate the process. Here's...

David: Your suggested solution is very helpful. Basically we're simplifying the query down to a couple of Last functions and a Group By clause to get the last record for each work order. Then we're outsourcing the heavy lifting of calculating the cumulative total to a VBA routine. This makes...

Hi, everyone. I need to create a summary report and I'm having trouble constructing the query. Here is a representation of my data table: FARM WORKORDER SURVEYDATE PESTCOUNT MyFarm 2009001 6/12/2009 10 MyFarm 2009002 6/15/2009 5 MyFarm...

Oh, yes, you are correct. Thanks again for the help! Duluter

Thank you for the great response, Brent. I will give it a try. "But with all this, why do you need the sub-query?" Because I do everything the most convoluted way possible. There's something wrong with my brain. :) Thanks again, Duluter EDIT: Wait, maybe there was a reason I used the...

Hi everyone. I have a database I built in Access 2007 (using the older mdb file format). Everything works well. In a bunch of forms I have dropdown boxes that are populated using sql statements in their row source property, such as: SELECT pID, Package FROM (SELECT [pID]...

Thanks, Paul. I will try that. Duluter

Hello everyone. I have a report that basically has one summary page per client. Originally, I just ran the report without filtering it, so all clients were included. But now I would like the option of choosing to include all the clients or only selected clients in the report. I built a form...

I'm loving SQL Cookbook by Molinaro (O'Reilly). The title explains it pretty well--it's like a cookbook full of recipes. Most of the recipes are for tasks that you would actually do in real life, which is refreshing. The book is categorized well and includes a nice mix of easy to hard SQL...

Banana and Brent, you have both given me some really great info in this thread. I can't thank you enough. I now have a much better understanding of the mechanics of these files and connections. Duluter

Thanks, Brent. I'm getting closer to understanding how all these parts work. Correct me if any of this is wrong: 1. When you "open" an Access file, Access creates a connection to the data through JET. 2. The connection mentioned above is not significantly different from an ADO connection to...

That pretty much sums up my life path as well. :) Duluter

I am still confused. Why are we testing if fx = 1? If it equals 1, then (amount/price) is equivalent to fx * (amount/price) Isn't it? So why not just strictly use fx * (amount/price) and eliminate the iif altogether? Duluter

Banana: Yes, lots of options. Unfortunately, I am a remote employee with limited administrator rights on the network, and we do not have a full-time IT person, so setting up and administering an RDBMS becomes problematic. Perhaps in the future one of these solutions will be possible for us...