Search results for query: *

Thanks to all who replied, I will give these ideas a shot this morning. James

I have a field with text formatted as follows: RACK 00150/BAY A/UNIT 01 I would like to create a function or something of the like that would decontstruct that field and place the five digit rack number into a field. Also it should take out the letter after the word BAY (never more than a...

I have a table of data and I need to export that data to a CSV text file so it will be usable by a different program. However, I need to transform one of the fields that contains a unique six digit number that I generated in Excel. The transformation on each digit is always the same. For...

We currently have an Access database and send weekly Snapshot report emails to our cutomers with status on their projects. We are interested instead in placing these files on SharePoint and making them available in a document library. Unfortunately the Export function does not seem to allow us...

I have two fields on my form: - HoldFor is a CheckBox field - ProjectID is a Text field I have the following code: Private Sub Form_BeforeUpdate(Cancel As Integer) If Me![HoldFor] = True And [ProjectID] = Null Then DoCmd.RunMacro("mcrReserved") ' Displays warning message...

I have a form that holds work order information. Each work order can potentially impact a group of systems. The systems information is a subform on the main work order form. I need a way for a user to go in and set a filter on the subform so he only sees the work orders that affect a...

I need a Function that I can run from within a Query that will take a date from a table and spit out which half of the year (First or Second) it falls in. I am pretty new to functions, but here is what I have so far: Function DateAnnual(AnnumDate As Variant) As String Dim HALF As Variant Dim...

I have a form that I will call Workorder. I have another form that I will call ProjectOutline. Each is based on two separate tables with the unique WO# being the common link between the two tables. I have a button on the Workorder form, that when clicked, should open the ProjectOutline form...