Search results for query: *

Sorry, im very stupid. What do i replace 'anyfiledname' with. The query name, report name?

I currently have a number have query which results in a number of records. I am then using this query to make a report. In the report is a list of all the records and small bit of information from the records. What i need is a small summary at the bottom saying something like: Number of Records...

Hi. I am currently using a specialised database which i am using to create a report in word. Unforunately this database is doesnt hold all of the information in the correct format needed to create the report. What i want is that for the word document to change certain words to different one...

Ok, ive figured out that i can copy and past the information into excel, then use the 'paste special transpose' feature to convert the rows to columns, and then import this table into access. Is there any easier way of doing this as i have thousands of these tables to import.

hey, I have a few thousand word documents that are sent to our department from another company whenever an incident occurs.. The document contains logos, some text, and a table. I would like to make a database of this table. the main problem is importing it into an access table. The table is in...

You could use a union query. You can then run other queries off this query or make reports from this query. Also any new information put into tables will automatically be uploaded into the query.

Im not sure what kind of data you are trying to send but MS access is able to attach files and send out emails automatically, although be warned that if the file you want to attach contains ny pictures or tables then access is not the answer your looking for. Actually thats not entirely true, if...

I need to place an attachment to every outgoing email. The file will be located in the same location all the time and will always have the same file name.

I need to place an attachment on every outgoing email sent using access. It is not a recognised access type so i cant use sendobject macro. The file is located in the same postion all the time. Maybe there is an outlook solution to this porblem. It would be even better if the attachment was only...

Hi im having the same problem and was wondering did anyone come up with a solution. I have two command buttons in my form one for creating a pdf report and one for sending emailing reports. I need to create some sort of link to send the pdf report as an email using a command button.

Could you please explain your method more clearly as it would really help me with what i am doind at the moment.

I need to e-mail reports to various organistions as they are created, does anyone know of a way to automate this. Thanks!!!

hey, i had the same problem recently when trying to sent reports as an email. The solution i came up with was to convert them to pdf, but this costs money as a pdf creator program is required. The advantages of this method are that it is very simple to create pdf, just click print, choose the...

For anyone who is interested i found a solution to my problem. I created an excel table with the numbers 1 to 4000 in a column and then imported this spreadsheet into a table in access using 'Report Number' as the column heading (which is the same name given to the column contain the report...

Im trying to fing missing reports in my database using and think i need to use an unmatched query, the problem is this add-on is not installed on my system and to get the IT department to do anything is a real pain. Can some one tell me the SQL code for an unmatched query.

I have a large table of reports all with their own individual report number which i set as the primary key, but some of the reports are missing. The reports numbers range from 1 to just above 4000 and about 500 are missing.My question is, is there any method of making a query that can give me a...

Hey thanks a million its workinf for me now ya saved me alot of time and effort.

Im trying to query two tables together which have almost the same information except for one column of information. In the query i want to get a list of all information in the two tables and leave out the columns that i don't need. My problem is how do i combine two columns from two different...