Search results for query: *

I'm building a project using an Access db and PWS. A frames page populates two combo boxes with information from two tables. No problem so far. The choices the user makes will build my SQL statement for reporting. I make the connection using an include, Jet 4.0 Provider. My problem is once I...

In an Access97 Db I have the following table: Table:IntrFac NameID,AccountID,AbsAmount,Amount,and S2KFormat Here's sample data: NameID AccountID AbsAmount Amount S2KFormat 4190 3290 536 536 419.0.2991.00.3290 3330 3290 536 536 333.0.2991.00.3290 3290 2100 536...

Only knowing enough to get myself in trouble, I'm trying to delete records from a recordset. I'm writing the code in Excel97 against an Access97 database using an ADO connection. I populate a table with data from one of the Excel worksheets. This data contains certain records that need to be...

I have a worksheet I'm testing controls with. I can place controls in the worksheet and run code off them but now I want to try something else. I've placed a Microsoft Forms 2.0 Frame on a worksheet. I then added two option buttons to the frame. How do I refer to those option buttons within...

I have a spreadsheet pulling information from an Access database. I use a form to get input from the user, then use the input to build the WHERE part of a SQL query. This is how the query reads: With oQryTable .CommandText = Array( _ "SELECT CJE.Department, CJE.Account, CJE.Debits...