Recent content by lcross

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.