Recent content by murpl

I've created a worksheet (Excel 2K) and preselected a range of cells populated with formulas and formatting that I need. I did this so that I could have the user fill in data using an access form however the input from the form won't allow the list to grow without losing my formatting etc. As...

Is it possible to use a single Access form to edit data in multiple Excel worksheets in the same workbook? Like using a dropdown combo box to select which sheet the user wants to work with? Mike

I've built an Excel 2K sheet and linked an Access (also 2000) form for the user to add/edit records. The problem is in getting Excel to autofill the formulas for each new record using the Access form. If I enter data directly into the Excel sheet it works fine. Do I have to manually fill the...

Gord, as I glance over this the lights are going on all over the place. 1000W+ ! :) Thanks for taking the time not only for the code but for the helpful tips and information! VBA help is still Greek to me but I know a bit of Latin ::chuckle:: You've answered more than a few questions for me...

Whelp, I've been hacking away at this off and on (in between more pressing demands - Sheesh! Wottaweek!) and I've finally got something that works but I still can't get rid of the final "The text you entered isn't an item in the list" Access msgbox. :( But if I click past that the...

:-/ The first error msg was due to a simple typo. Fixed that but it just seems to fall thru to Access' regular message that it's "not in the list go back and do it again" msgbox. Your revised code does the same thing. er, waitaminit . . . If I open my table I find several blank...

Hmmm, still getting an error &quot;jet database engine can't find query or table 'categories'&quot; (or words to that effect.) The table exists... <scratching chin> I've seen this elsewhere in the forums before but . . . Thanks for that, btw. Mike

It ain't happenin', folks. Here is my complete sub.. htis should work, right??? Private Sub CategoryID_NotInList(NewData As String, Response As Integer) Dim db As Database, rst As Recordset Dim strMsg As String, nd As Variant nd = NewData strMsg = &quot;'&quot; & nd & &quot;'...

Consider that stolen, rafe! ;)

Gord, Great examples on making use of the validation properties as well as the percent ideas. I went back to a situation I recalled from earlier (and had pasted in a lame-o workaround) and adjusted it more along the lines you suggested above. MUCH better. :) Mike

&quot;Only one column can be bound to a ComboBox or ListBox but you can do things to save all the data if you need&quot; I assume the &quot;things&quot; would be VB code, huh? I've been trying to work that out but I am kinda new to this and it isn't really all that important in this case. I'd...

If you have the format set to Percent then it will automagically multiply it by 100 (&quot;percent&quot; = &quot;of one hundred&quot; or &quot;x 100&quot;). You can just enter .05 or add some code that divides the input value by 100. Not real elegant. Mike

Thanks, rafe!

Just curious but wouldn't something like me.requery as an afterupdate event do it? I don't offer this as an answer, btw. Er, unless it works! :) Mike

I've done this as per Access help descriptions and examples but it doesn't seem to work... What I'm trying to do is select from multiple collumns in a table (or query; same non result) but all I get in the forms combobox is the value from the first field specified. Here's the SQL statement...