Search results

Hi...me again i have one report that is passed along a one of 4 almost identical queries. Therefore, as per wahtever conditions i need to set the recodsource to whichever query applies. I have written the below using 2 different tech's for setting it but it does not like. An error comes up...

Thanks.....your absolutly right about not opening the query and you were also right about the values (stupid error in form name which I c&p to all of them.) Thanks again

I have a form in which the user enters a bunch of criteria which is passed along to a query and that to a report. In the header of the report i have various textboxes stating the criteria values. I did this by setting the control sources. eg. =[Forms]![frmReport_Char]![cbox_status] but all i...

if anyone was interested........linking masterfields have to be a static value. So in this case where I had a range of value's it could only recognize the first one.

I posted a question earlier because I was only getting ALL of records with the first occurance of BV in the criteria. I am now thinking the SQL is not the problem at all. This is the snippet where I update a subform and my problem lies in the lines: Me.sfrmForm.LinkChildFields =...

I have this query QRY = "SELECT * FROM tblMain_BV WHERE ([BV] BETWEEN cint(" & tbox_BV_min & ") AND cint(" & tbox_BV_max & ")) ORDER BY [BV];" the problem is that I assign it to the record source of a subform but it lists only all the occurances of the next occuring value from the low end...

I have actaully asked this before but go no reply so i'll try my luck again. I need to retrieve a recordset from a table. The records i need to retrieve are related to another rs i've gathered which holds a list of keys. So me question is how do i write a query in SQL that takes 2 tables and...

No worries all......solved it. You can use the me.recordsetclone function and manipulate it like a regular recordset. Thanks though.

Hi all......I have a form with various combo boxes used for criteria. In the form is a subform which holds a table in datasheet view and updates as i choose from the combo box criteria's. There is a textbox on my form which i would like to fill with the average of on of the columns in the...

You'll all have to forgive my ignorance on this one, I am very new to this game. I have been developing a db but have written all my queries by hand as the query builder is making no sense to me. These queries are getting very long and difficult to debug so I am cracking and asking for help...

I have to write this ludicrussly long SQL statement so was thinking about doing it in steps for easier debugging. IE. Get a record set as per some criteria then with new criteria search that recordset not the whole table. i have never seen this before so is it even apossibility and if so what...

Good Morning all.....I have had an ongoing dilema which i have been ignoring thus far. In a como box with say 3 columns. After you pick from the list how do i get all 3 to remain in the box as opposed to just the bound column???? Thanks in advance

Got it........the alternative seems to be a must..... ie. " & Nz(tbox_SLOPE, 0) & " The help was appreciated G

i apologize about that. I honestly forgot i even posted that yesterday! However, the suggestion is not working for me. it is used in a SQL INSERT statement coming from a form. I have tried both of these but it still doesn't like ......., nz(" & tbox_SLOPE & "), ...... and ......., " &...

Hello all.....i have a form which is used to make an entry in a table with many fields. I do not want the fields to be mandatory. All the text fields are np as i set the allowzerolength property. Numbers however dont have this property and will crash the query when not entered. Anybody know...

This is a variation of code borrowed from www.candace_tripp.com and results in cascading combo boxes and an updating subform.it works great except the first time through the line : Me.sfrmForm.LinkMasterFields = "VEGETATION_CODE" results in an input box asking for a parameter value for...

i asked this question earlier about doing a SQL Insert but not working when fields left empty. I was refered to change all the "Required" and "allowzerolength". Thanks, it worked great with a table holding all text. However i have another table with all numbers. These dont have the...

Hi everyone...i finished up a form earlier where the user can enter a record with upwards of 20 fields. It works great when all the textboxes are filled. However, if any are left blank the record will not be entered at all. i am a bit of a newbie so do not know if that is standard. if so, is...