Search results

Hi, Is it possible to get the cursor to change on a OLE object like it does on an Hyperlink? How know that you can do that with a text box with the "Is hyperlink" Format property or by adding a space in "the hyperlink address" of a command button but I can't see any property that I can change...

It's strange if I try to create a comboboxe in the costumer form i have been using until now, the wizzard doesn't allow me to choose the option "find a record based on Combo selection" BUT if i insert the combo box just after having creating the form from scratch using a wizzard, I have the...

Hey Colin, Well i've tried the wizzard and I couldn't see where I could set the option to go on a specific record. I am using access 2003, does that matter?

Hi, I am having a problem using the combo boxe, I think it is an easy problem but I have been spending the all morning trying to find a solution with no success. i am designing a form allowing to enter the different costumer information in our system. The costumers information are broke down in...

I am sorry for the late reply, I had many problem to sort out all at the same time and I though that waiting a bit for that one would help me to find the solution but I am still pretty stuck. To answer the latest post : If I can use the primary key on form1 as a criteria for to the record source...

Hi all, I came to a situation I didn't think would occure. I have set up security for my application. I have an hyperlink field on one of my form and the problem is that because of the security I can't edit the hyperlink which I usually accessed by right clicking my mouse. As anybody had any...

Well, I have decided to create the Mdw file via the wizzard and now the database seem to be properly secure and can't be opened unless using the shortcut. I have now personalised the shortcut path and the workgroup file where Made sure that Admin is only part of users and not admins. I have...

That's what I am not sure of because i have rejoined my computer to the default "system.mdw" I can open all my different application normally without any password. the password is only asked when I click my custom shortcut (with the secure workgroup I have created)

Sorry to be going on about security but I think i have miss one step. I am using access 2003. Once you start the wizzard you got the 2 options: 1)Create a new Workgroup information file 2)Modify my current workgroup file (if you have created one previously) If you choose option 1) you will get...

Yes, it can be done but it is gonna be much more complicated than You expect. I hope you have plainty of time for reading because their is no easy answer to your request. First, you probably will have to secure your database and then you will have to split it in a front end (FE) and a back end...

Thank you very much for your advice ghudson. I don't want to sound like an idiot but there is still a fact that I am not sure of. If I put the Fe and the shortcut to the user drive, the user can access any of those: -If the user click the shortcut, the security is applied -If the user decide to...

Hi everybody, I have been spending the last few days trying to find a way through the "access security Maze" which I believe I have just done. I have been following the "Ms Access Security Faq to the letter" and just now, I can open the database via a desktop shortcut including a custom...

Thanks Pat, that's brilliant

Sorry to be annoying but is the "security Faq" still Exists?

I am trying to open a single form with a single subform with a command button. I would like to open the form with the subform on a specific record but I am not entirely sure how to do this, I was wondering if someone had any advice that could help.

Thanks Laurentech, I never thought of using a conditional statement, makes sense and works perfectly, thanks again.

I have a switchboard using 4 different label that open a specific form when clicked. I have been trying to add a very simple code on the "on mouse move" event of each label that change the state of the 4 labels I am using: Private Sub Form_Current() Me.Option1.FontBold = True...

Cheers Rural guy, I just though of doing what I wanted to do by using a command button. I can use the click event of the command button where if my condition applies then "DoCmd.GoToRecord , , acNext" Else message box "blah blah blah"

This is, I think a very easy question: What would be the apropriate form event to use when leaving a record on a single form (When you press next record for example)

I have just tried the following code, to get 0 instead of #Error but it doesn't seem to work. Public Function FctError(Results As String) If IsError(Results) = True Then FctError = 0 Else FctError = Results End If End Function