Search results for query: *

thankyou again for the fast response, there will only be a few users accessing this part of the database so when training takes place i will enphasize this point. the new code you have just posted, when i select a user a comma just appears everytime -without their email address?

thanks RoyVidar that works but it seems to copy the last value again? I dont need to populate a text box i was just using a text box to text the code. I want the list box to be used to select numerous users to send an email to.

hya, I have a problem with a multiselect listbox. I would like all the selected rows of the list box to appear within an unbound textbox but only one result shows at a time. I have th following code on the after update of the list box. If anyone knows and could tell me how to get around this it...

Using an ms access as a back_end will only support up to 40 users, if you have more users on the network it may be best considering moving towards using a sql serverback_end.

Hya, I am wanting to design a form with a unbound text box, i want users to input a date into the box and click a button, the form then displays the dates for the text box date + 4 working days, 9 working days, 14 working days and 29 working days. I have the code below which works out the...

hya, i have designed an application in vb6 i wish to distribute but if i compile it to an exe the route to my data source will be incorrect on other user's machines, currently the path is: Source=F:\BCT\BCT_be.mdb; i was wondering if it is possible to change it to this: source =...

hya, i have several list boxes which retreive data from a ms access database, when the user's selects to perform a new search i wish the listboxes to reset so they are not displaying the results from the previous search. if anyone can show me how to reset the results in my listboxes it would be...

hya i have several listboxes on top of each other i need the list boxes to stay open for future reference to their values. at the minute i am .width = 0 and .height = 0, i would prefer if the control stays the same size but is just sent to back. if anyone knows how i could do this it would be a...

hya, i have a listbox and would like it display 4 columns rather the 1 column it current displays, i have this code in place, im not sure how to add more columns: Do Until RS.EOF ListUser.AddItem RS("Employee Email Address") RS.MoveNext Loop the other 3 columns are 'employee tel...

hya, i have 2 list boxes, i would like the second listbox based on the first by using SQL, this is what i have tried but it seems to have failed: dim clist as string clist = ListCompany.List(ListCompany.ListIndex) SQL = "SELECT tblEmployeeInfo.[Employee Department]From tblEmployeeInfo Where...

hya, acjeff it sounds like you are designing the same application as my self. i am too trying to acheive the same outcome using listboxes for the same purposes. i would like a listbox with a list of company names, then on selecting a company name the user is asked to select a department within...

yes thanx harleyquinn ive just done that, now im getting a msg box "data source not found, use the ODBC driver manager" i wanted to stay away from using the driver manager. once ive completed my application i will be required to install it over 400 users computers and i dont want to have to set...

hya, lykeat i am getting an error with "Constring =" ???

thanx okay ive done this, but it is only listing 1 recording (there should be 2):??? Dim db As Database Dim rs As Recordset Dim sSQL As String sSQL = "SELECT tblEmployeeInfo.[Employee Company] FROM tblEmployeeInfo;" Set db = OpenDatabase("F:\BCT\BCT_be.mdb") Set rs = db.OpenRecordset(sSQL)...

hya harleyquinn, im getting an error: method or data member not found! vladk code seems to have done the trick though, thanx for the help

hya, thanx for the advice. the code still does not seem to be working could it have anything to do with the listbox/textbox properties?

hya, i have a list box and a text box within a vb6 form. i have put code on the afterupdate() event of the list box: me.text1 = me.listbox1 in ms access the text box value will equal the selected row of the list box, but this is not the case in vb6. does anyone know how i can use the listbox as...

hya, i am new to vb6 my experience lies with access. i have 5 lines of code that retreives data from a table within an accessdatabase. i want to use the same principle to retreive the data but rather than retreive one field from one table i would like to use SQL to get exactly what i want...

hya, i am new to vb6 my experience lies with access. i am currently designing an application using vb6 but i do not know how to get vb6 to retreive the data i want. I have set up an access database and created the tables and relationships i need. in my vb6 form i have a list box, i would like...

hya, i have a form with the code behind it to automatically re-size the forms resolution depending on your windows settings. I have a list box on the form but when the resolution is made larger the list box does not change with the form as its size is set on the on open event of the form. I want...