Recent content by AccessDevJunior

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