Search results

That did the trick. It now opens a separate xls file leaving the template intact....Thanks guys, you saved me a breakdown...Cheers

Worksheets seem to be problem Thanks for your time For some reason the routine is overwriting the Excel template and not creating a new xls document. The routine runs fine if i use a clean template for it to write to. Do not know what is wrong but the only way i know how to go is to reverse...

I have a clothing Database that orders and issues clothing items to members of staff. The program also keeps an account of clothing not issued and therefore still in stock. In order to have a written record of this, i have been able to write a routine that creates an Excel Workbook that puts...

Found it Just in case anyone is interested, i have found the solution to my problem... ' Code to Copy worksheets required Set objXLWs = objXLWb.Worksheets(intSheet) For i = 1 To (intRecords - 1) objXLWb.Worksheets(i).Copy after:=objXLWb.Worksheets(i) Next i

I have a button in Access that populates the worksheets of a template in Excel. Each instance of a particular item in my table is added to its own worksheet and the worksheet is renamed according to the item description. This works fine but only if there are enough worksheets in the workbook...

Ok got it, thanks a lot for your time..Much appreciated

OK cheers....What is the syntax of refering to a subform on another form

I have a [frmMain] form which i would like to run maximised. I also have a button on the [Main] that opens another form [frmAdjust] in Popup mode, because i do not want this form to be maximised. The problem i have is that when i return to the [frmMain] after closing the [frmAdjust] i want to...

Database was far too large to post. But what you said about the field being deleted made me look at a query that was designed to delete the contents of the table and populate it rather than just update it. This was the problem, now sorted. sometimes you find yourself looking all around the...

I have a textbox on a Subform which is updated when a record is double clicked in another Subform. This works fine until i move the mouse over the updated subform. Then the updated entry is replaced with #Deleted. The data is still in the table that gives the subform its value. Also another form...

DB zip The form in question is [frmStationStock] and the combobox is [cboRecipientStation]. Thanks again for your time

DB too large Can't post as it is cos it is too large. I have to go to work now but will try and trim the zip file down to the essential components and post. Thanks for the time.

I have a form [tblStock]with a combobox bound to the Primary key [ContactID] of a table [tblContacts]. Also on the form is a subform[subContacts] bound to a query that is based on the value of the combobox on the form. So that the details of the combobox[ContactID] is shown in the subform...

Thanks for taking the time to answer guys, but i attacked the problem from a different direction. I ran an update query from the click event of the checkbox. This seems to work better. Cheers for your time anyway

tried both Tried both methods from previous posts. Ok to update the subform but not the updated table with the last edited record. Clicking another record or closing and reopening the form is the only thing that has worked..:-(

I am a relative Newbie so if my question sounds stupid, bear with me: I have a form with a subform linked to a query. On the subform i have a checkbox[Recieved] and when checked adds a date to another field [Year] on the subform which in turn updates the record in a table[Orders]. I then...

Sorted but thanks for replying I was trying to update a field in another table depending on the state of the checkbox in the subform with the value of the textbox on the Mainform. I gave myself a slap on the head and included the field i needed to update in the subform and updated it as you...

I have a Mainform with a subform linked to a table. Within the subform i have a number of individual checkboxes and a field [Year]. One checkbox, [checkboxIssue] i have wanted to link two update queries in order to update the field[Year] with the contents of a [textboxValue] on the Mainform...

I have a database that allows the user to order clothing items. Each size of each item has a different stock number. I have [StockNo] - [StaffNo] - [Qty] i need to generate [OrderNo]. The problem i have is that [OrderNo] is incremented after every five five items (ie[StockNo]). This gives me...

Der Thanks for that