Search results

Hi Emma, I had the same issue I believe it's because Access reads the number as a string, and rates it alphabetically one letter at a time, so if 1 is less than 4, 100 comes before 40.... so clever (slow sarcastic applause for MS) Can't remember exactly, but I think I used the val()...

OK so I think I've found a work around. I still have no idea why it is happening but it seems setting the focus to an arbitrary control on the ParentForm before running the requery makes it work. This doesn't explain why it happened but it seems to be an easy fix. Thanks for reading...

Hi All, I have a form [FrmPersonnel] which contains a subform [sFrmQuals] showing personnel qualifications. I also have a third form [QualPopup] which is used to add the qualifications, rather than using the subform itself (I do this because the subform only shows a brief summary, rather than...

Have you set the Link Master and Link Child fields on your subform? If not that I agree with Gina, how are your tables setup? To be clear, which subform is causing the issue? The one that records office visits or the one recording the course they are attending? I assume you've...

Hold the phone - looks like a couple of extra spaces were removed from the hyperlink when I copied your code back (I know, but I didn't create the document names...) Anyway I added them back in and your code works perfectly! Thanks a tonne ArnelGP! :)

Hi Arnelgp, Thanks again, I've tested your code (Edit: And it works perfectly!) although I don't really know how ;) I must admit this is now going well over my head, how does the ShellExecute know to interact with the web browser? Sorry for being a pain :)

Ah I think I see where the disparity is now and I realise I may have been a little unclear with my first post. The Browser is a separate instance of internet explorer opened from a command button, not a webBrowser Control. I have continued searching and found some other suggestions how to...

Same issue again, me.WebBrowser0 method or data member not found... Getting closer though I will try messing with a few things :) Code as it stands: Dim MyBrowser As SHDocVw.InternetExplorer Set MyBrowser = New SHDocVw.InternetExplorer MyBrowser.Visible = True MyBrowser.Navigate...

Hi Arnelgp, Thanks for the quick reply, I've added your suggestion but now I'm getting a compile error: 'method or data member not found'. It is highlighting AcWebBrowserState.Complete Is there a reference library I need to add for this? I have attached a screenshot of mine fyi. Thanks,

Ps. I am trying to print the page without opening the print dialogue because the Users will already have made a selection in the database front end. When this code works it will be used to print multiple documents per 'print' action :)

Hi All, I'm trying to create a function to automatically open and print a PDF document from a hyperlink inserted in a field, unfortunately I am struggling with the .execWB method. My code so far is as follows: Unfortunately while this is loading the PDF no problem, it returns an error on the...

Yep all our databases are split with Back end(s) sitting on our network drives. thanks for the links I can see i'll have a lot to think about!

Hi all, I am looking for some advice/discussion. We are planning to migrate our access databases to a server to be accessed by a remote desktop application. I won't bore you with the details but the point is this allows a licensed number of users to open the database without having MS Access...

To retrospectively answer my own question, and for anyone else searching form vs forms Forms refers to the collection, forms!myform etc Form is a property relating specifically to a subform , forms!myform!mySub.form.property see link...

So further searching of the internet seems to be suggesting Access is not able to calculate the total number of pages on a report - unless you include a control on said report... surely that can't be right? Does anyone have a working example of when report.pages is actually useful? it...

Hi Arnelgp, thanks for the reply. I'm not sure exactly what you mean by Line Number control could you please explain? I'm trying to find a method which doesn't involve changing the controls on individual reports (if possible) but rather add a simple call function to the OnPage event that...

Hi all, I'm putting in place a register to log each time a report is printed. I wanted to record how many pages long each one is, but it needs to apply to any report on our system, so I want each one to call the same function. So, is there a method I can use to count the pages...

Wow I did not think of that... well I feel stupid. thanks a bunch :)

ps. the way I left example 2 it may look normal, but keep clicking tab! you'll see it doesn't cycle through all controls anymore...

Hi all, I've encountered a strange issue on a form with a tab control and I can't figure it out. I have two/three overlapping fields (see attached example) and am trying to set the tab order so you hit one before the other, however when I do this it seems to affect the layering in terms of...