Search results for query: *

AWESOME!!!!!! Thanks for the assistance

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...

Oh nevermind, missed the AJAX part, and after reading what that is my sugegstion will not work

Couldn't you just do a cfquery then cfoutput the values in a <marquee> tag? Please forgive me if this is a dumb idea, I am very new to CF.

MajP, thank you VERY VERY VERY much for all of yoru help. I got things working exactly how I needed to. In one "step" I import two different user selected files, and have another process to save the file via a "save as" dialogue box. I can't express how grateful I am for your help. P.S. I am...

MajP thank you for all of the help, I wish there were something I could give you other than a TT forum star ha ha. Here is the code I got from the link above, it works fine, I am able to edit it how I need. But this code alone will not import the file I select So I converted the Macro I had...

Excellent thank you for your help. I think I am about halfway down. I used the code from the second link you posted, and I can navigate to, and select the file I wish to import. Now I need it (after selecting open) to run the macro I created to import the data from the text file into the...

I'm sorry, my goal was to pick a particular file not a directory, is there something on there to pick a particular file?

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...

I am still a bit confused. I know how to create an input mask, but the underscores already exist, and they are different character counts in each record but the field must be 20 characters long once all of the fields are concatenated. so there is like a 2 charcter field, then a 10, then a 15...

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...

Exactly what I was looking for as well, thanks to all involved.

dhookom.............I love you :P Thank you VERY VERY much though, the second code you posted worked perfectly. I do not know much, but I do know spaces are bad, unfortunately I am using a data extract from another DB :( and I did not rename any fields. If you have time and are willing, can...

Oh and I now realize that I don't need the reference to a second table, so my syntax now looks like this SELECT Patients_QualifiedReportsCount.[Patient Id], Concatenate("SELECT Report FROM Patients_QualifiedReportsCount") AS AllReports FROM Patients_QualifiedReportsCount GROUP BY...

The error message is Run Time Error '3075': Syntax error (missing operator) in query expression "Patient id=a patient id value from the table

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...