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...

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, 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...

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, 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

Hi i am using MS Access and the tables are linking off SQL 2008. When i am trying to run the query in ms access by joining 2 tables there is an error message coming up "ODBC failed" [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot resolve the collation conflict between...

Hi, Just need some help i have a pass through query updating a sql table. (See below at query) UPDATE WATFORD_SHORT_PACK SET SH_ORDERADJUST = 1 WHERE (((WATFORD_SHORT_PACK.SH_ORDERADJUST)=0 Or (WATFORD_SHORT_PACK.SH_ORDERADJUST) Is Null) AND...

Hi, I have a problem when i am linking 2 tables. The data type is fine. Sometimes it shows me the results but sometimes it does not. The data type is text in both tables. In the table only problem i have out of 500 records is one record where for some reseaon it does not like the written text...

Hi i have just upgraded from Access 2000 to Acces 2007. I am using my vba script to export data but for some reason it does not like Access query exporting into excel. Below is my code DoCmd.OutputTo acOutputQuery, "qryCustomerSalesAndStockOfferExport", acFormatXLS...

Hi, Is there a way in MS Access to send an email to 500-1000 email address from a table? I want to send the email from MS Outlook. Any suggestions or examples would be much appreciated Thanks in advance