Search results for query: *

I have a user form with two fields StartDate EndDate I have a query that returns results based on this users input into these fields. If the user does not enter a value into the [StartDate] field I would like the query to return everything. I have tried everything I can think of with no...

http://www.tek-tips.com/viewthread.cfm?qid=1321843"]Old Thread[/url] I read through this thread and the MS help sheets on a FileDialogue object and I am still lost. I am not sure where to put this code, or how to get a button to show up on my form to generate this dialogue box once clicked. I...

I have a form which has two drop down boxes. The first queries a table to display options, the second is refreshed after a selection is made in the first, and returns values from a table based on the selection made in the first drop down. This works fine and dandy, except on two co workers lap...

SO here is a quick break down. We get a file from a business group, and there are two fields I am concerned with for this, an example is below Old Value New Value Name ______ (6 underscores) Drug ________ (8 underscores) Name ______ (6...

Search is down so I could not find anything. Is there a way to make the header and footer (font) of an Excel document always print the same size? Even if I put more stuff in the "body" of the document which makes all of that stuff smaller? TIA

Let me first say I am pretty new to this type of reporting, so please forgive me if my question is stupid. I have been trying to reference other reports but can't figure this out. Lets say my data table looks like this Group Name Cost East1 $10.00 East2 $10.00 East3...

I have spent the last hour reading through threads and trying different things and I can't get this to work :( Here is the code as it is in the module I created (taken from the FAQ http://www.tek-tips.com/faqs.cfm?fid=4233 ---------------------------------------------------------- Function...

I have search through the forums, and the closest thing I can find is this example http://www.tek-tips.com/viewthread.cfm?qid=1044612 I have this information I have detailed customer data (ID, Sale amount, Sale Item, etc...) I have grouped by CustomerID so that I can give a summary in the...

All, I do not even know what to call this, or what to search for, but this is what I need to do. I have a word document that has a summary sections with things like Total Spend = x Total # of Claims = x And as of right now these numbers are manually entered from looking at an embedded excel...

First I would like to say I know zero VB, I could work my way through editing some of it, but could not write it myself. That being said does anyone know of an "easy" way to keep say 3 fields hidden. If a check box is clicked (Value to Yes) the three hidden fields will become visible and data...

I tried searching and using the FAQ's but was not able to find what I am looking for, I may be blind. I have two macros I have created, one for a "Portrait Layout" the other for "Landscape". The macro enters some standard wording into the header and footer. Now I saved them in a file called...