Sabtu, 31 Maret 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 (165)

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, 30 Maret 2018

Re: [MS_AccessPros] Re: Learning SQL BE/Access FE

 

hi Marybeth,

I find using DSN files to be a good way to connect, especially for beginners. DSN stands for Data Source Name.

Make a file with NotePad or another text editor with the following (not the dashed lines):

-------------------------------------------
[ODBC]
DRIVER=SQL SERVER
UID=MyUserID
DATABASE=MyDatabaseName
SERVER=MyServerName
PASSWORD=MyPassword
-------------------------------------------

WHERE
DRIVER=SQL SERVER -- this is the basic driver for SQL Server. Others are faster, but this one should work if you don't know the exact name of another driver.
UID=your user ID.
DATABASE=the name of the database you want to connect to.
SERVER=the name of the server where the database is.
PASSWORD is not necessary if you are using Windows Authentication. If not, make MyPassword whatever your password is

Save this file. Call it something like MyDatabase.dsn where MyDatabase lets you know what database it is set up for.

After you close the file, if you used NotePad to make it, you will need to RENAME it to make the extension = dsn since Notepad always wants to use txt.

Now that you have a DSN file, you can use it to link to tables in that database from Access.
From the ribbon, choose: EXTERNAL Data.
Then click the ODBC Database icon� in the Import & Link group.
You have option buttons to Import or Link -- choose "Link to the data by creating a linked table"
OK
On the File Data Source tab, paste or type the complete path\file for the dsn in the box called "DSN Name". For instance:
C:\myPath\dsn\MyDatabase.dsn
OK
In the SQL Server Login dialog box, if you are using Windows* authentication, check the "Use Trusted Connection" box
OK
You should now see a list of tables you can connect to. Select which tables you want.
You may want to check the "Save Password" box.
OK

* also called Windows/Active Directory


have an awesome day,
crystal


On 3/29/18 9:46 AM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] wrote:

Hi Marybeth,


Can you tell us what rights/roles you have in the SQL database? Are you using an ODBC/DSN with your connection?


Are you using SQL authentication with a login and password or Windows/Active Directory authentication?


Regards,

Duane




From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Marybeth S Tomka marybeth.tomka@austin.utexas.edu [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Thursday, March 29, 2018 8:49 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Learning SQL BE/Access FE
�


Crystal,

�

I did try and link from Access and I couldn�t �see it� to select.� The migration isn�t working now either.� I really need some guidance.

�

Thanks in advance.

�

Marybeth

�

Re: Learning SQL BE/Access FE

Wed Mar�28,�2018 1:10�pm (PDT) .. Posted by:

"crystal 8" strive4peace2008

hi Marybeth,

>"I couldn't see in the access FE"

to have the table show in the navigation pane, you need to link to it
from Access.� Did you do that? Or try that?

have an awesome day,
crystal

On 3/28/18 2:43 PM, Marybeth S Tomka marybeth.tomka@austin.utexas.edu
[MS_Access_Professionals] wrote:
>
>
> Afternoon,
>
> Please forgive my ignorance in advance.� I have just split a database
> into an SQL BE and an access FE in order to have multiple users in the
> database.� We used a migration tool to do the split and with a few
> hiccups I can use it like I used to..� The other day I created a new
> table in the SQL BE and found that I couldn�t see in the access FE.
> Since I don�t have full rights to the server that the database lives
> on I am not sure if I don�t have rights to alter the connection or if
> I am attempting to make the connection incorrectly.� So I tried
> creating the table in the Access FE and migrating it to the BE.� Two
> of the four tables I wanted to add migrated just fine, the other two
> did not � �target does not exist� was not very helpful.� So my
> questions are since neither routine worked correctly, which would be
> the best way to add tables and second do you all have any ideas what
> went wrong with the two ways?
>
> Thank you in advance.
>
> Marybeth

�

�




__._,_.___

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 (6)

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.


.

__,_._,___

Kamis, 29 Maret 2018

Re: [MS_AccessPros] Re: Learning SQL BE/Access FE

 

Hi Marybeth,


Can you tell us what rights/roles you have in the SQL database? Are you using an ODBC/DSN with your connection?


Are you using SQL authentication with a login and password or Windows/Active Directory authentication?


Regards,

Duane




From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Marybeth S Tomka marybeth.tomka@austin.utexas.edu [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Thursday, March 29, 2018 8:49 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Learning SQL BE/Access FE
 


Crystal,

 

I did try and link from Access and I couldn't "see it" to select.  The migration isn't working now either.  I really need some guidance.

 

Thanks in advance.

 

Marybeth

 

Re: Learning SQL BE/Access FE

Wed Mar 28, 2018 1:10 pm (PDT) .. Posted by:

"crystal 8" strive4peace2008

hi Marybeth,

>"I couldn't see in the access FE"

to have the table show in the navigation pane, you need to link to it
from Access.  Did you do that? Or try that?

have an awesome day,
crystal

On 3/28/18 2:43 PM, Marybeth S Tomka marybeth.tomka@austin.utexas.edu
[MS_Access_Professionals] wrote:
>
>
> Afternoon,
>
> Please forgive my ignorance in advance.  I have just split a database
> into an SQL BE and an access FE in order to have multiple users in the
> database.  We used a migration tool to do the split and with a few
> hiccups I can use it like I used to..  The other day I created a new
> table in the SQL BE and found that I couldn't see in the access FE.
> Since I don't have full rights to the server that the database lives
> on I am not sure if I don't have rights to alter the connection or if
> I am attempting to make the connection incorrectly.  So I tried
> creating the table in the Access FE and migrating it to the BE.  Two
> of the four tables I wanted to add migrated just fine, the other two
> did not – "target does not exist" was not very helpful.  So my
> questions are since neither routine worked correctly, which would be
> the best way to add tables and second do you all have any ideas what
> went wrong with the two ways?
>
> Thank you in advance.
>
> Marybeth

 

 



__._,_.___

Posted by: Duane Hookom <duanehookom@hotmail.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.


.

__,_._,___

[MS_AccessPros] Re: Learning SQL BE/Access FE

 

Crystal,

 

I did try and link from Access and I couldn’t “see it” to select.  The migration isn’t working now either.  I really need some guidance.

 

Thanks in advance.

 

Marybeth

 

Re: Learning SQL BE/Access FE

Wed Mar 28, 2018 1:10 pm (PDT) .. Posted by:

"crystal 8" strive4peace2008

hi Marybeth,

>"I couldn't see in the access FE"

to have the table show in the navigation pane, you need to link to it
from Access.  Did you do that? Or try that?

have an awesome day,
crystal

On 3/28/18 2:43 PM, Marybeth S Tomka marybeth.tomka@austin.utexas.edu
[MS_Access_Professionals] wrote:
>
>
> Afternoon,
>
> Please forgive my ignorance in advance.  I have just split a database
> into an SQL BE and an access FE in order to have multiple users in the
> database.  We used a migration tool to do the split and with a few
> hiccups I can use it like I used to..  The other day I created a new
> table in the SQL BE and found that I couldn’t see in the access FE.
> Since I don’t have full rights to the server that the database lives
> on I am not sure if I don’t have rights to alter the connection or if
> I am attempting to make the connection incorrectly.  So I tried
> creating the table in the Access FE and migrating it to the BE.  Two
> of the four tables I wanted to add migrated just fine, the other two
> did not – “target does not exist” was not very helpful.  So my
> questions are since neither routine worked correctly, which would be
> the best way to add tables and second do you all have any ideas what
> went wrong with the two ways?
>
> Thank you in advance.
>
> Marybeth

 

 

__._,_.___

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 (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.


.

__,_._,___

Rabu, 28 Maret 2018

[MS_AccessPros] Re: Learning SQL BE/Access FE

 

Hi Marybeth (and others),


You might not want to include all of your private information in your postings. I don't know if it will cause any harm but if it's not pertinent to your question then you should probably delete the private signature stuff before posting.

Notice how Crystal nicely removed the information in her reply. Thanks....

Regards,
Duane


From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Marybeth S Tomka marybeth.tomka@austin.utexas.edu [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, March 28, 2018 2:43 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Learning SQL BE/Access FE
 


Afternoon,

 

Please forgive my ignorance in advance.  I have just split a database into an SQL BE and an access FE in order to have multiple users in the database.  We used a migration tool to do the split and with a few hiccups I can use it like I used to..  The other day I created a new table in the SQL BE and found that I couldn't see in the access FE.  Since I don't have full rights to the server that the database lives on I am not sure if I don't have rights to alter the connection or if I am attempting to make the connection incorrectly.  So I tried creating the table in the Access FE and migrating it to the BE.  Two of the four tables I wanted to add migrated just fine, the other two did not – "target does not exist" was not very helpful.  So my questions are since neither routine worked correctly, which would be the best way to add tables and second do you all have any ideas what went wrong with the two ways?

 

Thank you in advance.

 

Marybeth

 

__._,_.___

Posted by: Duane Hookom <duanehookom@hotmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

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] Learning SQL BE/Access FE

 

hi Marybeth,

>"I couldn't see in the access FE"

to have the table show in the navigation pane, you need to link to it from Access.  Did you do that? Or try that?

have an awesome day,
crystal

On 3/28/18 2:43 PM, Marybeth S Tomka marybeth.tomka@austin.utexas.edu [MS_Access_Professionals] wrote:

Afternoon,

 

Please forgive my ignorance in advance.  I have just split a database into an SQL BE and an access FE in order to have multiple users in the database.  We used a migration tool to do the split and with a few hiccups I can use it like I used to..  The other day I created a new table in the SQL BE and found that I couldn't see in the access FE.  Since I don't have full rights to the server that the database lives on I am not sure if I don't have rights to alter the connection or if I am attempting to make the connection incorrectly.  So I tried creating the table in the Access FE and migrating it to the BE.  Two of the four tables I wanted to add migrated just fine, the other two did not – "target does not exist" was not very helpful.  So my questions are since neither routine worked correctly, which would be the best way to add tables and second do you all have any ideas what went wrong with the two ways?

 

Thank you in advance.

 

Marybeth

 
 


__._,_.___

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 (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.


.

__,_._,___

[MS_AccessPros] Learning SQL BE/Access FE

 

Afternoon,

 

Please forgive my ignorance in advance.  I have just split a database into an SQL BE and an access FE in order to have multiple users in the database.  We used a migration tool to do the split and with a few hiccups I can use it like I used to..  The other day I created a new table in the SQL BE and found that I couldn’t see in the access FE.  Since I don’t have full rights to the server that the database lives on I am not sure if I don’t have rights to alter the connection or if I am attempting to make the connection incorrectly.  So I tried creating the table in the Access FE and migrating it to the BE.  Two of the four tables I wanted to add migrated just fine, the other two did not – “target does not exist” was not very helpful.  So my questions are since neither routine worked correctly, which would be the best way to add tables and second do you all have any ideas what went wrong with the two ways?

 

Thank you in advance.

 

Marybeth

 

Marybeth S. F. Tomka, M.A., PS Cert CM
Head of Collections
TARL       
The University of Texas at Austin
1 University Station R7500
Austin, Texas 78712
512-475-6853 direct line
512-232-6563 fax
512-471-5960 TARL main phone

www.utexas..edu/cola/tarl/
www.texasbeyondhistory.net

State Certified Repository

 

__._,_.___

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.


.

__,_._,___

Senin, 26 Maret 2018

Re: [MS_AccessPros] Querying From a Form Parameter

 

Greg,

Again, you should be including the previous replies in the thread so we know the issue(s).


What is your control source of the control that is displaying ?NAME? What is the Name of the control?


You should only store the product description in one field in one table. You can always display the description using the Column() property of the combo box.


However if you feel you have a need to maintain more than one copy of the description you can use the after update event of the combo box used to select the Product_No like:


Me.[Name of your Product Description Control] = Me.[Name of your Product No Control].Column(x)


x is the column number from the Row Source of the combo box. Column numbers begin with 0.


Duane Hookom




From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of xenon.blue@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, March 26, 2018 2:03 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Querying From a Form Parameter
 


Hi Duane,
My apologies for not being clear on the threads.
I have a form based on the Samples Table which uses a lookup query for the Prod_No. This Prod_No is used to query the Product Description and return the Product Description to a field in the same open form.

The idea is that when a Product_No is selected, a field on the form will automatically update the Product Description on the same form. It looks like it should work but returns a ?NAME value.

Greg


__._,_.___

Posted by: Duane Hookom <duanehookom@hotmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (8)

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] Querying From a Form Parameter

 

Hi Duane,
My apologies for not being clear on the threads.
I have a form based on the Samples Table which uses a lookup query for the Prod_No. This Prod_No is used to query the Product Description and return the Product Description to a field in the same open form.

The idea is that when a Product_No is selected, a field on the form will automatically update the Product Description on the same form. It looks like it should work but returns a ?NAME value.

Greg

__._,_.___

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

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] Querying From a Form Parameter

 

Greg,


Please make sure the significant parts of the thread are included in your replies.


I didn't expect the filter to be applied. I only wanted you to be able to see the value. This was only a single step in troubleshooting.


Now you mention filtering "Product Descriptions".  Are there any "lookup" fields in this query/table? 


You can find the parameters/data type in the query properties window.


Regards,

Duane




From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of xenon.blue@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, March 26, 2018 1:19 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Querying From a Form Parameter
 


Hi Duane,
Yes that does create a column in the query with the correct value listed beside every Product_No. However I was hoping to simply filter the Product Descriptions based on the Product_No to one value that could be read back to the open form.

Greg


__._,_.___

Posted by: Duane Hookom <duanehookom@hotmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)

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.


.

__,_._,___