Search results

This worked great. i just made the subform super small to show the one text box and hid everything else

Hello, I have 3 tables, tblDailyLog DailyLogID | LogDate tblVisitorInfo VisitorID | VisitorName | CompanyName | TrainingDate tblVisitorLog LogID | VisitorName | TimeIn | Time Out I'm using 2 Forms [frmDailyLog] from [tblDailyLog] with a continuous subform [frmVisitorLog] I have entered...

Hi, I'm using the following query to display total completion % for a project. SELECT qryProjectSubSubTaskTotalCount.ProjectSubTaskID, qryProjectSubSubTaskTotalCount.TotalTasks, qryPRojectSubSubTaskCompleteCount.CountOfActualCompletionDate, [CountOfActualCompletionDate]/[TotalTasks] AS...

I don't but i will definitely research it.

Bam, Solved.

it's a lookup field using both UpdateID and version num

Hi, I have 2 tables, tblUpdateVersions | UpdateID | StartDate| VersionNum | TblUpdateStatus | UpdateStatusID | VersionNum | UpdateDescription | I'm trying to run a query to show the latest group of records that all have the latest VersionNum from tblUpdateStatus When i use Last or Max...

Perfect thanks.

Hello, I have a PO form (frmOrder) from tblOrder with a field (ProjectID) from (tblProjectCoding). I have a query (qryProjectDetailForm) that pulls several fields from (tblProjectCoding) to show all my projects. I then have a secondary query (qryProjectPurchases) which shows all purchases...

Jdraw, thank you for your input.

Thanks Plog, this is what i had initially thought of but i wanted a second opinion

1. My company manufactures goods for the oilfield. We use numerous machines throughout the process. We also install new machines ourselves to further our capabilities. 2. My database is used for numerous reasons, Purchasing of new equipment [tblPurchasing Details of owned equipment...

This is a very basic layout from my main database. See attached.

hello, I have an existing database that i currently use to store detailed information on hundreds of machines, instruments and other equipment. This is stored in [tblEquipment] I am building a new project management database for installations of new equipment/machines in order to assist me in...

I am using the following code to change numerous images/text/buttons on my home navigation screen from white to orange when they are highlighted and then returned to white when the mouse is moved back over the background that is behind/ separates the boxes. Private Sub ButMOC_Click()...

Hello, I am using the following code to generate vertical lines for my report but im having a slight overhang. Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) Dim ctrl As Control Dim intLineMargin As Integer ' This is the spacing between the right edge of the ' control and...

I tried this but it didn't work. Sometimes my records can be over 1 page long.

That worked thanks.

Hello, On my report i am using alternating colors. Some of my records can have a lot of text in them where they carry over to another page. i notice that when a new page starts the same record picks up the alternating color on this new page. How would i keep each record color specific?

Hello, I am having 2 issues on my report that i cannot figure out. 1. Empty space appearing on footer of each page. I only want the footer on the last page. 2. Header appears on last page even with no details.