Search results

How would I set up my totals query? When I create a totals query, based on the first one, I make one of my columns =SUM([Expr1]) but its only totaling the record's $$ and giving me the same value of Expr1. Its not giving me a total even on the report when I reference it in the field. Thanks.

Ive been trying to get this and my brain is just frozen. I have a query which gives me values of my table: Name | DateofEvent | Expr1 Joe 3/15/2003 $1000 Rich 5/15/2003 $2000 How do I get this query to give me the total of all records? ie. Count = 2...

Hi, Is it possible, when adding a record via a form to table1, to have that form obtain the autonumber from table2, put that number in a plain non-indexed Integer field and then increase table2's autonumber by 1? Thanks

That would be great, but Im migrating from an Old Q&A database where many of our customers have 2 or 3 records already (with duplicate data) and I need to keep all these records. Also, people only stay in my quote file for a week or two then I delete them. Is there another way just to copy...

I have a Quotes table with clients info, and a bookings table. When people are shopping, they are in our quotes file. When the want to book, I want to create a new record for them in our bookings file. I tried doing this with an update query, but Im not having any luck. Most (not all) of...

Is it possible for a checkbox to get its initial value from a field? I have a field that tells me if someone is interested in our services. When the form loads I would like the check box to check if the field says "Yes". How would I do this? Something like this? Private Sub Form_Current() If...

Is there any way to copy a field to the clipboard without first setting focus, or GoToContol to that field? Thanks.

Thanks.

I asked a week or so ago about calculating time differences and I got help, but I lost my database and I cannot remember how to do this. I was pointed to a function to calculate the elapsed time between 2 hour fields. Here it is: Public Function fElapsedTime(vStartTime As Variant, vEndTime...

Im almost there, its working now, this is what Ive got, but it wont close the original form. Is something wrong with my close syntax or should I do it a different way? Private Sub List6_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String stDocName = "QUOTES"...

I have an unbound box on one form which is populated by a query. I would like to then doubleclick the row with the persons name and quote number and have thier record in another form open. Im having trouble with the syntax. I assume it should be something like this: Private Sub...

I have a Database with my customers names, party date, payment info etc.... I have a calender control on my form when I click a date, a query opens which shows me all the parties I have on that date. Would it be possible to then be able to click a party on the query list and have thier record...

I have a form with lots of fields on it. Ive found the tab order on the view menu and set the order I want. When I move into a field that is a Combo Box, and type (for example) "c", and press down cursor, I would like the drop down box to start to cycle the values starting with "C". Kinda...

Made some progress, almost there. Ive created a query called JDContract, and have the button do this now: Private Sub Command320_Click() DoCmd.OpenQuery "JDContract", acViewPreview End Sub Then I just hit the print button on top. But how would I do it if I dont want to preview and just have...

Sorry if this has been discussed here before, But I could not find it. Ive created a button on my form "Print Contract". When I press it, I want access to prompt the user for a "Booking#", which is the name of the field with "Booking#" in it. Right now, I have: Private Sub Command320_Click()...

Ok, almost there....I put the code in my Code builder, but the field is giving me a #?Name error. This is what I pasted into my code builder. Public Function fElapsedTime(vSTART As Variant, vEND As Variant) As String Dim intHrs As Integer, intMins As Integer If Not IsDate(vSTART) Or Not...

I have a date field too called "BOOKINGDATE". How would I incorporate that into the datediff?

Im sorry if this has been asked before, but I couldnt find it in the forums.... I have 2 time fields and a total hours field in my form. "START" "END" and "TOTAL HOURS". I needed to calculate the hours between start and end, so someone suggested that I use this as a control source in the...

Thanks for your help. I did search before I asked but I searched for "time calculation"...My bad. Thanks again :)

I have 4 fields on my form. "MUS-$" "PROP$" "UPGRADE" and "TOTAL" I have the "total" field control source set to this: =[MUS-$]+[UPGRADE]+[PROP$] When I add a new record, it will not total unless all fields have values in them. How do I get the Total field to update regardless of if they have...