Search results

hi - i just wanted to add that except for the authors notinlist event, all my other notinlist events work just fine. the new string is added, it tells me so, and that is that. authors is the only one where i have to have a form open also, so maybe that has something to do with it. do i need...

hmm, i think this is one of those times where i'm missing something basic but critical, kind of like when your car won't start and then you realize it's not in park? i've attached my db with the code from you RG that i've been fooling with. i think i have it right. i went back and...

here's my code for the NotInList event: is the acDataErrAdded in the wrong spot? or do i need to put in two places? Private Sub cboAuthor_NotInList(NewData As String, Response As Integer) On Error GoTo cboAuthor_NotInList_Err If MsgBox("The author " & Chr(34) & NewData & _ Chr(34) & " is not...

rabbie - cool, thanks!

oh, ok, RG. i just saw your post - i hadn't refreshed. i'll see what i can figure out!

okay, update...the string is getting back to the main form. but it dings at me and gives me the error msg, i have to reenter the name in the main form or select it from the drop down box. so it works just fine, i just need to get rid of it dinging at me after i enter the info in the popup and...

okay, using the original code i had (posted above) for the NotInList event for cboAuthor and the OnLoad code from RG that uses the split(), i can get the string passed and separated like it should be. now i just need to get the popup to close and go back to the main form and have the new author...

feeling less crazy okay, i have a few questions (of course). 1) In VB (or the MS version of it), does capitalization not matter? - in the Form_FrmEmployees NotInList event, the private sub is called CboEmployees and then it the on error says "cboemployee". That is read the same way by...

ok, i got it open! looks like the example i needed to understand this thing. thanks for the offer RG, but i used to do tier 1 tech support at a cable company, so troubleshooting internet connections is something i CAN do :cool: lol i'm going to go check this out. i'll post back later with how...

ah, i see. i'm at my friend's house today working on the database. they do not have wireless internet, so i have to use their computer to get online. their version of access is 97. i'll have to see if i can get my laptop to hook up to their internet access. thanks rg and dcrake!

thanks but i was unable to open it.

i have to remake the main form and then i will. thanks!

when i use that second bit of code, which i tried before, it tells me the item is not in the list. it is a text box, not a combo box or list box, i just double checked. i'm really confused. i'm attaching my db, maybe that would help. crap, i just accidentally deleted the main form. that...

here is the link for where i got the code. http://www.access-programmers.co.uk/forums/showthread.php?t=135415 In the OnLoad event, what is the Me. to refer to? My second form looks like this LastName __________________ FirstName__________________ The AuthorID is an Autonumber. When I've...

my code thank guys, but gemma - you lost me. and rg - i think i am using code you suggested to someone else. here is my code: Private Sub cboAuthor_NotInList(NewData As String, Response As Integer) On Error GoTo cboAuthor_NotInList_Err If MsgBox("The author " & Chr(34) & NewData & _...

ok, here goes. i have a combo box on a form called cboAuthor. in the form, on the row source line, i used the ... to create a query that will concatenate the first name and last name of the authors and sort alphabetically. that all works just fine. however, i am trying to do the NotInLIst...

cool ok, that was a short answer! easy enough. mol

Success!!!!!!!!!! :D thank you very much! so just to sort of make sure i get this...the code you provided works because it uses the recordset instead of the table to add the data with the punctuation? and the code i was originally using was trying to insert directly into the table causing...

hey - i can see what did wrong already! i did not place the rs. etc stuff after then if then for the msg box. i thought it should go somewhere else than where i put it. giving it a whirl, will post back. thanks! If intAnswer = vbYes Then rs.AddNew rs!Title = NewData rs.Update

where exactly should i put that? i did this and now i get a syntax error (which i've been getting) about an operator missing because it sees the " in the ptg title. ------------------------------------------------------------------------ Private Sub TitleID_NotInList(NewData As String, Response...