Search results

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

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

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

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

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 have created a form with some combo boxes to assign values to other boxes on the form. I can used the combo boxes to select the data I want to get the Task Code field to updated when I selected the Task Name in the combo box. I can't get the updated field (Lower right box) to update unless...

Good day all, I am familar with Access but haven't used it in several years and just started using Access 2010. I am working on a databased based on an exteranl database so I can't change the way the tables are set up. The tables combine serval parts of information that I need to seperate into...

Good day to you all, I have been trying to figure out a problem and can't seem to find the solution. I have a data table that has 3 parts to it in one cell. I want to be able to break the part into individual cells on a form so as to edit the data in that part without having to edit the...