Search results

Hello, I have been thinking, is there someone I need to declare the properties I am using in a global scope or does Access know what they are eg Dim StartUpform As Type etc etc Any ideasif I need to do this. I don't even know where or which Type they should be?? thanks, nosaj

Thanks Cyber Lynx, I have now changed the lines to your suggestion above. Now getting a different runtime message Runtime Error '2455'. You entered an expression that has an invalid reference to the property 'StartUpform' The 'StartUpform' in the error message would be the other property...

Anyone have any more info on this? Sorry to be impatient, but I am at a complete loss to the solution :( Thanks, nosaj

I thought my error may have been to do with the fact that I have the same startup form declaration in the first line of both statements, however when I changed that, I get the same runtime 2467 error with the other lines. would anyone have any further ideas. I have spent the last few hours...

Thanks gemma. I will try and explain what I have so far and where my errors are I have a login screen (frmLogin), where the users enter username / password combination and click an Enter button. The following code is then attributed to the onclick event of that button Private Sub...

Thanks gemma, can this sort of stuff be programmed into a button click event, or would it need to be put somewhere else?

Hello all, Firstly I have done a searhc here on this topic, and have found some information to help me, but am still fairly stuck. My VB code knowledge is fairly limited. I have in my database a login form where users are either Admin or Normal. I wish to change the startup propertied in VB...

We've decided to go a different way about our database design, but thanks for the info anyway folks nosaj

Hello, I have a question I would like some assistance with if possible I am using a switchboard for my database and was wondering if it was possible to display an Information MsgBox when going from one switchboard page to another. I already have a Msg Box when I open a particular form from the...

I think I may have found a solution to the 'blank' problem, instead of using NULL as above I use the following value list ""; ;"Yes";-1;"No";0 with no integer value assigned to the blank option. This seems to work so far, but if anyone feels there is a more optimal or efficiant way to do...

DCrake, thank you for that, it is almost exactly what I need. I was trying something similiar earlier and just did not think abou tthe column settings. Final questions on this, is there a way I can have a 'blank' option in my combo box? and still use the above? So that if the user wants to...

Hello, firstly apologies if this is being posted in the wrong section. I thought this one would be most appropriate. Let me try to explain my problem as it is confusing to me. I have been designing an Access database for my company which keeps track of orders. Users enter the data through a...