Senin, 03 Oktober 2016

[MS_AccessPros] Attachment field question

 

Hello all,


I was just given a new project on a database that I did not build. There is an attachment field on the form. I am not very familiar with that. I was always told that it bloats databases. Yet when I tested the process, it looked like the opening of the attached files where looking at a location in a folder.


So the question is, does the attached field bloat the database and make the 2GB limit a quick reach in a very short time?


Thank You


Jim Wagner

__._,_.___
Posted by: luvmymelody@yahoo.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

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

Re: [MS_AccessPros] Help with filtering report

 

Kat-


You don't need to change your code as long as you change the Row Source of the EmpName combo box.  What you need is a "null" or empty value  added to the list.

Row Source: 
SELECT Employees.EmpName, Employees.EmpName As Display
FROM Employees
UNION 
SELECT Null, "<All Employees>"
FROM Employees
ORDER BY 2;

Set the Bound Column to 1 and the Display Widths to 0"; 1.5"

If the user selects an employee name, the name will be returned by the combo box.  If the user selects <All Employees>, the box will go blank and return a Null value - which will keep your code from adding a filter.

John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
(Paris, France)




On Oct 3, 2016, at 10:53 PM, ka0t1c_ang3l <no_reply@yahoogroups.com> wrote:



Hello,


I have a form which has several unbound text boxes for start and end date, employee name, training class, and the form also has several option buttons for different reports.  One of the option buttons is for a report that will display training history for a specific employee.  Currently an employee name and training class must be selected from the combo box, and the option button for training history for specific employee option button must be selected, and the report will display the history for that employee and specified training class.  I would like the option to type in an "*" as a wildcard indicating all values, and when the training history for specific employee button is selected, it will open the report which will display all the training records for the selected employee.  This is the code i have currently for that option button:


Case Is = 8

     If Not IsNull(Me.EmpName) Then
          strWhere = strWhere & " AND [NAME] = """ & Me.EmpName & """ "
       End If
     If Not IsNull(Me.CDesc) Then
          strWhere = strWhere & " AND [Desc] = """ & Me.CDesc & """ "
       End If
       strReport = "R_TrnHist4SpecificEmp"


Any help is great appreciated!!

Thanks!

Kat



__._,_.___
Posted by: John Viescas <johnv@msn.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

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

[MS_AccessPros] Help with filtering report

 

Hello,



I have a form which has several unbound text boxes for start and end date, employee name, training class, and the form also has several option buttons for different reports.  One of the option buttons is for a report that will display training history for a specific employee.  Currently an employee name and training class must be selected from the combo box, and the option button for training history for specific employee option button must be selected, and the report will display the history for that employee and specified training class.  I would like the option to type in an "*" as a wildcard indicating all values, and when the training history for specific employee button is selected, it will open the report which will display all the training records for the selected employee.  This is the code i have currently for that option button:


Case Is = 8

     If Not IsNull(Me.EmpName) Then
          strWhere = strWhere & " AND [NAME] = """ & Me.EmpName & """ "
       End If
     If Not IsNull(Me.CDesc) Then
          strWhere = strWhere & " AND [Desc] = """ & Me.CDesc & """ "
       End If
       strReport = "R_TrnHist4SpecificEmp"


Any help is great appreciated!!

Thanks!

Kat

__._,_.___
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

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

Re: [MS_AccessPros] Simple Default value question

 

You are more than welcome!


John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
(Paris, France)




On Oct 3, 2016, at 9:29 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



Thank You John. 

I put =Year(Date()) in the Default value of the field on the table and put Long Integer for the Field size and it worked. 

Thank You for your help over all these years. 

 
Jim Wagner


On Friday, September 30, 2016 11:10 PM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


Jim-

Sometimes referencing an earlier calculated column alias in a query works, and sometimes it doesn't.  The SELECT part should be:

SELECT Date() As CurrentDate, Year(Date()) As CurrentYear

John Viescas, author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Access Applications

On Oct 1, 2016, at 01:02, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I just discovered something odd about this issue. I am taking this database over for someone that retired and there is a macro that has a delete query and then an append query that appends to a table. the SQL is below. Apparently the current year needs to be a number somewhere down the line for some reason or another. I have not gone that deep in the database yet. 

In the macro

Delete Query
the comment in the macro states the following
    deletes the LU table (LU_CurrentDateYear) of current date and current year field (this is so we don't have the date problem of coming in as text (Cdate thing)

DELETE LU_CurrentDateYear.*
FROM LU_CurrentDateYear;

Append query
the comment in the macro is
 populates the LU table (LU_CurrentDateYear) with today's date and the year part of that

INSERT INTO LU_CurrentDateYear ( CurrentDate, CurrentYear )
SELECT Date() AS CurrentDate, DatePart("yyyy",[CurrentDate]) AS CurrentYear;

 LU_CurrentDateYear table

the CurrentYear field has the following properties
Data Type: Number
Field Size: Long Integer




 
Jim Wagner


On Friday, September 30, 2016 3:32 PM, "luvmymelody@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
Hi all,

I am trying to make a field in a table to have a default value of the current year. I have tried a lot of variations like =Year(Now()) but I am getting 1905. 

Why is this happening?

Thank You

Jim Wagner







__._,_.___
Posted by: John Viescas <johnv@msn.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (5)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

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

Re: [MS_AccessPros] Simple Default value question

 

Thank You John.

I put =Year(Date()) in the Default value of the field on the table and put Long Integer for the Field size and it worked.

Thank You for your help over all these years.

 
Jim Wagner


On Friday, September 30, 2016 11:10 PM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
Jim-

Sometimes referencing an earlier calculated column alias in a query works, and sometimes it doesn't.  The SELECT part should be:

SELECT Date() As CurrentDate, Year(Date()) As CurrentYear

John Viescas, author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Access Applications

On Oct 1, 2016, at 01:02, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I just discovered something odd about this issue. I am taking this database over for someone that retired and there is a macro that has a delete query and then an append query that appends to a table. the SQL is below. Apparently the current year needs to be a number somewhere down the line for some reason or another. I have not gone that deep in the database yet.

In the macro

Delete Query
the comment in the macro states the following
    deletes the LU table (LU_CurrentDateYear) of current date and current year field (this is so we don't have the date problem of coming in as text (Cdate thing)

DELETE LU_CurrentDateYear.*
FROM LU_CurrentDateYear;

Append query
the comment in the macro is
 populates the LU table (LU_CurrentDateYear) with today's date and the year part of that

INSERT INTO LU_CurrentDateYear ( CurrentDate, CurrentYear )
SELECT Date() AS CurrentDate, DatePart("yyyy",[CurrentDate]) AS CurrentYear;

 LU_CurrentDateYear table

the CurrentYear field has the following properties
Data Type: Number
Field Size: Long Integer




 
Jim Wagner


On Friday, September 30, 2016 3:32 PM, "luvmymelody@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
Hi all,

I am trying to make a field in a table to have a default value of the current year. I have tried a lot of variations like =Year(Now()) but I am getting 1905.

Why is this happening?

Thank You

Jim Wagner




__._,_.___
Posted by: Jim Wagner <luvmymelody@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (4)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

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

Sabtu, 01 Oktober 2016

[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 (115)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
SPAM IS PROHIBITED

.

__,_._,___
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 (147)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

Please zip all files prior to uploading to Files section.

.

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