Search results

Hi, Is there a way of importing MS Excel Spreadsheets but starting from row 8. I am now getting lots of spreadsheets but i only need data from row 8. I have to manually delete the rows and save the spreadsheet then import. Some days i can have more then 1. If you got any ideas i appreciate it...

Do i need to create lots of if statements saying if lenght is 4 then need (6) 000000 to make 10 or if length is 6 then i need (4) 0000 to make 10.?

I can run this off a query just thought i run this off a table as it will be faster to run

Hi, I have 2 fields in a query which I want to write to a table Eg ProductName (field length 10) and Product Code (field length 5) the fields need to be filled out so the length makes the maximum text For example product name 'test' length is 4 i have to add 0 to make the length to 10 so the...

Hi, I import data through different files into a table, the data comes in different formats. I have a problem sometimes some records have double quotation marks and carriage returns. I know how to replace them as Carriage Returns Replace([FieldName],Chr(13) & Chr(10),"" Double Quotation...

Hi i get this error message, when trying to run some code. When i click a button get an error message Argument Not optional on Call ConvertToLetter. There are no other functions with the same name. Not sure what i am doing wrong. Private Sub Command0_Click() Dim icol As Integer icol = 30...

Hi Sorry what i meant to say is it did not produce the data it should.

Hi, I have a query which i am a bit stuck. I am using Not Like [FieldName] *. So it does not include anything from that field which is from a table called Postcode. The PosCode table has 250 records. The criteria Not Like [PostCodeCheck] & "*" works with if the postcode table only has 1...

Thank you for your help i will try this out in the next couple of days and get back

Hi, I have the below code which works fine. DoCmd.TransferText acExportDelim, "ProductFile", "qryEportProductFile", "L:\Sales \ProductFile.txt" But now I want to export code to an existing text file. So the data appended starts from a new line from on the existing text file. Do you know how...

Hi, I have created some code in MS Access 2010 for sending out Emails and formatting Excel Spreadsheets. Problem is it works fine in 2010, but if a user uses the database in Access 2007 They get an error because the Microsoft Excel and Microsoft Outlook Object library 14 is missing. I know i...

Hi, I am trying to open a MS Access Database which was made in MS Access 1997 or MS Access 2000, at the moment i am using MS Access 2010, i cannot open the database or link the tables. Does anyone know how to get around this, i do not have MS Access 2000 anymore. Thanks

Hi i am copying a query from MS Access to an excisting excel template. I am using VBA code, once the data is copied then it formats the excel document. When i run this function, 1st time it runs properly, then i ran it again the same function does not work and stops on the formatting part. If i...

Hi I have attached a txt file which should be a csv file but it did not accept it as an attachment. Ok here is the problem, i am importing the CSV file into MS Access 2000 and it imports into a new table without any extra blank records. But if i import the same file into MS Access 2010 i get...

Hi, I am try to join 2 tables together. 1 table is a SQL table and the other table is a MS Access Table. The problem i am having is on the sql table sometimes the field is either null or " " or "" so in my MS Access table i have tried joining when the field is null but does not bring out any...

Hi, I am getting a runtime error of 429. Am using MS Access 2010, it works fine on MS Access 2007 and MS Access 2010 on windows xp. When i use the Windows 7 64 bit MS Access 2010 i am getting the runtime message. Does anyone have any ideas why this happens? Thanks Hemish

Hi thank you for your reply the code works but does not work on the last record of that group. eg Group Sup -- Cust -- ORDER -- Product SupTest1 -- CustTest1 -- 1 -- Crisp SupTest1 -- CustTest1 --...

Hi, I have a report with Force New Page, what i don't want to happen is if its the last record in the group report then i do not want to force a new page. Want to try keeping that group together. I have 3 groups for footers below is the groups which i have set force new page after section...

Hi, I have a report in MS Access which used to use MS Access 2000 and upgraded it to MS Access 2007. The problem i am finding is in the report the last group on the report was selected as Forced New Page After Section, which never created an extra page but in Access 2007 it does with a page...

Hi, Does anyone have any samples or code on how to export data from MS Access to an FTP site, i have the user name and passowrd Thanks Hemish