Just what I was looking for.
missinglinq never miss :)
kudos! (^_^)/
keirnus
Last Activity: Sep 6 '10, 05:28 AM
Joined: Aug 11 '08
Location: Nagasaki, Japan
-
Oooops! I did it again...got it already (with the help of my friends)...
The answer is UNION...
The query would be like this:
It is my first time to use this query...hehe.Code:SELECT ColumnLetter FROM TABLE1 UNION SELECT ColumnLetter FROM TABLE2;
I admit, I am noob...Thanks for reading anyway.Leave a comment:
-
Query for getting all unique data from 2 Tables
Hello,
I actually don't know where to post for SQL Queries used in MS Access.
If this is not the correct thread, please redirect this to the correct one.
Anyway, I am kinda newbie to the query I want here.
Let's say TABLE1 has the following data:
<ColumnLetter >
A
B
C
TABLE2 has the following data:
<ColumnLetter >
B
C
... -
Auto-compute on cells of Datasheet
Hello,
I got something interesting which I hope it really exist.
If the title isn't understandable enough, I will explain further.
I have a SubForm in Datasheet view.
I set SubForm's Control Source with a SQL query in order to display a table of data.
Example:
Same as the automation in Excel, I want something to be implemented in Access.
Everytime a data... -
I was able to make a test form.
I got a subform in Datasheet view in my form.
I set the Recordset of the form and executed the tests for Begintrans, CommitTrans and Rollback in DAO. All went well.
I implemented it in my system. But I can't edit the fields.
My guess is the query in my Recordset is using more than 1 table and the data displayed came from more than 1 table as well. Unlike in my test which...Leave a comment:
-
hmmm...it could be...
DAO and ADO are different, right?
Have to check it when I get back in the office tomorrow.
But, if DAO or ADO works, would it still be working for a Datasheet?
Could it be because I'm using Datasheet?
Coz I checked the net and there aren't any samples of Datasheet....Leave a comment:
-
BeginTrans, CommitTrans, Rollback in Datasheet (MS Access)
Hello,
I am using Datasheet view when displaying my data.
The data are displayed in a "x,y" matrix wherein data can be directly edited
in the Datasheet.
Anything inputted in a certain cell is directly updated to DB.
I want to open the Form, input data but WILL NOT COMMIT then close the Form.
If I open the same Form again, the data shouldn't be changed because it wasn't committed.... -
I want to select one cell only. Data are inputted or edited per cell only.
Yes, both axeses in the matrix are dynamic. Let's say the data in rows are fruits like Apples and Grapes. The headers in columns are stores that are ordering the fruits. There are variety of fruits. There is a possibility that the company will add more stores who are ordering the fruits or delete one when the contract was not continued. That makes the...Leave a comment:
-
Editable Multiple Cells in One View/List/Form
Hello,
Once again, I need some advices from the Access Gurus here.
I have a list of data. Please refer to sample below:
I need to edit from x1y1-to-x3y4 cells.
It's like editing multiple cells in one view.
Editing the items will be faster when done this way.
What is the best UI Design and table structure for this display?
One more thing...y_Item ROWS... -
nevermind...i thought it will take me long time to figure it out...
sharing my knowledge:
Code:With oXL .Workbooks.Open (sXclFilePath) .Workbooks(sXclFilePath).RunAutoMacros (xlAutoOpen) .Application.Run ("ErrorCheck") .Workbooks.Close End WithLeave a comment:
-
Calling an Excel Customed Function Within MS Access
Hello once again...
I made a function in Excel. The function does some error checking within the Excel file.
To be easy for me, I want my code in MS Access to simply call the function in Excel.
I check this MS Support site: http://support.microsoft.com/kb/198571
I tried calling my function and it didn't work.
Here's my MS Access code:
...Code:Dim oXL As Excel.Application
-
(I edited this reply coz I was wrong...sorry)
Thanks for the reply ADezii.
But I noticed something. The SortKey is the column index in listview.
It starts with zero(0) so in my example, since there's only 1 column so
it starts with index 0. If I got 3 columns and want to sort the 2nd, I will
be using index 1. (please correct me if I'm wrong)
I tried sorting the column with number type...Leave a comment:
-
Sorting Number Type
Hello,
I am currently using Listview control.
The sorting feature of the control is useful.
It sorts well with Text type but is weird when sorting Number Type.Code:<ListviewCtrlName>.Sorted = True <ListviewCtrlName>.SortKey = <FieldToSort> <ListviewCtrlName>.SortOrder = <SortOrder>
Ex.
(before sorting)
[1st] 3
[2nd] 2
[3rd] 11... -
I am referring to Freeze Panes... =D...Leave a comment:
-
Thanks Stewart for the advice.
I like the less is more perspective.
Also, thanks to DonRayner and NeoPa for the advices.
Continuous Form is a good start....Leave a comment:
-
oh yeah...that was two "total" words...sorry about that...they are just one and the same...those total data are total per column...so each column has its own total amount.
like what you have stated, remaining a set of totals while scrolling (up and down) the rest of the data.
what if due to lots of data (vertical and horizontal), there would be vertical and horizontal scroll bars...it would be great to maintain...Leave a comment:
-
Thanks Stewart for your reply.
How about in Listview control?
Is it possible?...Leave a comment:
-
Vertical Freeze Pane in Datasheet
Hello,
There's a freeze pane function in datasheet but for horizontal scroll only.
How about for the vertical scroll?
I need to implement this to be able to view the total data of each column by scrolling up and down but maintaining the view of the total data.
Calling all the Access gurus for help.
-= kerinus =- -
Seems like "yes"...the columns are the workers in a certain project.
Let's say "Painter", "Helper", etc. These are the headers in a column.
Data in the column are numbers of workers per row.
There are times when new workers are added in the list.
So, there will be new columns for the new workers.
What's the best way to handle this number-of-workers matter?...Leave a comment:
-
You can give me the code.
I will try....Leave a comment:
No activity results to display
Leave a comment: