Search results

Thank you John, I don't think that works. While your report shows the correct total there are not totals for the "SalesQTY" and "SalesDollar". Thes feilds are the "many" part of the one-to-many relationship which should show up in the query results and also causes multiple results in the query...

Here you go...

Thanks for the help guys! I have tried the structure as suggested with no change in results :( I have attached a sample database to make it easier as suggested. If you run the report you will see what I mean I hope! I will also want to total the "SalesQTY" and the "SalesDollar" fields by...

Hello, I should know how to do this by now, but reporting is one of my weak spots :( My report groups: Campaign District Basic info: This is a mailing tracking database. We mail letters out and track results. The main form contains a field called "MailListSize" (number of letters sent), there...

Worked like charm! Thank you

The query has a 2 tables, one called tblMSR and it contains a field called "MailListSize" and the other table is a detail table called tblCampaigns. if the detail table only has one item then of course the "MialListSize" shows onece, but if the detail table has 2 records in it then the...

Thank you for the reply Bob. I am not very experienced at code and least of all debugging, but I gave it a try. I commented out anything that said "on error" which were 2 instances on the first code set and then the 1 instance on the second code set (at the bottom). Then I ran the debugger and...

Hello, I have a some code from the following site that keeps giving me a "type mismatch" error. I have used this code with sucess quite a while ago and don't remember having this sort of problem. The code is supposed to look at column A and based on unique values make new sheets within the...

I would use the macro recorder to start with as it would allow you to see the code generaated from your actions, providing a great learning experience.

Thank you 2.0! I did find an excel solution that works very well and wanted to get back to others who may be looking to do this same thing. This solution however is an add-in, so I will disect it later to learn from it. But I must say it works VERY well. Here's the link to the add-in along...

Append from multiple workbooks I have looked around and can't seem to find a solution... I have a folder with many workbooks that are all layed out the same, with 1 worksheet that has three columns of data with varied row counts. I would like to copy each workbooks contents starting at cell...

Thank you, I will check it out. My intent is to use it like in(bob,dave,rob...) but the list of names would be from the text file. I could see where it would not be used too much, but I was just wondering.

Just a general question... Is there a way to have the contents of a text file become included in a query. Say I have a list of names in a text file like: Bill Bob Chuck... Can I connect to that file and have the names be part of the query? Thank you!

Thanks again for the input. You pretty much confirmed everything I was thinking on the subject. I have played around with replicating, but am a bit hesitant as I can see it wold be a pain to manage and have noticed a few quirks. Thank you

Thank you for the food for thought guys! I started thinking of different approaches and one thought occured to me. Since I do have a shared network (but very slow)...what if I did not give the dataentry form a control source, that would eliminate any query being run as the form starts up. Then...

Thank you guys! I work for a very large company, so as they plan to get rid of something they are less than receptive regarding adding new things. We do have a shared network, but the isssue is speed. If I use the shared drive using the database is unacceptably slow (but it does work). Maybe...

Hello, At work we have Citrix which is like a shared desktop on a network. Our company will most likely be getting rid of it soon and we have many Access applications that we share. I have heard about replicating, but never used it and would like to know your thoughts on it. We currently...

Sorry it took so long to get back (they're killin' me here!). A combobox has a control source, I thought the control source could do 2 different things... 1.) point to the field you want to store the data in once you pick it from the list in the combobox. 2.) have a function like "date()" and...

This works fine: This is handled: The combobox is already doing this, I have the control source on the combobox set to "MSRCampaignID" which as I undestand it is what takes the "campID" value from the campaign table and moves it to the "MSRCampaignID" in to tblMSREntry (?) See note above...

Hello, I have posted this problem in the past and just haven't quite got it down yet. I think primarily because the way i explained the issue, so I going to try starting over... I have 2 tables: tblMSREntry * This has a field in it called "MSRCampaignID" (which is a number datatype)...