Filtered TextBox Value

I've not had time to have a look, but I will. Don't worry I've not forgotten, I have your tab open. If there's anything salvageable I'll let you know. Hopefully I can take a look tonight!
 
I would really appreciate that. Working on this database is my only job. I am at work 8 hours a day, and I am hoping to resume working on the database as soon as possible. I understand you are busy and I thank you in advance for taking the time to help me. I am not sure, but I think my biggest problem is the NewMetal portion of the database.

Thanks again,

Conner
 
I've only just had time to look at it, and made a few diagrams in the process and I've got to say that you've beaten off more than you can chew Conner. Your boss is asking for a replacement of a full blown application to be completed in a month by someone who is new to Access (and perhaps also new to programming)... a job that even an expert would refuse to take on considering the timescale. You have the design phase to complete, then the testing phase which would take up a lot of your time too, and then finally deployment. And of course this is an iterative process because you may find kinks that may need ironing out or further enhancements that may (in some cases of poor design) require an overhaul or a rethink of the current design. It would have been slightly easier if this was a totally new system, but in this case you're replacement an existing system so expectations will be high and they would expect all (and even more) functionalities that existed in the old system.

At this stage I would strongly advise that your boss seriously considers getting an expert to come in and develop the system or gives you a lot more time (i.e. 2 or 3 months) to come up with a satisfactory workable system.

In the meantime, I have some questions/requirements:
1. Is the pricing of base metals different from precious?
2. What is TBD1 and TBD2?
3. Upload a spreadsheet that includes sample data.
 
1. The pricing is different in the market that is used from precious to base metals. The company may use a different market, however the calculations and all are the exact same.

2. TBD is To Be Determined. Those are extra slots in case there is more than only the two precious metals involved in the quote. so that the employees do not have to add the calculated fields themselves. for example if there is a part to be quoted that has gold, silver, and platinum the TBD1 after silver would become platinum and the prices would carry through the calculations. This also goes for the base metals.

3.View attachment quote examples.zip
 
Last edited:
I understand that the task at hand will be extremely difficult for me to accomplish. I do have longer than one month. I have until my internship is over which is August 7th 2015. I can tell you that I will work my butt off to get this done in the time frame. My boss understands that there is a possibility that I do not get it done, but I believe I can do it. I am relatively new to Access, but I am not as new to programming. I understand a lot of things, and am continuing to learn every day. I appreciate all of your help, and I will do everything that I can to get the job done.
 
I had an idea to see if I could create a smaller version of my database that will quote one individual external part. this eliminates the assembly aspect, which makes it a bit more simple. I also had to add a few fields to my tables and one new table. I was missing a few things from the spreadsheets.
 
I almost thought that TBD1 was a type of precious metal ;)

Are you using the words Vendor and Supplier loosely or do they actually differ? I don't seem to find any vendors in the spreadsheet provided.

Also how does a part relate to precious/base metals? Is the part made up of either a precious or base metal? Can you indicate how it relates in the sample spreadsheet you uploaded last.

I'm sure that your company has enough financial resources to hire an expert to do this job but because you're an intern trying to prove your worth, I'll give you a hand with the tables. And because there are so many different elements to this, I can't spend too much time looking at it, that's why it takes me a little while to reply.
 
And you don't need to upload another db, I'm looking through the other one. If I need some clarification on something, I'll ask.
 
The words vendor and supplier refer to the same data. the marketing team calls them suppliers, and the sales team calls them vendors. the spreadsheets do not have any of that information. each time one of the 4 initial spreadsheets is used the information is then saved in a folder on our server under the supplier company name. my boss wants the quoted to be stored in the database according to supplier/vendor and customer.

one part could have many different metals as components, whether those metals are precious or base metals. a part could also have no metals and just be a straight part as charged by the fab price. the base metals are almost always included in the fab price by the supplier, but there is one supplier that does not do this. the precious metals are priced based on the metal market price and weight.

my company does not have the means to hire a professional, but I am trying my best. and I understand that there is a lot to this. I am very thankful for all of the help that you are providing.

as for the last spreadsheet I uploaded, that was an actual quote with a few numbers changed by me for confidentiality. so each part has components that are either base or precious metals as indicated. the supplier chooses a market to quote by, and there may or may not be a supplier mark-up on the metal. the first two worksheets are based solely on the suppler information, which calculates the cost to my company.

the second two worksheets are for my company "Naeco", which calculates the cost to our customers and profit for my company. the market for the base metals does not change from supplier to Naeco, so Naeco has the ability to place a mark-up on the base metals. the market that Naeco uses for precious metals is either "EngleHardFab" which there is never an added mark-up, or "EngleHardBulliun" which allows for an added mark-up determined by the employee generating the quote.

Please let me know if you have any more questions or requirements of me. And thank you again for all of your help.
 
VBA,

I have been working on a few different databases, all of which relate to quotations but on a much smaller scale. I tried to make a database that would quote just an external part (I believe I have accomplished this). I then tried to create a database that would quote a part internal or external (I also believe I have accomplished this). My next goal was to create one for Assemblies. I have learned a lot by experimenting with the smaller databases. With all of that being said, I believe I have come to a solution to my corrupt tables within the database that I sent you. I have eliminated many tables, and established my relationships according to what I believe will work. I have attached a screenshot of my relationships page. I think I have figured it out, but I am not completely sure and was hoping you could have a look at it. Thank you so much for all of your help. I have learned a lot from you and the forum in general. I look forward to hearing from you.

Relationships.PNG

Regards,

Conner Owen
 
VBA,

Today my boss threw a monkey wrench in my work. I believed that the Metal Market Prices would be entered once a week in the current DB. My boss informs me today that he wants an employee to go in every morning and enter that days Price for Each Metal with respect to many different markets. There is a total of 12 metals, and 5 markets. I need the data to be stored first by date, then by either market or metal, and lastly by which ever isn't used second (Either: date-market-metal, or date-metal-market). I think the Latter of the two methods makes the most sense. Is it possible for my current DB to lookup values from the Metals Database based on date-metal-market?
 
All these changes are to be expected... that's why I kept banging on about sorting out your structure. I've not had time to look at this since because I've been busy organising myself for a trip tomorrow morning.
 
I know that changes were to be expected, but I did not expect something this big. I do not think that the metals database will be as difficult as my current one. and I have made some serious progress in my current DB by making the smaller databases. I appreciate your help. I will continue to work with what I have and try my best to get the job done. Thank you again.
 
Upload what you've got so far so that when I do get round to your thread I can have a look at it.
 
As I said before, I have created some mini databases to do simple quotes, and try my hand at queries with calculations. I got one of them to work for an external part as long as there is a metal. I have not figured out how to do the calculations if there is no metal involved. Also I have figured out a way to do an internal part and do the calculations based on that information. I continued to work on my calculations in my queries today and tried to implement the assembly. I have to leave work at 5:00 here and regretfully I do not have time to upload what I have currently. I will work on them and upload everything tomorrow. At the moment I want to forget about the Metals Database and get my current DB working with the calculations. Thanks again for all of your help. I hope you have a great trip and look forward to hearing from you soon. Regards, Conner Owen
 
There's no hurry, I probably won't get to it today anyway, or even whilst I'm away. It all depends on when I have time to scribble something down on my notepad and come up with a relationships diagram.
 
VBA,

I believe I have made some progress and have the new quotations working properly and can get all calculations. My problem now is the Quote format as a report exporting to word or a PDF, and the other functions that My boss wants. I have a decent start, I am just stuck with some of the code. If you could help when you get the chance, that would be great. I am also going to post a new thread in the Modules & VBA Forum. I would greatly appreciate any help you could offer. Thank you so much for all of your help thus far.

Conner Owen
 
A while back I saw some other thread(s) that you posted in the Tables section (I think) so it looks like you got some good help there?

DoCmd.OutputTo will allow you to export to Pdf.

Any other questions, feel free to ask.
 
I think I was able to get my table structure correct. The data entry forms are working however I still need some help with my report and other forms. I posted a thread in the reports section and the Modules & VBA section. I hope I can get some help soon as I have not much time left in my internship and I would really like to get as much as possible completed. Thanks again for all of your help and patience.

Here are the links to my two new posts:

http://www.access-programmers.co.uk/forums/showthread.php?t=278947
http://www.access-programmers.co.uk/forums/showthread.php?t=278948
 
You must log in or register to reply here.

Similar threads

A
Solved Problem with the format property of a combo box.
2
Replies
24
Views
1,026
AHeyne
A
G
Strange behaviour from a combo box on a form when trying to evaluate data in another column
Replies
6
Views
685
GPGeorge
GPGeorge
tmd63
How to use a combo box to filter a forms data
Replies
2
Views
657
theDBguy
theDBguy
G
Combox uses 'wrong' value list
2
Replies
32
Views
2,276
June7
June7
J
Textbox as source criteria for multiple queries
Replies
10
Views
425
JPR
J

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom