Search results

I uploaded as an excel file. The first three tabs are examples of tables... The last tab is the Query. I want a form that can sort by any one of those first fields. Just one field, or all the fields that correspond with the tables. Does this help?

I searched for the answer to this but was unable to find a solution that I understand. I am terrible at coding but I am good at copying code to fit my database. I currently have this form (combobox) that filters using one piece of criteria. Private Sub cboSelectPress_AfterUpdate()...

I will do some more research. I just thought that if I have a user keying this information in, they will want to see the name that they are keying it for.

The Overtime and Vacation tables will be used to key daily information about different employees. To simplify data entry i wanted to be able to key the employee ID and say that for 05/03/2012, employee X worked 4 hours of OT. The attached picture is just the basic form that I am looking at...

It may help to understand what kind of tables I currently have in Access 2010.... I have an employee table that shows all employees and some basic information about each of them. This table has an employee ID field that is not an autonumber but it is unique to each employee (10004928). I...

Nevermind... One of the forms I was using labeled the fields as TEXT instead of number or currency. I corrected that and now I am in business.... Thanks

No, I actually made them all currency because I could not get anything else to work.

I have three combo boxes linking to three different forms. One form for each box. Each form has the numbers from 1 through 10. However, I have also included quarter values so they look like this... 1, 1.25, 1.50, 1.75, 2.... Two of my combo boxes are doing fine and allow you to select each...

THANKYOU!!!!!!!!! I learned ACCESS by watching youtube videos. This has made my life soooo much easier. Thanks again. It works great.

Private Sub DupRecord_Click() End Sub If Me.Dirty Then Me.Dirty = False DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdCopy DoCmd.GoToRecord , , acNewRec DoCmd.RunCommand acCmdPaste End Sub Private Sub Command223_Click() End Sub

It appears that it is already trusted. I am believing that I will not be able to have this function work for me. Thanks though. lol

I found out where to put the code, but it does not change the effect of the button. nothing happens when it is clicked.

Thanks so much... I am a noobie. How do I get to copy that code into design view for this button?

Please help

Thank you. However, it seems that these options would change the entire form to become default. Can I have both options? Also, that shows how to do it for Access 2007.

Hello. Working in Access 2010. I currently have a button in my Form that automatically goes to a blank record and allows you to create a new record. I would also like a button that creates a new record but duplicates the previous record. My database tracks what products my employees...