Recent content by BWP

Hi Devo - i'm looking for something similar - actually something exact....did you ever get a solution to this? At present i have some users who experience the "click here to relink tables" message where it should be saying "Online with SharePoint". This causing mass confusion and is not great...

This is about "any bad/illegal" characters (i'm not sure what these are). In context - the reason for asking - is during import from legacy system (memo data type field (more like long text field)) - there was some kind of symbol in the text looked like a diagonal arrow pointing top right up...

Hi All Is there a way to go through an entire table and look through a field (either using VBA or query) to simply say something like: "If [FieldName] has bad characters, "Yes","") Then once established these are "bad rows of data" - a separate query to update/replace/remove those records...

I don''t have a printer setup on my local pc and i can print to .pdf - so i am not quite sure that's correct Mark. Would you know how i can "reference" the .pdf printer? If Application.Printer=false then Set Application.Printer(.pdf) End If ?

Hi - thanks... I think that will deal with first part question, but how do i then set the default printer to .pdf? Dim prtDefault As Printer Set Application.Printer = Application.Printers(0) Set prtDefault = Application.Printer With prtDefault MsgBox "Device name: " &; .DeviceName &...

Hi All Currently users can only access the "print" facility using shortcut menu (i've created on right-click) - oh and I guess using Ctrl+P. How /where do i call the function from to check whether default printer exists? Does Access check for default printer when using clicks to view report in...

This also shows no difference to the speed... --maybe it will when other users are online...will have to check tomorrow...

So i tried this and honestly - very little change. I can hardly notice the difference. Both occurrences took roughly 5 seconds to update (so i'm guessing this has to do with the server/architecture setup of the SP or something)...

OK - so that I understand this correctly: StaffID: 1 [Name]:"John Doe" and [DOB]: "08/08/1945" = old values. [Name]:"John Doney" and [DOB]: "08/09/1945" = new values. in my current setup - before update event will write old value and new value in two new records in auditTable. ---update...

Minty - i really like that idea... Wouldn't the time it takes to update from local to SharePoint (when form closes) still take the same time?

Thanks - so let's assume the way i have it now is what the requirements are - i.e. every change to any field (not every single field, but around 8/10 fields (the form has roughly 15-20 controls). I've gone through the code step-by-step and the only place it "lags" is when it gets to .Update...

ok thanks - appreciate it... Any idea on other question getting it changed from ADO to DAO?

Thanks - but how do i change what i have to use DAO instead? Also - re: cache format - can you let me know more about that?

No reason - is ADO better/faster and if so - how do i change it? -> and can you expand on the "use cache format"? - is this under backstage/options/current database?

So what kind of work would be required to change that from what it is now to an append SQL query? Do I just get rid of all the recordset stuff? And any idea what this is doing: rst.Open "SELECT * FROM tblAuditTrail", cnn, adOpenDynamic, adLockOptimistic And I absolutely agree that SP is not...