Recent content by collizz

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

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

One last question - how do I close this thread ??

OK, all is now well. I removed ".DefaultValue" from the initialization process for the combo boxes and everything now loads properly. I would still like to know why the heck it had problems with alphabetic key values, but you know, I'm going to pretend it never happened! Thanks so much for...

The table data is retrieved as expected by both queries and is available to the combo boxes (you can the data when you click on the dropdown arrow). The difference is that in one case, the combo is provided an intial value that is shown in the control. The other combo has nothing loaded into the...

Linked it back in to the calling menu, opened it in Add mode and still no success, unless I used a numeric key in the source table. Going to lunch! Thanks

I just created tblTest, with two columns testID (autonum) and testText, populated a few rows, created a query to select both columns, changed the control's Row Source to "qryTest" and it works fine. Then, I changed the tblTest key field to be text, changed the key values from 1,2,3 to...

I got the ItemData() usage from a Google search, and it does load the values (I display them immediately following the load in the Load event). The form is normally opened as acFormEdit (from a menu) but I have changed it a fair bit and now I'm testing it "standalone", so I don't know how it...

Thanks, vbaINet, but as I mentioned in my post, I loaded both comboboxes and checked out their contents with a msgbox display. Both ItemData(0) values were non-blank, with the first expected value inplace. They just don't both show up when the form is presented!

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

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

Thanks to all for the helpful replies. I managed to get it sorted by using the GotFocus and LostFocus events to store the values in public variables. Probably not the 'right' way to do it, but it worked for me. I was so smug about solving that, I decided to be adventurous and split the db. That...

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

The value for Person.personID may be present in Document.authorID and/or Document.ownerID. If this is a compound query, I'd be interested to know how you put that together, guys.

Sample db and report to explain There is only one record per personID, so not sure what GROUP BY would give me? Honestly, I do appreciate the help, and would really appreciate an assist on the syntax for the query. I know what I want, just can't figure out how to put it into SQL. Person table...