Hi,
You have an option in Access ie Macro.
In Macro, you can select SendObject from Action Column, Below you will find the details ie
Object Type : Report
Object Name : Report 1
Output Format : Snapshot Format
To: Email ID
CC: Email ID
BCC: Email ID
Subject: Subject 1
Message Text : Message
Edit Message : Yes/No
Templete File:
Save...
kartikss
Last Activity: Apr 25 '09, 01:58 PM
Joined: Apr 4 '07
Location:
-
Select the row as same as you select in excel and press delete button it will be deletedLeave a comment:
-
Presently i am working with help of coding
for ex
but now i want work with help of table name security...Code:private sub command1_click() if id= form_login.id=kartik and pwd=form_login.password=123 or form_login.id=guest and form_login.password=g12 then open the particular form else error message endif end sub
Leave a comment:
-
kindly inform previous message send by me
Hi!!!!
There are 2 options to work on it.
Option 1
1. Create a query by selecting 2 or more table in 1 query.
2. Select the fields in query as per your requirement.
3. After saving the query , then create a form
4. Select the tab option in form
5. Select the fields (created in query) in tab 1 and go to tab 2 select the...Leave a comment:
-
Hi!!!!
There are 2 options to work on it.
Option 1
1. Create a query by selecting 2 or more table in 1 query.
2. Select the fields in query as per your requirement.
3. After saving the query , then create a form
4. Select the tab option in form
5Leave a comment:
-
Here Data Entry Enable and Report Enable should function in such a way when i say "No" to Data Entry Enable and Report Enable , then it should be disable those command buttton and if i say "Yes" to Data Entry Enable and Report Enable , then it should be enable those command buttton.
So how do work on it?
Thanks & Bye
Kartik...Leave a comment:
-
Security Control To Certain Users In Ms Access
I Have Created A Table & Form : Named : "Security Control" : Field Having
User Id - Text (pk)
Password - Text
Data Entry Enable - Yes / No Option
Report Enable - Yes / No Option
And
I Have Another Form : Named "Login"
Field Having
User Id And Password
I Am Trying To Pick Up User And Password From Security Control... -
...Code:Private Sub Command12_Click() If USER_ID = [Form_LOGIN MASTER].ID And PASSWORD = [Form_LOGIN MASTER].PWD Then MsgBox (Form_Login.USER_ID + " - " + "WELCOME TO ENAM SECURITIES PVT LTD") Dim stDocName As String Dim stLinkCriteria As String Me.Visible = False DoCmd.OpenForm "STARTUP", acNormal, , , acFormEdit, acWindowNormal
Leave a comment:
-
I Am Working On Ms Access, So Whatever I Enter On Form Gets Automatically Gone To Table. So Whenever I Open The Form , All Records Are Displayed. I Want To Display A Blank Form Directly. I Should The Records To Display Only If I Search The Record. For Editing Or Changing The Records.
So How Do I Work On It.
Thanks & Bye
KartikLeave a comment:
-
Blank record while opening the data entry form in Access
I have different form linked with command button, when i go to data entry i get 1st record details avaiable in table. i do not want the data display until i get a command to search a record and only that record to be display in access
how do i work on it?
Kartik -
Mailing Address also different from Residental or Office address.
How do work on it ?
The entire help is in MS Access only.
Thanks & bye
kartik...Leave a comment:
-
HIDE / SHOW OF FORMS in MS Access
HI!!
If I have 2 forms ie form 1 , form 2
In Form 1 I have a command button to open form 2.
how will i hide form 1 and show form 2, until i click on close button it open form 1 and form 2 should hide. in ms access
how do i work on it on ms access?
Thanks & bye
Kartik -
Auto pick up of default address in printing in ms access
Hi!!
I have two different addresses ie Residental Address and Office Address. I have also created a drop down list for default option giving Residental and Office, and go to mailing address (field created for mailing address) along with their names in MS Access
Residental and Office Address having fields of Name, Address, City, State, PinCode, Country, Phone Nos, Email ID etc....
Same field are... -
You don't require dim option here. no coding required.
simply create a table you need create field name next to field go to data type and select memo instead of text
Thanks & Bye
Kartik...Leave a comment:
-
I want this option to worked on old toolbar or menu available also.
Thanks & Bye
KartikLeave a comment:
-
Enable and Disable option in Toolbar or Menu to certain user.
I have a created new toolbar and inserted new menus in it.
I want to enable or disable option to those new menus created by me to certain user created by me.
How do I work on it.
Thanks & Bye
Kartik -
Hi!!!
try this option
In Query select two table ie A & B and select the field as per your requirement.
Go to the field name "Codes" there is option certeria - write this code ' =Like "*" & ["Codes"] & "*" '
it will work
thanks & bye
KartikLeave a comment:
-
Hi!!!
Is there any option because when i create a form linking to the table of login and enter everyone user and password, i want the user to to enter the username and password , if the user name and password matches the login table, then it should continue or else it should show an error message.
thanks & bye
KartikLeave a comment:
-
Hi
For Yes/ No you try working this option ie
First table for Yes / No
In another table create Field where you want to create Yes / No option. - select the data type as Yes/No
Below there is option of General in that there is option of Format. in that option is combo box select yes/no option from the drop down list.
try this option, it might work.
thanks & bye...Leave a comment:
-
Hi
If you want to search the word or letter, create a query for particular table and select the field to be displayed in query. Just below the field ie in cirteria write this command - Like "*" & ["Field Name"] & "*"
Eg: Table having 5 field - code, name, add, city, pin
in query select all field if required, if you want to search address then below the address field...Leave a comment:
No activity results to display
Leave a comment: