Recent content by aucho22

Thank you Burrina, I will try this as soon as I can!

Hello burrina, Thanks for the tips, I believe vbProperCase would work only to change uppercases & lowercases, Password code is great, although as before if users decide to replace one of the line with another role instead of using a new line, all the related records in the table will change...

Hello fellows, I have a form that allows users to add items to a table -of employee roles - (later used as drop down list). I turned off AllowDeletions and AllowEdits, so they were only able to add new records to the list. But let's say, they enter a new item in the list "Forklift Driverrr"...

Hello Plog, I do apologize for the late answer :( Thank you for your reply, I will try your advice and let you know if I have any problems! Fingers crossed Auho22

Hello guys, I have been working on a simple data base for some time now (beginner level) and am still trying to improve it. I would like to do something but before that I would like to have your opinion to know if it is even possible? I have a query QryMainReport: Start Date/Time End...

I am never too sure about these junction tables... :o Thank you very much for the treasure of links! Very useful to my learning! Aucho22

Good morning everybody, I am looking for some feedback on my db design :o Please note I am a beginner but I am really trying to learn Access (so much fun :D ). Can I please have some feedback on my structure? I would use a db to track qualifications in training... I did 3 tables: tblIndividual...

If anyone is in need of a "quick" solution... I simply added a command button (Undo Record from the wizard) to cancel data entry, which then allows the user to go to another tab without the "Missing field" message popping up. Aucho22

Thank you Doc_Man for the reply! I think I will stick to my current form then! :o Aucho22

Hello readers, In my db (I am a beginner) users will add records to a table through a form in a navigation form. When the nav form opens, the cursor is not located in the fields of the sub form (first tab). Fine, the user can select other sub forms. When the user accidentally puts its cursor...

Alright, solved my own problem:D I checked a dozen times my query and found out I had simply put too many joins between tables/queries which caused my query not to be updatable. So much more to learn... For future reference, check your relationships/joins first :) Thank you, Aucho22

Good Morning, I have a form for users to be able to delete or edit records. I have 2 command buttons (Delete and Save), when I click on them I get this error "the command or action is not available now"... It was working fine before but for some reasons it stopped. Even two other buttons...

Hi GinaWhipp, Thank you so much again :) I managed to modify the query so that only the names (grouped by) and the columns for regular hours, overtime 1,5 and 2 appear. Now I just need to figure out why when I create the report, it is asking me twice for the start/end date :p Crosstab queries...

Yes for this query "qxtbEmployeeHours", I will eventually create a report (the user will have to choose the date range)... I noticed this query was more of a matrix, so not sure if it is possible?

Wow, it definitely looks more like what I intended to do at first, thank you :D Only thing, when creating the report I wanted the user to be able to enter the date range he/she wanted the report for. I thought I would just need to add a criteria in the query for WorkDate: Between [What date?]...