Search results

Ok just thinking out loud, but I think something like this will do it. Private Sub Command0_Click() Dim objPrinter As Object Dim sAction As String Dim vPrinter As String Dim vLink As String Dim MyBrowser As SHDocVw.InternetExplorer Dim dbs As DAO.Database Dim rsQuery As DAO.Recordset Set...

Ah sorry I think I misunderstood slightly. That code works off the basis that it's one PDF but you could add a loop for each record in the query. Not entirely sure how you'd go about that at this stage but let me look into it :)

I recently had a go at something very similar to this, I quickly found it became very convoluted so I hope you're good with VBA! First let's assume your form is called MyForm, and you're using a combo box (MyComboBox) based on the query you mentioned to select individual PDF's related to the...

Gotcha you little ...! I was calling the fOSUserName Function On the HomePage to detect the current user (Intention was to monitor users logging on/off, as well as presenting a little 'welcome back InsertNameHere!') You can see it on the attachment I provided, but for some reason its not...

... Ok wait a second, I downloaded my own attachment and it seems to be working fine... The only thing that changed was after deleting all the other objects I ran a compact and repair, which must have removed the issue. I'm going to run through the other objects a chunk at a time and see...

Hi JHB, No problem, I was going to attach the whole thing since its a draft project anyway, but the file size was too big... I've left the aforementioned components in and the issue remains. Any ideas? :)

Hi All, I've encountered a strange feature of Access VBA, which while isn't critical, is very annoying. So I'm typing in the code window for a form (doesn't matter what form, report, macro, or if its real code or just 'notes), but Access is deleting the spaces I type almost as soon as I...

Doc_Man I've just got to say thanks for the interesting post. Obviously this isn't exactly the answer I was hoping for (that would be = 'there's a big red button that does it for you!') but it is intriguing nonetheless. If I understand correctly you're suggesting it would in theory be...

Thanks apr pillai, this will give me plenty to look into :)

Hi All, This is going to sound really pathetic and I'm sorry to even ask. But does anyone have any good examples of Access Charts and graphs? The thing is, I have never used Access for this function, always been much easier and simpler to export data into Excel and do all the number...

Is this a display issue on the form? if it is you should be able to hide the extra stuff by messing with the formatting, make sure it's property 'is hyperlink' is set to yes. Otherwise I think HyperlinkPart will help.. see https://msdn.microsoft.com/en-us/library/bb225915(v=office.12).aspx So...

Reading this back I think I made a false assumption. Where exactly does this folder icon sit? is it on a form that shows Employees? From your screenshot it looks like a fairly standard form + subform setup (employees plus their certifications I would guess) If that's the case you should be able...

So at the moment your code works out to: Followhyperlink "\\SPFS01\shared\QualityandSafety\QA Common\Quality (Q1)\Authorisations\ENGINEERING RECORDS\LastName_FirstName" Presumably you want LastName_FirstName to be replaced by the fields in your table? if that's the case replace the...

I'm only guessing here but I would assume once you have created the task in Outlook it is no longer reading 1.21 as a number, but as text. Maybe you just need to add quotes to your strFilter so its read as text? strFilter = "[Mileage] = """ & Me.Case_Number + 0.21 & """" I think...

I never thought of this, support your favourite websites by increasing ad traffic! In theory advertisers more successful, demand goes up, price goes up, web host richer, and maybe doesn't need as many adverts anymore! OP, is this a workable solution? ;) P.s. No-one solicits advertisements...

Hi Dave (and Gemma), interesting point about caps lock, but this seems to be the only way I can get it to work :) I just switched out the code from my previous post for the below and it's now working for both the Access reports. Not sure what was wrong with the 'for each method', but frankly...

Hi IssKint, I've tried to change as you suggested and added the following just before the first print: For Each prt In Application.Printers '''Where Me!PrinterList is a combo box listing all available printers. If prt.DeviceName = Me!PrinterList Then Set Application.Printer...

Thanks for the replies this is all very helpful :) I see what you're saying - if I can set the default printer before hand then that should do the job. However part of the issue is that my users often move between different sites and printers, so setting it to just one printer wouldn't work...

Hi All, I've been asked to put together a function that prints two different reports and up to two hyperlinked documents on our network (based on a selected combo box item). The idea is to save users from having to locate each report individually - Easy enough I thought, I just tell access...

Fascinating, and no-one is in the office at this time? Doesn't that present a fire risk!? (Better not tell Health and safety) ;) Sounds like you're 99% there.. if your macros work, have you tested the batch files during the day, maybe there's an error with one of those? Stupid questions...