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 Rhinorhino 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: *

  • Users: KenReay
  • Content: Threads
  • Order by date
  1. KenReay

    Word 2003 Labels

    I need to set up (same) custom label format for several users. I have no problem with setting up the label format in word. But where does word store this data, and can I set it so that I can "centralise" the settings so I do not have to repeat the operation on each users PC? Regards Ken Reay...
  2. KenReay

    Access2003 ADo with Jet and SQL Server

    Hi I am attempting to write an application (front end) which will be able to use either a Jet (mdb) or SQL Server Backend. My approach thus far has been to use forms and set the recordset "on the fly", using code like so: Set Rs = New ADODB.Recordset 'Rs.CursorLocation = adUseClient...
  3. KenReay

    Excel 2000 - Combo Box - AddItem

    Hi Is it possible to have a multi column combo box, eg Code, Description in the way you can in Access ? If yes, how do you use the .AddItem method to populate the combo with values ? Thanks Regards Ken Reay Freelance Solutions Developer Boldon Information Systems Ltd Website needs...
  4. KenReay

    PCL File to ASCII text file

    Hi I have encountered a legacy application at my current client site which does not seem able to output data in text format. It is possible to ouput reports to a file, but what you get is (I think) a Hewlett Packard PCL format file, complete with printer control commands etc etc. Given how...
    • KenReay
    • Thread
    • Replies: 2
    • Forum: PCL
  5. KenReay

    Excel 2000 Linked Spreadsheets

    Hi I have inherited a spreadsheet which produces a weekly analysis from a series of daily spreadsheets. The daily spreadsheets are one (.xls) file per day. The file name and folder location changes each day. Sometimes there is no file for a given day (eg Saturday and or Sunday are often...
  6. KenReay

    Access2003/Word2003 Mail Merge

    I am attmpting to automate Word Mail merge from Access, using code like set wobj = GetObject(,"Word.Application") set oDoc = GetObject(strLetterName,"Word.Document") With oDoc .MailMerge.OpenDataSource Name:=Db.Name, LinkToSource:=True, Connection:="QUERY...
  7. KenReay

    Optimistic Locking - Bound Form - Access 2000

    Hi I am using Optimistic Locking (.RecordLocks = None), with a bound form. Does anyone know if it is possible to trap the standard Access message given when two users change same record (ie the message giving three choices Save and overwrite other users changes, discard changes, save to...
  8. KenReay

    "Description Property" Access 2000

    Hi I once knew how to do this, but cannot remember, anyone out there jog my memory? How can I make the .description property of Table, Query, Forms, Reports visible in the database window? Thanks Regards Ken Reay Freelance Solutions Developer Boldon Information Systems Ltd Website needs...
  9. KenReay

    Behaviour Entering a field - Access2000

    Hi tried this in the Forms Forum and got not response so trying my luck here It is possible to modify the behaviour when you enter a field by using the Tools \ Options, keyboard tab, then the options under Behaviour Entering a field does anyone know how to achieve this in code?, I have...
  10. KenReay

    Behaviour Entering Field Access 2000

    Hi It is possible to modify the behaviour when you enter a fiedl by using the Tools \ Options, keyboard tab, then the options uder Bahaviour Entering a field does anyone know how to achive this in code?, I have searched databse properties but cannot find a likely candidate thanks in advance...
  11. KenReay

    Access2000 Limiting Users in a Form

    Hi I have request from a user, which I am unsure how to service I have a form which allows users to create/amend/deleet rows in a table. Client want this to be restricted so that only one user may update at any given time, any further users get readonly access to the form Anyone any bright...
  12. KenReay

    Office (Word) 2003

    Hi Do anyone know if it is possible to amend the dialog which result from file new in Word2003? I have a client who has just upgraded from Office97 to Office2003. They use a set of templates specific to themselves. In Office97 it was simple to restrict the Template dialog to show only thier...
  13. KenReay

    Access 97 - WindowsXP - FAX

    Hi When using the Fax feature of WindowsXP from Access/VBa does anyone know if it is possible / how to: Suppress the (Fax) wizard Pass the Fax Number etc from the Access Application to the Fax service so that user is not prompted for it Thanks in advance Regards Ken Reay Freelance...
  14. KenReay

    PDF Writer and Access (97)

    I have a need to EMail documents as PDF file attachments from within Access 97. The Application will soon be upgrdared to Access2002 (or possibly Access 2003), so any solution needs to work with both versions with minimal changes between versions. Anyone out there done this? Have any...
  15. KenReay

    Outlook -Custome Email format

    Hi I would like to customise outgoing EMail messages to use 'corporate' style ie have my company name, my company logo etc Anyone give me a pointer where to start looking in Outlook to do this? Will I have to use 'full' Outlook rather than Outlook Express? Thanks Regards Ken Reay Freelance...
  16. KenReay

    Excel automation from Access (2000)

    Hi I have an application which automates Excel from within Access, (via VBA) basically it it creates and saves some spreadsheets. When I initially create the spread sheet and save it (with oWs.SaveAs ..etc) all is OK, but if I need to re-create an existing spreadsheet and save it with .SaveAs...
  17. KenReay

    Excel VBA Excel 2000

    Hi I am trying to save a workbook in VBA oWs.SaveAs etc does the job if the file does not already exist, but how do I save it when the file does exist without receiving a warning message?, I would have thought it was simple as oWs.Save, but this gives a compile error saying method not...
  18. KenReay

    Recommended reading - New User

    Hi I am experienced Access/VBA programmer, making the switch to using SQL Server2000. I will be using it from VBA and/or Visual Basic. Can anyone recommend good book(s) I should read, looking to learn TSQL, Stored Procedures, how to defines database contraints, referential integrity etc...
  19. KenReay

    Access XP with Access2K and Access97

    Hi I have several Clients who I must support, now running various versions of Access (ie 97, 2000 and XP) On my (Windows 2K Professional) PC I currently have Access97 and Access2000, co existing without a problem, now I need to put AccessXP on, anyone have any experience/tips on sharing all...
  20. KenReay

    Match Similar Strings - Fuzzy match?

    Hi a general query does anyone have any experience of matching (for example similar names and addresses), so that (say) 1 King Street and 1 King St are recognised as the same thing, or even close misspellings, say Whitchurch and WhiteChurch, and recongnised as probably being the same. Any...

Part and Inventory Search

Back
Top