Search results
-
R
Calculate hours between 2 times.
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... -
R
Calendar to Query to Form?
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... -
R
Where is the field size spec?
But why cant I enter more than 12 characters into the field's textbox? -
R
Where is the field size spec?
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... -
R
Drop down box pulls from Table
ok got it thanks! I had to use the Query builder. -
R
Drop down box pulls from Table
Sorry, but on the Data Tab, Row Source, there is not option for Ascending. It is only giving me a list of the tables to pull the data from. Maybe Im not looking in the right place? -
R
Drop down box pulls from Table
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. -
R
Simple Addition
Ok, then how would I do it on the Form? I thought I needed the calculated value in the table so that when I print a contract, it will pull the value of that field and put it to the report. -
R
Simple Addition
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... -
R
Calendar Control
Ok, thanks again for sticking with me on this.... I have a whole table full of bookings for the future with client names and dates. I have a calendar control on the form. When I click on 10/4/2004 date on the calendar, I want the query to give me a list like this: Booking Date Name... -
R
Calendar Control
Then it changes the BOOKING DATE field of whatever record Ive got showing to the calendar selected date! -
R
Calendar Control
Ok, Im with you. Thanks for all your help....Im close to getting it. I think Im just a little confused on the "UnboundControlOnForm". I created a field with the name "UnboundControlOnForm" and added it to my form. When I double click the calender date, it puts the date that I click into that... -
R
Calendar Control
Ok, Ive created the unbound control on the form field, named "UnboundControlOnForm" and made the Visual basic screen look like this. Private Sub Calendar3_DblClick() Me.UnboundControlOnForm = Me.Calendar3.Value DoCmd.OpenQuery "BOOKINGS Query" End Sub But its still giving me all the records... -
R
Calendar Control
You lost me... Im just trying to invoke a query based on the date I double click. Do I change this part? Private Sub Calendar3_DblClick() DoCmd.OpenQuery "BOOKINGS Query" End Sub Thanks -
R
Calendar Control
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...