Search results

Thank you! It worked perfectly!

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?

Thanks, so much! That did it! Without your help, I'd be beating my head against a brick wall for who knows how long!

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

Many thanks AccessBlaster! That did it exactly as I originally intended to do it. I appreciate your help!

Hi, Thanks for responding! I did not originally have the "Me.Visible = False". I inserted it because the "rptInvoice" preview would flash on the screen, but be immediately covered again by "frmInvoice". After I inserted it, I tried to add either "Me.Visible = True" or "DoCmd.OpenForm...

Thanks for responding! I really appreciate it! Unfortunately, I can just barely follow what you are doing. But I must confess that I'm not experienced enough to fill in the blank spots just out of view in the video. I'm hesitant to ask, but would there be any chance I could get a copy of your...

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

Thanks for the input! I always have had a Now() in the txtTimeStamp text box and it worked flawlessly until I changed something and your response led me to the culprit. The problem was that the line should have read Forms!frmMain!txtStamp.ControlSource. I have no idea when or why I changed it...

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

Yes it opens, just fine. But, your question got me thinking that I did not know if it would open with the main form open. Then I realized that the main form was set to modal. Of course, when I changed the modal property from Yes to No, everything worked as it was supposed to work. Thanks, for...

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

I looked at the video and he said that there was a way to use a command button to browse to get your path and file name, but you have to attend one of his classes. I can't do that but I would really like to find out how to display a picture that way. Can anyone help?

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