Search results

Use DoCmd.Maximize on the On Open event of the form Private Sub Form_Open(Cancel As Integer) DoCmd.Maximize End Sub

See if this helps you get started Running (or moving) Calculations (Sum/Total, Count, Average)

What about using a custom function to generate a random function that incorporates a Randomize() function in the query? Public Function fRandomNum() As Double Randomize (0) fRandomNum = Rnd() End Function

qry3 still wasn't pulling records properly. Was missing the start dates, i.e. the lower end of the criteria. So I made the folowing changed. Changed qry3 PARAMETERS [dtFind] DateTime, [intMins] Short; SELECT [dtFind] AS dtDate, dtReading, dblValue FROM tblData WHERE dtReading >=...

This SQL statement seems to return the correct records. qry3 PARAMETERS [dtFind] DateTime, [intMins] Short; SELECT [dtFind] AS dtDate, dtReading, dblValue FROM tblData WHERE dtReading >= DateAdd("n",-1*[intMins],[dtFind]) AND dtReading < [dtFind]; Just FYI, this SQL statement also works as well...

EMP, Thank you for your reply! I was afriad that it was going to be something like that. I ran into the problem of subtracting decimals recently. I had read FMS's article - "When Microsoft Access Math Doesn't Add Up" before but didn't think of it until I was testing the code. So I am aware...

I have the following two querydefs. Here is the SQL; qry1 SELECT [dtFind], tblData.dtReading, tblData.dblValue FROM tblData WHERE DateDiff("n",[dtReading],[dtFind]) Between 1 And CInt([intMins]); qry2 SELECT [dtFind], tblData.dtReading, tblData.dblValue FROM tblData WHERE dtReading Between...

Try this - Concatenating unique field values for records matching a query's GROUP BY clause

Anyone playing Dungeons & Dragons Online? If so, are you enjoying it?

It was a really sad to watch that story on TV. I'm glad that the (insert your own expletive) was caught quickly!

http://namedecoder.com/ - http://cyborg.namedecoder.com/ - http://monster.namedecoder.com/ - http://sexy.namedecoder.com/ I was going to post the sexy decoded name but am not sure it would be appropriate!

MrsGorilla, Thanks for the reply! Much appreciated! :) Now all I have to do is to figure out which books I want! :confused:

Thanks! Thanks for sharing that! I will check them out. :)

fuzzygeek, Thanks for the reply!! Good to know that other people have tried the book club with no problems. Do they regularly add to or revise their list of books?

I came across this website - http://www.computerbooksdirect.com Anyone have any experience with them? They look to be part of http://www.booksonline.com/, which has the Science Fiction Book Club. I've been a member of Science Fiction Book Club for several years and haven't had any problems...

Since you aren't really loking for a running sum, but rather just a sum of all the transactions; where Advances are negative and Payments are positive (at least insofar as calculating the Loan Balance). Why not have a table structure along the lines of the folowing; tblLoan LoanPK (Primary...

See the following article - Running (or moving) Calculations (Sum/Total, Count, Average) Hope this helps!

Use the Form's BeforeUpdate event. Add code to check if your checkbox is false or true, maybe something like Cancel = Not Me.MyCheckbox

Thank you to one and all for your kind wishes! That's wonderful! Congrats to you and your soon-to-be wife! :) That's cool that you are going to do it in Japan! Any particular reason you choose Japan? I can't say I'll be in to often. Between work (the kind that pays the bills) and working on...

I had some news to share with my fellow forum members. I've been absent from the forums for awhile now so this bit of news is overdue. Early last year, I proposed to my long time girlfiend. In September of last year, we got married. :D