Simple Sales Quote Access Desktop version Database

[snbbrewing]

Hello,

I've spent a few days searching this forum and Microsoft's... I need some help as I am pretty familiar with access however no experience with VBA or custom access db design.

I have tried downloading and converting the Services database to the desktop version however I cannot adjust the tables/forms without blowing it away or no access at all to the tables due to the Web based database.

I am trying to have a simple quote tool where I can have a customer table, quote table and form, and services table. The Quote Form should call from the customer table and Services table and I would like to be able to add the services line by line with quantity and calculate a total.

I am savvy enough in access to adjust an existing desktop database where I have access to the tables/forms etc. where I have no skillset is the vba scripting etc. so please do not hammer me over the head with what I should know etc. Just looking for a bit of help here! Thanks!

 

[theDBguy]

Hi. Welcome to AWF!

There are lots of people here to help you. You could start out by creating a database file with just your tables in it and then post it here for review and guidance. After that, we can work on the forms.

 

[snbbrewing]

Hi. Welcome to AWF!

There are lots of people here to help you. You could start out by creating a database file with just your tables in it and then post it here for review and guidance. After that, we can work on the forms.

Thank you! Will do. Some of the items in my database are proprietary to my company so I will need to clean that part up.

 

[theDBguy]

Thank you! Will do. Some of the items in my database are proprietary to my company so I will need to clean that part up.

Definitely. We don't want to you to compromise any sensitive info. We just need test data.

 

[MattBaldry]

Hello,

I've spent a few days searching this forum and Microsoft's... I need some help as I am pretty familiar with access however no experience with VBA or custom access db design.

I have tried downloading and converting the Services database to the desktop version however I cannot adjust the tables/forms without blowing it away or no access at all to the tables due to the Web based database.

I am trying to have a simple quote tool where I can have a customer table, quote table and form, and services table. The Quote Form should call from the customer table and Services table and I would like to be able to add the services line by line with quantity and calculate a total.

I am savvy enough in access to adjust an existing desktop database where I have access to the tables/forms etc. where I have no skillset is the vba scripting etc. so please do not hammer me over the head with what I should know etc. Just looking for a bit of help here! Thanks!

I have a well established database with this as one of the modules. Feel free to message me if you want to bounce some ideas.

~Matt