Search results

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 installed the Service pack 2 this morning and it still was not working. I tried the code from above and it works fine, its was fairly simple. Thank you very much for your help

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

I have pasted my code first part puts the info into excel and the second part formats the spreadsheet. I have closed the workbook. The workbook = xlbook Thanks for having a look at this Public Function fn_ExtractCustomerInfo() As Boolean Dim db As Database Dim rst As Recordset Dim xlApp As...

Hi, I have code in MS Access 2000 where it imports the data into an excel spreadsheet from vba code and formats it. Then closes the spreadsheet. Only problem is next time i open a spreadsheet it does not open or if i run the vba code again it will throw up a debug message. Only way it will...

Hi thanks for your help. Just a quick one regarding using a keystroke to the keyboard using the SendKeys command, do you know how that works? Because I am not familiar with Keystroke and SendKey commands. Thanks

Hi, I have written some code which works kind of. Basically i am exporting data from Access 2000 to Excel 2000 onto a template in excel then making a copy of the worsheet and saving the file. The code works 1st time but second time when i try opeing up excel it does not open up and when i try...

Hi Thanks i used this code and it worked fine Dim lngRow As Long Dim intCol As Integer Dim ranCell As Range For lngRow = 13 To ActiveCell.SpecialCells(xlLastCell).Row For intCol = 5 To ActiveCell.SpecialCells(xlLastCell).Column Set ranCell = Cells(lngRow, intCol) If Left(ranCell, 7) = "http://"...

Hi, I am using MS Access 2000 and have a problem when i export data from access to excel regarding hyperlinks. Once the data is in excel the hyperlink is not working, i have to click on each cell and press enter for the link to work. I have tried 2 ways which are ...

Do if you in MS Access 2000 if you can scale a report like in MS Excel you can scale a worksheet under Page setup change the scale to eg 50%.

Hi, I'm using MS Access 2000, and I have images on my report, which is no problem, but is there a way when I export the report for the images to be shown in Excel? I have exported my report to excel and only the data comes up but no image is there any code or anything, which can be done to...

Hi, In Ms Access 2000, is there any way not to show a blank space in detail part? For Example I have a group heading called Stock and if there is no history for stock under detail I do not want a blank gap there instead move to the next record. The gap is there is because if there was data...

Hi, I am using Access 2000. I have a problem with continious forms. I have a imgage which is a link, only problem is its displaying on every record. On Current Event Procedure i have put the following code Me.ImgSC.Picture = [FileName] SysCmd acSysCmdSetStatus, "Image: '" & [FileName] & "'."...

Hi, I have a list of 100 pictures in a folder and I want to link them on a table via OLE Object. Is there a way I can do this in 1 go instead of linking each picture. Thanks

Hi, I am a bit confused as i have a query which is a cross tab and i want to creat a report of it. Only problem is as its a cross tab the headings change all the time eg April 2007, May 2007, June 2007 If i run the report again the headings may be different as the data would of been updated...

Hi, I just need some help regarding populating a table called tblDates using VBA code. I just want to populated fields with adding in dates from 01/01/2005 to 31/12/2009. The fields I want to populate are Date Month Year Day Wk_Commence MonthID Week_Nu 31/12/2005 December 2005...

Hi I have a problem with my Outlook referencing in VBA in Access 2000. On one machine I use Access 2000 and Outlook 2000. This machine I can send emails via Access and its fine. But on another machine, which uses Access 2000 and Outlook 2002, it does not like it. I have gone under reference...