Recent content by habbabub

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?