Hi everyone, I want to create a image map in my form. I have my picture of country map. And it devide into provinces. So I need to click on each province to...
... The type of DB I'm working on is a Chemical Inventory DB for the research lab I work at. The idea is that when someone selects a particular chemical (from...
I've got a command button on a form in my Switchboard that will print a report based on the input provided via query, which requires multiple input to get the...
Bill, The primary sort on the query is by Test Type which is not unique. Also, because the db is replicated, the TestID field is an Autonumber with Random...
Jim, Simply remove the WHERE clause from your query. Darrell ... the ... stDocIdJim ... define ... tries ... the ... one ... Jim C ... particular ... that ... ...
Hi, It turned out that it needed an Nz at the sums because sometimes it adds up to zero. Only took me three hours to figure that out, ugh. You can be so proud...
Hi Bill I was able to reproduce this in Northwind, both with a UNION query that I created and also with the existing query "Customers and Suppliers by City." ...
Darrell Maybe I can come up with another way, but tell me, why would you use a random autonumber with a replicated database? You should be using a GUID to...
Irene Glad to have been of some help although I can't remember which post that was. Too many boards, too little memory. :O) And I'm glad you will have "Access"...
Thanks, Tedd. I dont' have 2002, bu ti do have 2000 and 2003. I'll test this in both versions. Bill ... (BEFORE ... or ... Design ... the ... MVPs. ... if I ...
Darrell, Just wanted to ascertain whether you happened to connect my previous post (message #40953 of 01-Sep-2006). Method A demonstrated in my sample db named...
I created a query where I pulled in a memo field (set-up for 255 characters). My query is cutting off the memo field at 250 characters any ideas on how to...
A.D., I'm not trying to change the BE, I want to move the current mdb file that is the BE to a different folder named SynchError because an error occurred ...
Why would you set up a memo field for 255 characters? Why not use a text field? A memo field is for thousands of characters. Just wondering. Tom Ewald ...
Suzanne This is a very common bug. Is your query an aggregate (Totals) query? if so, remove the memo field from the query, save it and then create another...
Tom I think Suzanne means the query is truncating her memo field at 250 characters. Regards, Bill Mosca, Microsoft Access MVP Founder, MS_Access_Professonals ...
Tedd Thanks. The same thing happens in 2003. I'll report it...or at least notify someone who knows how to report it. I'm still new at this MVP thing. :O) bill ...
Yes, that is what I mean (truncated) - the field in our database is set for 1,000 characters. Thanks, Bill, I will try your suggestion. Suzanne ... 250 ... ...
WOW! I discovered a bug in a release version of Access. Does that mean I get some sort of certificate, like astronomers get to name comets when they discover...
Hey all I recently stumbled upon a situation that at first perplexed me, and having resolved it, I thought it might be useful to others who might encounter...
I'll name my dog after you. Does that work? :O) I've found bugs & reported them, but they never even got fixed. I guess you have to catch them early. Bill ... ...
Glad you sorted it out, Tedd, but it would have been better to do the linking only in the FE. You can link the FE to several BEs, not just one. Bill ... and ...
Hi, I have a simple database with a Table that contains the result of a Survey. The Survey form has 5 fields for an area called "Themes". So the user can...
I think I understand what you are saying, but it would not apply with the configuration I'm using. The database that I was having trouble with (a single-user...
Tedd I'm curious as to why you would link to a split DB instead of linking directly to the source. Can you explain? Bill ... with ... not ... when ... do ... ...
Hi Grant, I have uploaded '060901_AutofillFixed.zip' for you to look at. I think that it would be worth your while to find a typical Stock Control database to...
Jeremy Without getting into normalized tables (which would have eliminated all these unions to start with) you can run a Totals query on your union query to...
Hi, I have three different report options when I create my filter. But suddenly it doesn't recognize the filter. So I placed it into the Open Report Sub and it...
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.
