Search results

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.

I am getting the error "The specified field 'ID' could refer to more than one table listed in the FROM clause of your SQL statement". The query that the combo box is pulling from has 3 tables tied to each, and each of the tables PK is labled as ID. Can't change the PK name because the database...

I am trying to get my form to bring up a certain record based on a combo box. The combo box's list is based on a query that is filtered based on data typed in to several control text boxes. I got the combo box to bring up the PK of the record that I want to edit but it won't move that that...

I am using a Function to put the concatenated value into the text box. Public Function Joined_dbo_Checkpoints_BarCode(dbo_Checkpoints_BarCode_Task, dbo_Checkpoints_BarCode_Employee, dbo_Checkpoints_BarCode_Status) As Variant 'Joined_dbo_Checkpoints_BarCode = dbo_Checkpoints_BarCode_Task &...

The Transaction ID comes from the Query that I use to filter down the fields. It is kind of like an Excel sheet where you apply a filter to each column and need to know what row all the data is on that meets the condition of each text box. The ID is the first column...

Ok, here is the pic. http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=33764&stc=1&d=1284741937