Search results

  1. M

    Variable screen size?

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

    VBA-Tools-References ?

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

    Access2007 VBA code in Access2010

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

    Landscape Printing?

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

    This recordset is not updateable

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

    Maximum number of fields in report?

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

    How do I tell what filename I'm working on?

    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. :(
  8. M

    Compile error when creating accde from accdb

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

    Using data from a table not currently open or joined

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

    Simple Query? or basic structure?

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

    Report not printing correctly?

    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?
  12. M

    .accde picks up function error

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

    Monospaced fonts on template

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

    Simple Yes/No Message Box

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

    Updates for distributed applications

    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?
  16. M

    Force user to select drop-down item

    How do I force a user to make a selection from a drop-down list? (or at least make it glaringly obvious that this is required)
  17. M

    Check if record has changed..

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

    Displaying forms with common 'frame'

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

    'Hover' text should stay open

    :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
  20. M

    Form macro returning 'ole server' error

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