Re: Access Web Application

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Jeff,

Did you have any suggestions for me on this project?

What approach do you suppose would be appropriate for me to take? I am just
learning, so perhaps a more simplified, Access based program would be the way
to go, although a web based system would be great.

Thanks in advance...

Ariel

"Ariel Dugan" wrote:

Hi Jeff,

Thats right, same program, just a previous version. We are using version
8.3.4

Thanks
Ariel

"Jeff Conrad [MSFT]" wrote:

Hi Ariel,

Very interesting; thank you for the additional information.

Is this the system you are currently using?
http://www.synchronics.com/products/cpv7.htm

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

"Ariel Dugan" wrote in message:
news:ED4D7042-AA92-408D-966F-32E2EA1D3A42@xxxxxxxxxxxxxxxx

Hi Jeff,

I hope this isn't too much info...

I would like to make the application fairly complicated over time. I have
really enjoyed making time saving features in our current, Excel based
Produce Ordering system, which has a custom menu, many userforms, and
thousands of lines of VBA. It generates Weekly and Qtrly reports for all key
statistics, and takes a lot of work out of the actualy ordering, saving many
hours of time a month.

I am looking to do something similar, but on a better platform, with the
benefits of relational data. If it works well, I would like to use it for
all of our Departments in the company.

I'm not exactly sure how many forms, reports, etc, but I want to make it
open ended, so that as needs come up, I can add the features. Of course we
will have an initial plan that will attempt to cover all the obvious ones. I
would like to be able to retrieve records, and update records from our SQL
data with this application. I would want it to update inventory, pricing,
etc.

When you ask how many people will working with the Database Objects, if you
meant working on developing the application, that will just be me. If you
were referring to using the application, then 3 - 5.

We are using CounterPoint, (A front end for SQL Data that is designed for
Retail POS (Point of Sale). It holds all items, sales history, etc. The
company we are working with has created an array of interfaces to accomplish
all of our tasks like updating prices, running sales reports, and changing
bin locations, using Excel.
I am not looking to replace any of this, but I am wanting to create an
ordering and distribution system that works along with our current system.

We are using XP Pro, Office 2003. We have a central Server at our corporate
office, and Servers at each of our 4 other locations. Each replicate back to
the central Server every hour with all updates.



.

Relevant Pages

  • Re: Access Web Application
    ... I'm not exactly sure how many forms, reports, etc, but I want to make it ... It holds all items, sales history, etc. ... bin locations, using Excel. ... the central Server every hour with all updates. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access Web Application
    ... Co-author - Microsoft Office Access 2007 Inside Out ... I'm not exactly sure how many forms, reports, etc, but I want to make it ... It holds all items, sales history, etc. ... the central Server every hour with all updates. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access Web Application
    ... Co-author - Microsoft Office Access 2007 Inside Out ... I'm not exactly sure how many forms, reports, etc, but I want to make it ... It holds all items, sales history, etc. ... the central Server every hour with all updates. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Not Even Gheylo 3 Can Save the Xflop ThreeShitty From The PS3
    ... Not Even Gheylo 3 Can Save the Xflop ThreeShitty From The PS3 ... single Microsoft Quarterly Report which you can access yourself. ... gather Microsoft SHIPPED data for the console (Sony & Nintendo quote sales ... People forget that the original projection for XBox 360 sales was ...
    (alt.games.video.xbox)
  • Not Even Gheylo 3 Can Save the Xflop ThreeShitty From The PS3
    ... Not Even Gheylo 3 Can Save the Xflop ThreeShitty From The PS3 ... single Microsoft Quarterly Report which you can access yourself. ... market but are simply unable to gather total and complete sales statistics. ... People forget that the original projection for XBox 360 sales was for ...
    (alt.games.video.xbox)