Search results for query: *

Hi, I have a form with a calendar control which I want the user to select a date from the calendar and then run a report. This works fine. When the user selects the date, I need the command button to identify the Monday and Friday either side of the selection and pass this to the report in the...

Okay here is the deal. I have a report which uses a crosstab query to show Mon - Fri as column headers and event categories as row headers (I can anticipate your groans as I type): Event Type Monday Tuesday Wednesday Thursday Friday ---------- ------ ------- --------- -------- ------...

The users of my main form have requested a change to the way it works when selecting a button which creates a new record. Essentially, the users open the form initially from a menu. At this point the form is blank except for its default values (which is fine). After they populate the form and...

Now from the title this sounds easy, but what I would like to do is this: 1) When the user enters a value in my JobRef textbox on my form, it checks to see whether there is another identical jobref in the underlying table for the current value in the COrder field (these fields are both in the...

I have created an Access database originally on Windows 2000 and since updated it on Windows XP Pro. The database was created in Office 2000 (and still is in 2000 format). When I installed the database on the server and attempted to run the front end from the users machines, I get an error when...

When a user clicks a New Job button on my form, I would like the values for four fields to carry over from the previous record (many jobs have this information as the same and this will help speed up input). All other fields will either be blank or have their default values as is cuurent. I...

How easy are these to create? I have a combo box which filters the contents of a subsequent combo box depending on the value selected. When the user selects a value from the second combo, I would like to create a different input mask for each selection. Then the user only needs to enter a...

Can I make the default value of a textbox on a form equal to the value displayed in another textbox? i.e if textbox1 value is 0 on the form, then the default value for textbox2 = 0, but if textbox1 = 7, then textbox2 default value = 7. There are only two possible values in textbox1. I want...

Hi, I have a subform which builds up cost items for a job from a schedule of rates. This subform updates tblJobItems with the link to the main form, the various item ID's, the quantity and a mark-up figure. tblJobItems ----------- JobID ItemID Quantity Markup The problem I have is with the...

I am looking to put the UK tax week on a form so it displays automatically when a user creates a new record. There is a catch however, as the field WeekNo must first look at the date the record was entered (the record may be for last week for example)in a DateRec field. How do I get the WeekNo...