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...
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...
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 =
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.