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 "jet database engine can't find query or table 'categories'" (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 = "'" & nd & "'...
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
"Only one column can be bound to a ComboBox or ListBox but you can do things to save all the data if you need"
I assume the "things" 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 ("percent" = "of one hundred" or "x 100").
You can just enter .05 or add some code that divides the input value by 100. Not real elegant.
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...
Thanks, DougP. That'd probably work. What ended up working was to tile the open windows, resize and move, and save. I can't believe how I was held up by something so dumb that had such a simple fix. A real "forehead slapper". <G>
Thanks for the response!
Mike
Vman, you ARE great! <vbg>
Yes, that did it. I should have read a little more closely the first time. Thanx muchly! (Gave you a star for that.)
Thanks mate
Mike
I've asked this question in another forum but then realized that perhaps it was the wrong forum for the question. Or perhaps I'm just too impatient and find it hard to understand that other folks might just like to enjoy their weekend. LoL! (Btw, hope everyones weekend is/was great!)
Here's...
This is likely a problem of my own making but how do I fix it? The problem is when I press <F11> to display the database window it opens but places itself just outside the Access window... all I can see is the bottom portion of the database window and I can't move it back to gain access to the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.