Search results

Hi all, I need to clean up a date field (I hate dates in access!). The field in the table (imported from a spreadsheet) has records where users have simply entered a date in the correct format and then others where users feel obliged to add comments after the date rather in the 'Comments'...

Hi all, The following code allows some users to update an access table (on a shared LAN) from an excel workbook (code is within an excel module). Dim accApp As Object Dim strOrder As String, strCode As String 'DFII = txtDFIName.Value strSQL = "INSERT INTO [PDI] ([Part No],[PDI...

Hi, We have an access database stored in a shared location. One of the tables in the database is used to record transactions made in an excel spreadsheet-this is done programatically using VBA and SQL. So here is my silly question; If users don't have access installed locally will the code...

Hi hope someone can help me with this, I'm trying to pass some dates from an excel userform into access. The date is chosen using the DTPicker tool ( basically a drop down calender). I have set the property of this to custom format dd/MM/yyyy, however dates get passed to the appropriate field...

Hi, I'm trying to append a record to an Access database from an Excel userform. I have already written update and select queries from the same form for the same database which work. This is the offending code; StrSQL = "INSERT INTO [DFIDatabase] ([Part No], [Supply], [Supplier],[DFI...