Search results

That is strange... I just tested this quickly and it worked properly for me. Perhaps there's some other setting there somewhere that's conflicting? Not sure. U could try re-creating the main form, see if it works then? Or do a quick test on a new form and if that works compare the settings?

Generally speaking, u don't want or need to have calculations stored in a table. U already have the Monthly fee stored, so all u need to do in a form or report is create a field called Late Fee or something and in its control source put: = 0.05 * [Monthly Rent] Or even better, create a query...

Not sure if this is your problem or not, but if u change the allow edits property u need to requery the form before it takes effect. Which i guess is what your doing by switching between the main and sub form...

ok, I was asked to do something like this and this is the only way i could think of doing it. Private Sub Form_AfterInsert() If Not IsNull(Me!myField) Then Me!myField.DefaultValue = me!myField End If End Sub So u basically change the default value for the field to the last value...

Should be possible. Just use the form to store data in a table for each user. Then when u open the particular form u want to change colours/enable buttons etc on, look up the settings in the table.

In a Continuous form?

Try this: Private Sub Form_Current() If Me!BkrInit Then Me!myName.ForeColor = vbRed Else Me!myName.ForeColor = vbBlack End If End Sub

U can use something like this in the before update event of your form: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim strFields As String strFields = checkFields If strFields <> "" Then MsgBox "Please fill in the following fields:" & vbNewLine & strFields Cancel...

Private Sub box1_DblClick(Cancel As Integer) openServiceJob 1 End Sub Private Sub box2_DblClick(Cancel As Integer) openServiceJob 2 End Sub Sub openServiceJob(jobNo As Integer) Dim stDocName As String Dim stLinkCriteria As String DoCmd.OpenForm "frm_weekstartservice"...

The problem is, unless u specify the mailto: then access assumes it's a web address. So if u enter: me@here.com Access actually enters: me@here.com#http://me@here.com# The format being displaytext#address#subaddress#screentip So to get around this u could do something liek this: Private Sub...

Yup. Have one table for your CD info tblCDs cdID cdName cdArtist etc And one for tracks: tblTracks trkID cdID trkName trkLength etc Then bind your main form to the tblCDs and create a subform bound to tblTracks, linking them via cdID.

I'm not sure either. I think if your field is set to the date/time data type it won't allow u to enter it like that. It might work if it's set to a number data type? But that might defeat the purpose of having a date. Is there a reason u need the users to enter the date like that? Another...

This won't help u edit the text at all, but will allow u to see all the text without scrolling. Private Sub txtField1_Enter() If Not IsNull(Me.txtField1) Then txtField1.ControlTipText = txtField1 txtField1.StatusBarText = txtField1 Else txtField1.ControlTipText...

Oh so it is... Sorry i was thinking of the types for the number data type... Have a look at this page, it might be what your after: http://support.microsoft.com/?kbid=210304

Is that just an example? Because Currency is a format, not a data type... I've nver used the Alter Table statement, but i think it can only add an delete columns?

u can use something like this in the onClick event of the command button... If InputBox("Enter Password?", "") = "myPass" Then doCmd.openForm "myForm" ... Else msgbox "Incorrect Password!" End If

I've created a user log so i know when people log on and off (or when they don't log off correctly), and this doesn't seem to be the problem. For example, i've just repaired the database and with 30 minutes it's corrupted again. And this is with only 2 people logged on (using the Citrix front...

Have a look at this page: http://jamiessoftware.tk/articles/handlingimages.html

Try putting a requery here: Else DoCmd.OpenForm "frmAddEditVendor", , , , , acDialog cboVendor.requery pintResponse = acDataErrAdded

Can i just ask why u need to use a seperate form for the status? Could u not use a combobox in the datasheet with an after update event that asks if they want to send a letter or something like that? Or do u do other stuff in the seperate form as well? I'm assuming u have a requery or...