Andrew- Most of us who answer questions on this forum have been programming for a long time. (I've been doing it for almost 60 years.) When you post...
98763
Robin Chapple
d9790
May 11, 2012 5:55 am
I have a database that uses a front end that is linked to an on line data source. I use a query to make a table so that I can make reports from fixed data. I...
98764
John Viescas
jlviescas
May 11, 2012 7:56 am
Robin- That code looks fine. What is the SQL of the two queries? John Viescas, author Microsoft Office Access 2010 Inside Out Microsoft Office Access 2007...
98765
Phil Knowles
pdk444444
May 11, 2012 9:20 am
Hi John  I already had the requery statement in the On Enter event of the shop field which I believe achieves the same as doing it in the AfterUpdate event...
98766
Clive
horastacatto
May 11, 2012 9:33 am
Hi John F, I have never done it but this looks like a good link, http://www.granite.ab.ca/access/email/lotusnotessample.htm Regards, Clive....
98767
Phil Knowles
pdk444444
May 11, 2012 9:56 am
Hi John  Thank you for that - I think the clearing of Use Special Keys may be OK but it would be better if I could do this programatically based on the user...
98768
Dennis Davidsson
dennisdavids...
May 11, 2012 10:20 am
Hello, Trying to open another form from my primary form by clicking a button I get the following error message from Access , which I cannot figure out how to...
98769
John Viescas
jlviescas
May 11, 2012 10:44 am
Phil- You need a Requery in the Current event of the form so that the Shop control updates when you move to a new company. You don't need the Requery in the...
98770
John Viescas
jlviescas
May 11, 2012 10:50 am
Phil- The link wrapped in the reply, so it's not complete. Try this: http://tinyurl.com/cxuju38 As for setting the option "on the fly," take a look at the...
98771
John Viescas
jlviescas
May 11, 2012 10:51 am
Dennis- You must enclose the criteria string in quotes. Try this: stLinkCriteria = "[Mässa Huvudtitel]=""" & _ ...
98772
Graham Mandeno
grahammandeno
May 11, 2012 10:52 am
Hello Dennis Because [Mässa Huvudtitel] is a text field, you must enclose 'BRAU Beviale' in either single or double quotes. These quotes need to be included...
98773
acravenrohm
May 11, 2012 12:01 pm
Using CStr() is a habit I developed sometime in the dim-and-distant past. And, again, the actual code does not use CStr() but does infact use: &...
98774
Phil Knowles
pdk444444
May 11, 2012 12:13 pm
Hi John  It would appear that the 'allowspecialkeys' option is only checked and applied when you open a database - and if you change the setting, it only...
98775
Dennis Davidsson
dennisdavids...
May 11, 2012 12:32 pm
Thanks Graham and John for your suggested solution to my problem! It solved my syntax problem correctly. However, then coming one step further in my debugging...
98776
Dan Fielding
amessyguy
May 11, 2012 12:36 pm
I'm wondering if it is possible to have too many Check Boxes even though that is the only way I can envision it. By way of an easy example, let's say I want...
98777
John Viescas
jlviescas
May 11, 2012 12:51 pm
Phil- Ah, I didn't check that. It means that you have to close and reopen the database for the setting to take effect. But "Allow Special Keys" (and any...
98778
John Viescas
jlviescas
May 11, 2012 12:51 pm
Dennis- Probably. You have to filter the bound value of the combo box, which is not necessarily what is displayed. For example, if it is bound to and ID...
98779
John Viescas
jlviescas
May 11, 2012 12:56 pm
Dan- One alternative would be to have a table that captures each individual option for an order, but that would then mean you would need to make all your check...
98780
Phil Knowles
pdk444444
May 11, 2012 1:00 pm
Hi John  I think I am getting there!!!  Everything seems fine now in form view and when I look in the table I can see that the ids for the appropriate...
98781
Dennis Davidsson
dennisdavids...
May 11, 2012 1:05 pm
Hi John, but that is not the case. I.e. the combo box is bound only to one column, and that is the very column called (Mässor Huvudtitel] containing the name...
98782
Phil Knowles
pdk444444
May 11, 2012 1:08 pm
Hi John  OK I can live with setting it manually but I still have a problem if what I said before is happening.  ie I set the value. I then have to close...
98783
Robert Peterson
dandbpeterson
May 11, 2012 1:20 pm
Hi, These last comments suggest to me that your database is not split. Do you have a "back end data" file and a "front end forms and code" file? If not you...
98784
Phil Knowles
pdk444444
May 11, 2012 1:26 pm
Hi Bob  Thanks for joining in.  My db is not split. I have not weighed up the pros and cons of splitting and so far it doesn't seem to have been an issue. ...
98785
John Viescas
jlviescas
May 11, 2012 1:32 pm
Dennis- Yes, the field must be in the Record Source. It sounds like your combo box has not Control Source. Is that the case? John Viescas, author Microsoft...
98786
John Viescas
jlviescas
May 11, 2012 1:33 pm
Phil- Oh, my! It sounds like you have multiple users sharing one copy of the "code" part of the database. You should NEVER do that. Each user should have...
98787
John Viescas
jlviescas
May 11, 2012 1:33 pm
Phil- There's only one copy of the combo box in the form even though you can see one on each row. When you move to a new row, the filter gets applied for the...
98788
John Marshall
lancucka
May 11, 2012 1:34 pm
Rather than Check boxes, why not drop down lists? If you ever decide to add another option, then the drop down list can be easily modified. Adding a new check...
98789
Dennis Davidsson
dennisdavids...
May 11, 2012 1:48 pm
John, The combo box has the column [Mässor Huvudtitel] in the table Mässor as Control source. And has as Record source the query: SELECT [Mässor Huvudtitel]...
98790
ka0t1c_ang3l
May 11, 2012 1:57 pm
I have a query with several fields that have the criteria "true" so that if the record has that field checked it will display on my report. My question is...
98791
jfakes.rm
May 11, 2012 2:00 pm
John Visio, I agree with you. I love using drop down lists. My users are always wanted all sorts of reports (usually on a word in a memo field) so I try to...
