Search results

I have a backup procedure that is giving me a "Permission Denied" on my own profile. Can anyone spot an error in my code?Public Function BackupFE() On Error GoTo BackupFE_Err Dim SourceFile As String, DestinationFile As String Dim aFSO As Variant Dim Path As String, Name As String...

IHi, I have a very simple single-table database with 23 fields. Some of the records have only two or three fields populated. I would like to be able to print a summary of only the populated fields in each record. It would Ideally look something like: Record 1 Name Field 1 Title: Field 1...

Hi, I'm trying to change the table links to a password protected BE DB. I found an example online, which I adapted to my needs. When I set it up to fail to find the normal BE it seems to work as intended until it gets to the line "Tdf.RefreshLink". Then it crashes with a 3031 "Not a valid...

Hi, I have searched and have not been able to find anything on creating a read-only copy of a back end DB with VBA. I am creating backups of my back end file and would like to create a local read-only copy to use in the event that the regular back end is not available. If anyone has any insight...

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...

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...

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"...

Hi all, Many thanks again for all the kind and helpful responses to my many questions! I have yet another. I would like to set a flag when a report gets emailed. Is this possible?

Hi all, As you can see from the title, I have lost my installation disk. :o I'm afraid I know the answer to this question, but is there any remedy, other than repurchasing the software? Obviously I didn't make a backup. :o :o

Hi, I got these three code routines for backing up an Access database file from two different forums. I installed them as is, on a test database, creating command buttons for each. The test database is not password protected. I intend (if I can get one of these working) to install it on simple...

Hi, I have a crosstab query that is crashing and I wonder if it is too complex. It uses another query which gets a value from a textbox on a form. The code that calls the query is: DoCmd.OpenForm "OpenTabsFrm" DoCmd.OpenQuery "qryWeeklyBedtimeHumalog", acViewNormal Me.Visible =...

Hi, Can you force print preview to open in zoom 100% mode with VBA?

Hi, I'm trying to set a filter with a command button. I've tried to do it like the examples I've read on numerous sites, but I can't seem to get the filter set. The code that seems most like the examples to me is: Me.Filter = "[chkPaid] = 0" Me.FilterOn = True When I run this I get a...

Hi, Is there any way to open a report in print preview and have the form that opened it be reopened? I've puzzled over this for hours with no success. I can open the report in print preview with no problem, but none of the report events seems to fire when the print or close options are clicked...

Hi, My tooltips for my command buttons do not work at all or in some cases not until you click the button. I tried this code from a post on this forum that was supposed to fix this problem, but it threw a "Method or data member not found" compile error for the "lblHelp1": 'Event on command...

I have a line of code that used to work and now does not. I must have changed something, but the only things I am aware of are cosmetic. The code is: Public Sub ResetTime() Dim DesiredVal As String DesiredVal = "= 'Your last activity on Wilbur was at '" _ & " & Format(Now(),'Medium Time')"...

Hi, I've taken a break from Access for a while, but I'm back at it again and having some difficulty. I am trying to open a form with a timer to state that the database is going to shut down in five minutes if they don't respond. I'm obviously using the wrong code. I've been trying to use the...

Hi, I know that Access can display images, I have seen it done. But I can't seem to figure out how. I am using Access 2013. I am trying to display a photo in a form field. In the underlying table I have tried using attachment and OLE Object data types and I couldn't get the picture to display...

Hi, I'm OB Burton. I am glad to be with you. I have a little limited experience with Access and programming but no experience at all with forums. Please excuse me as I stumble through the etiquette of posting on a forum. I hope to learn a lot here.:)