Recent content by mr_fish

Hi all, A switchboard at the front of my application has VBA code that opens a form and lets the user pick browse to a graphics file that should embed and appear on the switchboard menu. It all works o.k and the picture appears while the user has the database open. When you close and open the...

Hi all, I've got a little problem when users move through records on a form that has an image embedded the source of which changes for each record linked using a filename field and path in the database. The pictures are served across the network from another computer. Some of them are...

Linking just one External Table to many databases I have created an Access database application that is stand alone for each account manager/client at our business except for one table that I want shared as a source of data across all separate databases that are created. I've investigated...

It was the date format, and a few annoying brackets, the code below worked. On Error GoTo Error1 Dim strSQL As String Dim objWord As Word.DOCUMENT Dim Date1 As String Dim Date2 As String Date1 = DTPicker0 Date2 = DTPicker1 Date1 = Format(Date1, "m/d/yyyy") Date2 = Format(Date2...

Hi all, I've got a form that lets a user select a date range between two dates and runs an automatic mail merge in Word. For some reason no matter which date range is chosen, it always selects all records in the query and not the range the user selects. Not sure why the problem occurs, may be...

Field code syntax is really annoying, after a bit of trial and error all that was missing was quotation marks around the nested fieldname. Code below {IF {MERGEFIELD Page_Number} <> 1 "" {MERGEFIELD "tbl_Coverage_Coverage_Date" \@ "MMMM YYYY" }"}

Hi all, I'm trying to nest a date formatted MERGEFIELD with a switch within an IF THEN ELSE word field code. The quotation marks are causing the IF field to think the data ends just after the \@ and doesn't complete the merge. Does anyone know how to get round this? Code below, any help...

Solved half the problem by creating a page number field in Access. Then in word I used an IF fieldcode in the template itself to compare whether the page number was <>1 and changed the headings based on that. {MERGEFIELD "tbl_Media_CompanyName"}{IF {MERGEFIELD Page_Number } <>1 " - continued"...

Hello all, I've been looking into Mail Merges from Access through VBA and after much messing got a basic mail merge working, but I want to be able to do a bit more with it, the only problem is I'm not sure if a mail merge can do what I want or whether I should be looking in another direction...

Looks like another access quirk, if the month/year the user enters is in the same year as the system time the user can enter the date in MMM YY format and it works, otherwise the user has to enter MMM YYYY format for other years.

hi all, I've got a form with a text box you can enter a date in mmm yy format, it works o.k if you enter any 06 date (e.g jun 06) but when you enter any other year 07 08 etc. it defaults back to 06 everytime. Not sure why this is happening. The underlying table has mmm yy as format type as well...

Hi all, I've a form with an image on each page which is linked (not embedded) to filenames from another table. When moving through the forms the time it takes to import the picture is relatively slow, is there any method or hack I could use to speed this up? The code I'm using at the moment...

Thanks guys, didn't realise all variable data types in an equation had to be able to handle the size of the result.

Hi everybody, Getting an overflow error that i just can't fathom. Basically the code takes a string field tbl_Media_Page_Size (e.g. 297 x 210) and strips the left and right numbers into num1 and num2 then tries to multiply them. It always overflows whether I'm using integer, long, single or...

Thanks Col, you saw through my confusing question and adding multiple Is Null criteria has worked in ridding the query of the Not Null entries. Is that a bug? Oh how can it be, Microsoft..........bug those words can't possibly go together ;)