Search results

hi if i had 2 tables (below) how can i do a search for the staff and there sub-task? all in one table? table 1 staff---- job 1 -------cleaning 2 -------washing 3 -------fixing table 2 job---------------task (subtask) cleaning ---------bathroom cleaning ---------bedroom washing...

is there an easy way? rather than distribute an MDE to users.

Hi there, how can i manually insert data from a text box into a table using vb? i assume it involes the "insert" command?

How can i Disable a forms ability to select previous records in a "add new record" form? thanks

how can i disable access to the form design and visualbasic code so only authorised persons can make changes to the code?

how can i use two control sources from a table and place them into a single textbox?

when i perform a query and atribute a ascend ordering for a date feild, the blank feilds always show up on the top of the list, but the rest of the feilds are what i need. how can i keep the blank feilds at the bottom, whilst keeping the same ordering of the non blank feilds?

how can i change a database to allow multiple access? is there a downside to doing this? eg. if two or more people are trying edit the same feild???

how can i make a text box (with multiple lines) display a permant scroll bar on the right hand side?

I was just wondering what the drawbacks for using Shared and exclusive databases. id like to create a shared database but has anyone come across any problems? what happens when 2 people at the same time access the same row and save at the same time? is the first persons work get overwritten?

i have a string in VB (eg. "test")that will cahnge depending on the input, ihow can i search for the string and display the data into a form? i currently have this "SELECT [Tasks].Staff_Name, [Tasks].Project_Title, [Tasks].Percentage_Complete, [Tasks].Tracking_Number FROM [Tasks] WHERE...

i have a vb string. how can use that to make a query and spit all the data onto a form like it does if u were to perform a wizard

how can i pass a variable from one form to another this works fine Tracking_Number = Forms("Main").Control("mytext") but if "mytext" was in vb (rather than from a text box as shown above) how can i do this

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

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

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

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"

hi how do i make a query that prompts a date and searches for anything that occured after that date? thanks:eek: