Search results

I know this is frowned on, but I didn't want to start a new thread for the same issues. We have started having some problems with our Access Database lately ... Two weeks ago, in one table two records with the same value in one field (for Example Field A had value 001) were missing/deleted...

In my case, the timers are set via the startup code in the database.

@Pat Hartman - I didn't catch all of the nuances of the code you posted. My code turns the timers off when I am developing code. When I want to test with the timers on, I close and re-open the database. I will probably test and possibly adopt your code instead, though.

Simple routine to turn timers off: Public Sub SilenceTimers() ' Must be run to enable typing in the VBE - space bar is cancelled otherwise - 2023-Sep-7 - MB. '...

Old thread, but in case someone is searching and runs across this, there are too different issues being described: If you have a timer running, the vb editor will drop spaces that you typed while the timer was active. So instead of "If X = 3 Then" you end up with "IfX=3Then" (and probably a...

AFR didn't work very well for this. It's a fantastic idea, but the database wasn't really designed for it from the beginning and I tried it previously and ended up switching back. But if you design for it from the beginning, it's a fantastic idea!

And if these navigation buttons are behind my banner, then they can't receive focus except via VBA.

@CJ_London - Thank you! That's what I'm looking for. It's PROBABLY okay to use the second code, but it's SAFER to use the first one.

Semi-related question ... What determines the foreground/background priority for items. For example, this is my current code (for non-HD monitors): Me.FooterBanner.left = 0 Me.FooterBanner.Width = (Me.InsideWidth / 2) - (1.625 * 1440) Me.zz_frmNavButtons.left =...

@isladogs - Thank you! I'll take a look at that code section and see if I can implement that instead of the method I used.

Sloppy but solved. In FileOpen: Dim HRes As String, i As Integer CheckMonitorInfo 'check current monitor in use i = Nz(DLookup("MonitorID", "tblMonitors", "CurrentMonitor=True"), 0) HRes = Nz(DLookup("HRes", "tblMonitors", "MonitorID = " & i), 0) ' Access gives Error 2100...

@CJ_London - I think you are onto something, but I'm getting lost in the circular logic - i.e. if windows is returning a misleading value, how do I get the true value? I found a Stack Overflow post where the max value was 31680 - I'm not sure if it is 32760 or 31680. (I'm not trying to start an...

I think so. You are suggesting setting Me.FooterBannerWidth = 24840 and going from there. Odd thing is: It seems to be working for everyone else. Unless I am misunderstanding, I'm not sure how she has double the screen resolution and her form is smaller inside width than mine. Unfortunately, I...

This one has me baffled. I created a new status bar/navigation pane in this thread: https://www.access-programmers.co.uk/forums/threads/hide-default-add-new-record-button-only-how.329982/page-3 We've been using it for some time. I was using this code in the Form Open procedure...

The main issues I've heard with "Select" had to do with the macro recorder and Excel/Word Macros. It uses "Select" liberally, i.e. RangeA.Select, RangeA.Copy, RangeB.Select, RangeB.Paste, where the macro would work the same and be faster with the select statements omitted. It isn't that Select...

I know this is an old thread, but I had the same question and @The_Doc_Man has helped me out before, so I wanted to give back a little bit. Basically, the answer is a combination of: http://www.vbaexpress.com/forum/showthread.php?2512-Solved-Position-on-page - Start at the end. And...

@isladogs - Thanks, great stuff as always!!!

I feel stupid. It's there and it works!!!! I was used to only seeing Alternate Background Colors in design view and grayed out. As you said, when I changed it to pop-up > No and opened it normally, the Form Datasheet option popped out and there it was. I never would have figured it out on my...

I was going to post something sarcastic like "Of course, that was totally obvious", but it didn't even work???

This is the form (basically) that @arnelgp posted in Reply #20. I'm not sure if you would call it a datasheet form or not. It's a regular pop-up form with the default view set to datasheet view.