Search results for query: *

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

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

hya, im sending mail from an access database and i am wanting to retreive mail received from lotus notes. im not sure if this is possible if not could someone put my mind at rest, if it is then it would be a great help if someone could help me do it

hya, im still having problems with Dlookup, i have a form with the following code on the timerinterval. Nothing happens when the date and time match??? does anyone know why? Private Sub Form_Timer() If DLookup("[Date]", "tblCallRecords", _ "[Date] = Date()") And DLookup("[Time]"...

hya, i have a main form called 'frm_ID', its record source is a table (tbl_ID) with only one field 'ID Number'. The main form has a subform called 'frm_IDSub', its record source is a table (tbl_IDSub) with a field 'ID Number' and several other fields. the two tables have a one to many...

hya, i have a main form with a subform, the main form recordsource is from 'tblReferenceNumber' and the subform recordsource is from 'tblCallRecord' the two tables have a one to many relationship. i want an unbound text box on my main form where the user enter's the reference number then clicks...

hya, this is the scenario: if the user wishes to receive a call back reminder they tick a box and update [date] field and [time] field with the date and time they would like the call back. the switchboard is always open and when it does open up it also opens open another form...

hya i am able to view all the users logged into my database, the thing is there is no one logged in not even myself but yet windows explorer still shows the '.ldb' file which appears when some one is in the file, also i am unable to rename the file or delete the file because there is a sharing...

hya, i have a large database approx 50 mega bytes in size, last night i tryed to open database and only only access loaded up, there was no sign of the database or any information. The database is still 50 mega bytes in size, i dont understand what has happened. I really need to resolve this...

hya, i have created a database in XP and windows NT using access 2000, the database works fine for all users. I now have several users that want access that use Windows 2000, the applications loads up but it does not open any forms, it just opens access and the title bar becomes the name of...

hya, when a user clicks 'save' i would like a msg box to appear displaying " 'Reference Number' has been updated' ". 'Reference Number' being the name of a field. it would be a great help if someone could show me how to o this