All,
Could someone help me understand the following issue?
Basically, I have copied the scrolling text example from this forum, slightly modified with a dlookup to the BE Database.
The way I have everything set up is off of a main form, or what I call a 'Switchboard'. The switchboard has several buttons that will take you to the various places in the FE. This switchboard also includes the scrolling text as a news feed.
I used to disable document tabs, and have everything set on the navigation buttons as - close current form, open the new form. This worked well, but from a functional point of view, you couldn't do two things at once, say check a password, and then check a telephone number.
So I thought to myself, it would be better if I enabled the document tabs within the FE itself, so that way I can speed things up.
I don't use any macros, but instead everything is in VBA coding. A specific part of the FE uses the command - DoCmd.RunCommand acCmdRecordsGoToNext.
This command when pressed, when both the switchboard and the form with the DoCmd.RunCommand acCmdRecordsGoToNext is open will return the error: The command or action 'RecordsGoToNext' isn't available now. Run-time Error 2046.
After figuring out that it was actually the scrolling text box that was causing the issue (by closing the switchboard/setting the timer interval to 0), I have set the timer interval to 0 when it opens anything else up.
Am I right in saying that due to the Timer Interval being set at 100, it is constantly calculating and therefore the RecordsGoToNext command doesn't have the chance to be fired?
Could someone help me understand the following issue?
Basically, I have copied the scrolling text example from this forum, slightly modified with a dlookup to the BE Database.
The way I have everything set up is off of a main form, or what I call a 'Switchboard'. The switchboard has several buttons that will take you to the various places in the FE. This switchboard also includes the scrolling text as a news feed.
I used to disable document tabs, and have everything set on the navigation buttons as - close current form, open the new form. This worked well, but from a functional point of view, you couldn't do two things at once, say check a password, and then check a telephone number.
So I thought to myself, it would be better if I enabled the document tabs within the FE itself, so that way I can speed things up.
I don't use any macros, but instead everything is in VBA coding. A specific part of the FE uses the command - DoCmd.RunCommand acCmdRecordsGoToNext.
This command when pressed, when both the switchboard and the form with the DoCmd.RunCommand acCmdRecordsGoToNext is open will return the error: The command or action 'RecordsGoToNext' isn't available now. Run-time Error 2046.
After figuring out that it was actually the scrolling text box that was causing the issue (by closing the switchboard/setting the timer interval to 0), I have set the timer interval to 0 when it opens anything else up.
Am I right in saying that due to the Timer Interval being set at 100, it is constantly calculating and therefore the RecordsGoToNext command doesn't have the chance to be fired?
