Search results

alarants I didn't find a solution exactly more a work around. I changed the file type to .txt and ran a couple of import definitions - one using tab delim and the other space delim. Then they were moved into one table. change to .txt OldName = "C:\database\imports\Gamma\DUSurvey\" &...

Hi I have embeded Excel 2003 sheets embeded into my form (better charts) and I have two sheets on the excel - sheet1 - chart (chart is only displayed on the form) sheet2 - external data query pulled from within the same database My issue is that I can refresh the data (Sheet2) only when I go...

Guess this means it can't be done then? :confused: :(

Anyone? Anyone at all? Maybe there is another way to do this then? *shrugs*:confused:

I am using code from the microsoft site below to check linked tables in my database when to database opens and then prompt the user to locate the data source if it's no longer found. (not using the common dialog control though) http://support.microsoft.com/kb/181076/en-us This works great...

answered my own question LN() =LOG() natural log in excel is the same as log in access who knew?? anyways this might help some else or just make me look silly either way its being posted. Cheers. :p

Can some please tell me if there is an equivalent of the excel LN() function in access. I have tried to find it all over the web and beyond and cannot :( I dont mind if there is a long winded work around for this function. I am using it in a query and it shows unrecognised function but for...

Sorry i think i may have misled you The file extension is .Las and is not supported by Access at all and the file file is both Tab and space delimited. Access cannot open a file that is delimited both Tab and Space seems to only handle one or the other Therefore I open it in Excel and save as a...

I have looked through this Forum backwards and forwards I am using the following code to open a .las file (essentially a text file) in excel and save it as a .txt file, then import it into access. I cannot get rid of the instance of Excel that open during this process The rest of the code...

I am having to open a delimted .LAS file in excel as access will not import a file that is both TAB and SPACE delimited. The following code is meant to open the delimented .LAS file in excel and save it as LasImport.txt. I am getting the following error Object does not support this property or...

This link was very helpful as well. You can code it all and make it much more dynamic http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart05/html/sa05d1.asp :)

Thank you that is exactly what I was after. NOw that you have pointed it out I have seen it on another post but not understood it related to my situation. DOH!! *smacks forehead* Cheers :o

Anyone please help me? :( :o :confused:

Hi, I wish to use the results of a crosstab query in another query which will make table. The trouble is the field names are not always the same in the crosstab. The results are coming from a normalised table so if there are no records for a particular field then that field will no appear in...

I am trying to append record from one tables to another... sounds easy but there is a catch. The 1st table tblTexuralCode is structured: HOLE FROM TO Mj1 Mj2 Mj3 Mj4 Mj5 Test 0 1 AB Test 1 2 AC AR Test 2 3 AS AV AB Test 3 4 AB AV Test 4 5 AV AC the new table tblTexturalNew is...

I have many columns on a datasheet imbedded into my form and they don't all fit on one view. Need to slide right to see them. I would like to be able to show only selected columns at the press of a command button. I don't want to hide the other columns but just force the screen to slide to the...

sorted........brain was shutdown I have sorted this myself............. must have temporarily disconnected from my brain. Just made a new field and populated with IIf(IsNull([Depth_From]),[Assay From],[Depth_From]) then sorted by this field 2easy :p

Hello good people of the forum In the attached db example2 the report "report_log2" is not sorting properly for me. Ideally it would be sorted by the first field depth "from" and then by the assays "from" field. The problem is that not all of the assays "from" fields have values. The ones...

I know that this may seem like it's been answered 1000 times on this forum already but I can't figure it............. I am trying to sum some fields on my subform but it keeps comming up with #error. I know all of the reasons why it would normally do this. Naming controls the same. Not looking...

:D Anyone? Anyone? :D