Search results

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

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.

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...

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...

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()...

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...

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...

I have a form with these 3 fields. "Start" "end" and "Total Hours". How do I make "Total Hours" equal the number of hours between "Start" and "end". (ie. Start= 7:00 PM, End= 11:00 PM, Total Hours field simple have a value of 4) I Tried using the Expression builder in the TOTAL field and...

I have a database with Customers (weddings). I have their names and dates, charges payments etc... Now, I have a form with a calendar on it. When I double click a date on the calendar it invokes a query which gives me a list of all the weddings I have on that day (just thier name and location...

New to access here as you can tell...but Im learning.... How do I increase the field size? Ive designed a form with text boxes, but each box only lets me put about 10 or 12 characters in it even though there is lots of room left in the box. Where is the option for increasing the character...

Ive created a drop down box on my "bookings" form, which pulls its values from a "location" table. How do I have these locations appear alphabetically in the drop down box? Thanks.

I have a table which Ive imported from an old Q&A Symatec database. Im trying to program my fields like I used to have. Lets say I have 3 fields named "music", "Props" and "total" How do I make the TABLE automatically update the "total" column to equal "music"+"Props" and where does this...

Calendar Control Help Please Hi, Im very new to access but I think I have the basic idea of it. I have a form which I added Calendar Control 10.0, when I double click a date on the calendar I want it to invoke a query based on only the date I picked. (My table is an event planner, so when I...