Search results for query: *

Thanks cmmrfds, The cross post was not intended to confuse - I didn't realise there was a dedicated .adp forum until I commenced it in Access Other Topics. Sorry for the protocol breach. I have discovered that you must load/ensure that all the machines using the 'client' (Access adp ) have...

Thanks all, I have discovered that you must load/ensure that all the machines using the 'client' (Access adp ) have Microsoft Office Service Release 1/1a applied (for Access 2000). Older releases of Access were released before SQL Server 2000 and hence incompatible. Microsoft mention that even...

Thanks in anticipation... I have an .adp where I connect to an MSDE sql backend. A number of networked PC's connect to this MSDE datasource. All PC's can see and connect to the sql service. However, when I open the .adp, a number of the computers rename all the stored procedures (Office 2000)...

Thanks Greg, The problem exists whether it is one user or many - it appears to be specifically related to the users computer - one PC in an office will see the correct Stored procedures and work correctly, while another in the same office renames them to StoredProc;1 In our development...

Thanks in anticipation... I have an .adp where I connect to an MSDE sql backend. A number of networked PC's connect to this MSDE datasource. All PC's can see and connect to the sql server. However, when I open the .adp, a number of the computers rename all the stored procedures (Office 2000)...

You can add the NZ function to all the individual calculated elements of the main summing equation. The NZ function - Null to Zero - takes two arguments, the actual value you are trying to calculate, and the second (I assume you want to use a zero) as the second argument if the NZ value sees a...

Thanks Dawn, Will hunt that down and thank-you once again Thom

I am using Access 2000 and when printing reports, the page setup changes of it's own accord. Not just reverting to Imperial measurements, but a 'new' page dimension - especially when the report contains columns. I have been told this is a known Access bug but have not been able to track it down...

Additionally, the Error message when I attempt to open the Addin Manager, SwitchBoard Manager or any Wizard driven/generated object from the Forms Toolbox is "ActiveX can't create object". It sounds like a missing or corrupt library - which is what the 'Help' file indicates. The same...

Me. references the current object. i.e. you can get a form to refresh it self as a consequence of an event on the form e.g. when an object (textbox) is updated. Hope this is of use, Regards... Thom

I have delivered a custom db to three Access 97 PC's. Two work fine but the third won't run the Switchboard Manager nor any wizard buttons on forms not the Add In Manager. The object libraries for all three machines are indentically checked. I have reloaded Access 97 to no avail. Much thanks, Tom

Thank you Maverick and Terry. I have succeeded with the import Terry and have passed the info on to Maverick. Thank you ...

I am importing a straight Excel spreadsheet. It contains 35,000 rows but when imported into Access 97 only 16383 records are imported. Much thanks... Thom

I have created a few reports - mailing labels and catalogues. Half the time when I re-open them they revert to the default report page settings and I have to set it up all over again.

Doug,<br>I now have inserted a '#' before the drive letter ... Me!Image14.Picture = &quot;#p:\ViewPhotos\Photos\&quot; & Me![YourTextBox] & &quot;.tif&quot; and it now points to the actual address.<br>The correct syntax is 'displaytext#address#subaddress'.<br>All is well now.&nbsp;&nbsp;Thanks

Thanks Doug,<br>I've introduced the code as per your reply. Everything appears to work ie it looks like a standard hyperlink but upon clicking on the field, it does not follow the path. Upon further investigation the path you see 'underlined in blue' is in fact the 'Display Text' element of the...

Hello everyone,<br>I recently posted a request for inserting hyperlinks but realise now that the brief may have been a little too lateral. I actually need the VBA code. I already have thousands of scanned documents in a directory all with the names of their bar-code identifiers eg 123.tif...

Good morning,<br>I am scanning a volume of documents and saving them as the bar-code number on the face of each page i.e. '123.tif'.<br>Via a form in Access, I then need to enter this barcode number into a textbox and locate that 'tif' file and insert it as a hyperlink to the current...