Recent content by David_P

Well, it seems like I figure out the problem and solution. And of course I just made the problem more complex then it really was. All I had to do was remove [Forms]![Navigation_Form]![Transactions]! and the extra brackets from the code for the Where section of the SQL and it worked. Old Code...

I added in ![Navigation Form] into the script but it still comes up with the parameter boxes. I am not sure what you mean by "and make sure that the subform name you are using here is the name of the CONTROL on the main form which HOUSES the subform - not the subform name itself unless it and...

I believe I have determine what is causing the problem with the subform when using it from the Navigation Form. The subform has a combobox that runs a query based on fields on the subform that the person inputs data into. When I click on the combobox to give me the list produced by the query it...

I am having a problem with the subforms that I created with the Navigation Form. I am using Access 2010. I have searched the web for the answer to my problem and can't figure out why my subforms are not working. I created some forms and got them working the way I wanted. I then created a...

Thanks. Anyway to correct it though. I like my code nice and neat and easy to read?

I am having a problems with VBA. When I typed in the word for a form, VBA changed it to a different word (I want Transactions & VBA changes it to tRANSACTIONS) so when I try to run the vba code I get and error. I have tried to do a replace all to replace the word with the one I want but VBA...

Thanks for your help DCrake and vbaInet. DCrake - I tried the way you suggested, and it gives me an error (see below). As you can see by the my code I posted ealier, I have to pull apart the information out of 3 tables with each table having the information I need combined so I have to tear it...

Combine Two Rows to One Row I have a query table that I need to combine two rows of information to one row. This is what the query looks like: Job_No. Part_No. Task_No. Employee_No. Task Employee Status Date In Out J015978 P000001 T0007 E0004...

Each record should have an IN and Out paired. (Will have to create a report to determine if there is a missing out or in later). Each record is a different line entry in the table so they are not paired up and are only paired after I run a query to pair them up. So would it be easier to run...

I am trying to get a report to group 2 rows together so I can do some calculations on them. The report has several fields that group together to match up the rows but I can't figure out how to only select two rows. Below is a sample of what the report looks like. Job_No Object_No Task_No...

Ok, so far so good on creating my report. I got the report to group the Job and person together. I got it to display the time in military time so it should be easier to do calcumation on it. Now comes the more complex part. I need it to find the difference between the in time and the out time...

I have search the web but can find a solution to the problem of converting the time to a 24hr format so I can get rid of the am/pm field. It would also make grouping my ins and outs better I think. It probable is just a command but can't seem to figure out proper format.

When I try to only group Job and Employee, it won't allow me to just group only those two. I wants each column to have a choose, what do I use in the other colums? When I do sort it, it groups the Ins together and the outs together. The date and time is actually from 1 field that I split...

I am need help with a sort query that seems to be complex and I can't seem to get the query to sort in the certain order I need. I am not sure how to go about it. I have 6 fields that I am using as to sort with. We will call them Fields A thru F. Field A=Job, B=Employee, C=IN/OUT status...

>Hits forhead with open palm - saying duh!< That fixed it. Thanks for your help help.