Search results

I have Office 2000 installed on my pc, but also have access 97 installed. Everything works fine except when I am importing/exporting an excel file. I have already installed a service pack that fixed the import/export process for text files, but I want to know if there is something else I have...

If you are just opeing a form put that code into the ON OPEN action of the form.

Try putting this type of code into the After Update of the FullTime/Part Time field. If txtFTPT = "PT" then txtBenefits.enabled = false txtSalary.enabled = false end if

See if this will work. It is kinda vague, but let me know if you have any more questions. Enter this into the On Load or On Open of the Form: If txtUserWhoEntered = CurrentUser then Memo.enabled = true else memo.enabled = False end if

See if this link helps. There are a couple options depending on what you are trying to do. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=53867

That will work.. Thanks!!

How do you set a value or integer to return a certain amount of characters. Please refer to the example where I am asking to place zeros so that the value is still 4 numbers long. 0005 0025 0035 0100 0001 ?expression(txtbox)

I don't have jack crap on this pc. Supposed to be getting some new ones, so I'm not worried about fixing this pc up quite yet. I'll look around for something though. Thanks!

Does anyone know where I can download a free calendar addin for Access that I can place on a form? I've used them before, but have switched jobs and we don't have licenses for the ones currently on this pc. Thanks for any info!

Try double clicking checkbox 2 to open the properties and set the default value to zero. Also, you may want to consider using an option box, where you can only have one selection active at any given time.

I appreciate the reply. That wasn't necessarily what I was trying to do, but I did figure it out. Basically, I was trying to change the properties of some check boxes in an array, when one of the boxes was checked. Here's what I came up with for anyone else that may be interested. Private...

Does anyone know if this is possible?

I am trying to cycle through some checkboxes on a form. I can't quite figure out the right code. Here is what I have. Private Sub chkSnap0_AfterUpdate() Dim intchk As Integer Dim rpt As CheckBox Dim strrpt(6) As String If chkSnap0 = -1 Then For intchk = 1 To 6 strrpt(intchk) =...