Search results

Trying to use the choose function can't remember exactly how Have an option group for departments on my screen would like to use the Choose() function in a list box in the control source for the list box i am typing: choose()"Department1";"Department2";"Department3" But it is not working...

Thank you Thanx works like a charm

I have an option group on my form now and the user selects the option desired, the value in the option group is then defined as a numeric value. I now need to put an hidden unbound box on my form that will look at the option group value and convert the value to text to be used for my criteria...

Currently use unbound combo box's that specify the criteria for my report query [forms]![formname]![comboboxname] Would like to know how to use check box's to specify criteria example check the box for your department check the box for your shift and the query will use the checked box's to...

Have a report that i generate from a query. The query includes Employee Vacation Date Employee Job Would like the report to look and see if there is another employee off the same week or day and identify such conflict by emphasizing name in bold or colour.

In reading a post below i have learned how to make the default value of a field the first day of the month. Very handy thankyou =DateSerial(Year(Date()),Month(date()), 1) Question: I would now like to learn how to make the other field on my form default value to be the last day of the month...

Have a database for which i have setup a password to open the database. it has been requested that i identify who is making entries to the database for data entry mistakes tracking. Thinking i could set up some sort of unique passwork login for each user but not sure if i would be able to...

Request: I have some tables all linked through there respective relationships 1, Employee Job Table Employee Number* Name Machine Job Shift 2, Employee Vacation Table AutoID Employee Number* Vacation Date** 3, Employee Shift Calendar AutoID Shift...

I have a sub form that is based on a query The form is set for continuous form view but i would like only to see the last 5 records Problem, i have used the top 5 command in my query but is shows the last 5 decending 5 4 3 2 1 New Record I would like to see the last 5 records in acending...

I am using the following code to print a report based on a date range: Problem is that to get the date range that i want i have to enter the start date as mm/dd/yy and the end date as dd/mm/yy Can anyone tell me what is wrong with the code would like to enter start and end dd/mm/yy Private Sub...

I have a report that has Employees start dates I would like to print a seniority list of start dates however i do not want to include employees that do not have a value in the start date field. For instance in my employee list when an employee retires i remove his seniority date but do not...

I have a form that prints a report for vacations using a date range, i would like the month of the date range to appear at the top of the report ? ie if the date range is 01/04/02 to 30/04/02 i would like the title APRIL in large bold letters to appear at the top of the report.

Have a report would like the report title to change depending on the values on the report [Field1] [Field2] If [field1] is completed i would like the report title to read "JOB POSTING" If [field1] & [field2] are entered i would like the report title to read "JOB AWARD"

I have a form upon completion of the form i would like to be able to push a button to print the Report for that form. Problem: i have inserted the print report button but when i push it is prints out all the records in my table, i only want it to print the report for the current record on the...

I have a notes box on my form, when i print the form all the contents of the note box do print and the note box resizes to fit all the text, however when viewing the form on screen i can only see all the information that i have typed into the notes box using scroll button at the side of the note...

I have a form that has a couple of text box's and a couple of combo box's, once the form is filled out the initiator simply hits the print button and the current form record prints out. Problem: I would like any empty text box's or combo box's not to print their outline if they are empty, if...

I have a table that contains a field for birthdate. I would like to notified whenever it is someones birthday via e-mail Any suggestions

Currently i have a form that i use to print a report for a specified date range i am using the following code: DoCmd.OpenReport "Maintenance Request Query by Date", , , "[Date] Between #" & Format(Me.StartDate, "mm\/dd\/yyyy") & "# And #" & Format(Me.EndDate, "mm\/dd\/yyyy") & "#" What i would...

Although you can not change the colour of your command buttons you can display a picture on them and if you creat a square bitmap image and use that as your picture you will have a button that appears to be what ever colour you want.

I have a form that i have made that prints a report for a date range of records in my table. Using the "openreport" "Me.StartDate" and a "Me.EndDate" code. In addition i would like to add to this report another text box where i can enter a field to also select only records for a specified...