I am trying to see if the following is possible. I have created a form in my database that tracks how many thank you letters I have sent out with a "check for yes" box.
On records where there is no check I want to create a button beside that says "Print Thank You Letter". It would then generate a form based on that certain customer's information.
Is there a way for me to do this? Also, will the report automatically generate that person's information found in the record?
We are trying to use Access to generate, job, task and craft numbers in Access. Job and task will be unique. Craft numbers can use the auto number function. We need the numbers to be 4 digits for Job and Task.
i need to append data that is currently in a single MS Access table into multiple MYSQL tables that have primary keys and auto_ids etc. Therefore I need to run the queries in order so that I can use the new auto_ids correctly, see below:
I am trying to create a button which will merge data from specific fields from the active record in my impounded dog table/form into a pre-existing word template. I have the table & form set but am only trying to merge a few of the fields in the table. Things like the Impound ID (Primary Key), Time, Date, & Location of Seizure, Dog Breed, Colour, Markings, Age, Sex, & Collar.How would I put this in a macro or is it even possible to fit in a macro?
Hi guys . I got a table in my db called week. It has the following feilds on it . Year, weekno and monday. I created a button and a text box in a form. when i type a year name and press a button i want the the follwing happes:
it check if the year exist in the db. if the year does not exist it goes and inserts week number from 1 -52 along with start of date and year in to the db. I be happy if some one show me how to do this in access.Thanks
How to generate an export specification file by using Access 2007. Many instructions says click on "Advance" while exporting a text file manually but unfortunately i can not find that "Advanced" option in my access software.
Using Access and Outlook 2010. I have a database that tracks Contracts for our University. One of the fields it tracks is Expiration Date.
Is there a way to have Access prompt Outlook to send an email to my boss when the contract is a month or within a month from expiring?I'm assuming when the database is opened it would have to run a query for expiration dates expiring within one month of today's date (which i know how to do).
I just don't know if it's possible to generate an email or some kind of message with those records/contract numbers displayed? I should also note my boss is the only one who uses this database so even if the email notice isn't possible, is there a way to show a message of what contracts are expiring soon when he opens the DB?
I am creating a database relates to hospital medical equipment using Access 2003. Using VBA code, I want to generate an AutoNumber for each Equipment falling under different Equipment and different Hospital.
Ex: DGG-ECG-001 DGG-ECG-002 DGG-XRY-001 WBH-ECG-001 WBH-XRY-001 WBH-XRY-002 and so on.....
Where DGG & WBH are Hospital Codes (PK in tblHospitalCodes) ; ECG & XRY are Equipment Codes (PK in tblEquipmentCodes) ; last 3 digit denotes the AutoNumber.Both the Hospital & the Equipment select using combo box then generates the AutoNumber Using command Button.
I'm not sure if Access is the right program to use for this scenario as I only know the basics on creating the database.
I want to be able to create a client database and then be able to generate a number of standard template letters at any particular time for selected clients.
I don't want a mail merge!!
Can access be used for this?
Ideally I would like to create a form for administrators to use to input new client info and update existing clients info and then just be able to click a button (or the like) to generate the standardized letter for a particular scenario.
So Access was unable to manage the amount of content that I needed to produce in a single report. The reports contain 12 charts/graphs all of which I needed on separate pages (one chart per page). As such I could not create large enough charts in access to fit to each page, as Access limits the amount of space one can use in a report.
I downloaded Microsoft Reports Builder 3.0 and built my reports as needed and can generate them as desired at current. I'm wondering if there a way to call that RDL file I created to generate my reports from a form control button in Access?
Dear sir, Wish you all a happy X'mas . I wish to get some values while enter these tags in the form as shown in the excel format. The same thing i want to do in access but i am not aware how to do that can anyone please help me. It would be a great help if some one can explain me the steps as i am a beginer in doing access.
The alphabets AA,BB,CC... are what i will enter and should display the appropriate values for them as shon in excel coulms Please find the excel file attached to get a clear idea of what i am looking for. thanks & regards pillaisg
I really could need help with the using of the IIf function in the queries of MS access. I really need to know how to use them.. So please help me out as fast as possible...
I have a column-I containing 100 different values. I need to find the bigger one between 0 and each of those 100 numbers in column-I accordingly, and put the results in column II. I tried to use max function as I did in excel, but couldn't work it out. Help please? Thank you!
I'm currently importing a sheet from Excel into Access 2003 using Docmd.TransferSpreadsheet.
This works fine but requires the path of the file in question to be stated as one of the parameters. I have donjhe this and it works but, I would like the user to be able to navigate to the file using the standard open file dialog box.
I used to do this in oracle using RANK function. I do not know how to do this in MSACCESS
SELECT Tax_ID, Tax_Name, Start_Date, Tax_Percent, RANK() OVER (PARTITION BY Tax_Name ORDER BY Start_Date desc) as Date_rank FROM TaxType where start_date<=to_date(10/01/2010, 'mm/dd/yyyy')
I will firstly give you the low down on the business that I am doing the database for. It is a Car Restoration Business, where we deal with vintage/classic/muscle cars and restore them to the former glory.
I do not know Microsoft Access very well, I have attached a file with what I think is a databae I could be wrong. The main function of this database is to search for suppliers for a specific car part for a specific car.
So if I want to find a doorhandle for a 1970 Ford Mustang, I need the suppliers pertaining to those criterias to come up.
I am trying to import a excel spreadsheet ( 3,000) rows into a access database. It has been working finr for over a year. When I do the import it gives the following message: I have attached part of the excele spread sheet.
'Master 7-20-07$'_ImportErrors Error Field Row Type Conversion Failure pID 161 Type Conversion Failure pID 162 Type Conversion Failure pID 163 Type Conversion Failure pID 164 Type Conversion Failure pID 165 Type Conversion Failure pID 176 Type Conversion Failure pID 177 Type Conversion Failure pID 180 Type Conversion Failure pID 181 Type Conversion Failure pID 182 Type Conversion Failure pID 183 Type Conversion Failure pID 184 Type Conversion Failure pID 185 Type Conversion Failure pID 186 Type Conversion Failure pID 187 Type Conversion Failure pID 188 Type Conversion Failure pID 189
Can anyone tell me what is happening. I cannot even paste the spreadsheet into the DB.
I have a table which has information the count of students in classrooms around the university and I need to summarize the table by Faculty. Therefore, all I want to do is a count of students for each faculty i.e. Art and Design, Business and Law etc.
The query i put together is: SELECT Count([tbl_Audited Classroom for Week 02].Faculty) AS CountOfFaculty FROM [tbl_Audited Classroom for Week 02] HAVING (((Count([tbl_Audited Classroom for Week 02].Faculty))="BAL"));
So when I run the query I get the error message 'Data Type mismatch in criteria expression'. The Faculty field is a text field, so I don't know if that would make a difference.
i'm trying to count the total number of records found for this query. i used the following expression (code) in the QED field row Total Incidents: Count([IncidentID]) which, result in an error message.
Can sum1 help me solve this problem. any help would be highly appreciated.
