Recent content by Mist

I am really interested in this code as well. You've got lots of takers M Hicks! Pls let me know the FTP site as well. Many thanks :)

Is there a means of making an application grow/shrink to accomodate different screen sizes? eg. not all users of a distributed application will necessarily have the same screen size. Any coments appreciated. Thanks.

Thanks for your comments CJ. The OS in question is Windows7 Prof, 32-bit (app. developed on Xp SP3, Access 2007 PC) and I'm sure therefore that my Win7 Access is 32-bit version. I scrolled down in 2010 and there's definitely no 'msinfo32... Type Library' but right now my app is working...

I have a working application running under Access 2007. The list of available references is shown on the left of the attached image. The image onthe right shows the available references running under 2010. Two references are 'missing'. Where can I locate these missing references or how can I...

I have developed an application with MS-Access 2007 and it works perfectly. When I try to run it under MS-Access 2010 I get 'compile errors' and 'missing library' errors. The attachments should illustrate my problem. I will sincerely appreciate any input from someonewith experience here. Many...

Here's the thing CJ! DoCmd.OutputTo acOutputReport, "ReportName", acFormatPDF, "C:\reportname.pdf", False - works, thanks, but I still have the same problem: the report output (both pdf and printer) is cut off on the bottom and right with the 'cut off' sections printing on subsequent pages...

Thanks CJ - Will do (not on my PC now) ..like the pdf option too

...Oops sorry! I said 'form' when iactually meant 'report'! I have edited out my mistake..:rolleyes:

I have a landscape oriented report which is A4 size. When I select Landscape in print preview the result is cut off on the right. :confused: In the form's design mode I get a little green triangle on the top-left which tells me that the form is wider than the page size. Is this because I am...

Thanks again Bob - I changed the PK to the join field and it works perfectly! Thanks also for the link, I will checkit out.

Thanks Bob, In in the gray area where the tables are located I selected PROPERTIES and then under Recordset I selected DYNASET (INCONSISTENT UPDATES). Still the same problem. The tables have a 1-1 relationship and the query returns the correct data. I did notice that the PK in both tables is NOT...

The following query is used as the record source for a form. Why is it not possible to edit the data on the form? If I try to update certain fields using VBA it returns "this recordset is not updateable" :confused: What am I doing wrong? Thanx for any assistance. SELECT IT77C.RefID...

:confused: I have a forms printing application which is designed to print several different types of form from a 'common' table (containing data common to all forms eg. Name & Address) joined to an 'application' table (containing data NOT common to all forms eg. fevourite colour). => I am using...

Hopefully a simple question. When I work on a database I copy it and change the name (sort-of backup copy) Sometimes I forget which one is loaded. How do I confirm without closing the app? Thanx for any reply. :(

I get this compile error when creating accde from accdb:banghead:Does anyone know what I can do? Application has only one module and about 7 tables. Many thanks.