Search results

  1. O

    pass through fun

    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...
  2. O

    Quick Dates filter question

    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...
  3. O

    Making a normalised table have a decent form

    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
  4. O

    Making a normalised table have a decent form

    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...
  5. O

    Making a normalised table have a decent form

    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...
    • oli82
    • Thread
    • Replies: 3
    • Forum: Forms
  6. O

    normalised table - great! entering viewing data - HELP

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

    normalised table - great! entering viewing data - HELP

    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...
  8. O

    normalised table - great! entering viewing data - HELP

    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...
  9. O

    ADO and SQL help

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

    ADO and SQL help

    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(" & _...
  11. O

    Table design query

    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
  12. O

    Table design query

    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...
  13. O

    combo box lookups in datasheet VBA

    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...
  14. O

    Table design query

    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.
  15. O

    Table design query

    Sorry didnt format right picture attached. Very Sorry
  16. O

    Table design query

    Hi, I am designing this database I have decided that using the row entry route for date is the way to go. However I have a couple of questions as it stands I have tables like so: Analytes lookup table ANALYTE_ID CLASS ANALYTE...
  17. O

    Reversing pivot table - solution

    For people out there that need to do this in either excel or access here are solutions, I spent last night looking at it and there are some great timesavers. to make fields go from un-normalised to normalised use select sample as Sample1 , " value1 " AS col, Value1 from Table1 where value1...
  18. O

    Quick test

    Sorry formatting went array. Here is a better picture of the tables. Cheers, Oliver
  19. O

    Quick test

    Thanks for your help in advance. As a quick test of mental agility on a cold afternoon, I have a quick question. Two tables with numbers like so Table A Table B NameID Number Number AA 1.5 2.3 AB 1.6 4.9 AC 5...
  20. O

    Table design rows or columns

    Thanks for the comments George, to confirm do you agree that putting the data in rows is suitable and then having each subform as a potential different row for a record. I don't quite understand how the subforms would work, do you have lots tabs in 1 form - if thats the case wont the load up...
Back
Top Bottom