Search results for query: *

Thanks guys, I have code to import ONE word doc into excel, and I have a macro that reads each line (in the imported document) and parses it correctly. Do you guys happen to have an example of the Dir function in use? In the meantime I will play around withit, I should be able to figure it...

oops, meant to mention, the link above was the closest thing I could find by searching, thanks in advance for any advice.

Hey guys, I haven't tried something like this before, was hoping someone could lend some advice. I have 500+ resumes in a folder that I want to import into a spreadsheet. Right now I am manually importing each one, then running a macro to parse the data into the correct colums (Col A = name...

Thanks guys, I am using v.10, I had to right click, I knew it was going to be an easy fix, Thanks again,

Ok guys, I am pulling my hair out... Is there a way to change the order of the parms when they are prompted for? Hope I am making sense, an example below: I have 3 parms: Month, Day & Year In the Field Explorer they are listed in the order that I created them: Day Year Month When the...

This is what I was looking for, found it on another forum, in case anyone needs it: DoCmd.ShowAllRecords Me.MATCHFIELD.SetFocus DoCmd.FindRecord Me.COMBOBOX Me.COMBOBOX.Value =

um, ok... so, am I wrong in assuming that I can use the DoCmd.GoToRecord,, function to do this?

I have tried using the third radio button, here is what i get: Data cannot be retrieved from the source you have selected. You must select a different table or query to continuein the wizard.

Thanks, I tried that, it does not seem to work, I guess it has something to do with the fact the the combobox values come from the same table that the Form's records do...

After spending the past hour searching, I must finally ask for help!! I am building a simple data entry form for my users to enter and maintain some information. I would like for them to be able to pick records from a list using a combobox and have the form navigate to the complete record. I...

Thanks guys, The convert nulls to default did not work unfortunately, i did try.... The second option DID work, I had tried putting an if then into the original sales formula (which calculates which field to pull from the sales table based on the month the user selects), Creating two...

Ok, hard to put into words, please have patience. Background: I have a report that displays in the following manner: (ignore underscores, entered to help preserve formatting) Salesperson______Sales_____Quota Bob______________$500______$900 John___________$1,200_____$1000 Salesperson is...

yikes, I was trying to use "keep together" at too high of a group level (group1 was too big to keep on one page) and it was ignoring the "keep together" of the subsequent group2. Once I removed the keep together from Group1, the keep together worked perfectly for group2. Group1 H Group2 H...

I just checked the SQL and things are looking good. I am on Crystal 10, maybe that will make the difference. Thanks!

First of all, I am learning SO much from this BB, thanks to all for help on past threads. If only my company would spring for some training, maybe I wouldn't be posting so much! I have a report that groups by period, so far I can keep the records together by using the "keep together" function...

Please Disregard, found faq767-3825 and that did the trick... I was unaware that I could use If/thens in my record selection... live and learn. Thanks,

I am trying to use a parm in my select statment, to limit records returned by the report. Right now, I have a parm set up to ask the user for a reporting period (month) and the report returns only data for that period. So, currently, if the user wants more than one period of data, they can...

Thanks LB, That would work well to cap the commission at 2000. Now, what would really help would be able to calculate the commission on the 12/3 and 12/4 entries. Currently, I use a standard formula to calculate that amount (Revenue * .05). BUT, as you can see, the commission amount changes...

oops, supposed to say "Revenue

I am writing a report that lists records like this: Date Company Reveue Commish(5%) Run Tot 12/1/04 A 10,000 500 500 12/2/04 A 20,000 1,000 1,500 12/3/04 A 16,000 800 2,300 12/4/04 A 12,000 600 2,900 I...