Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Zaichik123

    Is it possible to get an image in the header of an xls file?

    and if so, whats the code and type of file that the object has to be?
  2. Zaichik123

    Formatting all sheets within a workbook?

    I've tried doing this via a With ActiveSheet.PageSetup and then selecting all sheets to run the macro on - and also With ActiveWorkBook.PageSetup but still to no avail. Predominantly I want to PrintTitleRows across all sheets within a workbook - is this possible? Whats the code for this? Z123
  3. Zaichik123

    Insert sheets and copy

    My fault to be honest, I should have scrutinised the code more myself to realise that - but to be honest didn't have time... Thanks for your help
  4. Zaichik123

    Insert sheets and copy

    Thanks Skip but it needs a bit of debugging... nn - First it asked me to Do without Loop so I added in a loop at the end of the code but the macro had no control over the amount of sheets added and didn't copy the text. test - tells me Subject out of Range, or Object Required if I change the...
  5. Zaichik123

    Whats the separator for this query?

    Thanks Golom, But its then asking me for a parameter - I've not come accross these before - how should I tackle it?
  6. Zaichik123

    Whats the separator for this query?

    Probably two of the easiest questions ever, but how do I combine these two queries? UPDATE CWT_Room SET CWT_Room.cwfADB_RoomCode = CWT_Room.cwfRoomTypeTemplate; UPDATE CWT_Room SET CWT_Room.cwfExtRevCde = CWT_Room.cwfRoomTypeTemplate; I was thinking UPDATE CWT_Room SET...
  7. Zaichik123

    Insert sheets and copy

    The report is for several rooms within a department, the macro is to count how many rooms, add that amount of sheets, and each time it adds a sheet it should copy the room info into that sheet.
  8. Zaichik123

    Corrupt records in converted AccessXP database

    You may need to update service pack info. Downloadable from the Microsoft website...
  9. Zaichik123

    Insert sheets and copy

    The formatting of the report is not the issue, I need the macro to recognise the next room instance, add a sheet, copy that rooms data into that sheet and then continue doing so through the rest of the report. Hope this clarifies...
  10. Zaichik123

    Insert sheets and copy

    Trust me I would love to, but unfortunately this is on a massive scale and the report is for several external users whom aren't particularly IT savvy.
  11. Zaichik123

    Insert sheets and copy

    I agree, but the report is for several different rooms within a department that need to be on different sheets within the same xls file. 'Split' I suppose isn't the correct term - separate seems more suitable.
  12. Zaichik123

    Insert sheets and copy

    Hi, I have a report that I need to split down into several sheets within the same workbook. I've already developed the majority of the code, but am struggling to add the correct number of sheets and then copy info into the 'next sheet'?? Dim strDept As String Dim strGrp As String Dim...
  13. Zaichik123

    Header and Footer problem

    Hi, I need to collate several similar reports (individual files) into one file. This can be done through MS Binder, or by pdf'ing and inserting files... however by adding a continuous page number to the bottom of the file, this knocks out the existing header created in the MS Word, or in...
  14. Zaichik123

    Image file within Excel Header or footer

    Thanks anyway.
  15. Zaichik123

    Image file within Excel Header or footer

    Unless I am mistaken it is impossible to select an image file (like a company logo) to be added to your header or footer through File/Page setup... (Microsoft Office 2000 Pro) But I'm sure it must be able to be done through VB, I've been playing around with some code for a hour or so now and I'm...
  16. Zaichik123

    Query to compare two versions of the same table

    Thanks for your help so far Golom, but rather than NOT show any duplicated records in the two tables and only display records that are unique to one or the other of the tables - it is just showing that which matches. If you imagine you have two tables which have 10 identical records...
  17. Zaichik123

    Query to compare two versions of the same table

    SELECT a.room_num, a.room_name, a.hce_code, a.item, a.quantity, b.room_num, b.room_name, b.hce_code, b.item, b.quantity FROM CWT_CdeB_HCE_DataTransfer AS a INNER JOIN CWT_CdeB_HCE_DataTransfer2 AS b ON a.room_num=b.room_num is the easy part of the query. What I need to display are fields that...
  18. Zaichik123

    Query to compare two versions of the same table

    I want to write a SQL query that compares two tables and only shows the differences between them. The tables are large and predominantly the same so as a result of running this query I'd like to be left with a new table that only shows what is in table a and not in table b, and what is in table...

Part and Inventory Search

Back
Top