Recent content by KLahvic01

Here is a question, I do not even know where to begin. I have a database that helps my son and I track a collection of hot wheels cars. In the database, I have a Collection table and I have a Master List table with all the vehicles from 1968 to present. Each vehicle has a name, series, year...

I figured out that it was simply that both controls were on a form with the same record source and that by creating a subform/main form relationship with parent and child, I got it to work exactly as I had anticipated. Thank you for your help!

Yes the field exists, that was the first thing that I checked. However, the field is part of a relationship and it is used on a form whose record source is a different table (tblCollection). What is interesting is that when I click ok on the record, the functionality works. Could this be...

Question. Why does my database populate this error when I open my form: The Mocrosoft Access Database Engine cannot find a record in the table 'tblMasterList' with Key matching field(s) 'MasterID'. But when I click ok on the error message, the database works fine until I try to navigate to...

I understand how the examples you provided work. The question is, can I use this code on a check box for an individual record from table A (search form) and move it to Table B (collection form). This is a hot wheels collection database and I may have more than 1 of a specific car and they...

This has been phenomonal advice, and I think I am almost there. After reading up on data types and all, I tried to write my own SQL string and after a few revisions, I think I am close. Here is the string that populates with the debug.print: INSERT INTO tblCollection ( CollProdYear...

I have this working, but here is the problem I encounter. When I move to a new record all is well, but when I try to go back to an existing record the values in my unbound text boxes are gone. These are populated based on values assigned by the checkbox being checked. The checkboxes stay...

Here is an instersting question. Either it is that unique or I havent searched for the correct things, but I havent found the answer I am looking for. I have a main form with a subform linked with CollectionID field, basically the subform is a series of checkboxes that when checked an unbound...

That makes more sense now. I will read up on that stuff and make another crack at this. Thank you for your help!

Yes that is correct. This is where I am lost, CardNumber and MstrCardNumber are both categorized as 'Text' in the tables but their values are numeric. Do I need to change that? I'm sorry, I really am trying to understand this, I figured it was over my head, but in the past I have been able...

I see, I reviewed my SQL string and it doesnt look like I am missing any quotes (single or double). Here is the code string, I hate to be a bother, but do you see anything? strSQL = _ "INSERT INTO tblPersonalCollection " & _ "( Description, CardNumber, CarNameID, SeriesID...

I do see what is happening, thank you for the updated code, I am not at all familiar with SQL. Here is what is happening now: Run-time error 3075 Syntax Error Missing Operator in query expression When I Debug.Print, this is what I get: INSERT INTO tblPersonalCollection ( Description...

I am recieving the following run time error when I click the 'Owned?' check box on my form. Run-time error '3142': Characters Found After End of SQL Statement When I debug, this is what it highlights: dbs.Execute strSQL, dbFailOnError Which is part of this code string: Private...

I added the code to the After Update event and when checking the Owned Box to test I recieve the following error: Run Time Error: 3142 Characters Found after end of SQL Statement When I debug it highlights: dbs.Execute strSQL, dbFailOnError Any ideas on what can cause this?

Thanks, I will try this out on Monday and let you know how it goes.