Search results

  1. B

    Moving Around a Word Document

    Easy cheat If you get stuck on how to do this in terms of fonts, formats etc. I just opena word doc, start a macro, then do all the bits including the movright and then look at the code it generated.
  2. B

    Moving Around a Word Document

    Dim Memory My memory is a bit dim on this but I am absolutley sure that it works. Used in a Gov job and builds remittances for Millions of £s !!! The 12 is the 1 cell bit. Equiv to wdCell
  3. B

    Merging Fields - some help with my code

    Moving in Recordsets Not sure why your doing 2 recordsets but your missing RST2.Movenext
  4. B

    Moving Around a Word Document

    Moving in a table This moves on cell to the right. objWord.Selection.moveright 12 This is some code I have used before and gives the jist of what you need. ' objword.selection.Shading.Texture = 150 objword.selection.Shading.BackgroundPatternColorIndex = 7 objword.selection.font.bold =...
  5. B

    QueryDefs and dates

    I have multiple queries in a search form which when selected change the query in the data using QueryDefs. Set Q = db.QueryDefs("QrySearchEventID") Q.SQL = strSQLHadEvent Q.Close This works fine for the 3 main queries I need to change. These are all then used in a single...
  6. B

    Send file to pinter

    I have an access database which creates an HTML message body and sends the message as an email. This code runs through a loop in a recordset, but if there is no email address I'd like to outpout the message to a printer. I can create the html fine with ... Set objFso = New FileSystemObject Dim...
  7. B

    Table Help

    Product Tabel If you have Book and it is called "Famous Five go Mad" There may be 10 copies in a liabrary. Hence tblProductTitle PTID autonumber Title ISDN etc and tblProduct PID auto PTID number (FK from tblProductTilte)
  8. B

    Table Help

    Foreign Keys tblCustomer CustomerId AutoNumber (this is correct) The Loans table should be tblLoans LoanID AutoNumber CustomerId Long (as a foreign Key. Indexed & allow duplicates) ProductId Long (as a foreign Key. Indexed & allow duplicates) etc The rest looks okay but get rid of spaces in...
  9. B

    Counting the records in a report?

    Count is fixed The key is to place it in the report header or footer and not the page header!!! I am a dork!
  10. B

    Counting the records in a report?

    Count(*) dosen't work I have a report in an A2003 FE talking to a SQL server Db. I have a report and as per the MS Help guide and my own thoughts I placed =Count(*) in the Control Source of the Text box... to no avail. I tried =Count([AccountCode]) with acccountcode being a control... to no...
  11. B

    Preview vs printed report

    Oracle Have you tried moving the queries to the Oracle Db and indexing them or at least checking the indexing. You could test the query directly in the Db with an SQL Viewer to see if that is the problem. If it is not then the network is at fault not the query. If it is then redisgn the query...
  12. B

    the right way?

    Advice in general I have been reading this thread and no one seems to notice that all the users log in as Admin! This is a bit odd and may be causing some of your problems. I have a distributed (in 8 countries) system which has a BE, a FE and a workgroup file sitting in the same directory as...
  13. B

    Function question

    Functions You need to set it as a Public Function NB you are missing the error handling code. Set it in the Before Update code and then when you use the ado use the converted name. StrTestName = Me.SURNAME StrRedone = CorrectNames(StrTestName) Me.SURNAME = StrRedone Is the easiest way to do...
  14. B

    Setting a reminder in Access onto a shared Outlook calendar

    Appointments in Public Shared Calendar I have used the above code and can also create appointments in the local calendar but I am having a problem in getting the data to the public Shared Calendar. The code can't find the folder BrianCalPub but it appears as a public Folder in my Outlook. I...
  15. B

    Printing to Multiple Printers

    Print to specific not default printer I need help here too. Anyone have an answer? I have a client who needs to print a specific report to a colour printer. All the others can go to the default.
  16. B

    Fields not printing in report

    Printing Data There is a tick box for some printer which allow data only or headers only. This may be the issue.
  17. B

    Numbers in a report

    I have several reports in a networked system. When I run the reports on some PCs the numbers do not show in the reports. All other characters do. If it is a telephone number like +33(0)20 423 4444 this shows on soime PCs as +33(0)20 423 4444 but on a few as + ( ) and I have no clue...
  18. B

    Lookup Table getting Corrupted

    Lookup problem Not quite sure what Normalisation issues are represented here. The lookup table is a lookup table and nothing else. A previous deisgner decided to save the actual name to a record in a table to speed up loading certain very complex Forms & Reports and I concurred with this. The...
  19. B

    Adding common dialog box to form

    The search and why? Hi, The previous will give you how to Brwose and store a file, but why do you want to do this inside the appliucation. Surely the App and backend Db are linked and you should only do this once, and then refresh it. In practise you would nevver search for a back end as if you...
  20. B

    ListBox Focus

    In the OnOpen Event
Back
Top Bottom