Search results

  1. L

    A better way to design tables and forms?

    I am hoping for some advice about changing the set up of a database to follow better design rules and habits. The database I am working on has slowly grown and needs some changes which is a good time to look at the basic structure. The current requirement is that we receive a number of...
  2. L

    Return field name into array where field is true

    I'm chasing how best to store the field names from all "true" fields from a table in an array (recordset? SQL?) and feedback of whether I am going about this correctly. We audit documents and each document can have any number of issues from a defined issues list (although this list grows over...
  3. L

    Link scrolling of 2 Web Browser Controls

    I have 2 Web Browser controls on the one form (webLeft and webRight) which both have a .pdf loaded. I am hoping to link the scrolling between them so that if I mouse or keyboard scroll in one the other scrolls by the same amount. Is this even possible in Access for Office 365? There appears...
  4. L

    Dcount since last sunday

    I am trying to get a running total of documents we process during the week, displayed in an unbound text box with a dcount as the value. I have managed to get the daily count using: =DCount("*","[tblDocumentLog]","Int([DateCreated])= #" & Date() & "#") But I am struggling with the correct...
  5. L

    Mixed fields design suggestions

    I am trying to figure out the best way to design a table and form to achieve a result. I have 3 fields which I need users to enter: [Facility type] - one of 5 options: hospital, racf, community service, GP and Other. I have a set list for the first 3 options which I want to restrict users to...
  6. L

    Lookups - the finer points

    I am trying to piece together the best practice for lookups and have read the basics but have some questions on the finer points of setting it up. I have seen many times: http://access.mvps.org/access/lookupfields.htm and I am trying to avoid table-level lookups. I have table with a list of...
  7. L

    Propagate entries into table based on subform field number

    I am attempting to create a mail merge database which can create printable labels and need to increase the number of generated labels of certain types based on user input. I have a main form which has some fields which appear on every label (name and DOB) then I have created a subform which...
  8. L

    Drag & Drop Outlook .msg to Form

    I am trying to allow users to drag and drop an Outlook email on to a form and have it save the .msg to a destination folder and store the information in a table. I have read the tutorials and achieved this for regular files (drag and drop via explorer) using a ListView control but Outlook...
  9. L

    Best setup for cascading combo boxes

    I am seeking some advice on how best to set up some cascading combo boxes (or if this is exactly what I need to start with). (I have read the link to Cascading combo boxes examples but my needs go beyond those examples). The scenario - I have a form used for user entry which I want to guide...
  10. L

    Parsing pasted text into record(s) in table

    Hi All I'm a google search hacker when it comes to Access programming and am seeking some guidance about how best to achieve a goal so I can research in the right direction. I have a database with a main table (DocumentList) and a primary key DocID. This is linked to a second table (SiteList)...
Top Bottom