Search results

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 ;)

Hello all, A bit of a weird one, I've got a query and the criteria for showing records is that one particular field is null. However the query is showing records with the values in the field chosen for the Is Null. Not sure why this is happening, has anyone come across this problem before...

OK my research has led me to thinking I should use a multiselect list box to put all the file names in so the user can select the ones they want to associate. Could I use a form with the primary magazine records and a subform within it with the multiselect listbox. The records could then be...

Hi all, I've got a problem that I'm not sure how to go about solving, I've got a table that is full of jpeg filenames and paths that is created when a user selects to import them from a directory they specify. These jpegs are scans from various magazines that may include one to 50 pages all...

Solved! Found out that I can set up a Long variable (iPos in this case) and pass the character number at which the space occurs to it using InStr function. iPos = InStr(1, stMediaCode, " ") stMediaCode = Left(stMediaCode, iPos)

Thanks Peter that works a treat. Been looking into trimming down the text so only the relevant bits get put into the database. I've been able to use the trim, mid and left/right functions to chop out the crap before and after the fields so instead of this Name U78E-8 Computer Weekly...