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. |
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|