Hello,
I have few problem with Dlookup condition. I need to retrieve next record or previous record based on certain condition. The conditions are set in in the combo box. Here, I am trying to display the records in the text box based on my selection. I have given my selection in the combo box.
For example from the student table, I am trying to display as below...
a). Who are all coming from "Newyork"...
solargovind
Last Activity: Jun 23 '09, 02:28 PM
Joined: Mar 29 '07
Location:
-
Ms Access-Dlookup next record
-
Main form Selection data in Subform
Hi,
In my main form, i have one Combo box called "Student_na me" which displays Stud_id & Stud_name. When i select particular student name, i need to display their City in the Subform's text box.
Main form name is Mark_details. And,Sub form name is Stud_details.
I tried to use the below code in the text box of the control source.This text box is in Subform. But, it shows error like "#Name?"... -
Deletion of Current Record in Main Form & Subform
Hi,
I have one Form in which i have one subform also which links together by one common_id(Payme nt_id). When i display record, I need to delete Current record in both form & Table. I used the following code to delete.
---
Dim response
Dim strsql As String
response = MsgBox("Are you sure to Delete?", vbYesNo, "Payment Alteratiion")
If response = vbYes Then... -
-----
Its located in next controls of the gotfocus event..
Even, i tried with After_update of current control as below
If Not IsNull([Vendor_TAN_No]) Then
If Vendor_TAN_No.I nputMask <> "LLLLL0000L " Then
MsgBox "Eh..! The TAN Number must be 5 Alphapetic,4 Numeric, 1 Alphaphetic. Example : ABCDE1234A", vbOKOnly, "Vendor Creation"
me!Vendor_TAN_N o = null... -
============
Thnx...
Fine..But, I tried to show my own message instead of Access message in the message box as below ...But, its not working...
If Not IsNull([Vendor_TAN_No]) Then
If Vendor_TAN_No.I nputMask <> "LLLLL0000L " Then
MsgBox "Eh..! The TAN Number must be 5 Alphapetic,4 Numeric, 1 Alphaphetic. Example : ABCDE1234A", vbOKOnly, "Vendor Creation"...Leave a comment:
-
Validation Rule for combined Text & Number
Hi,
I need to accept in my Textbox ONLY 5 Alphaphetic 4 numeric and 1 Alphaperic. So, Totally 10 characters only should accept. And there should not be any space..
How can i Set validation rule & show my own message for this...?
Any suggestion would be appreciated GREATLY.
Thanks in advance.
ngr. -
=====
Thnx....its fine..the error was in compiling....Leave a comment:
-
Data From Excel File without import into Access
Hi,
Can anybody suggest me how to take data from an Excel file without import into Access as a Table..?
Bcoz...I hve several file. if i import, it would take more time and increase the file size..
My purpose can explain by below example..
In a Excel file, Assume that Name,Std,Mark1, Mark2,Mark3,etc ., are coloumn header, and under this coloumns header, necessary data are filled.
... -
MDE Problem
Hi,
When I try to make MDE file, it shows the below error..
"Microsoft Access was unable to create an MDE Database."
What could be a problem...?
Any idea would be greatly appreciated..
Thanks in advance..
ngr. -
How to Run Sql query in VBA code & Macro?
Hi,
In VBA code, How can i run Sql query..? I need to delete a record by the below query...
Docmd.runsql(De lete * from Payment_detail_ Table where Payment_id=(Sel ect Max(Payment_id) from Payment_Table)
Is it correct..? I tried, but its not working.
-------------
How can i run Sql query from MACRO..?
I put below code in Sql statement coloumn where it shows the below error...... -
--------------
Its ok....Actually, I dont get any errors. I am stumbling in calling the function which has been assigned in the module.
I believe you hve gone through those codes. I have done the steps what they have given in the URL. But, I am not aware how to call the code in Form's text box and in Report...
Believe its understood....( Please once again go through my whole question since beginning.)...Leave a comment:
-
Field & Field value
Hi,
I am using Ms Access'2000.
I have one Table called Rate_Table which contains all the rate for my consignments.,v iz...Rate for the particular weight and for the particular country
Note : Weight,USA,UK,U AE, etc.,are the fileds...
In one Combo box, i hve called "Weight" field's DATA as list of weight. Its for selecting the weight.
In another combo box, I hve called the... -
Rupees in words
Hi,
Can u please suggest me how to bring Rupees in words..?
I need to bring in Form's Textbox as well as in Report.
Mr.mmccarthy has suggested in forum to use as below code. But, I am getting quit doubts in calling the function in the form as well as in Report.
The Suggestion / Codes are in the below URL....
http://www.thescripts.com/forum/thread625202.html
Can... -
Help in Precaution to Safe database & Projects
Hi,
I have finished my project in Ms Access 2000.
My operating system is Windows'98.
My file Size is 15916 KB
Now, I hve below queries which i need to clarify with you.
1. Before & After Make MDE what are the steps that i should do to safe my database as well as Project...?
2. My company is medium size. What is the Maximum capacity of data storage?ie.,How... -
========
Hi,
Thanks for your answer.
I tried with your above suggestion. But...Even then..its not working...
Believe you hve understood already that i hve Autonumber field in my form whicy may causes problems
when i enter second field, the Autonumber fields get generated. It may give problems.
How to avoid even if the Autonumber field get generated..?
...Leave a comment:
-
Ignore to save data
Hi,
This question i hve asked in this forum already. They asked me to set Required property of field to Yes in Table design.
It was working fine. But, it is not convenient to me. So, I tried to put in the the below code which also allows me to stores the data.
--------------------
In the Command_Click() event..
Dim response
response = MsgBox("Are you... -
Subform query
Hi,
Can anybody suggest me how to call Subform/Main form's control in query...?
For example, I have Two combo box in Mainform.
If i select Student_roll_No in one combo box, in other combo box i need to display their marks,total,gra de etc., which has been called by query. This combo box has 7 coloumn heads which can display all the details.
How could i display 2nd combobox query list based... -
Bound Coloumns
Hi,
I hve designed one long QUERY which has number of fields which are to be shown in a form only 4 fields among more fields. These 4 fields fetches & shows records based on the control(combo box) which is choosen by the user.
For example,
In a form, Students Standard(8th Std,9th Std,etc.,) name are choosen by combo box and other Combox having query which is to be listed out based on the standard.... -
Unbound Control's data store into the table
Hi,
I need to store the Value of unbound Textbox control value into my table.
Because, I hve calculated Due date of Vendor's from the Invoice date which i also need to store into my table.
How could i do this..?
Any suggestions...?
Thanks in advance.
ngr. -
Query - Joins in Design View
Hi,
I am facing some eproblem in writing SQL query.
Hence, Can anybody suggest me how to assign Joins (Inner join,Outer join,Left join,Right join etc.,) in Query's Design View....?
For example,
From Stud_Table to Stud_Marks_Tabl e What could be a join while Dragging ...?
Suppose, If Stud_id from Stud_Table is linked to Stud_Marks_Tabl e's Stud_id, what could be a join created..?...
No activity results to display
Leave a comment: