Search results

Hi everybody, I have written a small procedure to increment one of my field by 1 each time the new record button is pressed but I keep getting the following Message: "You Canceled the previous operation" Here is the code: Private Sub CmdNew_Click() Dim inumber As Integer DoCmd.GoToRecord ...

I have implemented that method on three of my form recently and it seems to work brillantly and was exactly what I needed. Unfotunately, I have started to experience some problem related to that code (I think): my mouse started to be entirely disable and frozen and I ended up not being able to...

Thanks ghudson, I can't really think of an other solution either and will use the same "back to the top button event".

Yep, you are right but I want to apply that to an OLE object and I don't think OLE object have an Hyperlink address property. I've tried to look for an answer few weeks ago but never found anything, that's the reason I was thinking of using code instead.

Encore une fois, merci a toi Ghudson,

Cheers MStCYr. I haven't try the code yet but :"Oh My god!!??!!" I think will need a bit more code, indeed...

Hi I am trying to find a way to change the mouse pointer to the "Hyperlink" pointing finger via code. I know 2 different way to change the mouse pointer to an hourglass: DoCmd.Hourglass or Screen.Mousepointer = 11 I have just been trying 60 different number for the value of...

It is annoying...isn't it,

This is not an other post about disabling the mouse wheel in access application but an other issue that is starting to really bug me... Some of my forms have a continuous subform, I can normally use the scroll wheel to go up and down the different record in the subform BUT i have noticed that if...

Hey rural guy, Yeah what you're saying is working, thanks, Well, I also have "Compact on CLose" turned on so it might have something to do with it. It would be interesting to know how and why this is happening to see if there is any way to prevent it or see how often this is likely to happen.

Thanks John,this is working.

Hi, I have been doing some minor change in design view in my database but now each time I am closing the database. I am getting the following message: "Table 'Temp'MSysAccess objects' Already exists", Is anybody knows why?

umm.... I have added the following is loaded code in my modul Function IsLoaded(ByVal strFormName As String) As Boolean ' Returns True if the specified form is open in Form view or Datasheet view. Const conObjStateClosed = 0 Const conDesignView = 0 If...

Thanks guys I will give it a search.

I have witten a code in the close event of a "Primary" form that would update a Combo boxe on a "secondary" form only if the "secondary" form is open. ie: Private Sub Form_Close() If Forms!frmEnquiry.Open Then Forms!frmEnquiry!CboCustomer.Requery Else DoCmd.Close End If End Sub This code keeps...

Thanks supercharge, I am not sure I can because the database is already up and running (splitted and secure), and there is a very large amount of data that my company wouldn't allow to go on the net...I don't think there is anything I can do about it just know, i am going to see if I can make...

Cheers Supercharge, basically the form that I want to open is based on a very large query hence the 5 to 10 sec time needed to load and open the form. I have commented out the last part of the code just to see if the "cmd.hourglass true "was working at all because I was getting no changes, when...

Thanks supercharge, still no luck though. This is confusing me, if I try to open the form with a command button the hourglass is working fine.

Hey, Supercharge, thanks for your reply. Unfortunately, the changes don't seem to do anything, the pointer doesn't show the hourglass. I don't understand why?

Hi everybody, I am trying to personalised the way Access looks and in this specific case I am trying to open a form with a label: I: I have added a "space" on the hyperlink address property which is changing the mouse pointer to a "pointing finger" when the pointer is moved over the label...