Recent content by BobStubbs

I can't see a way to report directly on calls routing via an Auto Attendant in ShoreWare v11.2 - i.e. to see how many callers choose option 1, 2, 3 etc. from the Auto Attendant menu. This is my work-around - posted in the hope that someone has a more elegant solution. -- Assume my...

Could you use a bookmark? If you created a bookmark called e.g. StartHere in the document, you could then use this line of VBA code to go to it: Selection.GoTo What:=wdGoToBookmark, Name:="StartHere" You would need to use this code when the last popup box closes. I hope that this helps...

You may find this idea of use ... I created a table containing two fields: AutoTextID - text field, 2 chars, primary key AutoText - text field, 50 chars I wrote some test records into this table, e.g. A1 - This is test paragraph A1 B2 - This is test paragraph B2 Assume I have a text field in...

You can also do this with the WEEKDAY function. This returns a digit between 1 (Monday) and 7 (Sunday) if Windows dates are set up in the standard way. Try: =OR(WEEKDAY(A1)=6,WEEKDAY(A1)=7) If you want Saturday and Sunday to be different colours, set two conditional formats on the cell...

Can you place the database back end on a (hopefully fast!) network server? It seems to me that in your current setup, requests from other users' PCs are restricted by the speed of your PC's network connection - if this is busy with other tasks then they will see problems. I would think that in...

Hi - the command file won't delete the "personalised" copy of the database until the user closes both the database and their MS Access application window. When an application is run from a command file, command file execution pauses at the line that runs the application, until this closes. By...

You can use a command file to create and delete the personalised front end databases. Here's an example: @ECHO OFF TITLE=Create copy of Database and run it for %USERNAME% REM ------------------------------------------------- REM - If an old copy exists, delete it - REM...

You might find it useful to make this a two-step process. Create a table in your database that will hold the results of importing one log file - with no field validation etc. Structure your process so that you: -- Delete all records in the temp table -- Import one log file to the temp table...

How do users start the database? Do they have a shortcut to click somewhere, or click on the front end file directly? Also, how many current users do you have? I can think of a solution that I used once, involving multiple copies of the front end on the server, but while this is fine for up...

Have you thought about adding a Label to your form, and diplaying a "xxx Records Processed" message? Assume you add a Label control called lblMessage. The extra bits of code you would need are: Dim lnCounter as long (The start of your loop) lnCounter = lnCounter + 1 if lnCounter...

Does your 42nd or 43rd field contain an invalid character, such as the line end characters ASCII 10 and 13? This might cause the problem. I have just tested an import ... -- In Excel 2000, I created a test worksheet, 3 rows x 130 columns, populated with test integer numeric data -- Saved this...

First, check that the Excel viewer is the latest version, and works correctly if you start it manually (the file is xlview.exe and will be in a folder such as C:\Program Files\Microsoft Office\OFFICE11). Then try this process, which works for me with Excel 2000 running on Windows XP ... what...

This might be due to one or more of the characters stored in a hyperlink. Do you have a couple of examples of these hyperlinks that you can post? I'm thinking of the way in which spaces and backslashes can mess up file paths and URLs etc ... Bob Stubbs (London, UK)

If this just happens to one user, could it be that the standard Arial font is missing / damaged on his workstation? To check this, try getting the user to do the job on another workstation, while another user tries the workstation with the problem. If the fault 'stays put' on one workstation...

I would try: -- Exporting the records from the table in CSV format -- Deleting the existing table -- Re-creating it as a new, empty table -- Performing compact and repair on the database at this point, to see if the size returnsd to normal If the size is now OK ... -- Check the exported...