Search results

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...

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...

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...

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.

i want to run a querie to criate new tables every 200 records, how can this be done?

i want to build a query that says: in the col "properties" return all records that are between the word test. 1st record reads "test" and 34th record reads "test". so i want it to return the first 34 records. i know there is a way but i just can't see it. any help....

i've been ask to think of some solution to this problem but i'm no way near of it. i have a txt file (ascii) with aprox. 1845000 lines. the code is something like this "++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Date: 02-12-2004 Time: 11:06:24 Job...