Search results for query: *

sorry for late reply but been away for while!! You could use the VB sendKeys command on somethng like gotfocus for the field of the form. In this way when the field gets focus from mouse click or tab the vb command will run forcing caps lock on. You will have to force caps off by sending same...

You can use the transfer spreadsheet macro and specify the worksheet as part of the range function, see below, taken from access help. "The range of cells to import or link. Leave this argument blank to import or link the entire spreadsheet. You can type the name of a range in the...

I have just attempted to recreate your problem and can't. All I can suggest is that you remove the field from the form, ensure the format is correct in the table, i.e. memo selected with format > and then reinsert field in form. Worked for me, let me know what happens?? Alan

Also as long as you have formatted your dates correctly you can do a straight forward subtraction in any field. i.e. DateDiff = ([enddate]-[startdate])*24 where 24 is number of hoursin day. This of course won't work for short/long day

OK guys either the answer is so simple no one can be bothered telling me or no one has yet to attempt it, which I don't beleive. I am attemping to print a number of web pages from a command button on a access form, however I am having no joy. My code expertise is basic ( i grew up on...

In tools - Startup, you will find a host of options allowing you to specify how your db opens. autoexec is autoexecute, namely a macro that when called runs a specific command statement Initially paste code to new module set up new macro with runcode where parameters specify which piece of...

Surely someone has tried this before, I will have no hair left at this rate. Only other option I can think of is sending the command that would run print shortcut icon in menu-bar, but I have no idea how that could be done!! Cheers Alan

Surely someone has tried this before, I will have no hair left at this rate. Only other option I can think of is sending the command that would run print shortcut icon in menu-bar, but I have no idea how that could be done!! Cheers Alan

Surely someone has tried this before, I will have no hair left at this rate. Only other option I can think of is sending the command that would run print shortcut icon in menu-bar, but I have no idea how that could be done!! Cheers Alan

aqif Not sure if you solved your prob, but came up with this bad boy of a batch file which works a treat for me. see what you think. Run batch file from scheduler and don't forget to alter paths, etc @echo off rem Batch file to backup Live GTS FEP Database suite rem File in Source directory...

Further to this I have tried Sub ShellPrint() Dim strPath As String Dim strShellStatment As String Dim dRetVal As Double ' Get the path to Internetexplorer.exe. strPath = "C:\Program Files\Internet Explorer" 'build the first Shell function...

Further to this have now tried Sub ShellPrint() Dim strPath As String Dim strShellStatment As String Dim dRetVal As Double ' Get the path to Internetexplorer.exe. strPath = "C:\Program Files\Internet Explorer" 'build the first Shell function...

On top of this I have tried Sub ShellPrint() Dim strPath As String Dim strShellStatment As String Dim dRetVal As Double ' Get the path to Internetexplorer.exe. strPath = "C:\Program Files\Internet Explorer" 'build the first Shell function...

Record data type, max reqd size, etc. Two things come to mind 1- String of characters you are entering is greater than 255 (MS predefined max length) This can be altered in the properties. Or greater than a length you may have changed it too. I got caught out here before as when setting...

Aqif Also please see this earlier thread thread 705-182150

Hi Had an error of this description before, but would need more info about yours before being able to offer correct advice. Alan

Hi Select new query select design mode From menu-bar selct query and then select make table query, you can also use queries to update or append records to a table. Alan

Further to this I have attempted using send keys and follow hyperlink. The follow hyperlink works and I can send ctrl+ p to bring up print dialogue box, but sending enter actions on the web page itself not the dialogue box. think this might work if I could set focus to print dialogue but...

Further to this I have attempted using send keys and follow hyperlink. The follow hyperlink works and I can send ctrl+ p to bring up print dialogue box, but sending enter actions on the web page itself not the dialogue box. think this might work if I could set focus to print dialogue but...

Hi Easiest way to do this is to set it up under the standard windows scheduler cheers Alan