Search results

  1. I

    Data Manipulation

    The data is not in a consistent format, it represents quantitys and weights of food items.
  2. I

    Data Manipulation

    I have data in a field which looks like this 2-2.27kg. Is it possible to split this down so I can then automate calculating 2x2.27. Thanks in advance!
  3. I

    Field Data

    Hi I have a field which will contain 10kg, 500g, 1ltr etc, how can I get code to ignore the numbers and us the letters! Thanks in advance
  4. I

    DLookUp

    Can someone help! Can't get this to work.............driving me mad. =DLookUp("[FilterDescription]","tblFilterDescrip","[DescripIDNumber]=" & Forms!frmProductSelector!cboProdDesc) Thanks in advance!
    • IanT
    • Thread
    • Replies: 2
    • Forum: Forms
  5. I

    SQL Update

    I am using SQL to update a table using a form, code below: strSQL = "INSERT INTO tblQuote ( ProductIDNumber, Range ) "SELECT tblProductData.ProductIDNumber, tblProductData.Range, " & _ "FROM tblProductData " & _ "WHERE tblProductData.FilterDescription" &...
  6. I

    Form Data

    I have a form which is a continuous Form, using a combo you select a filter to display set data. Generaly there are two records. I then have a update sql statement to append the data to a table. The code appends the first record OK, but not the second record. I am assuming you would do some...
  7. I

    Data field

    I have a field which will contain 10kg, 500g, 1ltr etc, how can I get code to ignore the abbreviations and us the numbers!
  8. I

    List Box data to Update Table

    Hi I am trying to update a table with data selected from a list box, I have tried the code below with out success, can any one help. Thanks in advance........... Dim strCriteria As String Dim varItem As Variant Dim strSQL As String For Each varItem In Me!lsthold.ItemsSelected...
  9. I

    Populate list box

    I have two list boxs on a form, lstDescription Rowsource to a query, lstHold is unbound. What I would like to do is when you select a record in lstDescription, put the record in lstHold, this could be just one record or build up many records in lstHold. I have tried using this could with out...
    • IanT
    • Thread
    • Replies: 1
    • Forum: Forms
  10. I

    Data to List Box

    Hi If I select a record on a form, is it possible to copy the record detail into a list box! Thanks in advance
  11. I

    Another SQL

    Ideas please Does anyone have any ideas on how I can append the data from a quey to a table in another data base! The key here is I want the data to be added to the existing!
  12. I

    Another SQL

    Hi Have got this code but cannot get it to work. Has anyone have any idea why! It cannot find the input table dbCentralFulfillment! Dim dbs As Database Set dbs = OpenDatabase("C:\Documents and Settings\ithompson\Desktop\XeroxCentralDataBase.mdb") dbs.Execute ("INSERT INTO tblFulfillment " _...
  13. I

    Sql

    I am trying to copy data from a table then name the table with the Now() data. So each time the code is run a new table is created named with the date and time. I have used this so far: DoCmd.RunSQL ("SELECT * INTO datNow FROM xx") Can anyone help!
  14. I

    Sql

    Hi I am trying to append data from a form to a table. I have completed the vba below with out success. Can anyone help! Dim intBatchNumber As Integer Dim strType As String Dim dbs As Database Set dbs = OpenDatabase("PrintActivity.mdb") intBatchNumber =...
  15. I

    Populate field

    Hi I have a calendar control on a form. When I click on a date it populates a field in a subform. How can I get the code to move to the next blank record in the subform so when I click on a new date it populates the next record! This is the code I us to populate the subform: [tblSickLeave...
    • IanT
    • Thread
    • Replies: 1
    • Forum: Forms
  16. I

    text box number

    The number is used as a unique batch number for a piece of work produced.
  17. I

    text box number

    I have a text box on a form which shows a auto number. I would like to format the number when shown to split ie (123 456) instead of (123456). Can any one help! Thanks in advance. :
    • IanT
    • Thread
    • Replies: 3
    • Forum: Forms
  18. I

    Create data in table

    point I want to build up month data in a table, to link to a combo, so it can be used in selecting criteria in a report. ie sales in January 2004.
  19. I

    Create data in table

    Hi When I open a database, I would like to look at the current date, convert it to the month and update a table with the month only if it has not already been recorded. Is there a way of doing this!
  20. I

    Identify User

    Hi I have a multy user DB. Is it possible to identify who is using the data base. Access 2000 locks out if a user is inactive over a period of time which means no one else can us it!
Back
Top Bottom