Search results

wright, got it. i didn't use a recordset, i used a wiserd to generate the form, so i forgot that part... ok. tks a lot.

Sorry but i didn't follow you, can you be a little more explicit, please

Ok, i have a form in wich i want to set the parameters to a query. On the search button it will open another form to display the data. i used this code stLinkCriteria = "[ID]=" & Me![id] And "[status]=" & "'" & Me![sta] & "' the 1st value for status is "active" it returns a msgbox asking the...

i try this: stLinkCriteria = "[ID]=" & Me![id] And "[status]=" & "'" & Me![sta] & "' and when it runs a box apears with the title of the data i entered to set the value to look, i think i'm near but there's something missing

Ok, i have a form in wich i want to set the parameters to a query. On the search button it will open another form to display the data. i used this code "stLinkCriteria = "[ID]=" & Me![id]",but the problem is that i have 5 criteria from wich i can trim the query. is there anyway to do this and...

I'm trying to do a simple if then i'm using a value of a text box to the if like: if textbox.value is null then blablabla else blablabla end if but it the textbox is empty but i gives me the error of invalid use of null. i've tryed with "" or 0 but nothing works, always the same error...

go to the design view and your combo works like a normal query.try there to see if you can work it out. if you like try to send a db for us to see .

yep, that's it i already had it working but thanks anyway. you know how it is, go for a coffe and when returns the solution is right there in front of you... thks.

i don't know if is the correct way to do it, but you can create a table Assignee_details related with table A, then just call the query with that field. donn't forguet to make the right relationship

forget it i figure it out : "SELECT jobs.Account, Sum(jobs_details.PlottedArea) AS SomaDePlottedArea, Sum(jobs_details.UsedArea) AS SomaDeUsedArea FROM jobs INNER JOIN jobs_details ON jobs.JobID = jobs_details.JobID WHERE (((jobs.JobDate) Between #4/1/2005# And #4/2/2005#)) GROUP BY jobs.Account...

problem is i need the total area divided by account on a date interval (like a mounth) and it returns individual values per day, per account.

w, well, it's not exactly what i wanted, i need to select all records by mounth and some the plotted area for each account. that's why i used the distinct, it works if i dont use dates, but when use dates it splits by day and i can't work around it.

do it all in a form using vba! in your subform use fields to do the calculations needed and then the save the fields with the results on your table.

touche again!! But i need your help once more. on that same db i need a way to filter the data i thought on a form where i could select date account, etc and it give me the some of the print areas. i try to do this on a query but when i put a date it stops the select distinct to the account. i...

heve you tried to use the max function? in design view choose max, and it returns the last entry.

there you go

i have 2 tables jobs and jobs_details jobs have the fields name date account etc. jobs_details have the print area, file, etc. i need a querie to give me the total print area for each account on a particular date but i can't get it to work. I've tryed this: "SELECT DISTINCT jobs.Account...

wayne, i'm try to find a code to disable the sistem confirmation message after running the sql delete command. is there a code i can use for that???

i'm trying to put a button on my form to browse throw the files and when select a file loads the path and name of the file into a variable on my form, but i cant find the button "Browse". anybody knows were the hell is that thing... THKS.

w, You got it, know it works just fine!!!! i'll try the debuger now. you just saved me of a few hundred years of hard work. thanks again.