Hi Tim, Glad to know it helped. It was far from perfect as I found out when I re-read your FMPAF Form info. I have made quite a few changes including setting...
47053
Lee
leevt99
Mar 2, 2007 1:21 am
HI AD, This works great! However out of my own curiosity, would this work if you added a year column as well? Or would you just use the "Between" statement...
47054
bksinaz
Mar 2, 2007 2:03 am
This should be easy. I have 3 data bases. 1 customers 2 PC services offered 3 cusomer payments. I have no issues with sending blank data base to figure out my...
47055
tomelliott2002
Mar 2, 2007 2:03 am
I am using Office 2000. I have a reading list in a Word document with authors followed by series names and titles. When a book is read I change the style to ...
47056
Bill Mosca
wrmosca
Mar 2, 2007 2:32 am
Bob I don't know of any stated cause. Yahoo was just having a day like I had today. Nothing seemed to go right. If you missed any emails, read the posts...
47057
A.D.TEJPAL
adt_h
Mar 2, 2007 4:27 am
Lee, That should make it simpler. Could you please clarify as to what exactly you need to be done? Presumably, the combo boxes would have to show start & end...
47058
Andrew
andrewonebay
Mar 2, 2007 4:49 am
we are planning on coding a web application using coldfusion and access database. is there any problem with using access to make a website that will need to be...
47059
Jim C
liteguy.rm
Mar 2, 2007 4:53 am
I want to put a button on my form that runs a query against the data in the sub form. The form's name is FindCircuitMain and I want to pass the present value...
47060
A.D.TEJPAL
adt_h
Mar 2, 2007 5:01 am
Amber, If query Q_A is modified as given below, you should get the desired results. Could you please try it out & confirm the outcome? Best wishes, A.D.Tejpal ...
47061
amber
amber77074
Mar 2, 2007 1:41 pm
Hi Mr. Tejpal, Worked like a charm. Thanks again for your generous help. Really really appreciated. (Is there a way to delete those queries that was generated...
47062
Bill Mosca
wrmosca
Mar 2, 2007 3:04 pm
Jim Your command button code would open the query as an independent object. ... Like [Fomrs]![FrindCircuitMain]!.[circuitID])); But why are you passing a...
47063
horastacatto
Mar 2, 2007 3:06 pm
Hi Bksiaz, By all means. Upload your database to the Group Files 2_AssistanceNeeded folder and someone will look at it. But first, you have not said what the...
47064
Bill Mosca
wrmosca
Mar 2, 2007 3:36 pm
You can use the detail formatting event, but why not use Conditional Formatting to change the font to underlined or italic? Strike- through is not available as...
47065
Erik and Kim Smakal
kim_smakal
Mar 2, 2007 3:40 pm
I know, this is a MS Access list, but I'm trying to import a dbase file into ms Access and I feel like I'm missing data. Does anyone know anything about ...
47066
Bill Mosca
wrmosca
Mar 2, 2007 4:38 pm
Kim Ask the user how he is arriving at that count. Could it be that he is going by the highest identity number (autonumber) in the table. Any deleted records...
47067
Squires, Neil
greaterdesig...
Mar 2, 2007 4:44 pm
Bill, I ended up using your advice. I had a dropdown that allowed the user to select a number of copies between 1 and 30 and then when they press ok, a temp...
47068
Erik and Kim Smakal
kim_smakal
Mar 2, 2007 4:50 pm
No on the import errors. I think you're on the money with teh distort of the rec num/count ratio. If I do a select count of the table then I get my same...
47069
Myra Symons-kazanci
myrafly
Mar 2, 2007 4:54 pm
I usually ask questions.. Did you successfully import the list into Access? if so what is the format of your table? If you are changing formatting in a...
47070
Myra Symons-kazanci
myrafly
Mar 2, 2007 4:54 pm
This design sounds okay, from the little you've told us..What are you expecting it to do that it is not doing. (Sign your posts) Myra _____ From:...
47071
Lee
leevt99
Mar 2, 2007 5:28 pm
Hi AD, I was mostly just curious about how years would work in. What you gave me worked perfect for what we currently have. Although I guess knowing the...
47072
Myra Symons-kazanci
myrafly
Mar 2, 2007 5:32 pm
That's great.. Myra _____ From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of amber Sent: Friday, March...
47073
Jim C
liteguy.rm
Mar 2, 2007 5:44 pm
Thanks Bill. What I am doing is having the user select certain records on the subform in datasheet view, by checking a yes or no field. This button will run...
47074
DLE42@...
embreydl
Mar 2, 2007 6:04 pm
Jim, If you are limiting the query to a specific circuitID, why are you using the Like operator? Include the reference the circuitID from the subform in the...
47075
Bill Mosca
wrmosca
Mar 2, 2007 6:24 pm
Kim Ask him to also send you a flat file that you can import and compare for missing records. That's the best way I've found to check when a client disagrees...
47076
Bill Mosca
wrmosca
Mar 2, 2007 6:31 pm
Neil You might want to incorporate teh LabelSaver code in the download at: http://www.peterssoftware.com/ls.htm It lets the user select the starting place on...
47077
horastacatto
Mar 2, 2007 6:32 pm
Hi Lee, AD, For a MonthRange that can span years I use the absolute month value using the DateDiff() and Month() functions: intStartMonth =...
47078
Myra Symons-kazanci
myrafly
Mar 2, 2007 6:37 pm
How I have solved this in the past is either require an entire date be entered or allow the user to select month and year and then on the click event for the...
47079
MS_Access_Professiona...
Mar 2, 2007 6:40 pm
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
47080
MS_Access_Professiona...
Mar 2, 2007 6:52 pm
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
47081
A.D.TEJPAL
adt_h
Mar 2, 2007 6:53 pm
David, Your file duly fixed & renamed as PledgeSatisfied_Fixed.zip, has been uploaded to AssistanceNeeded folder in Files section. You might like to try it...
