Help

Access Report to multiple PDF files
Hello- I need to create multiple PDF files from one access report that breaks on client for approx. 20 clients. Any suggestions? Thanks! ... 7 Jan 2006 05:34

Problem with Query data in report
I have a database I am building that is for a police department. On the report I need it to display the following information: Date of Incident, Offense discription, Narrative, Offender/s, victim/s, etc. The problem I am having is that when I run my report, if I have more than one offender listed and no victim, it... 4 Jan 2006 17:43

rendered date
Is there some sort of formula that anyone knows of that it if provied it was a date it will tell me was the date was a number of days before it. Ex.. Say i put in a 12/29/2005 as a starting point and I want to know what the date was 90 days ago.... ... 30 Dec 2005 20:20

Run Update Query silently in background
I have a MS access 200 DB in which I have an update query which repalces all the " " with ''" in a field. I would like the update query to run in the background, and not ask the user for any perrmissions. I was thinking to run the query as part of the autoexec macro. can anyone recommend a way that I can have the... 30 Dec 2005 08:24

Bang vs. Dot - final answer
I once did all my control references with the bang (!) operator. All my controls were referenced as Me!txtInput, etc. I have now discovered that doing this loses much more than Intellisense. 1. Compile does not pick up missing controls, i.e., if I have a reference to Me!btnEdit, and remove that button from m... 3 Oct 2005 16:14

Run-time error 2465
TIA! (sory--originally posted in MS Access forms group, but no responses...) Error txt: DB can't find the field 'field1' referred to in your expression. (A2k running on winxp and win2000)The field does exist, is not calculated in any way, will compile and once compiled, the error never again rears its ugly ... 29 Sep 2005 12:11

Adding Excel Object Library Reference Programmatically
Hello, I'd like to programmatically reference the Excel Object Library from an Access form using VB. I am using this code: Application.VBE.vbprojects("VBAProject").References.AddFromFile "(file location)" ....but get a 'subscript out of range' message. Can anyone help? Thanks ... 22 Sep 2005 17:59

error message 3343
I have copied my database onto a DVd and brought it home to work on but when I tried to open it from the DVD (datadisk),I got the below error message. What am I doing wrong ? Unrecognized database format <filename>. (Error 3343) Graham H ... 12 Oct 2005 16:04

rolling average
Who can help me, I have a table which contain an artikels and a prices. What i want is to the following 1) The average price from the last 7 records. 2) The average from the last 14 records 3) Divide the 7 day average with the 14 day average. Who can help me. Thanks in advanced ... 18 Sep 2005 19:57

Linking Images using VBA code
Hi, All the records in my database will contain at least one picture. At the moment all the images are part of the database as ole objects although the database is way to big and there is only 12 records in it. I have been reading about linking images into the database and i would like to use the method linkin... 20 Sep 2005 23:09