Thank you aDezii,
Thank you very much. I am please to hear from you that you are ready to send the demo copy of the same.
Can you please send it to riphath@hotmail .com.
I appreciate your response and happy to see the code.
If required, I will customise it.
With sincere Thanks and regards
Repath Athyala
repath
Last Activity: Jan 10 '11, 07:31 AM
Joined: Dec 21 '09
Location: HSBC - Hyderabad
-
Dear Lysander,
what I thought is that,
1. create a new database on the desk top by selecting DISTINCT CLASS clause from the entire database.
2. This will give me values like class I, class II, class III,... class X and store them in an arrya say: arrClass
3. Now I want to create seperate access.mdb file for each class with the name of the class for each access mdb.
4. Create distinct...Leave a comment:
-
Dear ADezii,
the database has two tables, two forms and none other.
One form is to input data into existing database
the other is to retrieve data from the existing table on various conditions like top 10, more qualitative student, best in class, best in all classess, top students in each class, their performance per month, quarter, half-year and yearly and the other parameters.Leave a comment:
-
Hi Moah Scout,
as per my knowledge, reports are not dynamic:
Hence you should have code to place the number of required controls as headers in header section and text boxes in the detailed section so that they are automatically populated. (but at the contents grow, this becomes too illegible to read.
the following link may be of some help:
http://bytes.com/topic/access/insigh...eate-dynamic-r...Last edited by repath; Dec 31 '10, 11:49 AM. Reason: added link from our site as a help to the questionLeave a comment:
-
repath replied to how to prepare a report that identifies the five most expensive bikes from the db.in AccessHi Sharon,
the following link can help you..
http://allenbrowne.com/subquery-01.html#TopN
With Regards
Repath Athyala
www.Repath.WordPress.com...Leave a comment:
-
Hello Ganimex,
your task is simple, if you know how to create a SIMPLE QUERY.
If you know, then as a first step:
Create the said PREPAY, MONTHLY, SPOTWORK Queries.
as second step:
place a combo/drop down list box and select its source property to be VALUE LIST and type these three values in the combo box.
you have docmd.openquery
follow the syntax and write at the click code...Leave a comment:
-
Hello Andy Briggs,
if you are using any database then, the following solution works well.
In the table (from which you are populating values into the form), create a date column (with some temp name like jdate or dDate or the like) and put the Date value in the table with the above said functions like NOW() or DATE().
Now update this value from table to the respective field on the Form.
I hope this will solve...Leave a comment:
-
Segregate access database conditionally
Dear All,
I will take a hypothetical example:
I have a consolidated database which has the details all the students from class 1 to class 10 in a school (in Ms.Access)
All the data for all the students is maintained in a single table. (nearly 13 fields)
Now I want to segregate them into 10 different databases and distribute it to the 10 different classess so that they donot have to each others data, database... -
Validate another control based on selection.
Dear All:
Issue: I used a tab control with 3 tabs, named personal details, academic record, Extra curricular activities (ECA):
Each tab has respective controls like option buttons with in a frame, check boxes, text boxes, list box and others.
Like wise for the rest of other tabs. I have placed another control CheckBox (3 in number - each one for one tab)
Reason being: When I click UPDATE command button,... -
Deploy tool developed in Ms.Access 2003
Hi all,
I have developed a tool for a team in Ms.Access 2003.
According to the microsoft I have downloaded the RUNTIME Environment.
This is added to the network login Profile of all the users over here., and is installed automatically on the users computers.
The RunTime Environment can identify the tool.
When double clicked on the tool deployed on the share drive to which all the users have... -
Searching a record with special Characters
Hi,
I use DCount function to count the number of entries for the existing customer by name of the customer in the database table.
Table Structure like: CustRegion, CustName, OrdersPlaced.
One of the customers has a name like O'Neil
...Code:Me.lblOrderCount.Caption = "Total Orders Placed: " & DCount("CustName", "backUpData", "[CustRegion] = '" & Me.cmbCustRegion.Value -
I believe, tables will automatically be created in Access Database when you are importing any sheet from Excel based on the parameters given in the TRANSFERSPREADS HEET function.
So it is not the case with the table structure.
I even tried with Import External Data from File Menu in Ms.Access and the error is SUBSCRIPT OUT OF RANGE
Why does this happen...?
Any prompt answer will be app...Leave a comment:
-
3709 Runtime Error
I tried the code with automation:
For Each sheet In objWorkBook.she ets 'for each sheet in excel loop
Debug.Print "Imported sheet is :"; sheet.Name
DoCmd.TransferS preadsheet acImport, acSpreadsheetTy peExcel9, sheet.Name, "OperatorDa ta", True, sheet.Name & "!"
Next
the OPERATORDATA excel file has 10 work sheets.
after importing 6 sheets, this run time... -
more than 2 billion recordsLeave a comment:
No activity results to display
Leave a comment: