Search results

thanks again for the reply the link you posted, doesn't that go back to using the OutputTo method which causes my original error to occur? i guess i'm looking for a way to open the save as dialog box using the transfer spreadsheet method. anyone know how?? thanks

dont i have to declare the spreadsheet to transfer to with that method?? i want the pop up dialog to apper so a user can creat a new file and save where they like.

Hi i'm trying to export a query but am getting the following error : You selected more records than can be copied onto the Clipboard at one time. Divide the records into two or more groups, and then copy and paste one group at a time. The maximum number of records you can paste at one time is...

thanks both i will try these out and let you know how it goes

Hi i have a subform which is linked to a people table. when i start entering a new record sometimes i want to exit without saveing but when i click of the record i get an error message .... The Microsoft Access database engine cannot find a record in the table [TableName] with key matching...

hi i filter a form based on a selection in another form. problem is when i go back to the filtered form i can no longer cycle through records. only one record is available (the filtered) or i can add a new record. is there a way to select the record and also still be able to cycle through the...

i is set to 0 and increments at the next statement

Hi i'm trying to use this... for i = i to myForm.myList.listcount -1 If myForm.myList.Column(1, i) = myValueThen myForm.myList.Selected(i) = True End If next ...to select some items in a listbox. I've had this work on another list where the...

hi i'm using mystring = replace(mystring, aValue, "") to replace duplicates in a string used to build an sql string. i.e. i could have... 1,2,201,55,202,3,40,55, 555, 22, 222, 22 so if i use the replace on the 22 it SHOULD only replace the other 22. whats happening is its replacing the...

hi i have a table which contains report definitions. rpt_id, rpt_name, rpt_col1, rpt_col2, rpt_col3, ..... (there is some other stuff) so a cell in rpt_col1 will have maybe account numbers stored in a string in, so: 5001, 5002, 5003 i want to be able to load in a report def so i need to set...

perfect, that works fine. just had to wrap it in this.. If lst2.ListCount > 0 Then ... End If to avoid an error if the list is empty. Thanks

thanks it removed the last selected item but still unselected everything else which was selected??

Hi i have an multi-select (extended) value list listbox which i want to be able to remove multiple items from using a button. this code removes the first selected item but then deselects every other selected item so nothing else is removed. can someone advise what i'm doing wrong? 'loops...

is it possible to return the top/left position of an object. i might be able to get this to work if i had those? Thanks

thanks for the reply. i was hoping to be able to select everything and then move all the items to keep the layout. If i have to use top, left etc... then it'll take forever to move then re-align all the objects. doesn't look like it's possible. :banghead:

Hi i have some form object which sit on top of each other. I have brought them in and out of view by grouping them using tags. what i want to be able to do is select a bunch of items with a tag name and select them all (so i can move/format them). i though something like .. Dim ctl As...

hi i want to find an entry in a list box using the on change event of a text box. i've found this... Private Sub TextBox1_Change() Dim x, z ListBox1.ListIndex = -1 For x = 0 To ListBox1.ListCount - 1 ListBox1.ListIndex = x z = ListBox1.Text If...

hi i have a list box (extended) which i select all items using a button. after the selection the list box is scrolled to the bottom. i want the list box to scroll back to the top. i've seen... mylist.TopIndex=0 - which doesn't work. TopIndex isn't recognised mylist.ListIndex = 0 - which...

Hi i've put the values of a multi-select list box in a text box. i now want to use those values to filter another query (use for another list box) a typical value is : "INDEP", "NATIONAL" (i've added the quotes in the code) i then put this into my query : In...

Hi the company i work for has 4 meeting rooms which have outlook profiles in order to use the calendar to book time slots. The meeting room accounts are set to process meeting requests automatically however the account has to be open in order to process meeting requests from users. This makes...