Link to home
Start Free TrialLog in
Avatar of Rob4077
Rob4077Flag for Australia

asked on

Collect data for timesheet

I have never yet ventured into using MS Access for the web but now have a need and seek some direction as to whether the task I want is difficult or if I should look for an already developed app.

We have teams of electricians working in the field and I have been asked to create a system to monitor costs against each job so what I need is for the employees to be able to log in, record the start time and end time on each job, and a Job Number (free text field or preferably a combo box lookup) they attend. Most of them only attend one or two jobs each day but some of them will be attending multiple jobs. I then need to be able to download the data and import it into the main database. From there I can process it into a payroll file and do the job costings I need. Security is not a particularly big issue - I could probably handle that with a simple encryption function.

Is this going to be a feasible and difficult task for a MS Access web app or should I look for an off-the-shelf product and if so, any suggestions?
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Rob4077

ASKER

Thanks Ryan. I was under the impression that the MS Access web option would allow users to access my local database without having to download via FTP. Sounds like doing it myself may be a big deviation from a standard MS Access application. I will wait to see if there's any more comments but in the meantime I will look for an off the shelf package that may do the trick.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Rob4077

ASKER

Thanks for the comments, Pat. Where would I go to find a sample web app for data collection linked to Azure. Totally new to me but if it's within my ability I would like to have a go.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Rob4077

ASKER

Sounds like it's getting too difficult. Maybe I revert to plan B and see if I can find some service provider who has already developed it and sells it.

Thanks for your comments. I should've learnt some dot net language years ago and then built all my apps internet ready.
If this is strictly data collection, you can use Excel and/or Outlook and have folks send in their time that way.  Access can interface with Outlook to get the email and download and import the attachments.  If you do this, it is best to designate a specific data collection email account that only Access reads.  You could use Outlook forms but I've never built one so I don't know how they work.  You could also use InfoPath but I'm pretty sure that technology is being deprecated so check before you invest any effort in using it.
Avatar of Rob4077

ASKER

Thanks Pat for the extra suggestions. I will use those if necessary but would prefer to find something easier on line so I will continue my search. Thanks again.
I think you will find the Excel/Outlook solution not too hard to implement.  Anything you find on line will be difficult or impossible to integrate with the existing application.
Avatar of Rob4077

ASKER

My main concern with an Excel solution is that I think all my users would have to have Excel on their mobile phones and I am not sure of the price.
It would have been nice to know from the beginning that you wanted a phone app.

Look into what you can do with the free, web version of Excel.  Or, you might have to get an O365 subscription for each person.

I think your cheapest solution is having someone create an ASP data entry page.  Your Access app can then pick up new entries every day and process them.
Avatar of Rob4077

ASKER

Sorry I didn't make it clear that I wanted them to log in using a mobile phone. I knew what I meant but unfortunately it didn't translate to words correctly. I don't need a phone app, just a web page they can log into and record the data. I think you're right as far as best approach is concerned. I would guess that would be relatively cheap function to get done as long as I make the specifications very clear. The data needed is minimal - UserId Date, Start Time, End Time,  Job Name and a couple of other fields.

Thanks again for your ongoing help