Recent content by BruceMalone

Thanks again!

I do have one question, in the find drop box, its set to last name + first name. I realize I could have multiple workers with the same last name and it doesnt seem to list them all. How would I be able to use a different field in the dropdown thats a bit more uniqe for example pp number? I...

Thank you SOOO much!! I'ts very close to what I need. I will check it out and play around and let you know if any questions. Thanks again!!

Attached is what I came up with. Thanks!

Thanks for the replies. Yes the edit is set to YES. Iv been looking around and saw a video that instructs to add the following condition on the openform macro: ="[First Name]"=&[First Name] This is when I click on the table and its supposed to open up the record in the form. I cant seem to...

Hi. New to access and I have created a database to track employees. I have created a table and a form to input the worker data. I am able to create new records and have them show up in the table without a problem. Now I am trying to find a way to create a button to edit a selected record. There...

I’m just trying to find a way to show the number of records available. I guess I can do without it.

Thanks. But i dont think that solves the issue where i am trying to add a reference number to each worker? Using autonumber if a record is deleted, it doesnt auto fix the record numbering.

I was able to make it refresh by adding a event macro to refresh the form after clicking the button. Now another problem, I did not realize autonumber was unique and deleting a record wouldn't reset the numbers. Iv been reading to not use autonumber at all for numbering records but havnt found...

Hi. Yes it is.

Thanks. Im playing with both methods to see which works best. In the subform method, how would I get the table to update automatically? I have a main form which has the buttons to open the input form and show the table data. After inputing the data in the input form, the data doesnt show right...

Thanks. I'll check out split forms.

Attached is what I came up with. Not sure If i did what I originally wanted but it works for what i was looking to do.

So i created a main menu and added a subform to display the table. When I add a new entry to the main form, I want the sub area to refresh as well but I am not able to let it happen. I tried to put a macro to refresh upon load event but getting an error "the command or action refresh isn't...

Thanks. I'll try to build from scratch. One question, what is it called when you open a form and it shows the data table, but it has some buttons on the top where you can click to open the form, search ,etc. Like in the contacts template clicking new entry opens up the form in its own window...