Search results

Hi, I've created a 2010 Word Mail Merge into a 2010 DB. All is fine. When I open the Word doc directly, it prompts me to select "Yes" to updating the mail merge information into the DB. The issue is, when I open the Word doc from Access using VBA, there is no such prompt, it just opens the doc...

Hi - I'm hoping someone can help me please? I need to be able to scrape some basic details from a webform and put the values into a access database. When the fields are refferrenced by elementID's I'm okay, but in this case they are in a table - Argh!!! The fields I'd like are Name, Address...

Hi, I'm hoping someone can help please? I've setup a mailmerge from an access 2010 DB into a MS Word Doc 2010. I've added the placeholders and linked them to the appropriate query. I'm using VBA to open the Word Doc and print it. All this is fine! This issue I have is that where I have placed...

Briilliant - I use the enable / disable nav pane mod. That's been very helpful and thank you!!

Hi, Hopefully someone can help please? I'v seen a fwe posts on here, but no answers to be honest..... I'm looking for a way to password protect the Nav pane in a 2010 DB. It's split FE and BE which is all fine, and I've done all the usually bits of hide nav pane etc etc. That said, if anyone...

Sir - you have save the lives of my colleagues today - thank you from all of us. Seriously - thanks so much mate that's worked a treat!!!!!!

Hi, I'm hoping someone can help me before I kill myself or someone else :banghead: I'm trying to get a Dlookup going, so: I have a table: "Lookup_Outcomes". This has two fields: [Last_Outcome] and [Complete] The other table is Tb_Master where my main data goes. There are two fields in this...

What a total legend!! Thank you so much - really did the trick!!!

Hello all, I'm hoping someone out there can be very kind and help me please!! I have a field [Duration] which contains a numeric value which relates to seconds that a call has lasted for. So, typical values can be 0 2 157 Any value really, but they are all seconds. I have another field in...

I know, I should have stayed well clear to start with.... :banghead: Any help on this would be greatly appreciated!! I have two tables: 1 is "tb_Q&A_PPI". This contains a field called "Lender" I have another table: "tb_Q&A_PPI_Matrix" which has a field "Excluded_Lenders" The field...

Hi there, Thanks for replying. So would I use your query in the criteria field of a select query? Thanks again for helping me!!

Hi, I have a field: [CustomerName] which contains: Mr Chris Smith As an example. In some cases there is a "." after the Title, IE: Mr. Chris Smith. Ideally I want to be able to split these into Title Forename Surname But mainly just get the forename. Can anyone help please?

Hi, No one seems to have an answer on this so I'm hoping there is a guru out there. I'm using Access VBA to get data from a website using the Element ID. All fine. However, when results are displayed in a table, I'm stuck - Grrrrrr :mad: Example of what I want to get below: width="12"...

Okay, This is something I appreciate I should know (blushes with shame). I'm using the below to create an outlook event which is being populated (to, subject and body) from an access form. Private Sub Command14_Click() Dim Olk As Outlook.Application Set Olk =...

Hi, I am using VBA to get information from a webform. The issue I am having is that once I have executed the run query on the web form, I cannot get my VBA code to wait until the page has fully loaded. I've tried While ie.Busy DoEvents Wend Which doesn't work ; - ( The code I am using...

Hi there, I am very new to web scraping with VBA through Access. I'm using a form in an db which has some VBA in. This is accessing a portal from which I am putting data from the form into the portal, running a query, then needing to get some data back from the portal to my form. I've been...

Maaaaate - you are a total legend!! Worked perfectly. Thank you so much for helping me with this!!!!

Hi cyb3rwolf, Thank you very much for replying to this thread. I took the .text off the field (yes it's a field in the form) but still got the same error. I also then took the .value off the end of the code that was giving me the issue and did get a result back into the ms access form field...

Hi, I'm trying to get some information in and out of a web page (very new to this). The code is below. The aim of this is to take information from a form, input it into the site, run a search, then take the returned info and pop it back into some empty fields on the form. The highlighted...

I see where you are coming from, but I don't think that will help. The reaso being is that: Combo is in a subform. Combo control source is a table. Combo points back to table - table points at query, query points at lookup table. I know it seems a long way round, but take my word for it's...