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...

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 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...

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...

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...

I would like to open a PDF document using a button control on a form to a file path listed in a field on the form (Me.Link). I am trying to use the followHyperlink code but I keep getting the runtime 490 error. This is the code im using: Dim strFilePath As String strFilePath = Me.Link...

I would like to open a Word document using a button control on a form to a file path listed in a field on the form. I use the following code when I want to open a single specific document... Dim wdApp As Word.Application, wdDoc As Word.Document On Error Resume Next Set wdApp = GetObject(...

I have a form that is a datasheet. it contains multiple records. One of the fields in that datasheet is a combo box. I would like to make it so when I select a value from the combo box it changes all the values of the other records in that column/field to what was chosen from that combo box. is...

I know how to use openargs to pass values between forms but im not sure how to go about passing all the values from one subform to another. To be specific I have an order form (frmCustomerOrders) that has fields like CustomerName, EmployeeName, OrderDate and so forth, the subform...

I have lots of combo boxes in my forms that are mostly limit to list as I want the people entering the data to actually add the full details of a client or supplier or whatever instead of just typing the information in over and over again. if the person/client/supplier is not in that list I have...

quick question I have a form with a subform. I would like a control in my parent form to uncheck a checkbox control in my subform when that field value is deleted . I can get that to work if there is only one record in my subform but it doesn't uncheck the rest. how to I reference all the...

this is driving me bonkers, I have a datasheet form that is based off a query and is not editable due to expressions in the query. you might be asking why do you have a form that is not editable? well that's because the query im using has expression names that wouldn't be useful to another user...

I am trying to add a save/close button to a form that will only close if certain conditions are met and if they arnt then display a message box. I got the basics on how to save and close the form, do a simple if statement and display the message I want but the problem im running into is my...

Im am new to access and querys so im probably doing something simple wrong but here is my problem I have a query that sums up the amount of products that are allocated by customer Orders and another that sums up the Products that are allocated by pending Transfers to our trucks, so what im...

hello I just started working with access about a month ago and have been dabbling in access since as my boss is looking to get me more involved in the office side of things and could use some help managing our databases. I have been pouring over some access material and learning a lot...