In my Access(2003)Dat abase,I need to convert Row data to Columns..
For ex-E1
E2
E3
should be converted to E1 E2 E3 as Column headers...
Can anyone help me with some solution for this Conversion of Row data to COlumns..
Thanks
shalskedar
Last Activity: Nov 30 '11, 12:35 AM
Joined: Sep 23 '09
Location:
-
Converting Rows to Columns
-
Thanks for the solution...Its working fine .. -
How to Export Text (column) data from Access to Excel
In my Ms Access 2003 Database,there is a Text Column "Inv no" which stores the values as
"11/1234"
"11/2345PF" etc
When I try to export the Report containing this column,this column in Excel displays any arbitary value as "8990" or "6789" etc....
whereas actually the value displayed should be "11/1234"...
What format... -
How to Concatenate data in a Query?
In my Ms Access(2003)Dat abase,I need to concatenate data before the String..
For ex-If the String is"P001"..The data after contenating should be displayed as "10/P001"..
As seen in the above Example I need to concatenate String "10/" before the original String..
Can anyone Plz help me with some solution for this...
Thanks -
I need to display the result in query..Leave a comment:
-
Which wildcard to be used to display 2 digit numbers
In my Database for 1 of the fields as "ID "
i need to display the criteria as
10/2...followed by some characters till 90/2---
for ex-10/2001
11/2008
----
----
90/2005
So what criteria/wildcard i use for the above numbers..
The "ID" starts with 2 digit number as 10,11---90..
Can anyone Plz help... -
The Database contains 2 fields as Username & Password...
In the form there are 2 text boxes viz Username & Password & contains a command button as Submit...The code is been written on this button..
Plz help with some solution....Leave a comment:
-
How to continue the code on the same line
On Command_click i 've written the code but i m getting the error as "expected line number or label or statement or end of statement"...
The code is as follows for the Username & Password..
If Username="ash" and Password="ash1" or Username="par" and Password="par" or ---------continued for some 12 users,
At the end of the line after "or" ,I get the... -
shalskedar started a topic How to paste data from specific cell to the entire column in another workbook.in AccessHow to paste data from specific cell to the entire column in another workbook.
I need to copy data from 1 workbook & paste to another workbook which i could do.. but i m not able to paste the data starting from the specific cell...
Below is my code
...Code:Dim wbk As Workbook strSecondFile = "c:\\v.xls" ThisWorkbook.Sheets("Sheet2").Range("F:F").Copy Set wbk = Workbooks.Open(strSecondFile) With wbk.Sheets("Sheet1") -
How to copy a column(number format)from 1 worksheet in another worksheet
I need to transfer data from 1 worksheet to another worksheet..
Below is the code i m using to transfer the data..
...Code:sub mm() Worksheets("planning").Range("P7:P355").Copy Worksheets("Sheet2").Range("C2:C355").PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False MsgBox "done" end sub -
Thanks...
This data will b in the form of different columns whereas the data to be displayed should be as
Record1-20
Record2-43
Record3-46Leave a comment:
-
Splitting of a cell value
In my Application,I need to split the cell value in such a way that the each splitted values is stored as different record...
for ex-If the value in the cell A1 is (20,43,15) then it should be stored in the Database(Ms Aceess 2003) as
Record 1 :20
Record 1 :43
Record 1 :15
How to write a function in vba so as to split the cell value without using the built in option "Text... -
"Runtime error 3061..Too many few parameters..Expected 1"
In my DB(Ms Access 2003)I want to delete a record from 1 table which is linked to another table.
For ex- There are 2 tables "MasterType " which is the Master table & another table as "Sash DO" which is linked to this master table..Both the tables are linked by 1 common field as "Type"
I've designed a form with a TextBox in such a way that the user needs to enter the Type name which is... -
Thanks.
Had been checked several times that the Database is opened exclusively but still this error occurs..Leave a comment:
-
Compact & Repair not working for Microsoft Access Database 2003
The Compact & Repair option is not working on 1 of the computers .The Operating system used is Windows XP.
In the Database,when the Compact & Repair option is used it creates a separate file as db1.mdb.
Whereas other computers this option works fine..it no longer creates db1.mdbs separately.
Does the computer which is not able to do Compact & Repair require any specific setting..
Can... -
Client computers gets disconnected from the Server
We are using Microsoft Windows Small Business Server.
Operating System:Microsoft Windows Xp Professional
version 2002
Service Pack3
My query is some computers automatically gets disconnected after 5.30 pm..
We need to restart the system to get connected to the Server..
For the server settings there is no such scheduler set to such specific time for which... -
How to convert record row values into column values
In the Ms Access 2003 database,in 1 of the Reports I need to display the records in the form of columns..
For ex-If the values are
Elu
Ela
Res
then this data is to be displayed as
Elu Ela Res
Can anyone Plz help me with this.. -
How to delete record from a specific table
In the Database I need to delete a record from a specific table..
For ex-There is a field called as "Type" contained in the Master table "Type" .
I need to build the query criteria in such a way that i can select the table,let's say from combo box,so that the data from the particular table can b deleted
Can anyone Plz help me with such deletion of record from a specific table. -
There is only 1 form Copy of WIP ,contains 1 field as "RM"..This form is inserted as subform in the Main Report..In this Report need to display the grand total..but the
gives an error..Code:Sum(txtdisplay)
Leave a comment:
-
How to find grand total for subreport field
In my Database 1 of the Report i need to find the grand total for a field which is inherited from the 1 of the subform..
Ex-The report field control source property is set to as
=[Copy of WIP Form]!Text1693
where Copy of WIP Form is a subform on the main Report..
I need to find/display the grand total for this field.
Can any one Plz help me as to how to find the grand total...
No activity results to display
Leave a comment: