Search results

  1. R

    Please help building up SQLs, for separating out Year, Quarter and Month data

    Hello Ppl.. I want help regarding generating different SQL statements.....for the following kind of table...... Product|Parameter|ItmDes|jan'05|feb'05|05Q1|05Y|jan'06|06Q2|06Y....... _______________________________________________________________ So what I want to do is to run queries to find...
  2. R

    to get a specific type of table in output from other table

    I think from an example it will be more clear what I want. Me.Pcycle is my original table that has all fields and data too. product | parameter | Item Des.| jan'05 feb'05 jan'06 jan'07.....| Revision ________________________________________________________________ M1 test time...
  3. R

    Error in find duplicate query, table not found

    Hi People, I am getting error in find duplicate SQL on DoCmd runsql strsql1 statement. What I am doing is declaring p as an alias for table name, because I am taking table name as input from user from the form. That table is already in the DB. When I do MsgBox "" & p, in place of table name it...
  4. R

    to find duplicate records from the table and mark them latest based on revision no.

    Hello People. I need some help coding with an application. I have a table that includes forecast of different parameters for different products. So when ever new forecast data is added the already existing data for same product and parameter is not deleted, but there is a field called...
  5. R

    Report generation help needed in VBA

    Hello. I need help regaring report generation with VBA coding. I want to use two different tables for report generation on If Else statement. These two tables are basically queries run for different parameters and products. SO I am doing this. It works correctly and generates the query...
  6. R

    to find duplicate records from the table and mark them latest based on revision no.

    Hello People. I need some help coding with an application. I have a table that includes forecast of different parameters for different products. So when ever new forecast data is added the already existing data for same product and parameter is not deleted, but there is a field called revision...
  7. R

    DoCmd.RunSQL statement error. MS Jet DB not able to find table

    Hello People, I am very new with VBA coding. I am trying an application in that I am doing following steps. 1. Converting excel spreadsheets in to tables 2. Merging all those tables in to one result table columnwise, means the tables can have same or different columns, so if they have same...
  8. R

    for password protection of forms from dashboard form

    Hi. From the dashboard I have buttons for 3 forms. But I want to limit access of these forms. So when someone hits button from dashboard, it should ask for password and if the password is correct then the relevant form is opened. How to do this? Thanks..
  9. R

    Assign a max value from parameters to other parameter in table

    Hi People, I am working on a database related application in which the user enters the data from the form and it is stored in 3 related tables in DB. This is what I want to do, If IsNull(Me.Q1_2005) = True Or Me.Q1_2005 = "" Then rs!January2005 = Me.Jan_05 rs!February2005 = Me.Feb_05...
  10. R

    to find out maximum from the records entered by the form

    Hi People, I am working on a database related application in which the user enters the data from the form and it is stored in 3 related tables in DB. This is what I want to do, If IsNull(Me.Q1_2005) = True Or Me.Q1_2005 = "" Then rs!January2005 = Me.Jan_05 rs!February2005 = Me.Feb_05...
  11. R

    Help regarding finding out maximum value from the records entered by form

    Hi People, I am working on a database related application in which the user enters the data from the form and it is stored in 3 related tables in DB. This is what I want to do, If IsNull(Me.Q1_2005) = True Or Me.Q1_2005 = "" Then rs!January2005 = Me.Jan_05 rs!February2005 =...
Back
Top Bottom