Recent content by Antimatter

Yep i did and it worked like a charm, i'm not as familar with VBA so i try to avoid it for most items, althought as i get more familar with it i might use it more often.

Ahh i see cool thanks :-) that was the last thing i had left to fix in my database, i got all of the other NotInList code done, and couple of custom function for extracting the authors, and finished constructing the database, that was the last item left before i could say i was offericaly...

Hmm... i indexed the REPLACE and also tested out the SUBSTITUTE function so from what i read, i went on and plugged it into the row source such as SELECT DISTINCT [Author].[AuthorID], SUBSTITUTE( [First] & " " & [Middle] & " " & [Last] AS FullName FROM Author, " ", " " ); that gave me an...

Right now i have this following code for my author field in the row source SELECT DISTINCT [Author].[AuthorID], [First] & " " & [Middle] & " " & [Last] AS FullName FROM Author; and it works great, but this is not an serious problem but more of an vanity issue, but i can live with it if...

I'm posting my solution to the problem if anyone else runs over the same problems as i did. I spent several hours today trying to get it to work then i thought, hmm that control source seems interesting so i changed it from publisher to publisherID then access complained it was an auto number...

I looked at your example, and i played around with them and they made sense to me, atleast i thought it did, so i took the same concerpt in your example and applied it to my form, but no matter how i applied to it it still screwed up, so i'm uploading a copy of my database with my single book...

by not adding directly you mean if i type in a new entery it will pop up a new form with request for me to add the new entery is that correct? not just add it if its not already there, i sort of did that i think, basically if it wasn't there it would pop up a dialong box asking if you wanted to...

that what i thought, when i did it i added in the position and now the whole record addition and deletation works, i just need to get the combo box on my form to work properly and then i probably can figure out how to parase the author name into seperate fields. i posted over on the form...

got it, thanks, i thought the black dot was to adjust or change options on the ruler so i clicked the borlder of the subform. its now continious and it looks lots better now

*bump* worked a bit on this but haven't been able to solve the issue, i'm thinking that what i need to do is when i select an field is to have vba access the ID of that field and store it into the fieldID in the book tables. any ideas on this?

whoa didn't expect it to be that simple, i did that and it works thanks! now only one item remains is the parasing of the author name into seperate columes [edit] ah a little problem, when i select a new publisher, it replaces the one currently selected. how can i get it to take the publisher...

I finally got my database to work properly and got an ruminary form up and working properly i can enter all the information correctly, now i want to enchance my form. here's a picture of the structure of the database. and here's a picture of the current form as it is now Ignore the errors in...

i did some research before i came to the forum, and i ran over the many to many database, and it actualy was the model for my current database, it show me how to do a many to many relationship. Anyway i didn't know that about the compound key i'll give that a shot, the shared ID is there to...

sdebo2: How would i do that i right clicked and select properities for the subform on my main form and i couldn't find anything called or similar to default view so i'm not clear on that care to explain more? pat hartman: i thought so, thanks, but i'm still having problems geting the database...

ecniv: thanks for that suggrestion, i will probably take some of the extra fields and add it into the database, but correct me if i am wrong from my first look at your suggrestion it appears to me that it only support one author many book model? And actualy this is sort of an freelance project...