Search results

I know this is an old post, but I was just trying to do the same thing, and thought I'd share my solution. I place a label on the main form above the subform instead of using the subform label. Then, in the Form_Current event on the main form, I place the following code: If...

Hey there, Don't know how long you've been waiting for an answer, but I was trying to do this very thing and saw your thread. If this helps, this is what I did to achieve the same results In a VBA Module, I created a function, with the entires like so: Function InsertValues()...

I'd agree the refereeing has been a bit spotty - reds against Klose and Kaka for example - and one game with 9 yellows? That seems a bit much - these aren't particularly violent teams. I always try to appreciate the perspective of the officials, but sometimes they make it really hard. And...

Fun to look at this now with both France and Italy headed home after the group stage. Too bad for Australia and New Zealand, would have liked to see either side go through and they played well - esp. the Kiwis with amateurs on their side - how cool is that.

www.missing-u.ca. All the missing persons names are in the database, but none of those names are indexed by any search engine. That's what I'd like to achieve.... Thanks for looking, and for any hints. Don

I'm new to the website game, but have built several static brochure-type sites and recently my first data-driven asp site. It works well, but I have no idea how to get search engines to index the data that's in the database. For example, if someone googles an item that matches an item in my...

If you have your manager's email address and name in a table, use the manager's ID field as the value in the combo box, then on button click either do a DLOOKUP or run a query to retrieve the email address and use it as the recipient in your mail object.

Sheesh.... I figured it out myself *sorry* -- but I just added a Label and used the On No Data Event to set the value of the label to "No matching records" and then make either the text box with the Count visible, or my label visible, depending on the case. This might help someone else...

Corollory .... I have a similar situation, although in some cases I have a subreport that has no matching records, in which case I receive an "#Error" instead of a count of 0 .... Any help would be gratefully accepted!

Thanks! Matt, that looks like it worked -- thank you very much! Now, I have too many results, but that's another problem and I think I can solve it! Thanks again, that worked a treat. Don

Greetings all: I have a database tracking customers and inventory, and I've tried to add in a feature where I can meet customers needs with future inventory. Key to this process is three tables: tblCustomer - containing my customer information tblInventory - with inventory data including a...

Thanks! EMP, and to Jon by proxy -- that worked a treat. I am sorry I missed Jon's example in my searches, this is exactly what I needed. As usual, my indebtedness to the forum grows. Thanks ever so much.

Greetings, I am trying to write a parameter query ... I have multiple fields the users *could* search, but they may want to search only one, and I am having a struggle figuring this out. Ex. fields to search are Gender, Age, Date, etc., and I have created a parameter query that includes...

Hi Carol, I see this is a pretty old thread, so maybe you've already fixed it, but I've seen this before with a corruption of the form. I'd suggest this: 1) copy all of your code supporting the form out to a text file. 2) on the form properties, go to the property tag (on the other tab) that...

I'm just posting to see if anyone has a found a solution to this -- I am having exactly the same problem. I open Excel, drop some data in, close the file, do what I think is necessary to close the application, and the instance of Excel hangs around. I am using Access2K on Windows 2KPro ...

Regardless of how smart Selena is, and how many Greek letters she amasses behind her name, it's a very clever math trick, and Selena deserves kudos for her accomplishments.

Again, Juan, well said. I have found this site invaluable -- I've been a member over three years -- and visit almost daily, whether I have a question, or with the intention/hope of answering one. I'd like to think I've helped some people out, too, sharing some things that I have done. I am a...

Fear Naught, how right you are - a slip of the key (or something like that) when copying over. Hopefully, this works for DCXtreme

You need a join in your query to have the two tables work together. It will look something like this: SELECT Customer.membershipNo, MAX(Attendance.AttendDate) As MaxDate FROM Customer INNER JOIN Attendance ON Customer.membershipno = Attendance.membershipno HAVING...

I don't think you need to do DMAX, just write a query like this: SELECT tblMember.MemberID, tblMember.AttendDate FROM tblMember WHERE (((tblMember.AttendDate)>Date()-14)); Assuming tblMember is where your data is, MemberID uniquely identifies your members, and AttendDate is the date they came...