Search results for query: *

I have a database that keeps up with certifications for various employees. I need to be able to choose a particular employee (no problem with that) and then I need that data to be exported into a PDF form. The form has the employee id, name, status, instructor and method at the top and then...

Here is what the final report needs to look like: Surgeon:(Name) (Start date-end date) Surgery type ¦ No. of Procedures ¦ Avg Surgery time ¦ % Pediatric ¦ Avg length of stay And it’s the Avg surgery time & % Pediatric that I’m having trouble with. I have a surgery table that lists the...

I have a form that is used for creating a new office note and it needs to be accessed from 8 different forms. I do not want to create 8 different office note forms though. I have one form working and here is the code I'm using in the On Load event: Private Sub Form_Load()...

I am using DLookup in a query, and am getting no results. I moved the DLookup to a form so that I could "see" the results and then used the control of the form in a query, and still no results. However, if I copy and paste the results of the DLookup in the form to the query, I get the correct...

I have been doing fine with autofilling forms that are part of a tab and moving between tabs, etc. But the form I'm having problems with now is a separate form that is opened when a button is pressed (Create RMA). This is the code I have tied to the button on the OnClick event. Private Sub...

I have looked at a bunch of posts and tried to figure this one out myself, I'm sorry. I have a main form, a tab control and subforms on the tab control. I am using the following to get from the last field on the main form to the first subform in the first tab of the tab control: Private Sub...

I have a form with tabs and have information on one of the tabs from a subform. The subform gets its' data from a series of queries. Just for info, it's emergency numbers (ems, police or sheriff, etc) based on whether the client is in or out of the city limits and what city/county/zip combo...

I have a main form that has several sub-forms. However, I want to use a pop-up form as well if the client has a mailing address (i.e. don't want the info visible unless entering data). I created a button on the main form that opens the MailAddy form. And I changed the MailAddy form to only...

I am sorry to have to post this. I have searched and can't seem to find what I need. I have a Referral Due date and a Referral Received date. I want to add 14 days to whichever date is later as the Due date. This is what I have in my query. What am I doing wrong? DueDate...

I am trying to set up a report that sums month to date data. I have the user enter the report date and the dates sales data is reported. The I was using Format(Now(),'yyyymm') to get a total for the month. It works as long as the report is run the day after (i.e. run on 10/29 for 10/28 data...

I posted this in the "other topics" section and decided it would probably fit better here. I have an order-entry database that I pick up the item# from and want to auto-fill the price. However, the price is based on a calculation of the Price/Ton and Wt/Ft and is a Price/Ft price. If I try...

I have an order-entry database that I pick up the item# from and want to auto-fill the price. However, the price is based on a calculation of the Price/Ton and Wt/Ft and is a Price/Ft price. If I try to use the Price/Ton (not a calculation) it works fine. If I use the Price/Ft, it does...

I have a several numeric fields and a text field that I am using in a calculation in a query to join together as a "product description". However, even though the numeric fields are set to show 3 decimal places and I have tried using the "Round" function in the calculation, the ending zeros are...

I am trying to create a report for customer orders. There will be a different # of items each time it is used. However, they want to have horizontal lines that go down the right side of the report from where the data starts to the bottom of the page no matter how many items are printing. How...