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...
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...
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?
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...