Search results

I am a knucklehead! I don't even want to admit what my problem has been.I have the FE opening just fine now. Both FE and BE are password proteccted. I am now trying to back up the password protected BE file. The code to backup is called by the cmdGo button on the password entry form. The code...

More research. I found out that the Microsoft.Jet.OLEDB.4.0 provider does not work in Access 2013 64 bit. I changed the provider to "Microsoft.ACE.OLEDB.12.0" and now I get a runtime error "Not a valid password." My password is correct, so what are the possible causes?

I have password protected the BE database but not the FE. I have been able to open the FE, but if I try to open the main form (frmInvoices) I get an error message "Not a valid password." So I deduced that I had to call the OpenPotectedDB function (which I believed would pass the password to the...

Hi, I'm trying to use thi function from http://msdn.microsoft.com/en-us/library/aa141813(office.10).aspx which was suggested by vbaInet: Function OpenProtectedDB(strDBPath As String, _ strPwd As String) Dim cnnDB As ADODB.Connection Set cnnDB = New...

From the deafening silence in response to this thread, may I assume that this cannot be done? Or is it merely very difficult? :D

Thanks! It took me a minute to figure out the syntax but thanks to your example, I think I have it.

Thanks to vbaInet and EternalMyrtle for your responses! I got it working both for hide and un-hide of both.

Hi, I got this code function for hiding the ribbon and Navigation Pane from this forum at: http://www.access-programmers.co.uk/forums/showthread.php?t=262446&highlight=hiding+navigation+pane+vba It works great for hiding. I had to improvise to un-hide the ribbon, but had no luck with the...

Many thanks to the many who helped me with my last post on this subject. Well, I finally got a function working flawlessly until I password protect the database. Is there anything I can add to this code to prompt the user for a password? Or even code to embed a password? The code is : Public...

Hi, Thanks to JHB, pbaldy and AccessBlaster for the suggestions! :D I Found It! Somehow a page footer text box containing "="Page " & [Page] & " of " & [Pages]" was way over on the 21 inch position of the Page Footer!

I am trying to set a filter on a form with VBA using variables and having no success at all. The code I tried last, which seemed to be "close, but no cigar", was: Dim sFilterValue As String Me.FilterOn = False sBiller = Me.txtbiller.Value sLastSource = Me.txtbiller.ControlSource...

To answer JHB's questions, the pages appear as a second and third page on the printer or PDF file. I haven't made any attempt to control the page margins or any printer settings at all, neither manually or with code. The code I use to call for the printer is: DoCmd.OpenReport "rptInvoice"...

I can't believe I did that! I'm not trying to print a form, I'm trying to print a report! I am such a knucklehead! Should I close this thread and open a different one?

Hi, I have a form that looks and prints exactly as I want it to, except for two little things. These things are extra pages. They don't appear on the print preview, but they always show up on the printer and on the pdf file when I email it. One page is blank and the last page has "Page 1 of 1"...

Thanks! I actually figured that out for myself, but I do appreciate the continued input. I'm using a command button to send the email and set the flag. It shows the email form before sending and you have to click the send button on the form to complete the process. So, you can be reasonably...

Sorry, I just about thanked everyone, but I don't want to have anyone think I am brown-nosing, which I am not! I am just of the old school, where being thankful for others time is just good form. In the future I will try to keep my thank yous for complete resolution of my issues.

I'm using 2013.

Thanks! Could I take complete control and still use the print preview? Or would I have to use the report view and add a send email button to the report? If I did it that way, is there a VBA function or command to create a PDF file?

I realize this question was a little off topic and not posed very well. So, I really appreciate your taking the time to respond. Your information gives me a good starting place to deal with my problem. Many thanks!

On the print preview there are (among others) are buttons for: Print which sends the report to your printer, Close Print Preview and email. When you click on the email button a list of formats comes up. There are a number of file formats to choose from, PDF being our first choice. When you click...