Search results

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

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

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

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

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 am getting this error (As in pop up from Microsoft) in the form and also in the table. I see what the issue is in the field it has #Error. When i go and try to change it also gives me the same error. I can go ahead and copy the information from the table above into it. But when i go and try to...

I have an expression expcontribmargin: [exptotalcontrib]/[exptotalrevenue] Now that comes out as a percentage. I already have everything in but I cant seem to sort it. I need to make two, One about 60% and one below. In the criteria section of access I tried the > and < with the amounts and...

I made a query and there are two tables the report it being pulled from. tblMaterials and tblJobpartrun. The issue is on the tblJobpartrunsheets there are MaterialID1,MaterialID2,MaterialID3,MaterialID4. Which have a relationship with MaterialID. The only thing I want from the tblmaterials is...

My name is Paul I am a IT admin at a company. My concentration is on Networks not data bases hence why I am here looking for some help.