Recent content by LeeInEngland

Having used the AS400 I an say that it's a tricky one because the day is not always two digits. With my data I also found that if the day was more than 12, the data came out as ddmmyyyy whereas if it was less than 12 it appeared as mmddyyyy.

Or the miserable old goat could have answered the question in the first place instead of telling the guy to check Help for the Weekday function. We all code in different ways. Personally I never use the Date() function because it doesn't perform the same function in other languages and it...

Of course that can be done. Open the Quote, click a 'Send to Workorder' button. Code the button to open the Workorder form and fill the next sequential workorder number. Then select all the records from Quote Materials and seqeuentially add them to Workorder materials with the appropriate...

You could concatenate all of the responses into one mighty text box. Perform a loop through each record and append the new comment onto the existing comments. e.g. txtAllComments = txtAllComments + " " + table1.ThisComment

I would develop in Excel. Provide your data in a hidden worksheet that you can source for validation of part numbers etc. This will make life easier for everyone. I know many companies wouldn't be able to run an .exe if you sent them one because of permissions on their systems.

The 'problem' with that is that you're filling up a combo box with values that you don't need to be in there. Isn't a combox box limited to a certain number of characters, like a list box? Just a thought

Or what he could have typed instead of being a butthead was, If weekday(now()) = 6

public sub cbocourse.lostfocus () txtFaculty.value = DLOOKUP ("Faculty", "tbl_Course", "Course = " & cbocourse.value) txtDepartment.value = DLOOKUP ("Department", "tbl_Course", "Course = " & cbocourse.value) End Sub

Yes, we'll take a look.