Search results

yes that is USA billion

yes this is possible. You can do it from a subform, or search 'filter' on this forum and that should help you out.

youll need a form to to set parameters then have a query pull the parameters from the form. There are alot of examples on here, search!

i usually see chr(34) as chr$(34) .. is there a difference between the two?

link a combo box to a table with months

I use this code and it seems to work well for me... If Me.Name & "" = "" Then MsgBox "Name is required" Exit Sub End If

dont post in multiple forums, k thanks.

that code is too much just to check if 3 boxes are filled. try this. For Each ctl In Me.Controls Select Case ctl.ControlType Case acTextBox If ctl.Text & "" = "" Then MsgBox "You must fill in all data fields."...

SetWarnings NO, then turn them back on

jw if it has to be a string? have you tried DoCmd, that may make a difference. Or just use and object query.

wow, please proof read and pick better language. Try not to use a picture if it isn't necessary, I've found that it dramatically slows down databases, especially if it is on a network. If you NEED the picture get the picture down to the smallest file size possible.

try username = NULL cost_centre = NULL and so on

my database does that, this code is what does it. let me know if you have questions. Private Sub but6_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Call ButtonOver("but6") End Sub Private Sub Detail_MouseMove(Button As Integer, Shift As Integer, X As Single, Y...

it is saying if they type '1' open this form, if they type '2' open this form and so on

dont use the asterick, so just do like "2" hopefully that helps

oh i didn't know it was in a combo box .. do [Forms]![Form Name]![Combo box Name] for your parameter

do alt+print screen then paste it into paint

are you directly trying to type into the text box in design mode? or are you trying to type in form view?

like "parameter*" (asterisk if needed)

link the table like he said and maybe instead of an append query do a make-table query