Search results

yes - i know that there are issues with field names, types etc. i have just been trying to work out what fields should go where and how they would relate to each other for a few months now. it makes more sense to me to figure out how everything would go together first and then go back in and...

hi - i manage our company's cell phone plan. right now i have a massive spreadsheet which was developed by someone else many years ago. i do not have anyone who is able to help me who has db dev knowledge. i can get all the basics set up and normalized, but when it comes to usage, i...

Hi - I know this is probably incredibly easy, but I'm either searching wrong or completely missing something. I am using the Expense Reports template and have modified it for what I need. It's all working just fine except...(btw, Access 2003) There is a form to "view reports" that has two...

Hi all - I was away from Access for several months so forgive me if I'm overlooking the obvious or using incorrect terminology. I'm working on creating a database that will track all of our company's cell users and their charges. We pay for the voice plan, but they are responsible for all...

thanks pat - that sounds like something i could figure out without too much pain. i'm still open to any other ideas from the hive mind, of course!

thanks for the suggestion...but i'm not sure if cascading combos will work because i have info i need to fill in and the blanks would be different depending on the issue. if i select "cell service" i would want cell number plan? data? device to show up in the comments box, which is just a...

Hi all - I'm not sure if I should use a subform, a macro, something on the switchboard... I am using the Issues db template. What I'd like to happen is that if I select a particular category (Cell - Service change), in the Comments text box, some fields will pop up that pertain to that...

thanks, pat. let me explain - i have an Authors table that has AuthorID, AuthorLastName, and AuthorFirstName. In order to add a new author when inputting a book, the popup form has to be used (at least that's what worked after many other tries). The user enters it as LastName, FirstName so the...

answered one of my own questions! the one about editing entered records. i'm not sure if this is the correct way, so let me know: I made a copy of the frmBookInfo (which is used to enter info and has data entry set to Yes). I changed the data entry to No. I use the nav arrows to move through...

Hi all - I appreciate all the help I've gotten on this forum! My library catalog database now works so that I can enter book information and do reports etc. Now, I would like to make it better. Please bear in mind I have no training whatsoever. I barely understand VBA but I can muddle...

that's my question too. i'm going to look right now... ----------------------------- SELECT tblAuthor.AuthorID, tblAuthor.AuthorLastName, tblAuthor.AuthorFirstName, IIf([AuthorFirstName] Is Not Null,[AuthorLastName] & ", " & [AuthorFirstName],[AuthorLastName]) AS Author FROM tblAuthor ORDER BY...

Yay!!!!!!!!! okay, i found a solution that seems to work. on another forum, someone was having a similar problem, and someone suggested that she change the RowSource of her cbo to SQL stmt rather using the query builder. so now, my RowSource for the cboAuthor looks like this: --------------...

hi there - i've gotten a version of db working so i can enter data and use it while i make it better in a different version. i've been looking around to try to solve my cboAuthor problem. Bob said that the data i'm passing back is not the same as the data that went out. i found some advice...

cool, thanks!

i realize this thread a few years old but... i am so excited that code i modified actually worked! the first time! i was trying to prevent blank record creation and this worked, with a little mod that someone else might useful one day. i'm sure this is old news (or not the "correct" way to you...

thanks bob and uncle joe! so what i'm seeing then is that perhaps i need to requery the underlying table for authors instead of the combo box? i think i've read about that somewhere in my searches. i originally had my the "," set up with no space, but of course it gave me " Jones" so I...

oh man, i must be in trouble if you can't figure it out! :) if i figure it out somehow, even thru some convoluted way, i'll post back too. thanks for your help, rg!

uncle joe - thanks, i've tried that too. i just retried it to make sure. after i hit the button on the popup form to close the popup, it closes the popup, then it tells me i need to save the current field before the requery action and gives me the standard access error message. that's where i am...

vinzz - thanks, but what i have is working for me in that respect. i can add the data to the combo just fine, but i can't get it to act like the other notinlist events, meaning, after adding the new data, it says "ok great" and not "it's not in the list", making me have to reselect it. i...

i give up!! okay, so i've been trying all sorts of things and i just cannot get this to work. my code is below. What currently works: If user tries to enter an author that is not in the list, the not in list event is triggered. This opens popup form, frmAuthorEntry. The fields are already...