Sabtu, 01 Desember 2012

RE: [MS_AccessPros] IT suggests not to use MS Access

 

I don't have corruption issues but I always split my apps into front and back-ends with every user getting their own app file. Most of my back-ends are SQL Server databases. I don't separate out memo fields from my tables like some developers suggest but again these are typically SQL Server.

Duane Hookom MVP
MS Access

> To: MS_Access_Professionals@yahoogroups.com
> From: daniel2478a@yahoo.ca
> Date: Sat, 1 Dec 2012 18:39:19 -0800
> Subject: [MS_AccessPros] IT suggests not to use MS Access
>
> At work our IT is suggesting not to use MS Access because the data base is prone to corruption, is that true?
>
>
> the data bases that I made are small and still work fine after 2 years
>
>
>
> http://www.techrepublic.com/blog/10things/10-reasons-why-it-pros-hate-microsoft-access-but-really-shouldnt/386
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>


[Non-text portions of this message have been removed]

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)
Recent Activity:
.

__,_._,___
Diposting oleh di Tidak ada komentar:

[MS_AccessPros] IT suggests not to use MS Access

 

At work our IT is suggesting not to use MS Access because the data base is prone to corruption, is that true?

the data bases that I made are small and still work fine after 2 years

http://www.techrepublic.com/blog/10things/10-reasons-why-it-pros-hate-microsoft-access-but-really-shouldnt/386

[Non-text portions of this message have been removed]

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Recent Activity:
.

__,_._,___
Diposting oleh di Tidak ada komentar:

RE: [MS_AccessPros] Re: Changing the source data of a combobox while maintaining current functionality

 

Tony

I have a lot to say about your current design. I'm afraid if you keep going with
it as is you will paint yourself into a corner. Starting with the tables. You
are using a "spreadsheet" mentality. You are storing calculations (i.e., total
cost, average cost, etc. Those calculations should be handled by the forms and
reports so they are always accurate. Right now if you change the quantity, the
calculations become meaningless.

Access does not work well that way. It needs tables that are related such as a
product table related to an inventory table. Order table related to an Order
Detail which is related to the product table.

Orders placed would affect the inventory table...

Forms should have bound fields so data entry and editing does not take a bunch
of tricks to get it in the table. You can easily set up a form to search for a
record the way you started out to do. The combo boxes would go in the form
header and would filter the form's RecordSet to find the selected record.

Maybe John Viescas's sample inventory database would help you understand better.
I don't have the link but I'm sure John will read this and post it for you. Or
download the template Northwind. While it is not perfect, it does have sample
tables, forms, etc. to get you started.

Even better, get Crystal's free eBook Access Basics at
http://www.thatlldoit.com/Pages/AccessBasics.aspx

Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT <http://thatlldoit.com/> http://thatlldoit.com
MS Access MVP

<https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E>
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E

My Nothing-to-do-with Access blog

<http://wrmosca.wordpress.com> http://wrmosca.wordpress.com

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Tony
Sent: Saturday, December 01, 2012 10:56 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Changing the source data of a combobox while
maintaining current functionality

Was anyone able to take a look at this?

Thank you!

Tony

--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "Tony" <GKillah36@...>
wrote:
>
> Hi everyone,
>
> Please see formTicketMod in database PracticeNASDatabase_113012b in Files ->
AssistanceNeeded. To the very right of that form I have text boxes and
comboboxes in place so the user can have that data added to table
tableWarehouseData.
>
> I would like to make a slight change though I'm not sure how to go about it.
How do I make it so that clicking commandAdd still does the same thing it does
currently, but instead of the user selecting a UPC in comboAddUPC, they select a
style, color and size just like combobox cboStyleNo at the very left of the
form?
>
> Thank you very much!
>
> Tony
>

[Non-text portions of this message have been removed]

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)
Recent Activity:
.

__,_._,___
Diposting oleh di Tidak ada komentar:

[belajar-access] File - Tata Tertib dan Aturan.txt

 


Tata tertib dan peraturan
Mailing List: belajar-access@yahoogroups.com

1. Mailing list ini membahas mengenai pemrograman Microsoft Access.
2. Tidak diperkenankan mem-posting topik yang tidak ada kaitannya sama sekali dengan pemrograman MS Access, peluang kerja atau tawaran kerja sama dengan keahlian di bidang MS Access, atau pengajaran/kursus MS Acces. Pelanggaran terhadap aturan ini akan di-ban dari keanggotaan milis ini.
3. Mohon berdiskusi dengan baik, dengan semangat membangun, demi kemajuan kita bersama. Hindarilah perbantahan (flame) yang bisa menjadi pertengkaran yang tidak perlu.
4 Hindari reply permintaan one-liner seperti 'saya minta juga dong', 'saya setuju', dan lain-lain yang tidak perlu.
5. Sedapat mungkin memberikan data-data yang lengkap dalam mengajukan suatu masalah untuk memudahkan rekan-rekan sesama member mengidentifikasi dan mencarikan solusi, termasuk memberikan subject yang sesuai dengan isi email, tidak dengan kata-kata seperti "tologing dong", "pusing...", "ada yang bisa bantu..", dll.

Moderator

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (69)
Recent Activity:
SPAM IS PROHIBITED
.

__,_._,___
Diposting oleh di Tidak ada komentar:

[MS_AccessPros] Re: Changing the source data of a combobox while maintaining current functionality

 

Was anyone able to take a look at this?

Thank you!

Tony

--- In MS_Access_Professionals@yahoogroups.com, "Tony" <GKillah36@...> wrote:
>
> Hi everyone,
>
> Please see formTicketMod in database PracticeNASDatabase_113012b in Files -> AssistanceNeeded. To the very right of that form I have text boxes and comboboxes in place so the user can have that data added to table tableWarehouseData.
>
> I would like to make a slight change though I'm not sure how to go about it. How do I make it so that clicking commandAdd still does the same thing it does currently, but instead of the user selecting a UPC in comboAddUPC, they select a style, color and size just like combobox cboStyleNo at the very left of the form?
>
> Thank you very much!
>
> Tony
>

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)
Recent Activity:
.

__,_._,___
Diposting oleh di Tidak ada komentar:

[AccessDevelopers] File - Monthly_Notices.txt

 


Monthly notices:

Hi Kids!:

Don't forget to check out our "Links" section at the website for helpful sites. Also take a peek at books that others have found worthwhile in our books database under the 'Database' link of the main AccessDevelopers page. Feel free to add any books or links that you have found useful.

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (101)
Recent Activity:

Please zip all files prior to uploading to Files section.
.

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [MS_AccessPros] Referencing control on subform to requery

 

Dear rodbevill- (name?)

Assuming you'll be running Requery in code behind the outer form (perhaps
in the Current event), you would reference the controls on the subforms
like this:

Me.Subformcontrolname.Form!NameOfControl

Note that Subformcontrolname is the name of the subform control, NOT the
name of the form inside the control - though they are often the same.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: rodbevill <desertscroller@cox.net>
Reply-To: <MS_Access_Professionals@yahoogroups.com>
Date: Saturday, December 1, 2012 5:25 AM
To: <MS_Access_Professionals@yahoogroups.com>
Subject: [MS_AccessPros] Referencing control on subform to requery

The db that I am developing (Access 2010 on Windows 7) consist of a main
form with a tabcontrol. Each tab consist of a split form. Within the
split form are combo-boxes with data based on a saved query. The issue
is requerying the row source for the various combo-boxes when the record
on the main form changes. Each of the tabs contain different data from
the db tables. Each tab only uses one table. Each tab is linked to the
main form thru an id field.
Query definition for the combo-box row source:
SELECT tblParcel.lngParcelID, tblParcel.lngParcelNum
FROM tblParcel
WHERE (((tblParcel.lngTPTID)=GETTPTID()));

The function GETTPTID() retrieves the ID which is updated every time the
main form updates to a new record.
I am trying to use the TabCtl On Change to initiate the requery for the
combo-box. Tried several approaches at a loss. The combo-box is used to
list the currently identified property parcels used when sending
correspondence. Not sure if I have explained the issue well enough? Any
suggestions would be greatly appreciated.

------------------------------------

Yahoo! Groups Links

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)
Recent Activity:
.

__,_._,___
Diposting oleh di Tidak ada komentar:
Langganan: Postingan (Atom)