Search results

how can i join the tables ? can you provide an example

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

awesome! that takes care of the VB but im still able to view/edit the forms, tables, querys etc is there additional settings i can change?

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

how can that be done? do you have an example of useing that method? i have tryed a = "insert id ...." a.requery but thats me guessing!

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

thank you much!

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

that absolutly right, but when i go to edit a record that has more text that it carnt display it dosent show the scroll bar until i click on the feild, so i want it to show it all the time , if its needed

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

i have a string in vb from one form, and i like to pass that to another form so that ID="123" in form 1 is that same in form 2 (ID=123) and then how can i use that to do an sql query to search for ID? and spit all hte data into text feilds? thanks!

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

is it nesseary to have #4/5/2008# the "#"?