Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...