Search results

thanks for the advice. works great.

no because i have three groups (1,2,3,4,5,6), (7), and (8) that i want to either return or not by check boxes.

works great. thanks. apparently, i didn't know how to use the criteria properly, but do now.

I'm building a string of criteria with a public function, but can't get the query to recognize it. i've stepped through the code, and it should work, but i can't figure out the syntax to get my query to recognize the criterion. well, i may as well describe the whole situation. i have a field in...

I have this ugly criterion for a date range: Between DateSerial([Forms]![frmQtHst]![txtYear1],[Forms]![frmQtHst]![cboMonth1],1) And DateSerial([Forms]![frmQtHst]![txtYear2],[Forms]![frmQtHst]![cboMonth2]+1,1-1) frmQtHst is the Quote History form, which allows the user to select a range with a...

right....similar system different problem. instead of a tick box for partial deliveries, i have a column that lists the number of items received. this way if the # received = # ordered, that item (within that order) is complete. I have a report that lists which orders are complete and which are...

I'm working on a Purchase Order system, and on my search page i have a check box that selects wether or not completed orders will be included. I have a 'required' column that lists the number of items outstanding on each order. i need an if statement that determines wether the query selects all...

i = DMax("MembershipNo", "tblMembers") + 1 Me.txtMembershipNo = i "MembershipNo" is the name of the field in the table that includes the membership number "tblMembers" is the name of the table that includes the membership number me.txtMembershipNo is the name of the control (i assumed a text...

for the combo box issue, look at the data tab in the properties for the combo. the rowsource should include 2 columns: the primary key number (sounds like that's displaying fine) and the 'make' column from the same table... and the 'bound column' should be 1 if the number is the first field in...

Looks like canshrink did it. i had can grow on, but not shrink. thanks for the help.

I have a report... that includes a text box in the middle of the page for comments. on formopen (and form activate, just to see if it works), i have the following code to hide the text box if there's no text to go in it. If IsNull(Me.Comment) Then Me.Comment.Visible = False i have two buttons...

dateadd(1,d,dmax(...)) 1 to add 1 d to add day (m=month, etc.) dmax(...) what you want to add one day to. maybe you could find the highest value in your index, and add a day to the associated date......

what if you make a second combo (unbound) that determines the default for the original combo, which you can then hide?

I think you'd need to use a main/subform set up instead of a header, because the header (as far as i understand) is connected to the form's current record like the rest of the form. a main/sub setup may allow you to move through records in the sub without changing the main...or you could use the...

to find the last item in the combo, i think you could use the recordcount property of the combo's rowsource query. not sure, though. as for the format, maybe in the query section there'll be some help for how to adjust the format in SQL. I'm almost positive you'll have to format it in your...

Long can store a value between -2,147,483,648 and 2,147,483,647 maybe double? it can hold values between -1.797E308 to -4.940E-324,0,4.940E-324 to 1.797E308. not sure at what point (if at all) you have to switch to scientific notation with that..... but it allows up to 308 digits.

I'm using a notinlist function to add a contact on a form. each contact is associated with a client by selecting the client from a combo on the contact entry page. when the contact name is being entered, the client is already selected on my form, and i want the combo on my contact entry page to...

I checked for the default 0 in the form, but didn't realize it could be at the table level. thanks for the pointer.

I have a main form with a subform for creating purchase orders. in the subform, details for an order are entered in datasheet format. i have a problem with a quantity column. if you click in the cell and type 15, it doesn't overwrite the default 0 and the result is 150. this is bad when you want...

Well, as you can see from this table, i thought i was normalizing, but apparently wasn't. this actually happened in another aspect of my database, and so trying to correct all my forms and queries with these 2 changes is proving to be a nightmare. hopefully it'll be simpler soon. still learning...