Search results

Hey Spikepl/all, Sorted. The code below is working: Public Sub importFDU() On Error GoTo Err_Handler Dim wbFDU As Workbook Dim objExcelApp As Excel.Application Dim db As Database Dim rstCustomer As Recordset Dim columnW As String Dim searchInA As String Dim A As...

Hi Trevor, I don't know how can I open the excel workbook and then point it into specific cells so I wouldn't know how to change your code to do it. And the TransferSpreadsheet would copy the whole spreadsheet which is not exactly what I want (see the reasons bellow). Hi spikepl, Some of...

Hi Spikepl, For a bunch of reasons I can't use link tables in this project so, unfortunately, your suggestion is not a possible option in this case!! Any other thoughts please? Thanks

Hi Trevor, Thanks for the response but your code "exports data from the active worksheet to a table in an Access database" but I actually need a code to use in my Access database to IMPORT information from Excel. Would you have it as well? Thanks

Hi all, I need to create a vba code to import 1 specific cell from an excel spreadsheet containing some currency data for each of my registered customers. The excel spreadsheet contain more than 60 columns so I am not willing to upload the whole spreadsheet. Having in mind that in the excel...

Hi CBrighton, All my communication between FE/BE is done via VBA - open database/recordset, etc.... I had the same question posted back to me in another thread when I mentioned the FE/BE not being linked and it was mentioned that I am loosing a lot of what Access offer out of the box, that I...

Hi, I need to create an excel spreadsheet with the data entered in my database based on 2 dates (start and finish) provided by the user through a form. My database is designed with FE/BE but there are no linking tables and I want to keep it this way. What is the best approach...

It seems that it is not recognising your DIR function... 2 things come up to mind: * Missing reference; or * SandBox mode Have a look to this link http://beckelman.net/post/2008/01/06/MS-Access-Undefined-function-Dir-in-query-expression.aspx) Hope it helps

you can try something like: intPath = Len(Dir(strDirectoryPath,vbDirectory)) If intPath = 0 Then MkDir strDirectoryPath End if Cheers

sunset1215, I would create under the loading form a look up in tblTest using your Customer ID, storing the status against a variable; Something like: strStatus = DLookup("[Test status]", "tblTest", "[CusID] = " & CusID) Then you can do the if clause you mentiond above using the...

I would have chosen myself going to the SQL route but the company I am working for only have Access available for development and we are not allowed to install or use express version even though they are free in some cases. And I have to admit that although it might take a little bit longer to...

hi boblarson... Ms Access is the only tool available here and does the work quite neat and well!! And having the problem with speed over the network and old laptops this is the best approach (unless you want to hang on 30 minutes while the tables are linked between front end and back...

Great minds think alike!!! hehehe!!

yes, all unbound.

Everything I do is via VBA. So for example to add a new record in my table tblActivity_Contact I do: Dim dbContact As Database Dim rsContact As Recordset 'open contact/hospitality table Set dbContact = openDatabase(sourceDb, False, False, passwordDB) Set rsContact =...

Hi DCrake, why contradictory? You can have the db as FE/BE with linked tables or, as in my case, doing everything through VBA. Having a FE/BE using VBA can't be said to be a splitted database? Anyway, I managed to do it by using db.execute instead of docmd.runSQL db.Execute( "DELETE [" &...

Hi all, I have a database splitted in Front End / Back End. I am trying to delete some specific records ("activityID") using VBA code in every table that starts with "tblActivity". The code I am using is: For Each tdf In db.TableDefs If Left$(tdf.name, 11) = "tblActivity" Then...

Hi CBrighton, Sorry my mistake it should be: So for example: John Smith entered * 2 sales visits on the 01/04 AM * 1 sale visit on the 01/04 PM * In the office on the 02/04 AM * In the office on the 02/04 PM * 1 sale visit on the 03/04 AM * 1 sale visit on the 03/04 PM. The query...

Hi all, Haven't heard about my question above so just wondering if someone could help? Thanks

Hi guys, Any ideas for my queries above? Thanks