Senin, 29 Desember 2014

[belajar-access] Cari Jasa: Membuat Database Ceklist Dokumen (softcopy) via M. Access

 

Assalamualaikum wr wb

Selamat pagi semuanya :)

Perkenalkan sebelumnya, nama saya Didin.

Langsung aja ya, saya sedang mencari jasa pembuatan program monitoring laporan ditempat kerja saya.

Monitoring pelaporan yang sekarang dilakukan secara manual menggunakan ms excel diceklist satu2 dengan data hardcopy. Ini merepotkan karena harus buka dokumen hardcopy satu2.

Yang saya inginkan:
1. program yg bisa me-record ceklist dokumen
2. bisa diakses secara online
3. bisa backup data secara terjadwal
4. bisa diakses via mobile (optional)
5. menyusul..

Barangkali ada informasi pembuatan aplikasi/ program M. Access seperti keterangan diatas, mohon info2 ya.

Terima kasih sebelumnya ya.

Wassalamualaikum wr wb.

Didin A
WA 08882245518

__._,_.___

Posted by: d.afi_coldplay@yahoo.co.id
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
SPAM IS PROHIBITED

.

__,_._,___

RE: [MS_AccessPros] VBS auto updater error

 

Bill Mosca,  … or anyone with knowledge of this error fix.

 

I have been using Bill Mosca’s auto updater to update the FE database to a series of computers.  I have had no issues for the last year and a half.  Now, without any known changes on my part I am getting this error…

 

 

Script:  

Line:      54

Char:     13

Error:     Permission Dedied: ‘ParentWindow.Screen’

Code:    800A0046

Source:  Microsoft VBScript runtime error

 

I have copied a few of the lines below.

 

53       With .Document

54            With .ParentWindow.Screen

55                oIE.Left = 300

56               oIE.Top = 300

57            End With

 

 

Does anyone have any idea what needs to be change to get this working again?

 

Thanks

Bill

MN

 

 

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
Sent: Tuesday, March 19, 2013 3:30 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] VBS auto updater error

 

 

Bill

I've seen that error, too. It's the browser. I started seeing it with IE 9. I
haven't found a work-around yet, but since all the lines with that code are just
sizing the splash screen, you can just put in a hard-coded size (I think the
measurements are in pixels). Keep the window small. If I can get a test machine
with IE 9 and figure out a solution, I'll update the script.

And what better place to come to ask about my code than right here.

Regards,

Bill

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Singer
Sent: Tuesday, March 19, 2013 8:27 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] VBS auto updater error

This is somewhat related to Access. For quite a few months I have been
using Bill Mosca's VBS auto updater to update the Front end Access Databases
automatically. I have been using it on two different network and two
different databases. It has been working great until now. One of the
machines in each network gets this error.

Script

\\Server-hcc\users\Public\Documents\FrontEnd\Contacts_FEupdate.vbs
<file:///\\Server-hcc\users\Public\Documents\FrontEnd\Contacts_FEupdate.vbs>
<file:/// <file:///\\>
\\Server-hcc\users\Public\Documents\FrontEnd\Contacts_FEupdate.vbs>

Line: 55

Char: 17

Error: Object doesn't support this property or method: 'availWidth'

Code: 800A0186

Source: Microsoft VBScript runtime error

This is what line 55 is

oIE.Left = (.availwidth - oIE.Width) \ 2

The strange thing is that the computer that is having the issue in each of
the networks is the one that I do the Access programming on. The Users
computer seem to run fine.

Again, I understand that this is not directly an Access question but I do
not know where else to go.

Thanks for any help you can supply.

__._,_.___

Posted by: "Bill Singer" <Bill.Singer@at-group.net>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (7)

.

__,_._,___

[MS_AccessPros] Re: Conversion From Microsoft Access to MySQL ?

 

Thank you for the response, Bill. I already have Office 365 Personal as a monthly subscription, but when I contacted Microsoft through online chat, they told me I needed Microsoft SQL Server to create a web-based Microsoft Access database. I guess their support is not that great for web-based Access, but at least I can learn some fundamentals before migrating to MySQL. Thanks for the information. Jerry Boor, Rochester Hills, Michigan, USA

Sun Dec 28, 2014 4:20 pm (PST) . Posted by:

"Bill Mosca" wrmosca

Hi Jerry

Sorry you haven't been getting the responses you hoped for. This group really is for all levels of Access skill from the "What the heck is Access?" to the working developer. So you are most welcome to post whatever questions you have.

I would go with a MySQL database hosted by your web provider and web pages written in ASP or PHP or whatever the latest trend is these days. In my opinion, MS still hasn't got Access-to-web stuff ready for prime time. Access still relies on SharePoint even though the data is in an SQL Server Azure instance.

The only other thing I can suggest is to use Office 365, but you don't seem to want to do that. My Office 365 account is used mainly to host my website (which has been pretty much left on its own for over a year. I can't seem to be able to squeeze in any time to work on it due to an enormous workload right now). But my website doesn't do any transactions so I can't say how good that aspect of Office is. I do know that Access web apps are very limited. No VBA code, smaller set of macro actions, etc.

Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT <http://thatlldoit.com/> http://thatlldoit.com
MS Access MVP
<http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852> http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852

__._,_.___

Posted by: Jerry <bearjercares@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)

.

__,_._,___

Minggu, 28 Desember 2014

Re: [MS_AccessPros] Today's Date - Graph

 

you're welcome.  Luck!

I hope the graph template helps ~ it was difficult to figure out the charting commands from Access because it is so poorly documented.  The best resource I found is using the Object Browser (F2 from Visual Basic Editor) on the Microsoft Graph #.# Object Library (be sure to reference it so you can look stuff up).  Surprisingly, unlike many other common applets, using the macro recorder from Excel on graphs does not translate as well to Access.

Warm Regards,
Crystal

~ have an awesome day ~



On Sunday, December 28, 2014 2:57 PM, "statmanbp@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:




Thank you Crystal.  I am working on a program for my water plant.  Your graph program looks like a good fit for what I need to do.  Wish me luck




__._,_.___

Posted by: Crystal <strive4peace2008@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (9)

.

__,_._,___

RE: [MS_AccessPros] Conversion From Microsoft Access to MySQL ?

 

Hi Jerry

 

Sorry you haven't been getting the responses you hoped for. This group really is for all levels of Access skill from the "What the heck is Access?" to the working developer. So you are most welcome to post whatever questions you have.

 

I would go with a MySQL database hosted by your web provider and web pages written in ASP or PHP or whatever the latest trend is these days. In my opinion, MS still hasn't got Access-to-web stuff ready for prime time. Access still relies on SharePoint even though the data is in an SQL Server Azure instance.

 

The only other thing I can suggest is to use Office 365, but you don't seem to want to do that. My Office 365 account is used mainly to host my website (which has been pretty much left on its own for over a year. I can't seem to be able to squeeze in any time to work on it due to an enormous workload right now). But my website doesn't do any transactions so I can't say how good that aspect of Office is. I do know that Access web apps are very limited. No VBA code, smaller set of macro actions, etc.

 

Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT http://thatlldoit.com
MS Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852

My Nothing-to-do-with Access blog

http://wrmosca.wordpress.com

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, December 26, 2014 5:11 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Conversion From Microsoft Access to MySQL ?

 

 

I am working on a Microsoft Access database that I intend to eventually share, mostly as a "read only" status, on the Internet. I cannot create this database as a "web-based" database because my monthly subscription with Microsoft Office does not support SharePoint services. Microsoft told me I would have to have use Microsoft Server.  Trying to get answers from Microsoft or anyone else has been way too difficult on this issue.  So, I think the next best thing is for me to convert my Microsoft Access database to MySQL when it comes time to release it on the web.  Does that seem like a workable approach and does anyone know the basic process? 

It seems this group is way over my head and I guess set up for those of you who are professionals already, so I get very few responses.  Thank you to those of you who have responded.  But if anyone would be so kind as to tell me if there are some beginners or intermediate groups online that might have time for me, that might be a better option for me.  Thanks if anyone can help.
Jerry in Michigan, USA

__._,_.___

Posted by: "Bill Mosca" <wrmosca@comcast.net>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

.

__,_._,___

Re: [MS_AccessPros] Today's Date

 

Thank you Crystal.  I am working on a program for my water plant.  Your graph program looks like a good fit for what I need to do.  Wish me luck

__._,_.___

Posted by: statmanbp@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (8)

.

__,_._,___