Search results

Ha, i think i'll go with the fix rather than introduce a service pack that will create more hassles.. cheers

Hi, i'm unsure whats happening here, but it seems that when I have a label on a form and mouse over it it 'flashes' This is an issue for me, since I am building a Risk Matrix, where each square of the matrix is a label that has its color changed depending on selected options. Since I have a...

Only just found this after posting in another section.. From reading the above, is it possible to base the backend of a split database on sharepoint? (meaning the FE simply points to the sharepoint thing to get the tables etc)

Microsoft Sharepoint Help Hi guys. Over the past couple of months I have been developing an Access database to manage and track changes throughout the site. Recently, the company has decided to introduce Sharepoint (just services i think, not server), and it was suggested that my change...

Option Compare Database Option Explicit Private Sub Form_Close() Form_MainMenu!MainMenu_subfrm.SourceObject = "frm_Login" End Sub Private Sub Form_Load() x=msgbox(Date()) 'Sets the subform to be the login screen Form_MainMenu!MainMenu_subfrm.SourceObject = "frm_Login"...

what are the event headers?

Hi, im just experimenting with creating a backup button that simply copys the backend and pastes it into a backup folder with the date attatched. Since I have not used the Date() function I did some testing by putting msgbox(Date()) into a forms load procedure.. That worked fine when i opened...

oooo.. line numbers was the other thing... forgot about that... IMO thats the dumbest thing MS did. As if leave out line numbers.. as for the code compression.. using the combo boxes is what i've been doing, but i don't like it.. When coding in java i use JCreator which has this function...

One thing that I would bend over backwards for is the ability to 'minimize' subs. by this i mean a + button next to the sub declaration that when clicked minimized that sub to one line. This would make things so much easier to navigate long form codes.. Another thing, i don't know if this is...

Hey all, I was just wondering if there are any other vba editors available? The built in one is annoying me, there are some simple code formatting things that other editors I have used can do that makes editing code that much easier..

Yeah, I was coding like I was using Java. VBA seems to be a bit different in how it handles Instance Variables.

Ok, I fixed it by declaring the array in a module as a public variable. Most odd. btw, i'm waiting Adam

but it shouldn't be. The array in the form is declared outside of the subs, then initialized within the Load sub. array = getLocations(param1, param2) msgbox(array(0)) this works fine within the Load sub, but to do the same thing (msgbox) in the Cancel sub gives the out of bounds error As...

ROFL... I'll look into it this is a new problem Adam :) The problem doesnt seem to be to do with an upperbound. My function getLocation returns an array based on parameters. My form when loading runs this function and gets an array back, the first element of the array is a string used for...

hmm, it seems that wasnt my problem... On the load form, it runs the function that gets an array If changes are made to a control that is set from the array, and the user hits cancel, then the array is used to undo changes made to the table. Whats happening is array(0) is faulting with the...

Array Out Of Bounds Error is it possible to run a do loop until an error arrises? My situation is this, I have an array that is set from a function, the size of the array varies. What I want to do is run a loop that increments through the array until it hits an out of bounds error. can it be...

the other option would be to create a small background process that runs whenever the computer is on, and simply triggers the actions you want, when you want, depending on username. i dont know how you do this though, although it would be similar to those update processes that programs like...

im using '03 I think i've fixed the problem by including StopMacro after the code executions. Im assuming the macro kept running for some reason and it was perhaps looping somewhere. weird that it only happened when i included the OpenForm function on the macro. It seems to work now though.

I think i've just fixed it by including a StopMacro at the end of my autoexec macro.

Ill look into that gemma. However i'm still experiencing my initial problem where the form goes stupid, controls don't work and access locks up. Anyone know why this would be happening?