Search results

Thanks MajP that was just what I needed :)

Hi All, I have a main form with a subform and I want to insert all records from the subform into an Outlook appointment/calendar entry. Everything works accept how the subfrom records are copied. I use the following code to grab the subform records: Private Sub Outlook_Click() Dim rs As...

It is sage 50 and I think you're right there! I'll import the data! Thanks to all.

I've had some limited success with this. The following union query works if I first copy the source data from the Delivery Address table into two local access tables (table1 and table2) using append queries. SELECT * from Table1 where AddressType = 'Delivery' UNION SELECT da1.* from Table2 da1...

Yes - I hadn't realised that pass-through queries were read only. I'll need to read up on server side tables I think!

Hi everyone, I'm trying to make a query off of two tables that is connected/used with another database I don't directly manage. There is a field called ADDRESS_TYPE in the Delivery Address table that has two values as data options: 'Delivery' and/or 'Contact Address'. The Delivery Address...

Is there an example of some of this that I can see? I'm entirely new to server SQL and these types of query, which is why I think I've found the solution to this so evasive.

Hi everyone, I have a basic query that references a form's value in the WHERE clause. I'd like to try and turn this query into a pass-through query as I'm looking at moving my tables to an online SQL server. I'm aware that pass-through queries cannot utilise form values in the traditional way...

I've solved this. Idiot moment - the field customer name was also the record source of the combo box, so by concatenating the first two columns and then inserting them into the customer name field, I was also wiping the query result before it could finish updating the other fields. :sleep:

Hi everyone. I've come across a strange issue that I can't seem to figure out.... I have a combo box whose source is a query that runs and stores the results in the combo box drop down list, and it works fine. I have some VBA that stipulates when a user selects a result/row from the combo box...

They are strings, but, the first one still works as if it was a number range, and the latter doesn't, and I can't see why. Shoudn't either both work or both not work?

Hi guys, This might be an already-trodden issue...but does anyone know why this form validation works (in the form properties box): >="36.5" And <="37.5" But this doesn't: >="9.5" And <="10.5" What am I missing here?

arnelgp's suggestion to save it as an attachment seems to have worked. Thanks very much!

Hi everyone, I have managed to capture a signature in a form using the Microsoft InkPicture Active X control, and store that signature as an OLE field in a table. I can then also recall that OLE object in the form when cycling through the records. Each form record displays the corresponding...

Update - I managed to achieve this by running a query from a combo box and storing the results in another combo box, then from this second combo box I copied and inserted the results into the form datasheet using a loop. Dim i As Integer For i = 0 To Me.Combobox2.ListCount - 1...

Update - I managed to achieve this by running a query from a combo box and storing the results in another combo box, then from this second combo box I copied and inserted the results into the form datasheet using a loop. Dim i As Integer For i = 0 To Me.Combobox2.ListCount - 1...

So the subform is already bound to its own data source, and currently the user enters data into the form, and some of the fields then auto populate. For example, if they enter a code in the 'code' field, the corresponding description appears in the 'description' field. They want to be able to...

I don't think I can in this case, as the user also wants to (and does use) the option to add manual entries to the form as well. It cannot be bound to the query. They wish to copy the combo box rows AND enter their own data as well.

I think I might suggest that the form is redesigned on this occasion as per plog's suggestion. It seems more sensible. Thanks very much.

Hi guys, I have a combo box that displays the results of a query. The results are always more than one record, which of course translates to multiple rows being displayed in the combo box. I'd like to copy all records / rows from this combo box and insert them into a subform ( in datasheet...