Search results

Jobs Sounds you need Cascading Combo Boxes. Please search the Forum, there are many posts on this topic as well as examples.

Validation The following is not perfect, but it's a start, it goes in the Before Update Event of the field. Private Sub Email_BeforeUpdate(Cancel As Integer) If InStr(1, Email, "@") = 0 Then MsgBox " Email Address Invalid! '@' is missing. ", vbOKOnly, """" Cancel = True Else If...

Controls May be it would be easier to create the controls at design time and set the property to Visible = True or Visible = False at the proper event.

Type I'm not sure but the problem may be that the name of the Combo Box is Type, which may be a reserved word in Access. Rename the box and see what happens.

Tab I'm sorry, but I'm confused. Do you want to permanently disable a tab, or toggle it on and off, or what?

Timer What exactly is the problem?

Controls In the On Current Event of the form put something like this: If Me.Checkbox1 = True Then Me.txtField1.Enabled = True Else Me.txtField1.Enabled = False (Replace Checkbox1 with the actual name of the checkbox and txtfield1 with the name of the textbox) You can disable controls on...

Autofill Check out this link, perhaps it can get you started: http://www.access-programmers.co.uk/forums/showthread.php?t=68985

Timer If you do a search on 'countdown timer' some posts will show up, however i'm not sure if there's anything specific there that will help you. If you can explain how and why you intend to use a timer perhaps someone will come up with a solution.

Search Alright, how about this one: http://www.access-programmers.co.uk/forums/showthread.php?t=75365 Or this one: http://www.access-programmers.co.uk/forums/showthread.php?t=65331

Button A button for a print command should be on a form, not on the report itself.

Date Hmm, it worked for me. Perhaps you can post your db (without sensitive data) and I'll have a look.

Search Please search the Forum. There are many posts and examples on this topic.

Query Try this: In the Criteria Row of the Date Field in the Query put: Between Date() And DateAdd('ww',2,Date()) Which shows the records with dates between the current date and the date two weeks from the current date. In case you want the records for the past two weeks put: Between...

Great You're welcome. Have a good weekend. :)

Disable The easiest way would be to disable the fields you don't need. You could put this code behind a command button: Me.txtfield.enabled = false (where txtfield is the name of the appropriate box) And to enable the field again: Me.txtfield.enabled = true Or to make invisible...

Focus Before you disable the button you need to set the focus on another control, for example: Me.textfield1.setfocus

Box Open the form in Design View. Select the Combo Box and go to Properties. On the Data Tab go to Row Source. Click on the button with the 3 little dots. Now you will see the Query. The far left column is Column(0), in this case Supplier is Column(2). As for the After Update Event. In...

Box In the After Update Event of the Combo Box you need to put some code like this: Me.txtfield1 = Me.Comboboxname.Column(0) Me.txtfield2 = Me.Comboboxname.Column(1) etc. Replace 'txtfield1' with the actual name of the text box you need to populate Replace 'Comboboxname' with the actual name...

List It seems to me that you need cascading combo boxes. Please search the forum, there are plenty of posts and examples on this topic.