Recent content by oli82

Hi I am trying to setup a pass through query to sql to create a temporary table, insert records and pull back the results after they have been passed through a UDF. create table #UAI (User_Abstract_ID varchar(30)) Insert #UAI values ('XURBB_424384') Insert #UAI values ('XURBB_424385') Insert...

Hi I have some VBA which filters a form by date DoCmd.OpenForm "EntryAll", acNormal, , "[dbo_V_ABSTRACT].[ROW_CREATED_BY] = " & "'" & Me![CboCreatedBy] & "'" _ & " AND [dbo_V_ABSTRACT].[ROW_CREATED_DATE] Between #" & Me.CreatedDateFrom & "#" & " And #" & Me.CreatedDateTo & "#" I enter filter...

To better explain this if I link the form to the data table and then set up the combo's the drop downs work but the actual values are displaying the first record. Where am I going wrong. Many thanks for this help. Oliver

DCrake, Thanks for this, it's a great start. Do I need to bind the form to a control source to get this working, at the moment I have combo boxes like above but they do not display anything only when you drop down do they display the value - as opposed to holding the value inside the box...

Thanks for your help in advance, we have built a normalised table and now have the issue of trying to get this data in a form view to both view and edit the data. I have having trouble with which method to use to do this. I have investigated a few methods ADO looks good but I don’t...

Dave, Will I be able to add new records/delete/edit properties through these queries? Many Thanks, Oliver

Dave, Thanks for the help. we dont have any data stored like the bottom table it was in their to say that a form based on that would be easy. But I have the issue of turning data stored in the top table into a form that displays every possible option of property on the form. Thanks for the...

Hi, Thanks for help in advance. We have a table with data stored like in the top table. This is normalised and great but while it is easy to create a form when the data is stored like in the bottom table, I am at a loss with how to show forms with this data. Ideally I would like for each car to...

Bob, Many thanks for the help would it look like this then: strSQL = "INSERT INTO tblContacts(" & _ "txtLastName, txtFirstName, txtTitle) " & _ "VALUES (" & _ "'" & Me.txtLastName & "', " & _ "'" & Me.txtFirstName & "', " & _ "'"...

Hi, Thanks for your help in advance, its really appreciated. I am using ADO with SQL in Access VBA, I want to essentially devise a form whereby I can enter using the SQL insert statement more than one record of data through the same form. strSQL = "INSERT INTO tblContacts(" & _...

After the cross tab querying of the data into columns I would run a select query which link each column with its representative lookup table together to produce the end result. Does this sounds like it will work ok. Cheers, Oliver

Pat, Many thanks for this, have managed to sort something with VBA looks like below. Do you foresee any problems with this method. Thanks for your help. Oliver Private Sub ANALYTE_ID_AfterUpdate() Select Case Me.ANALYTE_ID Case 5 Me.SAMPLE_VALUE.RowSource = "SELECT...

I have a subform in datasheet view. I would like it such that if I select 'Ratio' from column 'Analyte', in the column called 'Value' I get a drop down with high/medium/low. Then if I add another row adding 'Chemical A' say I can go ahead and add a value (without using a drop down list). I...

I am asking if its possible to put up lookup numerical id's in the field and then have a lookup table with id, which includes low or high or med - for example. Thanks for the help.

Sorry didnt format right picture attached. Very Sorry