my table has a feild for machine 1 and a feild for machine 2
each job can have either machine 1 or machine 1 and machine 2
in the report it sorts by just machine one
how do i get it to put the machine two in the sort as well
brnkstyle
Last Activity: Aug 10 '07, 02:00 PM
Joined: May 30 '07
Location:
-
Report Header Problem
I have a report where it sorts jobs assigned to a specific machine and that all works well but...a job can have 2 machines and i have the feilds set up so that machine one is in one feild and machine 2 is in another...so is there a way to put the second machine in the sort so if job 1 uses machine A and Machine B then the sort with show Machine A has job 1 and Machine B has job 1 as well -
Average number of workdays per month from table
I figured out how to calculate the work day given two values but all of my records have dates and i want to be able to calcuate the average time it takes to do a job per month so basically take all the calculations add them up and divide by the total does anyone know how to do that.
[CODE=vb]
Public Function WorkingDays2(St artDate As Date, EndDate As Date) As Integer
'.............. ............... ............... ............... ............ -
WOW thank you so much worked like a charm i owe u one!...Leave a comment:
-
Command Button changing Textbox ControlSource
I want to change the controlsource of a textbox when i click a command button but everytime i do so it gives me #Name$ in the text boxt
this is what i want to control source to be
Combo2.ControlS ource = DCount("name", "table") -
OK will do looking forward to the replies...Leave a comment:
-
Inserting Hyperlink to Outlook Email through VB
Hi i need to insert a link into an email using visual basic but part of the link is also a variable which will be changing depending on the record in the database any ideas how to do this. When i use <a href ="link example"> link </a> vb gives me an error.
Dim mess_body As String
Dim appOutLook As Outlook.Applica tion
Dim MailOutLook As Outlook.MailIte m
Set appOutLook...
No activity results to display
Leave a comment: