Sabtu, 30 Juni 2018

[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 (168)

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.

.

__,_._,___

Jumat, 29 Juni 2018

[MS_AccessPros] Query: Make EndDateTime of a record the StartDateTime of next record

 

Hi,


I have a query that lists products in the sequence they are to be manufactured.  I calculate the time it will take to make each product (multiply individual per piece time times the quantity, result is in minutes).  I have 2 calculated columns at the end, one is StartDateTime (set to now()) and EndDateTime (calculated using dateadd function, adding the manufacturing minutes to the StartDateTime column.   This tells me if I started all products at now(), I would complete each product at some calculated time.


Problem is, I make the products in sequence, not at the same time.


How can I make the EndDateTime of record number one, become the StartDateTime for record number two, EndDateTime of record number two the StartDateTime for record number three and so on all the way to the last record.


Any suggestions?  I'll really appreciate this!


__._,_.___

Posted by: lrheimpel@gmail.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.


.

__,_._,___

Selasa, 26 Juni 2018

Re: [MS_AccessPros] Calendar tool

 

Hi Giorgio,

I am working an another project and won't be able to help with this anytime soon, sorry -- one reason I hesitated to post it! But please realize this is just a starting point. Things could be better!  Maybe someone else will jump in if you can't get it alone. Realize I spent many, many hours building this ...so investing a few hours to understand it is required. I would even need to put an hour in to refresh my mind!

The subform implementation uses a subset of the popup form, and has a few minor changes -- so the popup would be the version I suggest you change -- it works better too. Study how it was changed from a popup to a subform -- what is different?

have an awesome day,
crystal


On 6/26/18 10:14 AM, giorgio_rovelli wrote:
So I've uploaded a file GRTN for Crysta.mdb in the Assistance Needed folder.
The startup form compares Microsoft Active X calendar with yours.
I've made your subform unbound and here are 4 issues:

Make your calendar display the current date when you open the form that hosts it; it positions itself on the correct month and year but the wrong day is highlighted.

 

The button named Insert Date on the form, when clicked, creates 24 new records for the day you select on the calendar:

Private Sub Comando50_Click()

    On Error GoTo aa

    Dim rst As New ADODB.Recordset

    Dim cnn As ADODB.Connection

    Dim i As Integer, a As Integer

    Set cnn = CurrentProject.Connection

    rst.Open "Consuntivo", cnn, adOpenKeyset, adLockOptimistic

    For i = 0 To 23

        rst.AddNew

        rst!Giorno = CGior.Value

        rst!Ora = i

        rst.Update

    Next i

But I'm not sure what to use in place of CGior.Value where CGior identifies the ActiveX calendar.

 

The activeX calendar has an event Private Sub CGior_AfterUpdate() that positions the form's cursor on the record corresponding to the date selected on the calendar. How can you do that with your calendar? Maybe you can achieve that by adding code to the click event for each button on your calendar.

 

The day numbers in the outer columns of your calendar aren't bolded like the central ones.




__._,_.___

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

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.


.

__,_._,___

RE: [MS_AccessPros] OT: clock -- from: Retain only the letters and numbers in a string

 

So I've uploaded a file GRTN for Crysta.mdb in the Assistance Needed folder.
The startup form compares Microsoft Active X calendar with yours.
I've made your subform unbound and here are 4 issues:

Make your calendar display the current date when you open the form that hosts it; it positions itself on the correct month and year but the wrong day is highlighted.

 

The button named Insert Date on the form, when clicked, creates 24 new records for the day you select on the calendar:

Private Sub Comando50_Click()

    On Error GoTo aa

    Dim rst As New ADODB.Recordset

    Dim cnn As ADODB.Connection

    Dim i As Integer, a As Integer

    Set cnn = CurrentProject.Connection

    rst.Open "Consuntivo", cnn, adOpenKeyset, adLockOptimistic

    For i = 0 To 23

        rst.AddNew

        rst!Giorno = CGior.Value

        rst!Ora = i

        rst.Update

    Next i

But I'm not sure what to use in place of CGior.Value where CGior identifies the ActiveX calendar.

 

The activeX calendar has an event Private Sub CGior_AfterUpdate() that positions the form's cursor on the record corresponding to the date selected on the calendar. How can you do that with your calendar? Maybe you can achieve that by adding code to the click event for each button on your calendar.

 

The day numbers in the outer columns of your calendar aren't bolded like the central ones.



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

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.


.

__,_._,___

[MS_AccessPros] New file uploaded to MS_Access_Professionals

 

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the MS_Access_Professionals
group.

File : /2_AssistanceNeeded/grtn for Crystal.zip
Uploaded by : giorgio_rovelli
Description : Crystal Calendar vs Microsoft Active X Calendar

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/MS_Access_Professionals/files/2_AssistanceNeeded/grtn%20for%20Crystal.zip

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

giorgio_rovelli

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

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.


.

__,_._,___

RE: [MS_AccessPros] OT: clock -- from: Retain only the letters and numbers in a string

 

Thanks Crystal, your calendar looks very promising; I'll have a go at it and report back :-)

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

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.


.

__,_._,___

[MS_AccessPros] Re: Problem with SQL backend access frontend using table source as v

 

Sorry for the delay in answering – I was out of town for a few days.

 

Brian,

 

I think your question is the 64,000 dollar one.

 

Bill,

 

I don’t understand why you need the “make table” SQL statement.  I am joining tables not creating a new one from the tables

 

Marybeth

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, June 21, 2018 4:32 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Digest Number 9100

 

Yahoo! Groups

MS Access Professionals Group

5 Messages

Digest #9100

1a

Re: Problem with SQL backend access frontend using table source as v by "Brian Battles" brianbattlesws1o

1b

Re: Problem with SQL backend access frontend using table source as v by "Marybeth S Tomka" mstomka

1c

Re: Problem with SQL backend access frontend using table source as v by wrmosca

2a

Messages

1a

Re: Problem with SQL backend access frontend using table source as v

Wed Jun 20, 2018 7:05 am (PDT) . Posted by:

"Brian Battles" brianbattlesws1o

Have you got the proper primary keys and indexes defined in your new back-end SQL Server tables?

Brian Battles WS1O

954 High Path Rd
Windsor, CT 06095 USA

860-707-7021

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

1b

Re: Problem with SQL backend access frontend using table source as v

Wed Jun 20, 2018 7:38 am (PDT) . Posted by:

"Marybeth S Tomka" mstomka

Morning,

Follow up on my posting from yesterday. I create a unique constraint on the field that I am trying to link the tables with and now I get a message about foreign key violates "alter table" functions. Really could use some help here.

Marybeth


From: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com> [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, June 20, 2018 4:32 AM
To: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>
Subject: [MS_AccessPros] Digest Number 9099

[Yahoo! Groups]<https://groups..yahoo.com/neo;_ylc=X3oDMTJkbzhkYTc5BF9TAzk3MzU5NzE1BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwNmdHIEc2xrA2dmcARzdGltZQMxNTI5NDg3MDk5>
MS Access Professionals Group <https://groups.yahoo.com/neo/groups/MS_Access_Professionals/info;_ylc=X3oDMTJkY3QyNnNtBF9TAzk3MzU5NzE1BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwNoZHIEc2xrA2hwaARzdGltZQMxNTI5NDg3MDk5>
1 Message
Digest #9099
1
Problem with SQL backend access frontend using table source as value by "Marybeth S Tomka" mstomka
Message
1
Problem with SQL backend access frontend using table source as value <https://groups.yahoo.com/neo/groups/MS_Access_Professionals/conversations/topics/117651;_ylc=X3oDMTJzZmw2ajdnBF9TAzk3MzU5NzE1BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBG1zZ0lkAzExNzY1MQRzZWMDZG1zZwRzbGsDdm1zZwRzdGltZQMxNTI5NDg3MDk5>
Tue Jun 19, 2018 11:15 am (PDT) . Posted by:
"Marybeth S Tomka" mstomka <mailto:marybeth.tomka@austin.utexas.edu?subject=Re%3A%20Problem%20with%20SQL%20backend%20access%20frontend%20using%20table%20source%20as%20value>
Good afternoon, I really hope you all can help me resolve an issue I am having. I recently migrated an access database to a SQL backend and an access front end. In the original access database I had a form with a subform that calculates the costing for a service. Several of the fields are linked to a value list table to control entries as well as not storing these service values in the data table. Now I can't add records through the subform or the main form with the subform activated. I think it must have something to do with the relationship between the tables, but I can't get them to be a one-to-many and I have tried all the usual suspects for error trapping. What is a not so obvious reason for not linking correctly?

Marybeth

Reply to sender <mailto:marybeth.tomka@austin.utexas.edu?subject=Re%3A%20Problem%20with%20SQL%20backend%20access%20frontend%20using%20table%20source%20as%20value> . Reply to group <mailto:MS_Access_Professionals@yahoogroups.com?subject=Re%3A%20Problem%20with%20SQL%20backend%20access%20frontend%20using%20table%20source%20as%20value> . Reply via Web Post <https://groups.yahoo.com/neo/groups/MS_Access_Professionals/conversations/messages/117651;_ylc=X3oDMTJzNjJsbWp1BF9TAzk3MzU5NzE1BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBG1zZ0lkAzExNzY1MQRzZWMDZG1zZwRzbGsDcnBseQRzdGltZQMxNTI5NDg3MDk5?act=reply&messageNum=117651> . All Messages (1) <https://groups.yahoo.com/neo/groups/MS_Access_Professionals/conversations/topics/117651;_ylc=X3oDMTM5b3EwYmRvBF9TAzk3MzU5NzE1BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBG1zZ0lkAzExNzY1MQRzZWMDZG1zZwRzbGsDdnRwYwRzdGltZQMxNTI5NDg3MDk5BHRwY0lkAzExNzY1MQ--> . Top ^
Visit Your Group<https://groups.yahoo.com/neo/groups/MS_Access_Professionals/info;_ylc=X3oDMTJlbWZsbzJsBF9TAzk3MzU5NzE1BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwN2dGwEc2xrA3ZnaHAEc3RpbWUDMTUyOTQ4NzA5OQ-->
[Yahoo! Groups]<https://groups.yahoo.com/neo;_ylc=X3oDMTJkbzhkYTc5BF9TAzk3MzU5NzE1BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwNmdHIEc2xrA2dmcARzdGltZQMxNTI5NDg3MDk5>
* Privacy<https://info.yahoo.com/privacy/us/yahoo/groups/details.html> * Unsubscribe<mailto:MS_Access_Professionals-unsubscribe@yahoogroups.com?subject=Unsubscribe> * Terms of Use<https://info.yahoo.com/legal/us/yahoo/utos/terms/>

Marybeth


Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

1c

Re: Problem with SQL backend access frontend using table source as v

Wed Jun 20, 2018 11:34 am (PDT) . Posted by:

wrmosca

Using the SQL Server management studio, right-click on the table and select Script>Create Table>New query window. Copy and paste the "Make Table" SQL here so we can see what the script is doing to make the table.


FYI - You might want to remove all your contact info in your email signature to prevent spammers from getting it.



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 http://wrmosca.wordpress.com






---In MS_Access_Professionals@yahoogroups.com, <marybeth.tomka@austin.utexas.edu> wrote :

Morning,

Follow up on my posting from yesterday. I create a unique constraint on the field that I am trying to link the tables with and now I get a message about foreign key violates “alter table” functions. Really could use some help here.

Marybeth

Marybeth S. F. Tomka, M.A., PS Cert CM

State Certified Repository

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, June 20, 2018 4:32 AM
To: MS_Access_Professionals@yahoogroups.com mailto:MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Digest Number 9099

https://groups.yahoo.com/neo;_ylc=X3oDMTJkbzhkYTc5BF9TAzk3MzU5NzE1BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwNmdHIEc2xrA2dmcARzdGltZQMxNTI5NDg3MDk5
MS Access Professionals Group
1 Message Digest #9099
1
Problem with SQL backend access frontend using table source as value by "Marybeth S Tomka" mstomka
Message 1 Problem with SQL backend access frontend using table source as value Tue Jun 19, 2018 11:15 am (PDT) . Posted by: "Marybeth S Tomka" mstomka Good afternoon, I really hope you all can help me resolve an issue I am having. I recently migrated an access database to a SQL backend and an access front end. In the original access database I had a form with a subform that calculates the costing for a service. Several of the fields are linked to a value list table to control entries as well as not storing these service values in the data table. Now I can't add records through the subform or the main form with the subform activated. I think it must have something to do with the relationship between the tables, but I can't get them to be a one-to-many and I have tried all the usual suspects for error trapping. What is a not so obvious reason for not linking correctly?


 

__._,_.___

Posted by: Marybeth S Tomka <marybeth.tomka@austin.utexas.edu>
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.


.

__,_._,___

Re: [MS_AccessPros] Calendar tool

 

ps,

your idea to define properties so the calendar form can return values with an assignment is interesting! Well all the source code is there ... maybe you will do that and share your modified version back?

thanks, Giorgio

have an awesome day,
crystal


On 6/26/18 8:21 AM, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] wrote:

hi Giorgio,

just uploaded an example of a mainform with a calendar subform used 3 times.  The dates displayed are tied to values in a table, although they can be unbound too. 

This is a version of the calendar popup that was posted July 1, 2012, that you can also download from my Files list.

https://groups.yahoo.com/neo/groups/MS_Access_Professionals/files/Crystal/

If you examine the code behind the calendar form, you will see the first procedure, Update_ExternalForms, is to do stuff on other forms after the date is picked

have an awesome day,
crystal

On 6/26/18 3:28 AM, giorgio_rovelli wrote:
Speaking of useful adjuncts to Access, how about a calendar (to replace the sorely missed Microsoft active X Calendar) which could work in Access 64 bit as well? Personally I'd need a calendar that:
1) stays always open(unless the DatePicker that's been introduced since 2007)
2) isn't a pop up form
3) responds to events such as selecting a date and have the form hosting it move to the record corresponding to the selected date.
4) returns a value that can be used in subs, like 
rst!Giorno = CGior.Value 
where CGior is the calendar object





__._,_.___

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

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.


.

__,_._,___

Re: [MS_AccessPros] Calendar tool

 

hi Giorgio,

just uploaded an example of a mainform with a calendar subform used 3 times.  The dates displayed are tied to values in a table, although they can be unbound too. 

This is a version of the calendar popup that was posted July 1, 2012, that you can also download from my Files list.

https://groups.yahoo.com/neo/groups/MS_Access_Professionals/files/Crystal/

If you examine the code behind the calendar form, you will see the first procedure, Update_ExternalForms, is to do stuff on other forms after the date is picked

have an awesome day,
crystal

On 6/26/18 3:28 AM, giorgio_rovelli wrote:
Speaking of useful adjuncts to Access, how about a calendar (to replace the sorely missed Microsoft active X Calendar) which could work in Access 64 bit as well? Personally I'd need a calendar that:
1) stays always open(unless the DatePicker that's been introduced since 2007)
2) isn't a pop up form
3) responds to events such as selecting a date and have the form hosting it move to the record corresponding to the selected date.
4) returns a value that can be used in subs, like 
rst!Giorno = CGior.Value 
where CGior is the calendar object




__._,_.___

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

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.


.

__,_._,___