Search results

Thank you the On Got Focus one worked! Is there a website with examples of when to use these? Thank you!! Paul

Hi Guys, I am having an issue with onclick on a combo box. What I am trying to do is set a query based off of another Field Value. That value as you see is PEID. This works but only after the click not before. Example, I go and select a value any value doesn't matter if its in SL1 or SLB when...

Thank you for the quick response it worked :)

Hi guys I tried to follow the Allen Brown print the current record in the form and its not coming up. I can print all of the records but not the current. I know its an easy fix for you guys but I couldn't find anything else to help me out on the net or in any of my books. Thank you, Paul

Hi guys, I have a report that with a few different selections that can be selected Equipment, If its active or not and a date selection. Everything works fine on it, In the equipment selection I have the default value set to "*" so that All the equipment come up in the report. Once I select...

Ahhh makes sense why it didn't work. Thank you for your time!

FormPMDataEntryNC is a form I used a query to make the form. I deleted everything from the append qry only thing I have left is Equipment_ID Task_ID Occurance_ID PMID When I run the qry it still wants to add three rows not one. It says it set the fields to Null due to a type conversion...

INSERT INTO [PM Detail] ( Equipment_ID, DateRequested, DateCompleted, Completed, CompletedBy, Task_ID, Occurance_ID, NextOccuranceDate, PMID ) SELECT FormPMDataEntryNC.Equipment_ID, FormPMDataEntryNC.DateRequested, FormPMDataEntryNC.DateCompleted, FormPMDataEntryNC.Completed...

Thanks for your help the append qry works but if i have 6 records in there it copies all 6 records over instead of the current one I am working on. In the append qry in the Criteria I put in the "PMID= "& [PMID] and it doesnt like that at all either. So its working just copying all the records...

SQL I am assuming I am going to have to do a !Equipment=Me.Equipment !Task=Me.Task etc for all that?

Yes I have the date add to Due Next. What im trying to do is copying the info over to a new record on complete.

This is the form that I have what I would like is once the completed box is checked it takes all the information the Same Equipment, Location, Task and create a new record. With the new record the Date Requested would be the Due Next Date and the new due next date would be 3 months from that...

Hi guys, I am making a database that has to do with Preventive maintenance. Everything is going good and I came to a problem. There are recurring events. Some are weekly monthly quarterly etc all the way to 5 years. When I put in the task and a start date and the occurrence. So Say I put in a...

Found he issue it was when i didnt included in the qry of the form the equipmentname to write to it

What im trying to do is make a Preventive Maintenance Database. I want one place to enter all the equipment and another where you enter the tasks that need done and the date it needs to be completed by. Then also do a report for what needs done in the month of December etc. Thank you!!

What record would I have to add?? and to what table?

Hi guys, I'm making a db here from scratch. I am using 2013. I have two tables and i will post a picture with it. I am having problems when i select the field from the drop down. I will select it go and enter all the data then i get an error that pops up when i try to add another record that...

This expression is using two other expressions to get that decimal. That is the issue then? So in order to sort it by that I have to use the field and tables to sort it correct?

Hi guys, I have an expression that is contribmargin: [totalmoneycontrib]/[totalreveune] Now when that comes out its a percent What I want to do is sort it by anything less then 60 percent i want to show up. when i run the qry in designview I get a pop up for totalmoneycontrib and...

I have an idea. What if i just copy the table with the main ID on it and remove the one thats giving it issues and then rename it back to the current table would that work??