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...

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...

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...

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...

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...

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...

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...

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...

Hi all, Done a bit of research on this already, but not sure if I'm heading in the right direction. I regularly get a text file that is exported from another system that comes out in rows with records repeating one after the other. The way the other system exports data can't be altered so I've...

Hello all, I'm in the middle of a college project to design a database for a company while at the same time learning access. I've got a slight design problem which I'm not sure how to overcome. The database is attached as a zip file as this seemed to shave 500k of the size of it, any criticisms...

I have some code attached to a command button (shown below) that is supposed to check a form to see whether a number of fields are filled in before executing code to link a child field and open a the child table. For some reason it only ever completes the first if for journalists field...

I've split a table in which a number of fields weren't always relevant to enter on every occasion and linked them in a one to one relationship, the idea is to increase efficiency and help reporting. Both have the same name primary key linked with referential integrity and cascade update related...