Search results

I have a db which imports a sheet (Shipping Details) from Excel to a table. The user then selects a supplier code from a listbox for deletion and the following code runs a query (criteria based on the ListBox) to delete that supplier from the table, then transfers the table to a new sheet within...

Does anybody know how to select all the blank lines in an Excel spreadsheet that come after the data and delete them? This may seem like a stupid question (probably is) but here's the story. I'm importing sheet2 of the spreadsheet into Access, deleting certain rows and then exporting back to...

I'm using the following code to transfer a table to an existing excel spreadsheet DoCmd.TransferSpreadsheet acExport, 8, "Shipping Details", "H:\BIDataLoad\Supplier Orders.xls", True, "Shipping Details" The problem I'm having is, it creates a sheet called Shippiing_Details not Shipping...

I have an Excel Spreadsheet linked to my DB and need to delete certain rows from within my DB, but I'm getting a 'Deleting data in linked tables is not supported by this ISAM' error. Is there a way to delete from the linked spreadsheet or am I going to have to restructure the DB to Import the...

I'm using the following code to Output a report as a Text file, saving it as the name in an unbound textbox on the form DoCmd.OutputTo acReport, "rptAddCost", "MS-DOSText(*.txt)", "C:\Documents and Settings\temp\Desktop\(" & Me!TxtSupName & ").txt", False, "" all works fine but what I'd...

I've seen a lot of posts about how to enable/disable the mouse wheel and have come across this. Thought I'd share it with everyone. It's in both 97 and 2K IMO

Hi all, Can anybody tell me why the following query gives me the strange results attached?? SELECT dbo_HistoryLines.Qty, dbo_HistoryLines.UnitPrice, Sum([Qty]*[UnitPrice]) AS [Qty * UnitPrice] FROM dbo_HistoryLines GROUP BY dbo_HistoryLines.Qty, dbo_HistoryLines.UnitPrice...

Hi All, Can someone tell me why this code isn't working? It's driving me nuts! I'm getting the error 'Method or data member not found' and .FindFirst is highlighted. Thanks in advance IMO Private Sub List8_DblClick(Cancel As Integer) On Error GoTo Err_listbox_Click Dim stDocName As String...

Hi All, I have created a Toolbar for my Reports and would like that to be the only options available for the users. I,ve set the Menu Bar properties to '=1' which works fine in my Forms but not here, I'm still left with the Control Box in the top left corner. Can anyone help me and tell me a...

Hi All, I'm using this code to view the contents of a directory in a listbox : Private Sub Form_Open(Cancel As Integer) Dim strFile As String, strRowSource As String strFile = Dir("C:\MY FOLDER NAME\") strRowSource = strRowSource & strFile Do Until strFile = "" strFile =...

Hi All, Can anyone tell me why I'm getting the error 'Bad File Name or Number' when using FileCopy?? Private Sub Command1_Click() Dim strSource As String Dim strDestination As String strSource = "C:\IMPORTCSV\*.csv" strDestination = "C:\HISTORYCSV" FileCopy strSource, strDestination End Sub...

Hi All and Happy New Year. I'm a bit stuck. I need to import multiple .csv files on a daily basis for report printing. Each .csv file has the same format as the table and importing one file is not a problem but is there a way I could get the user to select the files which need to be imported...

Hi All, I have just installed my DB on a new PC and all works fine except one Date() field. It works fine with Now() but returns the error - 'Unknown function 'Date' in validation expression or default value on 'MY TABLE NAME.MY FIELD NAME' - if I change Now() to Date(). I've checked all...