Ingrid, The problem faced by you is attributable to an interesting quirk associated with report instances. When a report instance is opened (say by using New...
A.D. Thanks for the extra insight. I've used multiple instances of a report, but filter each based on a form's selection such as viewing several departments...
Woooooooo it works! What's silly is I tried something similar to this only I tried to set the conditional formatting with code (so I could customize the color)...
Which operating system? Fully patched? John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access Applications Microsoft Office...
I'm in contact with someone at MSFT support, and he's scratching his head. Not a reported problem. Do you have any problem browsing to a file in any of the...
In this group we post on top of the threads. Can you please do this, too? Thanks. It makes it easier to read the threads. Now about your issue. Could it be you...
Hello everyone, I have two Combo Boxes that I've made required. When the user goes into the form to populate the two fields and save, they are told that the...
Hi Dawn, What are the data sources for the ComboBoxes? Do you have a table(or a query), a ValueList, or a FieldList for each Combo's RowSource with the Bound ...
I am using Microsoft Office Access 2003 SP3 on a Sony Vaio 175mgz 512 RAM Windows XP Home SP3 I am trying to insert an OLE Object into a table and I am getting...
Hi Lee, [GrpID] would be the name of your primary key field. As I name controls the same as what they contain if they are bound, it may also be the control...
Darwin- Do you have Nortin AntiVirus installed? http://support.microsoft.com/kb/295824 John Viescas, author Microsoft Office Access 2007 Inside Out Building...
You are most welcome Bill! As rightly practiced by you, use of multiple instancing needs careful handling. Developers, on first encountering this feature, are...
Hi All As the title suggests I would like to update a value on record to the value contained in a different, related table. The scenario is new account...
Hi Dawn, with all due respect, you did not answer Clive's question ... that is ok, though What we need to know is WHAT the RowSource property is set to for...
I have to build an application that links to an Excel table that is generated by a different application. This table would be generated every time someone...
Patti- It's not code. Open your table in Design view. Open the Indexes window. On a blank line, type a name for your key, select the name field, and set ...
Dawn- OK, what's in the Row Source? If a query, please post the SQL. And what is the Bound Column value and the Control Source of each combo box? John...
Unless you want to capture the values from the agents table at the time the new account is created, you should always do a join with the agent table to get...
I know I've done this before but for the life of me I can't remember how. On a continuous form, I want to make the last value entered the default for new...
Bill- Me.txtLastName.DefaultValue = """" & Me.txtLastName & """" John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access...
I do not use Norton AntiVirus, I use AVG 8.0 for antivirus and ZoneAlarm Pro 7.0 for a firewall. I keep these up to date and I run AVG once a week, minimum. I...
Well, duh! Thanks, John. Regards, Bill From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas...
One more note of interest. I am able to place an OLE (the same one I tried to place in my db) in Word and Excel without any problem. I also tried to insert an...
Bill, This is something that has always bugged me too with bound forms. I saved this message when I saw it and just tried it. It works great! I love it! Thanks...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
