Help

Retrieve selected value from ListBox
I have a ListBox called lstInventory, with two columns, a text value, and the ID primary key for that value. When I click an item in the listbox I would like to use that value to display details about that record based on the ID. This code never shows any item as selected, i.e. lstInventory.Selected(i) is al... 12 Jun 2010 17:04

access97 - wrk.beginTrans - how many statements can I execute before the commit ?
On Tue, 8 Jun 2010 15:09:33 -0700 (PDT), Roger <lesperancer(a)natpro.com> wrote: I would recommend you implement the transaction in a stored procedure. You would create a Linked Server so the main SqlServer knows about the other one, and you can write queries using a 4-part name: select * from myLinkedServer.myDat... 8 Jun 2010 22:47

Access 2010 webbrowser control
Is there any way to navigate the new webbrowser control built-in ms access 2010 from VBA ? Webbrowser.navigate does not work. ... 14 Jun 2010 10:37

IsNumeric() Bug?
The following was ran from the immediate window of Access 2007: ?DLookup("PurgePeriod", "Info") = "" True ?IsNumeric("") False ?IsNumeric(DLookup("PurgePeriod", "CompanyInfoMaster")) True Huh? Is someone able to explain this? Vincent ... 8 Jun 2010 12:33

Track Name Autocorrect error when running mdb in 2007
For your information: Private Sub Form_Open(Cancel As Integer) On Error Resume Next Application.SetOption "Track Name AutoCorrect Info", 0 End Sub If you do this in 2003, no problem. The form you are opening will display correctly, and the option will be turned off. If you run this same .mdb in 200... 7 Jun 2010 16:34

Attached sql tables and WIN 7
Hi, i'm sorry for my bad english, I have seen somewhere the same problem but I haven't found the solution. I have a access application (XP, 2003.2007 it's the same) with ODBC attached sql tables (i have tryed MSDE, 2000, 2005 Express or full), now with O.S. Win XP all works fine with excellent response times, i... 7 Jun 2010 11:52

How to send a hit to a PHP web service
Hi - I'd like access to pass the date & time to a PHP web service. Something like: www.website.co.uk/php_script.php?datetime=13:42:00-7-Jun-10 The web service will update a field in a MySQL database with the data that is passed to it, in this case '13:42:00-7-Jun-10' There will also be a script that runs on a cro... 9 Jun 2010 20:54

Rounding Problem With Text Box Calculation
I have several bound text boxes on a form: Txt1Result, Txt2Result etc. The value of each of these is based on a formula that draws a value from another series of textboxes: Txt1Input, Txt2Input etc. Therefore; Txt1Result = Txt1Input*SomeFormula, Txt2Result = Txt2Input*Someformula etc. The values in the "Resu... 7 Jun 2010 02:02

Virtual checkboxes
At times I've wished I could have a virtual checkbox to select items for further action. Maybe you have a bunch of records in a form but only want to see a report of those you've flagged for display in a report. (Similar to a multiselect listbox but using a form instead). I wrote a small app to do that (code ... 21 Jun 2010 23:35

ODBC failure
Hello, Are you using a connect string in Access? If so, what is it. Also are you using TCP/IP (under Client configuration)? Albert "mcolson" <mcolson1590(a)gmail.com> wrote in message news:cb71b45d-82f7-43d9-a5b8-0b5c907ad8f6(a)e2g2000yqn.googlegroups.com... I am getting the following error when trying to op... 4 Jun 2010 18:05