Search options (Page 2 of 3)

Hello Dmitry,

My intentions were to run the software on my desktop.
Since I'm using the software  for my business I would like any updates that I make on the software to be
shared with administrative personnel. Meaning the software is shared among all users and updates are
automatically being made as user enters information to the software.

I tried  MySQL to see what was all about and also to see if there could be a benefit in utilizing in this manner.

I will send you the database.

Thank you,
Heriberto

Derek,

That a quick way of approach. That's a brilliant idea.
I'd have to give this a try.

Dmitry,
This is the ideal.. WOW! just completely love it.
The only problem is that I still don't don't what SQL stands for.. LOL

I'll try both ways  but, it's going to take me a month to figure out Dmitry's way. LOL

Thanks you guys greatly appreciate it.

Eddue

Dmitry,

I see....
Will give this a try.

Thank you,
Eddie

Dmitry,

Oh no!!

What options do I have if I want to keep the tables in my new database without
re-typing all my info into software?

Thank you,
Eddie

JB,

I noticed you mentioned, "Strange that unchecked box doesn't work."
If you mentioned this then, I knew I was missing something.
Sure enough... I did not uncheck the box.

Thanks JB I got it to work.

Eddie

Hello JB,

For the project that I created there will only be one user only.

In regards to the share drive. I was curious cause I noticed on the options-> settings ->database location.  Where I can input the share drive link for multiple users (multiple users).

Eddie

Another question...

Say I updated the database on my end.
How can I send the project  to my Admin personnel and have her database reflect the updated version on her end?

Thank you,
Eddie

Tcoton,

I greatly apologize, not explaining my self in detail.
I have a company that conducts Installation and maintenance services to dealerships.I have all my parts stored in a large warehouse, also I have 5 trucks that require parts to be carried in order to carry out the job. Being in a large and fast moving city like Los Angeles their is a high possibility of my drivers getting in to an accident of any type.

On software:
Want to have a database that allows me to search through all my inventory parts in the warehouse. Additionally have the option to keep a positive inventory control of all parts my trucks carry with them to the job site. Since accidents do happen, I would also like to have this in record and keep a history of accident reports for my workers.

Well, this morning I did not go to sleep till 5:00 am I was high on coffee and pre-workout supplements. not the best combination but it helped. :-D
I stepped back and observed my database schema and how I executed this database system. Well, It's now simplified and got it down.
I made the parts inventory form from the warehouse. I can search, add, and export to excel. works great.
Made a button that takes me to the Trucks Inventory form, this is where I store all vehicles inventory and in the inventory I added a "Truck No." this identifies the vehicle. So in this form I can search for a "Truck No." in result gives me all the inventory for a particular truck. works great. I also made the "TruckNo." on the Table NULL. This way my administrator does not forget to add the corresponding truck to the inventory.
in this form I created a form called "Accidents" which provides all necessary information to fill out an accident report. Here I can search by "Truck, person, and date" and analyze the history of all accidents.

I have to say I finished it. :-D
I'm just making it look pretty.
Thanks guys greatly appreciate your help. :-D

Eddie