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

Hey Mac, Thanks for the help, it worked a treat! I kind of went 'Doh' to myself when I saw your SetFocus answer, I should have known that myself... must have been working too long on this damn database! Thanks again, HighLightUK

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

Why don't you write a query based on your table and specify the data you want retrieving in the criteria part of the date field? Then you could build your form on your query...

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

Thought it would be something like this.... Our IT dept didn't even have a clue! Thanks for the help

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

Hmmmm... I wouldnt want to do this every time the form opened. For example, the user selects the form to enter new works from the menu, and I would want this to be blank then. I am only talking about when they already have the form open and are entering data. They click on a New Job command...

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

Hi Bob, Thanks that worked a treat! A quick overview of what I had to do for anyone else with this sort of problem: 1)Add an additional field to the table with the Job ID and Descriptions for the Mask (I called this FaultMask) 2)Add the required masks in the FaultMask fields of the table...

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

Hi Bob, Text1 is updated from a table via the Query which sits behind the subform. Text1's control source is set to this table where the master info is stored. Text2 ONLY needs updating when a new record is added to the subform. Currently, its control source is set to a Markup field in the...

Yes, I do know this only applies to new values. Essentially, these two textboxes are hidden from the user. Textbox1 holds user defined info specified elsewhere in the database. This is the master field. Textbox2 drives a pricing markup and is derived from the master. Once per year however, the...

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

If anyone can point me in the right direction it'll be appreciated, as I am completely lost.

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

Why dont you just hide the folder on the server, so the users can't see it?

Hi Guys, Thanks for the replies. Help is always appreciated. Ken, I was hoping for a way to do this without involving the users. They are REAL pains and I want them to maintain as little as possible other than the main data they input. Previously, I had them entering the week number...

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