Search results

Has anyone ever heard of creating an objects Menu with folders in it to store files (documents) in access and each folder is tied into the records (unique field primary). What would happen is the user would go to a certain record scan a document which would pop up on a form in access (2000...

Noob Because I'm a noob and wasnt aware of that function, looking up the function now and how to use it. Thank you

Hi everyone I was wondering if anyone can see if anything is wrong with this code,=DateSerial(Year([FIRSTRENEWALDATE])+2,Month([FIRSTRENEWALDATE]),Day([FIRSTRENEWALDATE])) I use it to help me keep track of when employees need renewals done. What it does in each field is add two years which is...

Has anyone ever heard of creating a tool bar with folders in it to store files (documents) in access and each folder is tied into the records (unique field primary). What would happen is the user would go to a certain record scan a document which would pop up on a form in access (2000 version)...

I forogt I forgot to mention that the databases wont have duplicate data because the inactive records will go to the inactive db and the active will be in the active db. Basically after the inactive have migrated out of the active db and to the inactive db then they will no longer exsist in...

Reason Thank you Wayne for your advice I understand why your asking those questions I should have explained that in the beginning. The reason for two Dbs and two tables is because each database is going to be huge as in over 4 GB so I'm trying to save space. Originally I was planning on...

I have a active DB and a inactive Db and I would it be better to use to update the second database. for instance if the records in the active became in active I would need to have those records migrate to the inactive db. Or would a Append query be sufficient??

THANK YOU Good grief I love this site. Thank you so much for your help. so much better then utteraccess (in my opinion). Is there a way we can help sponsor this site or donate or something???

Ok Now theres a reason yikes thats alot money, thanks Bob

Still a student Well thats true I can just get the .net version, its a book I need for my VB class thats all, plus it will help me with my database projects. Thank you everyone

thats great what if I wanted to have a list box with the names of the different tables in it and as soon as you select that table you would get the form associated with it, of which you could look up an employees team member number and their data.

New Project please help I have a database that has several tables in it, all of which are about employees that we license (gaming license) we have their active files and inactive files. The database has a 11 tables the reason for this is to track their licensing status, theres license...

Anyone know where I can get a free or cheap copy of Visual Basic 6 studio on the internet??

IIf(IsNull([Forms]![REVISED FORMS]![Srch_TM#/APP#]),True,[TM#/APP#]=[Forms]![REVISED FORMS]![Srch_TM#/APP#]) I have this in a query to look up values for me and it works pretty good, I just want to be able to apply this to a form, trying to create my own seach form only instead of using...

please ignore that response Thanks thats great

Forgive my ignorance Thank you Wayne I'll do that instead as you can see I still have alot to learn Thank you;)

I am trying to do an iif statement that if one combo box has the date in it the second combo box will return the value with a yes (yes/no combo box) the thing is I keep getting the statement wrong. Can you help me pls

SORRY Sorry about that I should have said guys and gals, I meant guys in general (slang I guess) referring to male/female. Your Gods and Goddess hows that??

THANK YOU THANK YOU YOU GUYS ARE GODS....THANK YOU SO MUCH. I have got alot to learn about programming, so I ordered alot of programming books and I'm taking a SQL class the end of January. Thanks so much for answering my questions, I sure do appreciate it.

I was thinking of making my own switchboard, and instead of having buttons that you push to bring up different forms. I was thinking of having a listbox with the names of different departments, as soon as you click on the department their information pops up on that same form (not a differnt...