Search results

re: Hi, run: DoCmd.RunCommand acCmdFitToWindow After your OpenReport method. The other options you have are: acCmdZoom10 acCmdZoom100 acCmdZoom150 acCmdZoom200 acCmdZoom25 acCmdZoom50 acCmdZoom75 acCmdSizeToFit HTH Good luck

re: You're welcome. Good luck.

re: It is actually possible for this option to cause problems. The process of compacting a database is fairly involved. Access creates a new blank database...imports everything into it from the old one...deletes the old one and renames the new one to the name of the old one. While doing all...

re: You're welcome. Good luck on future projects!

re: Depends what you are doing in code...it is hard to see from here. Normally you would just link to the backend tables and keep the frontend (forms/reports/modules/queries...) within Access. HTH Good luck

re: Hi, Only if the default 2000 file format was used when the 2002 file was created. If it wasn't you can of course always back-convert it to the 2000 format under tools--database utilities--Convert Database...! HTH Good luck

re: It is 2GB minus the space needed for db system objects in Access 2002 and higher. Most likely the db will become unusable if it gets too close to that limit. Corruption could creep in as well. HTH Good luck

re: So how much are we talking about? As long as the db doesn't reach 2GB it should be fine. If it gets to close to that then you can try to implement workarounds by splitting your data into several backends and linking them together with one frontend. However, at some point it might just be...

re: Hi, unfortunately another limitation of the sendobject method is that it can only send plain text emails. So you can't send formatted emails in the manner you want. If you do want to achieve that then you need to use automation code to create an html message. A good sample of that can be...

Are you just trying to open the file or automate it after opening as well? If just opening you can make life a lot easier using the followhyperlink or shell method e.g.: Application.FollowHyperlink "C:\Documents and Settings\Planner.xls" HTH Good luck

re: Hi, you could just make a screen shot (print screen key)...then open a graphic program or MS Word and paste the image onto a new document...then print it from within that. You could also check out the build in documenter to see if it does what you want. HTH Good luck

re: Hi, have you tried compact & repair (tools--database utilities). It is normal for a db to increase in size if it is holding more and more data...so is it increasing too much for no reason? What sort of data are you storing? You should not embed graphics or files within access itself. Is...

re: Hi, check the attachment...I threw something quick together for you. Furthermore, keep in mind that Date...Time...Name...are Access reserved words and should NOT be used as control/field/object...names. Try to adapt some naming convension. Also remember that the Sendobject method is very...

re: Hi, you might find this article helpful. HTH Good luck

re: Hi, use the DateAdd() function in the criteria of your date/time field e.g.: BETWEEN DateAdd("m",-4,Date()) AND Date() If you just want to query on the month and the year then create two new expressions...one: JustMonth: Month([YourDateField]) Criteria: BETWEEN...

re: Hi, you can't...there are several workarounds like using images or wingdings characters instead of the checkbox. Some of these are described in this thread! HTH Good luck

re: Hi, check this discussion! HTH Good luck

re: You're welcome. Good luck on future projects!

re: Yes...exactly...you could of course do the same on a form or report directly if the components are part of objects record source (use an unbound control to display the result)...but if you do it in a query you can access/display the result several times without repeating the steps over and...

re: Hi, You shouldn't...calculated values can be calculated at runtime in queries or on forms/reports. Storing the result of the calculation has the possibility of ending up with redundant data which breaks normalization rules. You can store the components which make up the calculation, but...