Search results

I have a navigation form that has a subform that is a list of employees. One fields is a checkbox that says if they are active or not, when the form opens it gives a list of all active and non-active employees which is rather long, as a default i would like it to show only the checked employees...

I have a table that with the following fields Item Number Product Catagory Quantity Sold OrderDate What i want to do is make a query that will sort out how many of each item is sold on average per month but i cant figure out how to make it. My initial thought is to make separate queries with...

I have a report that will require multiple images but that number will vary depending on how many records are included in the report. Each record will have a total of 4 images so for example lets say company A has 40 records that would mean i need a report that has 80 images. I want to print out...

Thought of that too but that goes against our company quality control policy, since its a controlled document there can only be one version of it available, its made that way so there arnt multiple versions of the same document floating around and if there are revisions to said document only one...

ok thats what i was afraid of....well let me put in more detail and see if there is another solution What i need to do is incorporate my terms and conditions document into my report or attach it. The terms and conditions document is a controlled PDF company document, this cannot be changed. I...

Hi Im trying to insert a PDF document into my report using the Unbound object frame but when i print or export the whole report to a PDF that part of the report is very blurry. Is there a way to fix this or is there another method of importing a pdf document into my report? thanks

I was outputting the wrong report. Once i put the right report name in that vba code it went back to working as intended

Nevermind figured it out

I have a report that has 2 image controls. the data for the images are from a text box control that has the file path to the image on my computer. Once the report is generated i output the report to a pdf and save it to a location on my computer so it can later be accessed and emailed if...

I have images on a report which is a image control, the image control is linked to the image file. When i look on print preview they look okay but when i convert the report to a pdf the images look much more blurry and are slightly bigger. Is there a way to fix this in access or is it a pdf...

Val([IRNzCount])+Val([U1NzCount]) That worked thanks

I am trying to add together 2 fields in a query but it keeps returning the wrong value, for example my first field(IRNzCount) value is 10 and the second field(U1NzCount) value is 2. I should get 12 as the result but instead i get 102 which is the two numbers just being put beside each other...

Im trying to make an Inventory count form with the basic info like employee name and date in the parent form then all the products i have in inventory listed in the subform along with a count field to input the count numbers. I can get it to work but you have to enter the item number and the...

Thanks for the help guys

I have a Sales Order form that has a sub-form. the parent form has all the basic customer info like company name, date, and so on. The subform has all the products they are buying. Once that is complete i have a report that pops up via a button that can be an invoice or quote for that order...

I have a problem.....I have a form that has a subform. The parent forms data source is a query based on my "tblSalesOrder" table that collects the data on my customer like their name, Phone number and so on. The subforms data source is a query based on my "tblSalesOrderProducts" table, this...

figured it out, some of the records had " before and after the filepath which made duplicate " which is why it wasn't working.

"X:\DOCUMENT CONTROL\01 MSP SYSTEM PROCEDURES\MSP 10 - Control.pdf"

Tried that, same problem. also tried [], "()" and various others with no better result.