Search results

well, Word Forms seem to be made just for that. It's not a huge number-crunching operation, just a simple totals column: The Score Risk Priority Column should be a total of the 3 checkboxes (if they're checked). This is not unlike what PDF documents can also do. I am just confused about...

I found out more for you: http://www.computorcompanion.com/LPMArticle.asp?ID=22 the part where it says "add sections" - allows you to have a protected section along with an unprotected one. hope it helps.

nobody at all? :)

i'm new to forms myself, but i think the idea is to set up the document so that only the stuff in the grey textboxes is user-formattable. Set up form fields for everything you want users to edit. Everything else is "locked". do you know how to use checkboxes? i've been waiting (in vain) for an...

please? :(

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

Ok, I found something online and was able to make it work (with the code below). The trick is that when you are relinking to a different location of BE (and not just refreshing) - you are deleting and re-creating a TableDef. I got it to work, yes, but the problem is that the Relationships are...

Ok, I tried the TransferDatabase method and what it did was create additional linked tables in the FE (like if there was a LinkedTable, it also added LinkedTable1) instead of re-linking or re-freshing the existing linked tables. I'm pretty sure that I had it coded right, because I ran the...

Thanks! That should work, I dunno why I didn't think of that. Any idea how to "check" whether or not the BE is missing (before the error messages start)? My frmMain (main form) is based on tables in BE, so if I open frmMain and BE is missing (not linked), it's error messages galore! Thanks!

bumped (just in case). any ideas? where do you place the code which will run FIRST, before anything else happens?

Hey, Moniker, thanks again! a quick question: where is it best to place the code to prevent the multiple error messages (due to missing links to BE)? I find that if I place it in the frmMain's "On Load" event, I get MANY of the same error messages BEFORE that event even fires. I need the...

Awesome answer, Moniker! One of the best replies I ever got, thanks! Yes, I can use the Common Dialog to get users to "browse" to the BACKEND location, capture the path and use it. Also great ideas about the list of linked table names. Awesome!

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

well, i did solve my own problem, so i thought i'd post the solution for consistency: here's what i did: in the parent table i added a field called "append_AssmtID" and when copying (appending) assessments this field will store the "old" AssessmentID. I also use a "NewOccID" to assign the new...

eh, i still don't get it - is there a way in append queries to append to a "query"? because if not, i don't see how the system will "know" to which new parent-table record to append the new child-table records. unless it's done iteratively via VBA, but I haven't come up with a way to do that...

ok, but how will it copy/append into both tables? append query only allows 1 INSERT INTO destination table, no?

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