Recent content by jk12

After looking at the problem a bit more, I can import data from the excel document (both through vba and get external data method) regardless of the excel document being on my desktop or on the server so long as I'm importing it to a local table. However, if I try and import to a linked table I...

A manual import works fine. By manual I've assumed you mean open excel, copy the records, then aste them into the access table.

That comment is my typing mistake and not meant to be shown. The code still doesn't work even if there is no comment. As I say, the same code but with the path set to my C drive works fine but as soon as I change it to a server path it stops working.

No probelm, code being used is as below. Private Sub Command2_Click() CurrentDb.Execute "Delete * From CSMR;" 'DoCmd.TransferSpreadsheet transfertype:=acImport, tablename:="CSMR", FileName:="\\B-srv1\Company\CSMR\CSMR.xls", HasFieldNames:=True MsgBox "Update completed" End Sub

Yes, path is as below \\b-srv1\Company\CSMR\CSMR.xls

Hi all, I've spent a while now trying to find an answer to my problem but so far no luck. I have a database which once a month someone clicks a button to pull info in from an excel document. My problem is if the excel document is on our server and the vba path points to it there I get the...

Perfect, exactly what I was looking for.

Hi all, before I start I want to say I've searched through the forums for an answer but I must be using the wrong search criteria as I can't find what I'm after. So, my problem is I have a set of data which my end users want to view and then apply several filter variations to. There is 4...

Perfect. I suspected it was something simple but was more than my brain could handle, especially after trawling through the site and internet for the last hour :)

Hi all Sorry if this has been answered elsewhere but I can't find the answer anywhere. I have the code below to open a pop-up form from within a form but whenever the code runs I get Run-time Error 13, Type Mismatch. Both the EnquiryCatergory and TenderRef fields are text fields as are the...

The second suggestions also works in case anybody else wonders. A double thanks must go out seeing as I now have two solutions.

Re: Filter query based on one specific character in field Fantastic. Works a treat. I had a feeling it would probably be something simple and I just wasn't seeing it. Thanks for the response

Hi all, Having spent much of yesterday afternoon searching the forums (probably with the wrong questions) I'm stilll wondering if it is possible to do the following. Within our work's database there is a field for a project number (input mask 00>L000C;0;*) which I need to filter down according...

Hi all, I am using the below expression in my query to caluculate the finish time. Finish: DateAdd("h",[workedhours],[StartTime]) I know this is not the best way to do what I want and that it would be a lot easier to have a start time a finish time and then work out the hours between the two...

Hi all. I have been tasked with answering the following for a database that was done by someone who has since left the company and I am approaching it from new. From what I can see, there are is a Start Date 1 End Date 1, SD2 ED2, SD3 ED3 which people use to assign blocks of days for which...