Moah Scout
Last Activity: Sep 16 '11, 08:32 PM
Joined: Oct 15 '10
Location:
-
Thanks alot Stewart! I will try your suggestion, this DB is just a trial version. It doesnt mater whether you disable it or not, we dont expect any editing after confirmation -
How to Make DB Objects Read Only?
Hi all!
I have a table of which should be converted to READ ONLY after confirmations! The Confirmation Button may be set to VBA to change the table properties to ReadONLY!!!!
Please help! -
wAOOOOO!!!
I couldnt imagine if this one were possible.
God has created you for us!
Finally I could solve my problem thanks again.
Thanks alot Neopa.Leave a comment:
-
How to Reverse a Crosstab-Query
Hi all!
I have a table in this format:
I want this table to be like thisCode:FirstName LastName Field1 Field2 Field3 JJ Ku 3 2 1 Lee Moah 2 5 3 Mr John 7 2 7
...Code:FirstName LastName FieldNames Values JJ Ku Field1 3 JJ Ku Field2 2
-
How to extend the FieldName
I have imported table(from Excel)with a Columns(Fields) named
Field1, Field2, Field3, Field4, Field5,.... and
I have a table with a FieldNamed
Field1 Names1, Field2 Name2, Field3 Name3, Field4 Name4, ...
I want this imported table name`s fields to change Automatically to:
Field1 Names1, Field2 Name2, Field3 Name3, Field4 Name4, ...
How can this be achieved! Please help!!!
Please Note:(Its... -
Being quite to this extent!
Does it mean impossible? I dont think so!!!
Should you think you need more clarification on this question, I willLeave a comment:
-
For the case of Dynamic report designed to be used with Crosstab Queries (Author: Nico5038).
1. Is it possible to vary the number of column headings with this?
2. Where is the recordsourse of this Code?Leave a comment:
-
Thanks!
I know that contents of dynamic report of MMcarthy, Nuco and Shap but couldnt settle my problem. The number of columns changes in my case, and I want to keep the same template!
I have three RowHeadings (do not Change) but the number Column headings changes from 3 to 27. When the templates prepared with three colHeading it wont function with 20columnHeading s.
I know I need a code on this but how?
please help!Leave a comment:
-
Moah Scout replied to Can't get Report to show data from records based on a Form's Combo Box choice.in AccessMy friend, you are talking too much!
Be straight to the point, brief as much as possible and includes all details of what exactly you are looking 4!
You may not get enough reponse otherwiseLeave a comment:
-
How to Create Dynamic Cross-Tab Query Reports?
Hi!
I have a crosstab Query with constant RowHeadings and Dynamic Column Headings. This Query is used as a record source for the reports as follows:
RowHeadings includes:
1. CustoName
2. CustoID
3. Products(SumOFP roducts)
Column Headings includes:
ColumnHeadings.
The problem is, with my Reports layout created with three ProductsName on the ColumnHeadings, I cant use the same... -
Try to use Cross-Tab QueryLeave a comment:
-
I didnt know how could this be possible, finally its.
Thanks all for your time!
Happy X-Mas and New yearLeave a comment:
-
Wellcome to bytes!
As Neopa said, it may be due to the [Quantity] try to replace [Quantity] with [Sales Query].[Quantity].
If it still gives you that parameters error, then try your design from the ScratchLeave a comment:
-
How to Transpose a TWO column table into Many Columns?
Hi all!
I have a table named tblCustomers, with the following fields,
...Code:ProductsName CustomerName Qty Maize Mpoto 2 Maize Mwita 3 Maize Mporo 5 Maize John 1 Mpunga Mwita 0 Mpunga Mpoto 8 Mpunga John 4 Mpunga Mporo 1
-
I have tried to past the code [ALTER TABLE Employees ADD COLUMN Next_Of_Kin TEXT(25)]on the data definition of the query DesignView but gives the same error as above and it works for tables as well!Leave a comment:
-
Sorry it works!
I have created a Module and run! It has created a new column named Next_of_Kin as you have stipulated, But if you run the Code against Query it gives error!
"Cannot execute data definition Statements on linked data structure"
How to get rid of this error?Leave a comment:
-
I have ambitions of using the code but couldnt make it.
Where can I exactly past the code?. Am not much familiar with access!Leave a comment:
-
How to insert new Field (column) in query
Hi,
I have a Select query from two tables, I want in this query to add new column so that I can enter a new data in that column directly. Under normal situations I know its impossiple, but with some sort of Designed VBA or SQL it can be made possible.
I also know how to insert column as expression in query, tell me how can a new field (not expression) be inserted?
Please, any hint!!!! -
Well it works after setting the Microsoft Office 14 Object Library, but it just open the dialogbox with .*XLSX* file format but it cannot allow me to select the desired sheet in a Spreadsheet and yet nothing happens after Click-OK; Only dialogbox dissapears. Assume it opens Successfully!
My question is How to set the newly opened .xlsx document to my query criteria without entering them mannualy?Leave a comment:
-
If you run the first Code, it gives error and point to the dlg As FileDialog:
User defined-Type not Defined.
I couldnt go around that error!Leave a comment:
No activity results to display
Leave a comment: