Search results

no actually im on australian time, which is may 4th 2008

how can i send text from a text feild from one form to another form using that text as the criteria to run the query?

how can i msgbox data from a sql query Tasklist.RowSource = "SELECT [Tasks].Staff_Name, WHERE [Tasks].staff_name = "josh" [Tasklist].Requery i tryed to use msgbox Tasklist.Staff_Name but i get an error message any ideas

is the sql statement correct?

but from the input for the sql string im getting is already in that format. do u need to actaully specify the format in VB for it to work? the sql string is as below "SELECT [Tasks].Staff_Name, [Tasks].Project_Title, [Tasks].Percentage_Complete FROM [Tasks] WHERE [Tasks].Date_Allocated <...

btw i appreciate the "HB" abbreviation haha

yea the fields are defined as dates but my suspision lies in the sql statement "SELECT [Tasks].Staff_Name, [Tasks].Project_Title, [Tasks].Percentage_Complete FROM [Tasks] WHERE [Tasks].Date_Allocated < #4/5/2008# ORDER BY [Tasks].Staff_Name;" this one works fine ( with date() ) "SELECT...

please help:eek:

aa= 2 and the sql is "SELECT [Tasks].Staff_Name, [Tasks].Project_Title, [Tasks].Percentage_Complete FROM [Tasks] WHERE [Tasks].Date_Allocated < #4/5/2008# ORDER BY [Tasks].Staff_Name;"

me.due is a number from a drop down list eg. 1 2 3 or 4

Why doesent this work aa = Me.Due aa = DateAdd("m", aa, Date) Tasklist.RowSource = "SELECT [Tasks].Staff_Name, [Tasks].Project_Title, [Tasks].Percentage_Complete FROM [Tasks] WHERE [Tasks].Date_Allocated < " & aa & " ORDER BY [Tasks].Staff_Name;" the sql dosent display any results!!!

.legend = pbaldy

i have an sql statement: aa = "hello" Tasklist.RowSource = "SELECT [Tasks].Staff_Name, [Tasks].Project_Title, [Tasks].Percentage_Complete FROM [Tasks] WHERE [Tasks].Date_Allocated < aa ORDER BY [Tasks].Staff_Name;" how can i make it look the the data i put in "aa" rather than prompt a msg...

Awsome.! it didnt work before when i :Dtryed it

How can i disable the naviation i get on my form? i have a form to add new records, if i accidently scroll the mouse i get previous records shown in the feild, so is it possible to disable the function?

how can i create a listbox in a form with predetermined values for a feild called status with the options, "IN PROGRESS", "DONE" and "DELAYED"

yes, i have a criteria that changes, according to what the user wants to type in .. so how can i do this?

my query has a critera so it is based on that, so if the criteria dosent match anything i want the error message box to come up the code above dosent allow this

any help? ??

im looking for an error message for the qurey itself, not a report