Search results

I would appreciate any help with my problem I am using a subform within a form to select data from a field, the records field is defined as a hyperlink which contains the location of a pdf file. When I use me.datadisplaysubform("report") to retrieve the data, I find that the field contents get...

Hi I am trying to extract records from a table using variables gained from another table, unfortunately I cannot create the correct syntax. I have 3 variables,i have shown my sql below Sql = "select seqno,surname,forename,diedon,warcemetery from ByCemetery where surname = CWGC_surname" If I...

Is it possible to merge 6 Word documents and the output the complete document as a pdf using access 2007 VBA? Has anyone and code example that I can use. Thanks in anticipation Regards Ian Clegg

I have a need to merge 6 pdfs using vba, I have checked all the bullzip pdf writer references but can find no info onto how to configure them. Can anyone help me or suggest an alternative method. Thanking you in anticipation Regards Ian Clegg

Hi Has anyone any simple code that merges multiple pdf documents that they are willing to share. I don't seem to be able to find anything that works so far. Thanks in anticipation. Regards Ian Clegg

Hi Has any done the above, I have read many help forums but cannot figure it out. I am wanting to store a bitmap photo in an access table and then want to include it in a report. Thanks in anticipation Ian Clegg

Hoping that someone can help I am trying to update a table in an access database storing war grave locations from memorial data. I want to query the cwgc.org website automatically using vba to retrieve the location of the cemetery or memorial that the person is located in or on, I know the...

Hi Can anybody suggest a method of reading web page source code data. I am trying to create an event similar to a web query in Excel. The table in question is not a html table but an asp.net table I think. Thanks in anticipation, I hope someone can help Regards Ian Clegg

Hi Am I missing something? I am trying to compare a field of which it should fall between 2 values which are LW_Less 5 and LW_Plus5 if the comparison falls between these 2 values it should turn the background colour of the box green. This condition is never met and the box always turns red...

Hi can anyone help or point me in the right direction. I need to access website information using vba from a button on a form. eg www.google.co.uk/news, I then want to extract some of the relevant information from that page ( This will be from a private website using a sign on eventually). I...

Can anybody point me in the right direction? I am trying to zip a file that I have exported as a csv file from a form in access. The file exports ok but the zipping is a problem. I have used the code suggested by keiths and is listed below Dim objzip Set objzip = CreateObject("poles.zip")...

Can anybody pointme in the right direction? I need to link or import a spreadsheet into access for processing. The worksheet that I want is on the secondtab in excel and is called worksheet, the firsttab is called JobProgress. My existing code is as follows DoCmd.TransferSpreadsheet acImport...

Can anyone help me with code to open externally saved PDF files from a button on an access formn using VBA. My pdfs are located in a folder on the c: drive eg. c:/jobpacks/a/alfreton/yyy.pdf /b/barnsley/xxx.pdf etc All I want to do is open them and display them on...

Can anyone give me an example of using F3 to paste a value stored in a variable into the current field on my form. I can work out how to use F Keys to display messages but cannnot work out how to paste as in Ctrl+V Regards Ian Clegg

Can anyone point me in the right direction, I have an input screen that with my normal working resoloution 1024 x 768 does not all fit on one screen. I thought that I may be able to change it using vba to 1152 x 864. Is this possible Regards Ian Clegg

Can anyone help I need to change the background colour of a field in a report dependant on it's value my code is a s follows and it is placed in the detail section in the on format event if togo.value < 10 then togo.backcolor=255 (Red) end if I can make all the records togo foreground...

I seem to be missing something! I have a memo field in a table that I need to update. The update data is in a fom field that is either a text field or another memo field. I have tried updating the recordset by adding the input to a string field and then adding it back but still the field does...

Can anyone help? I have a minor problem when sending emails from vba in an access appliaction. The code I use is as follows docmd.sendobj ,,," '" & email address & "' " ,,,msubject,,true My code sends the email ok, however before sending, Outlook displays the correctly formatted email within...

Hi Can anyone help? I am trying to identify selective records using vba and sql and am unable to select the correct records using my code. I have a table containing the records fro selection having the fields JobNo and Code which in all records the criteria for selection. The code reads...

Can anyone help, I am wanting to lookup place locations from a field held in a table. eg 'barnby dun', I need to know which county it is in. Can anyone suggest any method or code that can help? Thanks in anticipation Regards Ian Clegg