A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Home Version Access



 
 
Thread Tools Display Modes
  #11  
Old November 26th, 2006, 06:22 PM posted to microsoft.public.access.forms
accessdesigner
external usenet poster
 
Posts: 89
Default Home Version Access

(it was pretty much free... $23, lol... but I still want it to work)

"Granny Spitz via AccessMonster.com" wrote:

Rick Brandt wrote:
There is no "home version" of Access


The "home version" of Access is a fringe benefit of employees who work for
large companies. It's part of a licensing agreement from Microsoft (and
other software vendors who offer the same thing) where employees who have a
license for Office on their work computer can purchase (or get a free CD) of
the "home version" of retail Office to install on their home computers so
they can work at home. This often happens with antivirus software, since
many companies are willing to foot the bill for more secure computers on
their networks.

I don't know if they still mark them in newer versions, but you can tell you
have a home version of Access when you open a form in form view. There's a
red stripe across the top of the Detail section.

--
Message posted via http://www.accessmonster.com


  #12  
Old November 26th, 2006, 06:22 PM posted to microsoft.public.access.forms
ruralguy via AccessMonster.com
external usenet poster
 
Posts: 1,172
Default Home Version Access

Sorry to pound on you for the "Home Version" thing. Thankfully, Granny set
us all straight. Is the query NameThings bound to your form?

accessdesigner wrote:
Okay... too much emphasis on the use of the word home version... through my
job, I purchased the right to use MS Access on my home computer.. they mailed
me the software...im using it at home. however, when i practice using Access
at home, the same thing I did at work, doesnt work here at home...

when i used ......If Me.NameList = [NameThings].[NameLOOK] Then... an error
message read .....MS ACCESS CAN'T FIND THE FIELD 'l' REFERRED IN YOUR
EXPRESSION

when i used ..... If Me.NameList = NameThings.NameLOOK Then...an error
message read... OBJECT REQUIRED

Im trying to get a combobox selection from a form to match what is in my
query named NameThings, under the NameLOOK field...

I don't know what a "Home Version" of Access could possible be other than a
retail version of Access. It is probably a later version than you are using

[quoted text clipped - 21 lines]
End If
End If


--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200611/1

  #13  
Old November 26th, 2006, 06:31 PM posted to microsoft.public.access.forms
accessdesigner
external usenet poster
 
Posts: 89
Default Home Version Access

ty... ( need you all on speed dial.... lol)

my combobox is connected to :
SELECT Names.Name FROM [Names] ORDER BY [Name];
(thats a table where my list names scroll down from the combobox

The Query: NameThings .....is only connected to my Report

"ruralguy via AccessMonster.com" wrote:

Sorry to pound on you for the "Home Version" thing. Thankfully, Granny set
us all straight. Is the query NameThings bound to your form?

accessdesigner wrote:
Okay... too much emphasis on the use of the word home version... through my
job, I purchased the right to use MS Access on my home computer.. they mailed
me the software...im using it at home. however, when i practice using Access
at home, the same thing I did at work, doesnt work here at home...

when i used ......If Me.NameList = [NameThings].[NameLOOK] Then... an error
message read .....MS ACCESS CAN'T FIND THE FIELD 'l' REFERRED IN YOUR
EXPRESSION

when i used ..... If Me.NameList = NameThings.NameLOOK Then...an error
message read... OBJECT REQUIRED

Im trying to get a combobox selection from a form to match what is in my
query named NameThings, under the NameLOOK field...

I don't know what a "Home Version" of Access could possible be other than a
retail version of Access. It is probably a later version than you are using

[quoted text clipped - 21 lines]
End If
End If


--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200611/1


  #14  
Old November 26th, 2006, 06:40 PM posted to microsoft.public.access.forms
ruralguy via AccessMonster.com
external usenet poster
 
Posts: 1,172
Default Home Version Access

Well you can't say you don't get lots of help here, right? LOL

I'll drop out for a while and let the others bury you in fewer questions.

accessdesigner wrote:
ty... ( need you all on speed dial.... lol)

my combobox is connected to :
SELECT Names.Name FROM [Names] ORDER BY [Name];
(thats a table where my list names scroll down from the combobox

The Query: NameThings .....is only connected to my Report

Sorry to pound on you for the "Home Version" thing. Thankfully, Granny set
us all straight. Is the query NameThings bound to your form?

[quoted text clipped - 19 lines]
End If
End If


--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com

  #15  
Old November 26th, 2006, 06:48 PM posted to microsoft.public.access.forms
accessdesigner
external usenet poster
 
Posts: 89
Default Home Version Access

lol... true... but the delayed response time, and going back and forth on
things not directly related to the problem... and still trying to figure it
out while waiting for the solution.... and still not receiving the solution
QUICKLY, lol.... because logically it is supposed to work...
is quite disturbing.... just give me
your phone number lol...

"ruralguy via AccessMonster.com" wrote:

Well you can't say you don't get lots of help here, right? LOL

I'll drop out for a while and let the others bury you in fewer questions.

accessdesigner wrote:
ty... ( need you all on speed dial.... lol)

my combobox is connected to :
SELECT Names.Name FROM [Names] ORDER BY [Name];
(thats a table where my list names scroll down from the combobox

The Query: NameThings .....is only connected to my Report

Sorry to pound on you for the "Home Version" thing. Thankfully, Granny set
us all straight. Is the query NameThings bound to your form?

[quoted text clipped - 19 lines]
End If
End If


--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com


  #16  
Old November 26th, 2006, 10:10 PM posted to microsoft.public.access.forms
ruralguy via AccessMonster.com
external usenet poster
 
Posts: 1,172
Default Home Version Access

It looks like *everyone* stopped responding at the same time. If your
NameThings is only used in a report then you will need to use a Domain
function like DLookup() to retrieve data from that query.

accessdesigner wrote:
lol... true... but the delayed response time, and going back and forth on
things not directly related to the problem... and still trying to figure it
out while waiting for the solution.... and still not receiving the solution
QUICKLY, lol.... because logically it is supposed to work...
is quite disturbing.... just give me
your phone number lol...

Well you can't say you don't get lots of help here, right? LOL

[quoted text clipped - 13 lines]
End If
End If


--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200611/1

  #17  
Old November 27th, 2006, 12:01 AM posted to microsoft.public.access.forms
tina
external usenet poster
 
Posts: 1,997
Default Home Version Access

well, i don't know about anybody else, but i'm done trying to help anyone
who complains about the forum and the lack of a QUICK solution from unpaid
volunteers who have been giving up their Sunday leisure to try and figure
out what the situation is, so they can offer a working solution.


"ruralguy via AccessMonster.com" u12102@uwe wrote in message
news:69e197da1b34c@uwe...
It looks like *everyone* stopped responding at the same time. If your
NameThings is only used in a report then you will need to use a Domain
function like DLookup() to retrieve data from that query.

accessdesigner wrote:
lol... true... but the delayed response time, and going back and forth on
things not directly related to the problem... and still trying to figure

it
out while waiting for the solution.... and still not receiving the

solution
QUICKLY, lol.... because logically it is supposed to work...
is quite disturbing.... just give me
your phone number lol...

Well you can't say you don't get lots of help here, right? LOL

[quoted text clipped - 13 lines]
End If
End If


--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200611/1



  #18  
Old November 27th, 2006, 12:44 AM posted to microsoft.public.access.forms
John Vinson
external usenet poster
 
Posts: 4,033
Default Home Version Access

On Sun, 26 Nov 2006 09:31:02 -0800, accessdesigner
wrote:

ty... ( need you all on speed dial.... lol)

my combobox is connected to :
SELECT Names.Name FROM [Names] ORDER BY [Name];
(thats a table where my list names scroll down from the combobox

The Query: NameThings .....is only connected to my Report


The word Name is a bad Name to Name a field or a control, since both
tables and controls have a Name property already!

Try changing the table definition so that you're using a nonreserved
term in place of Name - or at the very least bracket it.

The difference between the home and work versions *MIGHT* be because
one of them has Name Autocorrect set in the database's Options, and
the other doesn't. IN my experience this misfeature should be turned
OFF.

Perhaps you could post the complete SQL of the NameThings query, with
some indication of the datatypes of the table fields.

John W. Vinson[MVP]
  #19  
Old November 27th, 2006, 02:08 PM posted to microsoft.public.access.forms
accessdesigner
external usenet poster
 
Posts: 89
Default Home Version Access

I may be slightly off, but I am not that crazy... I am extremely grateful for
your help,.... I'm just wondering why it wont work... LUV YA!!!

"tina" wrote:

well, i don't know about anybody else, but i'm done trying to help anyone
who complains about the forum and the lack of a QUICK solution from unpaid
volunteers who have been giving up their Sunday leisure to try and figure
out what the situation is, so they can offer a working solution.


"ruralguy via AccessMonster.com" u12102@uwe wrote in message
news:69e197da1b34c@uwe...
It looks like *everyone* stopped responding at the same time. If your
NameThings is only used in a report then you will need to use a Domain
function like DLookup() to retrieve data from that query.

accessdesigner wrote:
lol... true... but the delayed response time, and going back and forth on
things not directly related to the problem... and still trying to figure

it
out while waiting for the solution.... and still not receiving the

solution
QUICKLY, lol.... because logically it is supposed to work...
is quite disturbing.... just give me
your phone number lol...

Well you can't say you don't get lots of help here, right? LOL

[quoted text clipped - 13 lines]
End If
End If


--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200611/1




  #20  
Old November 27th, 2006, 02:11 PM posted to microsoft.public.access.forms
accessdesigner
external usenet poster
 
Posts: 89
Default Home Version Access

I will try that when I get back home.... I was trying to practice on my work
version, which still doesnt work:

strwhere = strwhere & "[queryobject.subject]LIKE ''*[Me.Combobox]*"

it still wont work.....

"John Vinson" wrote:

On Sun, 26 Nov 2006 09:31:02 -0800, accessdesigner
wrote:

ty... ( need you all on speed dial.... lol)

my combobox is connected to :
SELECT Names.Name FROM [Names] ORDER BY [Name];
(thats a table where my list names scroll down from the combobox

The Query: NameThings .....is only connected to my Report


The word Name is a bad Name to Name a field or a control, since both
tables and controls have a Name property already!

Try changing the table definition so that you're using a nonreserved
term in place of Name - or at the very least bracket it.

The difference between the home and work versions *MIGHT* be because
one of them has Name Autocorrect set in the database's Options, and
the other doesn't. IN my experience this misfeature should be turned
OFF.

Perhaps you could post the complete SQL of the NameThings query, with
some indication of the datatypes of the table fields.

John W. Vinson[MVP]

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:51 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.