Question about Microsoft Windows XP Professional

1 Answer

To dispaly row without duplication

Hi !
Plz solve my problem,
there is a query table (query) in this tabel there sare so many rows that contain one rows more time like 5 time or etc.
now i want to retrive a row from it without retriving all rows but i want to retrive that duplirow one row so plz give me the access query that display the same rows one time.
thanks for help.

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 44 Answers

Mini-05,

Try something like this:
SELECT DISTINCTROW Serial.SerialNumber, Serial.ID
FROM Serial
WHERE (((Serial.ItemID)=[CurrentItem]) AND ((Serial.Sold)=False))
ORDER BY Serial.SerialNumber;

Good luck!

Posted on Aug 05, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Merge rows and columns of table in vb


Under edit there should just be a button called merge cells. Columns you want to merge by holding shift and clicking on them. Then click merge cells.

May 03, 2011 | Operating Systems

1 Answer

Sir, I developed a website. I this website i have taking a table which have 3 rows and 1 column. In each row I am show the different slide show with mouseover event. but it is possible only a single...


Hello
  • Use the Marquee and other Html code with there attribute to get the desire result.
  • Here is the example for your problem :-

ykeen is my name! ykeen is my name!

Mar 28, 2011 | Microsoft Windows XP Professional for PC

1 Answer

I can not draw a table in microsoft word


hi ermelitacapa,

To create a table in Microsoft Word please do the following:

1. Go to the Table menu and select 'Insert Table'. The Insert Table window will open.
2. Select the number of rows and columns you want in your table.
3. Select the column width (up to 22 inches) or choose 'Auto' to have the column with adjust automatically, making the table extend across the width of the page.
4. Select the AutoFormat button to select one of Word's pre-formatted table styles. The Table AutoFormat window opens.
5. Click one of the styles in the Formats box in the upper left side of the window.
6. Preview each format, after selecting it, in the Preview box in the upper right side of window.
7. To customize a pre-selected format, select or de-select the borders, shading, font, color, heading rows, first column, last row and last column boxes.
8. Select AutoFit, and Word will automatically fit the table to your page.
(To manually change the width of a table or column after you have created it, use the mouse to place the pointer over the vertical line you want to move. When the pointer turns into a double-headed arrow, drag the line to the position you want it in the table.)'

I hope this helps!

** If you find this information helpful please leave feedback to help us help others **

Feb 24, 2011 | Microsoft Windows 7 Home Premium 64BIT...

1 Answer

We have a script which generates CSV file from DOS based paradox 4.0 table. Please let me know if there a way to get the report with table column description as the first row with the report generation.


What scripting language are you using?

In general, I'd say it wouldn't be hard, generically, you could parse the query and/or results to get the description.

Alternately, if your reports always use the same fields in the same order, simply write the headers to a file then append the results of your query (append instead of write).

Aug 29, 2010 | Operating Systems

1 Answer

I need to print mailing labels imported from excel to word in columnar order instead of in order by rows across the page.


hi Samajane,

I understand the you excel file has data that is stored column wise. Well you can first convert the column wise data to row wise data and then import it to you word.

To convert the column wise data to row wise data.
1.Select the data in your worksheet.
2.Right Click -> Copy
3.Create a blank worksheet.
4.Goto Edit - > Paste Special
5.Check the Transponse Option
6.Press OK.

Now you have converted your column wise data to row wise data and now u can import it to your word and print mailing labels

Dec 14, 2009 | Microsoft Windows XP Professional

2 Answers

Printing syntax


'declare the variables
Dim Connection
Dim ConnString
Dim Recordset
Dim SQL

'define the connection string, specify database driver
ConnString="DRIVER={SQL Server};SERVER=yourServername;UID=yourUsername;" & _
"PWD=yourPassword;DATABASE=yourDatabasename"

'declare the SQL statement that will query the database
SQL = "SELECT * FROM TABLE_NAME"

'create an instance of the ADO connection and recordset objects
Set Connection = Server.CreateObject("ADODB.Connection")
Set Recordset = Server.CreateObject("ADODB.Recordset")

'Open the connection to the database

Connection.Open ConnString

'Open the recordset object executing the SQL statement and return records
Recordset.Open SQL,Connection

'first of all determine whether there are any records
If Recordset.EOF Then
Response.Write("No records returned.")
Else
'if there are records then loop through the fields
Do While NOT Recordset.Eof
Response.write Recordset("FIRST_FIELD_NAME")
Response.write Recordset("SECOND_FIELD_NAME")
Response.write Recordset("THIRD_FIELD_NAME")
Response.write "<br>"
Recordset.MoveNext
Loop
End If


'close the connection and recordset objects to free up resources
Recordset.Close
Set Recordset=nothing
Connection.Close
Set Connection=nothing

May 16, 2009 | Microsoft Windows Vista Ultimate Edition

1 Answer

1. A software company has the following information about its cl


Shouldn't you be doing your own school homework?

Nov 18, 2008 | Operating Systems

1 Answer

Flex Grid


The most common multidimensional array, the two dimensional array table, is best presented to your users in row and column format. The grid control offers a convenient way for you to display table data to your users. The users can navigate the table's values using scrollbars. Therefore, the grid control does not have to be as large as the table, because the grid control automatically displays scrollbars.
To add the flex grid control to your toolbox, select project and components. Add the flex grid control:
lesson97-1.jpg Once it is added, you will see the yellow flex grid control in your toolbox:
lesson97-2.jpg When you place the grid control on your form, you will have to resize it before the control takes on a tabular appearance. As you expand the size of the control, it does not look to much like a table. The problem is that the table's default number of rows and columns are two. To fix this problem, you must configure the rows and columns in the properties window:
lesson97-3.jpg lesson97-4.jpg lesson97-5.jpg The grid control supports fixed rows and columns. These refer to rows and columns in a grid control that do not scroll when the user clicks the scrollbars. The fixed rows and columns provides labels that describe the data. The fixed rows and columns are often called row and column headers.
lesson97-6.jpg When working with the grid control, much code is needed to provide the grid with functionality. Call statements are used to break the code required by the grid control into smaller, more manageable procedures. This is referred to as modular programming (which refers to the practice of placing code with a single purpose in a general subroutine procedure and then calling the code from a second procedure.)
Here is the code for the form load procedure (this example is based on the computer disk example used in the last lesson)


Private Sub Form_Load()
Call SizeCells
Call CenterCells



grdGrid.Row = 0
grdGrid.Col = 1
grdGrid.Text = "Single Sided; Low Density "
grdGrid.Col = 2
grdGrid.Text = "Double Sided; Low Density"
grdGrid.Col = 3
grdGrid.Text = "Singled Sided; High Density"
grdGrid.Col = 4
grdGrid.Text = "Double Sided; High Density"

grdGrid.Row = 1
grdGrid.Col = 0
grdGrid.Text = "3 1/2 inch"
grdGrid.Col = 1
grdGrid.Text = "$2.30"
grdGrid.Col = 2
grdGrid.Text = "$2.75"
grdGrid.Col = 3
grdGrid.Text = "$3.20"
grdGrid.Col = 4
grdGrid.Text = "$3.50"



grdGrid.Row = 2
grdGrid.Col = 0
grdGrid.Text = "5 1/4 inch"
grdGrid.Col = 1
grdGrid.Text = "$1.75"
grdGrid.Col = 2
grdGrid.Text = "$2.10"
grdGrid.Col = 3
grdGrid.Text = "$2.60"
grdGrid.Col = 4
grdGrid.Text = "$2.95"

End Sub
Notice how the form load procedure is used to populate the cells in the grid control. To control cell size and cell alignment, two smaller procedures are created and each procedure is called by the form load procedure.


Private Sub SizeCells()
Dim intColumn As Integer

grdGrid.ColWidth(0) = 1100

For intColumn = 1 To 4
grdGrid.ColWidth(intColumn) = 2200
Next intColumn

End Sub

Private Sub CenterCells()
Dim intColumn As Integer

For intColumn = 1 To 4
grdGrid.ColAlignment(intColumn) = flexAlignCenterCenter
Next intColumn

End Sub

Notice that the size and alignment procedures are only applied to columns 1 through 4. Column 0, which is a fixed column reserved for labels, is not formatted using either of the above two procedures.
Here is the final result:
lesson97-7.jpg

Mar 26, 2008 | Operating Systems

1 Answer

How to create labels from excel data sheet


sir u just have to write all info row wise then ur issue will be resolved good luck

Oct 21, 2007 | Microsoft Windows XP Professional With...

Not finding what you are looking for?
Microsoft Windows XP Professional Logo

Related Topics:

235 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Operating Systems Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Scott Fryer

Level 2 Expert

80 Answers

Carlos L. Burgos
Carlos L. Burgos

Level 2 Expert

508 Answers

Are you a Microsoft Operating System Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...