Search results

Hi, I can’t get this message box to work: Private Sub Command18_Click() Dim Warning As String Warning = MsgBox "Are you sure?", vbOKCancel, "Delete?" If Warning = vbCancel Then Exit Sub Else Me.Recordset.Delete End Sub I keep getting a message about “Compile error: Expected: end of...

"You can split each string into Array and match each value in Array2 against all values in Array1. This will give you the parts in String2 that do not exist in String1" How would I do that? How do I split the strings into Arrays? Thanks Dave

Hi smig, It is not the design of my database, it is an export from Primavera P6 scheduling software. Thanks

If one string is XX-001, XX-002 and the other is XX-001 the difference is XX-002 Thanks

Thanks very much, guys. I will give it a go. Dave

Hi, I have a query with three fields; a primary key that is an Activity ID and then two fields that contain the part numbers associated with the Activity ID (PrtNos1 and PrtNos2). One of the part number fields is from the existing database and one is the new requirement. I am searching for...

Hi, I am trying to use Between in a calculated field in a query and not having much luck. The formula I am trying is: SizeRange:IIF( Between 0 And 150, “0-150”),IIF( Between 200 And 600, “200-600”, “600-1000”)) What do I need to change to get this working? [SIZE=3]Thanks very much...

Hi Forum, I have a query with a field for “Item_Number” that has items 1 to 33 running down the page. Beside that is a field of values for “Quantity” and another field for the month and year (eg. Jan 2015, Feb 2015, Mar 2015, etc). I run a report that shows the quantity by date. I now need to...

Found it! I used "Medium Date" in my formula. Works great. Display: IIf([TextDates] Is Not Null,[TextDates],Format([Dates],"Medium Date"))

Thanks pbaldy. I have set up the "real" dates in one field of a query and the text dates in another. I have used the formula below to bring them into the same column for presentation: Display: IIf([TextDates] Is Not Null,[TextDates],[Dates]) It all works great except that I need my "real"...

Thanks very much Dave

Hi, I have a Date field that shows forecast dates. In my organisation, and throughout the world of construction, people are used to seeing an actual date (the task has already been completed) with an “A” suffix (e.g. 25-Feb-2015 A). My problem is that I need “real” dates when the dates are not...

Hi Using AND with IIF in a query The IIF statement below works in most cases except where there is no value for the first condition, [ARRIVAL CURRENT ACTUAL] Is Not Null, and there is a value for the second, [ACTUALSTARTSET] Is Not Null. When there is a value for ACTUALSTARTSET and no value for...

Thanks very much for the feedback. Dave

Hi, In Access I have a query with a field, BERTHING F, that needs to have a date calculated based on the “ARRIVALCF” date and the “DepartDate”. The first date in the BERTHINGF column, 04-Jul-15, is hard coded in the table and does not change. I need to have a date that is equal to the...

Hi, I am importing dates from Primavera P6, via Excel, and any dates for activities that are already complete are in the format, 06-Jun-15 A, the “A” showing that the date is an “actual”. I had been changing the dates to text as they were just displayed, but now I need to do some calcs with them...

It's not a control I'm trying to clear. I have two fields displayed for each record (row) in my Form, ItemID and ItemDecsription. I want to be able to delete (or clear?) the contents of ItemDescription by clicking a command button. Also. I'm not trying to delete the entire record (row), just...

Hi, If I have a continuous form, based on a table, can I have the records displayed in the form controlled by a query? I have a query that returns the ID numbers of records that I need to edit. I would like to have the form show only those records so that I can edit them easily If the control...

Hi, How do I delete a field in a form? If I have a continuous form can I have a button beside each record that deletes the value of a particular field if pressed? How does the code know which field to delete? What would the code on the button’s On Click event look like? Thanks very much Dave

Hi, I just split my database and now the back end is empty and the linked tables from SQL Server are in the front end. Is there any point splitting a database with ODBC links to SQL Server? Or should the linked tables be in the back end? Thanks very much Dave