Search results

Thanks RV, I know that the DB is poorly designed. But I am not the owner of the DB. The tables in the DB are created by converting the spreadsheets in to tables. The spreadsheet is generated by another tool, so pretty much I am stuck with this. I know that to store data period wise is a better...

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

I am also trying with inner join.....Me.Pcycle is the table with all the fields that is data fields too. Duplicate is the summary table with latest records and I am saving the result table as Final_Duplicate table strSQL4 = "SELECT p.* " & _ "INTO [Final_Duplicate] " & _ "FROM [" & Me.PCycle...

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

yes.. I need to change the layout of report dynamically...Because the table I am getting output from the query statement can be having different field names each time. So need to have some kind of loop logic i put as above. Is there not any other way because I am not going to know the field...

I am trying this kind of loop logic.... Me.Parameters is the table name Dim dbD As DAO.Database Dim dbF As DAO.Field For i = 0 To dbD.TableDefs([" & Me.Parameters & "]).Fields For Each dbF In dbD.TableDefs([" & Me.Parameters & "]).Fields Set txtReportColumns =...

Hi Keizo.. rpt.RecordSource = "SELECT p.* FROM [" & Me.Product & "] p" Set txtReportColumns = CreateReportControl(rpt.Name, acTextBox, , , "infr_itm_nm") This one puts field infr_itm_nm on the report. But what I want is to output all the fields of the table on the report, so should I do this...

Thanks.. But won't rpt.RecordSource = "SELECT p.* FROM [" & Me.Product & "] p" statement assigns all the records from the table to record source. If not then what should I do to display the records of those query tables in to report?? Please help with this. Thx again..

Thanks Keizo, But actually I did not get what u r saying? I am only doing the previous coding in the button click event of my form.

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

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

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

Hi..Thx... But i do not have productID in my table. In place of that can I put combination of 2-3 fields to make a unique combination? and how to do that?

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

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

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

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

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

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