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.
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...
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...
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.
I have a form which derives its content from two tables
using a join query. I want to include name & address info
from a third table (user) which has only one record. I want
to be able to overwrite/change this info on the form if
appropriate to the situation.
Question: How do I retrieve this...
Hi to all.
I have an application in which the user selects an 'index' record from a table in order to gather information from just one of several 'data' tables (depending on the information required) and then print a report.
The user wants to print his details along with each report, almost like...
I have designed a report to print a form on a template background. In layout view the report looks good but the spacing changes when I print to a .pdf! Dos anyone have any ideas for getting it to print correctly?
I use the following 'ParseString' function in a report application, which works well - until I create a .accde file from my .accdb database. When I ry to run any report that uses 'ParseString' from within the .accde file I get an error: "Undefined function 'ParseString' in expression. (Error...
I have a number of forms containing templates for the desired positioning of data fields. The templates have a block-type display for each field (each character in it's own block) and in order for the data fields to line up with the templates I am required to use monospaced fonts.
I am finding...
I have a 'delete' (maco) button on a form to delete the current record and then do the same in other tables. It works just fine but I want to add a warning message to it with the option to cancel deletion. Will appreciate some guidance here :confused: Thanks
If I distribute an application/database and then wish to give my clients updated versions over a period of time, how does he implement such updates while also retaining his accumulated data?
I want to perform certain actions only if a user has changed the record displayed on the form. How do I query Access to determine whether the record has indeed changed (without adding an 'after update' action to each field dislayed!).
I would also like to offer the user the opporunity to discard...
I have an application with numerous forms which require the same button controls (ie. next; previous; first; last; new; delete). I don't want to design the same set of buttons for each form. How do I go about designing/implementing a 'template' or 'frame' in which each form can be displayed and...
:D When browsing through posts the descriptive text window would be far more useful if it stayed open - at least long enough for one to read it thoughtfully! Would really appreciate as it would avoid having to open the post just to see if it's what one is looking for. Thanx
I have a form macro which has been working perfectly, until now. All it does is concatenate two fields into one using the 'setvalue' command. The ole server-type error is shown here. Any suggestions? System configuration?
I reverted to a few backups previous to this and I get no error but I...