Search results

  1. R

    Access VBA to export to Excel

    Hey guys, I’m going to throw this out here in hopes someone may be able to shed some light on this. Have an Access form with essentially 4 fields ASM Certification MPR Certification (Combo Box ) TMS (Combo Box ) QUAL Type Two, as you can see are combo box. There are some other filters...
  2. R

    Binding Data to a ListView

    hey all, I'm back to banging my head against the wall on an entirely different issue, the elusive ListView. Let me tell you what I have, and works, and what I'm hoping for, not working yet. Shipping Database that seems to never be complete. REGION TABLE: REG_ID (PK Autonumber) SELECT...
  3. R

    cascading combo boxes with a junction table

    hey all, I have either given up or taken a break, not sure with on table / relationship structure with considerable help from both gemma-the-husky and Mihail. Thank you both as much for your patience as technical help. I'm jumping to the forms development and going to try what I need via...
  4. R

    trying again at relational for several tables

    To anyone who can help with relationship problems; I am trying yet again to create a Shipping Program here and about to pull my hair out trying to get the relationships right. I'll start by explaining what the 'process' is and trying to normalize a spreadsheet with over 8K records in it. The...
  5. R

    using treeview and listbox

    I'm hoping someone here might be able to add some insight into what I'm trying to do here. Getting ready to start on a project and want to use treeview and list in the project if possible. Lots of menu selections and sub selections. I came across the file that I am going to include which is from...
  6. R

    Nz function

    hey guys, I'm hoping someone here can help me with that elusive 'Nz" function. Here's what I am trying to do. I have a main form, called LIN_NOMEN. There are 3 subforms in LIN_NOMEN: 29SUB, 31SUB and 41SUB. each one of these subs has a total box that calculates a total. When the user selects a...
  7. R

    many_to_many relationship advice

    hey all, I am really hoping someone can help me out on this one since I have been banging my head against the wall for hours. It's a many-to-many relationship problem that I hope can be resolved in the simplest terms. I will try and keep from being too long winded here and keep it brief. I am...
  8. R

    Cascading Combo Boxes and keeping Relational data

    Ok guys, I am making myself crazy here and I know there has to be an easy way on this but I just can’t find it. I have finally gotten the relationship aspects of a Database down. Got that part finally working pretty well. But as you know, that is only showing me existing data in tables that I...
  9. R

    ListBox Troubles

    Hey all, I’m about to pull my hair out here trying to figure something out. Hopefully someone out there can help me out on this one. I’m finishing up a database and I have a form with several fields on it. There’s quite a few records so I want to be able to have the users be able to select...
  10. R

    Diaplay only if date is 6 months or less

    I am trying to create a query here and I am completely lost on how to work this. I have two functions I’m trying to complete. My company has many employees that have to travel extensively. They are trying to keep track of leave dates, return dates, and total days they are traveling. This one...
  11. R

    hyperlinking to external files from access

    hey all, I would very much appreciate any help or ideas on how to do this as I am stumped. I need to develop an access database to track documents but also link to them. I’ll explain what it needs to do; Every day there is a numbered (and titled) Word format document that is sent. Most...
Back
Top Bottom