Search results

  1. C

    Subform only shows first match

    It's been a while since I last used Access but now I need to be reminded how to populate a sub-form with all rows for a query (Access 2013). Can someone please let me know: - Do I need to establish a relationship between Table A (main form) and Table B (sub-form)? - What sub-form properties need...
  2. C

    Combobox update problem

    Hi I have a table: tblDocument, that includes a field statusCode, which is validated through a decode table: tblCodeDecode. tblCodeDecode has a 2-part primary key: categoryCode + subCode, as well as non-key fields: activeInd and description, as follows: STA | INC | True | In Progress STA |...
  3. C

    Combobox not displaying initial value

    Hi Hopefully, this is a basic problem that an experienced Access programmer has come across. I have a technical background, but haven't used Access for a while. Sorry this is a tad long, but I've tried to provide as much detail as possible. I have a simple "new record" form that includes two...
  4. C

    Setting a Global Variable

    Hi I need to create a global variable (user access level) in my Access 2007 application, that can be accessed throughout the application. I believe this involves putting together a Standard Module and defining the variable within a Sub procedure? Code for my module follows...
  5. C

    Before/After Values Test

    Hopefully a simple one: I'm trying to put together a simple before/after check on a continuous form's (frmActor) bound control (actorName), and then posting any changes to an audit table (tblModHistory). When I make a change and hit either <TAB> or <ENTER>, the control values Me.actorName and...
  6. C

    Problem retrieving counts

    I'm writing a simple report that needs to show individuals and the number of times that each individual has been designated the author and/or owner of a document. The two tables in the query (simplified) are: Person, with columns personID (PK) and personName; Document with columns docID (PK)...
  7. C

    SELECT for retrieving counts

    Need some help, please. I'm writing a simple report that needs to show individuals and the number of times that each individual has been designated the author and/or owner of a document. The two tables in the query (simplified) are: Person, with columns personID (PK) and personName; Document...
  8. C

    Access/Word interface

    My enquiry form allows users to view a Word document via a button-based hyperlink. This works fine, taking the user into the read-only Word document. My problem is that, when the Word session is closed, the Access task has been minimised and the user needs to maximise the Access task to view...
  9. C

    How to return cleanly from report with no data to report menu

    I need to identify where a report selected from a listbox menu of reports has no data to display, then display a "No Records" message before returning to the reports menu list. When a report is selected from the menu, I call the report with the code: OpenReport strReportName, acViewPreview In...
  10. C

    Importing picture to form

    If this is a duplicate posting, my apologies - my machine's playing up. I have a form that is part of an auction application, and displays a picture of an item when the record is retrieved (OnCurrent event). That works fine, but (presumably when the server is slow) I get a popup box informing...
  11. C

    Importing picture to form

    I have a form that is part of an auction application, and displays a picture of an item when the record is retrieved (OnCurrent event). That works fine, but (presumably when the server is slow) I get a popup box informing me that it is "Importing Picture", often flashing too quickly to be read...
  12. C

    Include pictures (jpg/gif) on forms

    I am putting together a query-based form for an auction, that needs to include an image of each item retrieved. One of the columns in the source table contains the name of the picture file (e.g. "pic001.jpg","nopic.jpg") to be displayed for each row retrieved. How do I link this text with the...
Back
Top Bottom