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 ...

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...

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...

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?

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...

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...

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...

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...

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...

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...

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.

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...

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 am running a query with a field that can have or a values or no records. When the field has no record the field is blank. My problem is that I am using a function with that field as a parameter, when that field has no record the function return #Error, It is quite important that I get a "0"...

Hello, I am trying to find a way to open a form with a subform on a specific record (for the form and the subform), I came up with the following but keep getting a mismatch mistake which means me think I am not doing it right. What would be the apropriate way to achieve what I am trying to do...

I have a problem with 1 of my form (FrmEditDrawing) that I use to edit a specific record from 1 of my table (TblDrawing). The user will see the Data for each drawing on a form that I called (FrmViewDrawing) and will be able to edit the data for each drawing by clicking a button that will open...

Hi Everybody, I am trying to delete a record on a Single Form, then Close that Form and then requery an other form that should be already open. The Code I wrote doesn't seem to work, the code is interrupted before the command Close? What would be the correct way to write the code? Private Sub...

Hi everybody, In a continuous form, If I use a comboboxe with a criteria looking up a field in the same record, it seems that the combo boxe only looks up the value of the firsrecord, Iam not sure I understand why? I was wondering if it there was any method to be able to use Cascading combo boxe...

Is it possible to reference a field on a form via code that as no record available on the loading event of a form. On the loading event of my form I have tried if TxtEssai="" then ...or if txtessai=null... but it tells me that I have entered an expression with no value which is making sense...

Hello, I have a small problem, I have just been struggling for the last 2 hours to be able to use the command "Find Record". I just wanted to enter a "number" in a txtbox and get the form to go to the corresponding record (where the drawing file is the "number" in this case) Private Sub...