Recent content by tragik

:D sorry to have wasted anyone's time or space on the server.. i found my own solution.. http://office.microsoft.com/en-us/access/HA102355831033.aspx?pid=CH100948231033 my database went from 400 mb to 1.6 mb.. A noob mistake i guess, kinda like looking down the barrel of a loaded shot gun.. hehhee

Solved::: Database trippled in size?? Ok, so i was building my database kinda simple and it was running about 37mb in size.. The only thing I have changed was, - move 5 tables of data into one table, for better searching. - added this function to my database (...

I know i have created a s**T storm with this code.. lol I am not sure why 4 out of the 8 search boxes work but not the other 4.. Maybe I should scrap this code and try another example? thanks.

you are correct.. sorry, I am remote into my pc at home (so i can work on it while at work, shhhh lol) and the VNC screen made it look like a - not a =.. so, you are correct " _Subject = 1932 Ford " to add more info: if i debug it highlights the row " Me.frmSearchAllArticles.Form.Filter =...

Ok, so I understand what you mean about the 'controls' and I have fixed that issue. I also had an issue where one of my fields was called combo09 and not a proper name. Changed it to cmbType as an example. Now if i choose an option from my subject (which is a combo from the tblSubject) and hit...

Thanks Neileg.. unfortunately i didnt use the wizard and this was all my fault.. could you direct me how to resolve my problem and rename the control.. or could you direct me to a good read-me on what you mean? When i get to work i will try an google what you mean about the 'control'. thanks...

question.. in my code am i missing something like Me!? or something.. i am trying to research why my Me. is failing..

Ok, so i got all my tables into one table now, tblReviews: Reviews_ID: unique id Type: text (type of article it is, ex: Builds, Review, Info, How To) Title: text (title of a how to article, ex: God i am lost on this code error) Reviews_Subject: Subject of the article (ex: P-51, or P-38 etc)...

UPDATE: ok, here is what i did, came to me late last night in bed, i appended the data to an already working tbl. it worked.. so if i have 5 tbl's i took #1 and append it to #5.. it worked either way, so i am back on track.. thanks

UPDATE: so, here are my tables and settings.. ( i still get the same problem if i take my tblBuilds and "create new table" from the query). tblScale (lists all possible scales) ID: unique ID, auto number Scale: Text (text box, indexed: no) tblBuilds: ID: unique ID, auto number Builds_Scale...

ok, now i am getting frustrated.. i am trying to append a table as instructed.. but i have a table called tblBuilds and my new table; tblMainArticle now, in a nut shell , when i preview the query i see my scale as correct (ex: 1/48, 1/72) but when i run the append part it changes to the UNIQUE...

Thanks David, heheh yea have several copies of my database. It is still somewhat small (23mb) but have more than enough records to not have to type them in over again.

Thanks David, I will look into 'append queries' today.. will try and find a tutorial on that somewhere.. Thanks for giving me a 'name' to go after and research.

Neileg.. can I smack you? (not in a bad way, buy you a 1775 beer, great beer!).. you are sooooo right and I will take your suggestion.. so, could you give me some suggestions the best way to get all that data into one table? Now, i understand i will have to have a universal table and some...

thanks John, will check it out after put the young one to sleep..