I've searched the site and haven't really come up with an answer for this. I have a Report that I want e-mailed to two people every 10 days. If someone could give me a direction to start in, it would be appreciated.
View RepliesHi, this is probably a very easy question for you “Access-gods” out there.
I’ve made a database (MS Access 2000) with all my clients. I collect a lot of contact info, including e-mail.
I want to make a function which opens a new mail window (Outlook 2003) and automatically puts in the e-mail from my form (In the send-to field of outlook).
Is this possible? And how?
(BTW: I’m a newbie with VBA)
I have a ms access table with two fields...tablename is ..."Addresses"..
Field1:= Employee_mail_id
Field2:= Leave_balance
What I need to do is that,I need to send individual mail (in Bulk) two each employee intimating their leave balances.
Is it possible to do it in vb .I want it to assign the codes in a button.
Below iss the code.
Dim r As Recordset
Dim email As String
Set r = CurrentDb.OpenRecordset("select * from Addresses")
Do While Not r.EOF
email = email & r(2) & ";"
r.MoveNext
Loop
r.Close
DoCmd.SendObject acSendNoObject, Null, Null, email, Null, Null, "Test subject", "Message body of the test letter", False, Null
I have a single table called "Books". One column is "Book title" and one is "Author(s)".
One author may have written several books, and one book may be co-authored by several authors.
It should be ok to use the analyze function to normalize the table into 3 tables. (autors, books and booksauthors_xref)
The problem is that the Authors-column contains one or more autors separated by ;
When I use the analyze function I only get the first autor in the join table. Since authors "AA ; BB" are treated as one, not to entities I had to split the field into a "co-autor" column and manually add one and one co author.
Is it a smarter vay to do the normalization?
hey, where can i set or how can i make the access automatic generate the the number. like i want it start from:
Account number: Ra-b200
Account number: Ra-b201
Account number: Ra-b202
cheers
I want generate and load the report using vba when a command button is clicked . (automating the report generation)
For example i have table in access that has name, address and email fields and onced command button is clicked the report is
generated and loaded.I be happy if some one show me wprking example.Thanks
Hi,
I have the following very general question, but I hope you can give me a few hints so I can start and find things out on my way.
I just created a database which via VBA procedures runs all kinds of queries and puts the results in tables, for instance I have about 20 tables now with 10 fields each and for every table I want to run the same type of report.
I already made one report for one table via the report wizard, I would like to use the layout of this table for all other tables using a VBA code, so when I run this code it will create all these reports for me.
What is the best way to start?
Many thanks!
can I make a field that can auto-number which the format that I want??
As I know that there is two format for auto-number
but I don't like them
I want to number my own format
like
XXX-YYYYMM-ZZZZ
XXX is the category number that would be selected in the form connecting to table
YYYYMM is the date year and month
ZZZZ is another auto numbering
Can I do so
i have a table where one column has numbers such as 6104003 and i would like another column to recogzie this number and make a new string in this format 61P04-003 ajacent to it. can i do that in a table or does it have to be a querie? and the bigger question is how do i do this :confused:
View 3 Replies View RelatedI have to generate unique code for each person in an Employee table. This code will not be the primary key for this table. Primary key is an auto number. This Unique code is for refering to each person in all the correspondence/document/everywhere and every person will know his code and refer in all the correspondance.
I want to make a column in this table for this code. There can be two criteria for this code generation--
1. The code will be First alphabet of first name followed by sr no for that letter in 4 digits. Say Mr. Andrew is 99th person with alphbet A then his code will be A0099. Or Miss Jany is first person with letter J, her code will be J0001.
OR
2. The code will be a five digit 7 digit number--of which the first 4 digits are year of joining in organisation and remaining 3 digits are joining serial number of this person in that year.Say Mr. Andrew is 12th person who joined in 1996 then his code will be 1996012. Or Miss Jany is 118th person who joined in 2000, her code will be 2000118. For this I will add two columns namely Joining Year and SrNo in this Table.
I want the Access, by some means to generate this code based on the above critaria in one table.Can you people help me with the ideas about achieving this task. Presently we are manually assigning these codes.
:mad: I know that there is the auto number function, however i would also like it to generate an ID with charaters. In my table theres a first name and surname.
Say for example: Harry Potter, i'd like the ID to generate HP001
then say there's another guy call Harriet Potter, i'd like the it to generate
HP002 insead of HP001.
appreciate any help, and if it's impossible just let me know thanx!!!!:)
I'm a novice in fact this is my first serious try at creating a database. I'm setting up a database to track contracts both potential and active for marketing. This will be converted to a SQL when I have it finished. I have a customer table setup in the fashion of a contact list. Most of my forms need to access the information in it via a list box. I want to set these list boxes to generate a new record in my customer table if the name that is entered is not currently in that list. By using the event option "On not in list" I'm able to get the form for the customer table to open but when the new data is saved and the Customer form is closed the information is not available to the list box. How do I get it to update the list box without having the user start from scratch on that particular form?
View 1 Replies View RelatedHello all,
Is there a way that I could put a command button on my form and on clicking it, it would generate a word document (I have a word document saved) but on the word document, it would populate the address field with the information on the form. I have about 5 fields on the form that will be used in the word document.
I thought about creating a report in access instead, but I might want to edit the word document manually, is there a way to do this?
Thanks much.
I have a talbe called LOOP in access. The fields in it ar appl,sales_table,title_code,and passalong.
From this table i want to autogenerate sql and run them in a vb function through access.
My first step was crating the sql. I did it using this query.
SELECT "DOCMD.RUNSQL "&"'"&"SELECT tsr,title "&title_code&" ord_time from "&sales_table&"'"
This generates the following vb command:
DOCMD.RUNSQL "SELECT tsr,title,q2_title,ord_time from appl_sales"
The genrated sql will be a insert into query but this is just an example.
Now this will give me the sql that i want. But I have no idea how to get that into a function.
Basically say it generates 10 different vb commands i need that to run as one function. Is there a way to do this through Access and VB.
Any help would be greatly appreciated.
Thanks
Hello Again,
I have an ID field that I want a custom ID generated based on Name, Phone Number & Record Number.
Here is the code I'm currently using....
'User moved out of supplier name field
Public Sub SupplierName_LostFocus()
If Me.NewRecord = True Then 'If user adidng new supplier
SupplierNameTemp = UCase$(Left$(SupplierName, 3)) 'Store 3 characters from supplier name
End If
nd Sub
'User moved out of suppliers phone number field
Public Sub SupplierPhoneNo_LostFocus()
If Me.NewRecord Then 'If adding a new supplier
supplierPhoneNoTemp = UCase$(Right$(SupplierPhoneNo, 4)) 'Get 4 right characters of phone #
End If
End Sub
I then have a procedure which combines the two strings such as....
Private Sub GenerateSupplierId()
SupplierID=SupplierNameTemp+SupplierPhoneNoTemp
End Sub
The problem is when I check the SupplierPhoneNoTemp & the SupplierNameTemp within the GenerateSupplierID procedure. The contain no information meaning the SupplierID will have nothing as well.
However, when I check SupplierNameTemp within the Public Sub SupplierName_LostFocus() & SupplierPhoneNoTemp within Public Sub SupplierPhoneNo_LostFocus(). They both contain the proper info. It seems they loose this information when moving outside their procedures.
Does anyone know why this would happen & how I could fix this?
Thanks.
I am working on a database for our health services office, which includes a table "Tbl_Patients"
THe Key in this table is a number the office will enter. They have an ID number for existing patients that they will use when they come in.
However, should a new patient come to the office, they would like for the database to assign a new number, the first one starting at 4000.
I would like to put a command button on the new patient form that says "Assign Number" and have that number generated and used as the new ID.
THis may not be real clear, so ask if you have any questions
Thanks in advance!
dspinner@saintmeinrad.edu
Hi i am new to Ms access, and i wanted to know how i could go about to create an auto generating number field that contains letters and numbers, e.g. a computer serial number.
Your help would be most welcomed
I am working on project for my office and get stuck at invoice option in database.I hve created 5 tbls :-
tbl assignment
assignID pk
assignname
tbl client
clientID pk
clientname
other feilds
[code]...
I have created Query so that i can make a report.Report is working fine. it will give me data for required month.I need to generate invoice and save it to a new table so that i can cross check that in future if required.
i have two combo box, one is cboMonth and one is cboYear. i am trying to get the values from these 2 combo box, and used the value to generate report. however, when i click the btnPrintSummary button, system keep prompting me to enter parameter value.
Code:
Private Sub btnPrintSummary_Click()
Dim stDocName As String
Dim stWhere As String
Dim blnTrim As Boolean
[code]...
I want to create a simple data base, in which I have to record Payments received from each customer on daily basis. and on daily basis i want to generate a report for the transaction I have made. example of data table is as follow. payment mode is cash or bank transfer.how to generate reports for day to day transaction.
View 5 Replies View RelatedI need to create a simple receipt on ms access.
Fields will include:
TransactionDate
ProductID
ProductName
UnitPrice
Quantity
SubTotal
Total
AmoundPaid
Balance
The subtotal= unitPrice*Quantity
Total = Addition of all subtotal
AmountPaid = How much each customer paid
Balance = AmountPaid - Total
fields the TABLE should contain? (Remember customers will purchase more than one product & there will be more than one reciept)..How I can generate a REPORT using a FORM ? The REPORT should contain the calculations. How do I make access do the caluclations?
I am trying to set a form that when you add a new report it will auto poulate with a number like this S44/13/001. I have not had formal training in Access.
The field name is S 44 NUMBER.
Hi, im new to Access -
Anyway, i have a table with two fields - Email, and Verify Email, how do i do it so the user has to type the correct Email twice or an error message will pop up?
I have searched the forums but have had no luck,
Thanks in Advance
Hi,
Does anyone know of a way to dynamically fill the content of a form at runtime. I want, for example, when a user clicks a button, a textbox is dynamically added (but I would prefer not to use hidden objects). I've tried the "CreateControl" option but I can't seem to get this to work. Any coding examples would be much appreciated.
Thanks,
Mark.
is there anyway to have the database autogenerate a random 8 digit reference number for each record.. this of course must be unique..
maybe something like
7C7CYU99, or HJUHU889... im sure you get the picture.
Hi everyone,
I am tring to generate a report or form, its generated by a combo box, which list all the categories of the products, when the category is clicked on it will generate the report or form showing all the products for that particular category. Can anyone point me in the right direction? Any help would be appreciated.