Search results

Hi, all. I am an Access developer, but i'm pretty comfortable with Excel and Word... except this forms thing - never had to set them up before. i'm talking about making a document a locked form, where you can only fill out the grey fields (similar to PDF forms). I've figured out text fields...

Hi. I did a search on this issue and know that there are a few reasons why Access truncates Memo fields. In my case I have a MEMO field with a default value "[Enter Description Here]", which the user can replace with text. Obviously I don't want the report to show the default placeholder text...

Hi. I am typically an MS Access developer, although I've done a few projects with Excel automation and I am quite comfortable with VBA. I am duplicating an Access entry form in Excel (for those who don't use Access) for a Risk Assessment database. I need to place multiple checkboxes in a cell...

Hi, all. I have a "client/server" split Access 2003 database with an Interface file containing all the code/forms/queries and some system tables and also a Data Backend file, with all the data tables and table structure. This is being deployed to multiple sites, each getting their own version...

Hi. I am working on a Risk Assessment database. I have attached an image of the 2 tables concerning my question. The main "transaction" table is the tblAssessments and a linked table tblRisks drives a subform - showing multiple Risks per assessment. The field "OccupantID" identifies the...

Hi, all. I have seen this issue before - some of the functions in an Access VBA module require "Common Language Runtime Library" and "Common Language Runtime Execution Engine 2.0 Library" to run. Before I've been able to go into VBA References and make sure they are "installed" (checked) and...

Risk Assessment database - "rollup risk scores" from workstation to department... I don't know if it'll make sense out of context like that. I am working on a Risk Assessment database, where a factory can be assessed to see which risks exist at workstations/departments or the whole facility...

Hi, all. An Access 2003 question: I use an OLE control frame in my forms to add pictures of items. It works fine, but I don't like having to right-click and select "Insert Object" - it's not user-friendly. I would like to have a button "Add Attachment", which would open a Browse dialog box and...

I have a database of Assessments, each record having multiple subforms. I am working on a button, which creates a "similar" (same) assessment, copying over all the subform records/selections. So, after I actually insert a new assessment, pasting all the values from the original Assessment...

I ran across this Microsoft article and was wondering if some of you adventurous souls out there might test this, whether or not this applies to maybe viewing Reports without having to actually close a PopUp form (with Access hidden/minimized). This is relevant to Access 2000, which doesn't yet...

I already have this working by means of: doCmd.RunCommand acCmdAppMinimize in Form_Load (or Form_Open) events. This works great to hide Access and only display the main form (like a standalone app). But I have 2 issues: 1. The PopUp form (main or "switchboard" if you like) opens, then Access...

Ok, I finally have it working the way I like. It's really slick - the main form (set to "PopUP" and with docmd.runcommand accmdappminimize line in the On_Open event) opens with customized icon (in titlebar and in windows taskbar) and behaves like a standalone program (you only see Access the...

Hi. I am using Access 2000 and in my code I'm exporting a table into an Excel file (creating it), then the code needs to export another query into the same file (a new worksheet). So I needed both a "Save As" dialog and the ability to grab the filepath so that the second export appends to it...