创建车辆服务车间计划的最佳选择 [英] Best Option for creating a Vehicle Service Shop Program

问题描述

大家好！我是新来的，但我想我来对了地方。我确实有一些使用Visual Basic的基本编码经验，但我不熟悉任何其他程序。



我有一个朋友做各种摩托车维修/升级/建造，他让我帮他出去。当我去他的地方时，我意识到他在纸上做了一切。在创建新发票并需要正确的零件编号和价格时，他拿出了一张旧发票，上面已经执行了相同的服务，我不得不在新发票上复制所有这些信息。这是非常耗时的，我想如果信息存储起来会更加有效和高效地利用时间，只需点击一下按钮即可将其拉出。



我正在考虑创建一个数据库和一个程序，允许我将客户信息输入系统，以获取他们的自行车已经维修过的日期以及可能在该服务中使用的每个部件并创建一个当前服务的发票。在程序中，我想创建一些常用的服务选项，我可以根据需要进行调整和编辑，因为某些特定的工作需要10个以上的部件用于该工作（密封件，垫圈，螺钉等）。如果我可以从下拉列表中选择和选项，这将在发票上显示该作业的所有所需部分，这将是理想的......然后，如果需要，我可以编辑/删除单个部件以消除冗余。



希望我没有太多絮絮叨叨。我只是想让你知道我的目标是什么。我可以访问MS Visual Basic和MS Access。我想创建一个程序，可以保留所有信息以及创建发票。如果您认为有任何特定的程序，软件和应用程序会有所帮助，我们将非常感激。



提前致谢。

Hello everyone! I'm new here but I figured I came to the right place. I do have some basic coding experience using Visual Basic but I am not familiar with any other programs.

I have a friend that does various motorcycle repairs/upgrades/builds and he asked me to help him out. When I went to his place, I realized that he was doing everything on paper. When creating a new invoice and needing the correct part numbers and prices, he pulled out an old invoice that had the same service performed on it, and I had to copy all of that information down on the new invoice. This is very time consuming and I imagine that it would be a more effective and efficient use of time if the information was stored and could be pulled up with the click of a button.

I'm thinking about creating a database and a program that would allow me to enter customers information into the system for the date(s) their bike has been serviced and each part that may have been used during that service and create an invoice for the current service. In the program, I would like to create a couple common service options that I could pull up and edit as needed, because some particular jobs call for 10+ parts to be used for that job (seals, gaskets, screws, etc.). If I could select and option from a drop-down list that would bring up all of the needed parts for that job on the invoice that would be ideal...and then I could edit/delete an individual part if needed to eliminate redundancy.

Hopefully I didn't ramble too much. I was just trying to give you an idea as to what my goal is. I have access to MS Visual Basic and MS Access. I would like to create a program that could keep all of the information as well as create an invoice. If there are any particular programs, software, applications that you think would be helpful, it would be very much appreciated.

Thanks in advance.

推荐答案

老实说，你的朋友最好买一些像Quickbooks这样的东西。



不是我想要令人沮丧，而是创建报告单独是高级编码。旧的VB6是一种死的，不受支持的语言，发票，库存和服务管理软件是一个相对高级的主题。另外，如果你想像会计系统那样跟踪资金，那么你必须担心复式会计和记录保存。



如果您想尝试制作一个，请务必去寻找它，但我不希望有一个解决方案可以让您的好友随时离开纸张不久。如果您处于基本级别，则需要花费很长时间来处理错误。

Honestly, your friend is better off buying something like Quickbooks.

Not that I want to be discouraging, but creating reports alone is advanced coding. The old VB6 is a dead, unsupported language and an invoicing, inventory, and service management software is a relatively advanced topic. Plus if you want to keep track of money like an accounting system, then you have to worry about double-entry accounting and record-keeping.

If you want to try making one, by all means go for it, but I wouldn't expect to have a solution that lets your buddy move away from paper anytime soon. It takes quite a while to work the bugs out especially if you are at the basic level.

这篇关于创建车辆服务车间计划的最佳选择的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！