Search results

OK so i did ad a Primary key ID to the tblManagers. you made sense there. the problem i will face with that in the future is if someone goes into the tblmanagers and edits a name to make it their own and will will cascade all the relationshipped (is that even a word..) table's data. It is not...

Alright well i have learned quite a bit since this last post and now i see the error in my thinking on how to set this up. So, now i have a login screen without passwords. I want to be able to set a variable based off of the id that was selected. pretty simple. the login page pulls from...

Haven't forgot about this. just no internet at work. I'll have this data tomorrow evening.

control source is "auth#"

Ok so i gave it shot.. and the debugger comes up... So since i am a big access dumdum lets say my table is "table1" my form is "form1" the field in question is in "table1" named "auth#" here is what i put into the code: Private Sub Form_Load() Me.auth#.InputMask = Format(Date, "yy-") &...

Sorry it took so long to get back to this Ok i have had some time to play around.. i think i know allot more than i did before. been hitting the books and what not. I think what I am looking for now. On my main form i have a "PRINT" button. i would like that button to bring up a pop-up modal...

Sorry it to so long to thank you.. Being a Military man has its downsides Thank-you JHB

In this DB that I am working with i have 6 different entry fields. everything works fine bu ti want to the control # to update automatically. So the control number is "14-###". Where 14 is this year andthe ### is the variable for the control number. it was easy enough to set a control number...

Thanks for the reply! However the computer has no accounts and no user login. Just a simple stand alone. So it has to be easy to update later when i am gone.. even if i had to make another menu button to link to another table that you could input the data into and it would update the printed...

I have a printed form that pulls some of its data from a table. What i need is that printed form to have a variable that two area in the form can change based on who is printing the form. I have a table that has all the users data in it. the current form pulls that information from the label and...

Just started working with access. hoping to find some answers to questions that are more than likely pretty easy but difficult to find answers to on Google. Thanks in advance /RMC