Search results

Hi This bit of code will add one to the current invoice number when the check box (chkUpdateInvoiceNo) is true and subtract one when the box is unchecked (in case it was checked by mistake). Private Sub chkUpdateInvoiceNo_Click() me.txtInvoiceNo = me.txtInvoiceNo + iif(chkUpdateInvoiceNo...

Possible solution... Why not use the Val function in a query whenever you want to display your values in numerical order. This should do it... SELECT DISTINCTROW Val([OriginalValue]) as NewValue FROM [YourTable] ORDER BY Val([OriginalValue]); shay :cool:

Jen That line of code looks ok to me. The only thing that comes to mind is that you need to define 'rst' eg Dim rst as Recordset Shay :cool:

Not sure I understand this message nor the one you sent in reply to PaulJK. You have a Combo box (combo46) which displays the Date and Location and its rowsource is Query1. After double-clicking the date, you want to combo box to display just the Locations for the selected date. Is this...

I think I understood the problem! See if the following helps: SELECT DISTINCT tblRegHistory.[Person ID], tblRegHistory.[Name Prefix], tblRegHistory.[Last Name], Left([Meeting Code],4) AS ConfCode, Count(tblRegHistory.[Meeting Code]) AS [CountOfMeeting Code] FROM tblRegHistory GROUP BY...

The field in the Excel worksheet contains both text and number and is formatted as Text. shay

I am writing a VB5 application which imports an Excel 97 worksheets into an Access 97 database. The code works fine except for one field on one worksheet. The first hundred or so values for this field is Text, thereafter it is numeric. After running the VB application, the imported table...

Thanks Bob. It would have been nice to get Access to import an entire specified worksheet but being able to specify columns is a reasonable compromise. shay

I'm using the Docmd.Transferspreadsheet method to import data from a spreadsheet which contains several worksheets. To select the worksheet to import, I have included the worksheet name as the final parameter of the DoCmd.Transferspreadsheet method. The only way I can get the code to work is to...