Recent content by keden

I have a similar dB that tracks units of work...I didn't want anyone dup'ing up on records so I added a complete field to the form/table. Once someone hit the submit/save button on the form to save the record, it checked the field to complete. When someone retrieves I a new record, I have the...

you would tell Access where to save the data by the control source. This may sound like a silly question but is anything showing up on your form?

Have you changed any of the properties on the form?

Galan, I currently have textboxes which default to the date the form is open by putting =now() as the default in the textboxes properties. I then set the format to short date. Not sure if this fits the same scenario but thougt I would throw it in all the same. Keden

ok, so I went with the list box to view accounts my employee. I then added a combo to give the user the option to select customers by name. Thanks for your help Wayne. I really apreciate it. Keden

Am I just not getting it? Is there another way I should be looking at this? Keden

I was trying to get away from having the user choose their name from a list. That is why I was trying to retrieve by user login automatically. I was thinking of writing the SQL queries into the code using an if then else statement. If value is not null select deliminating by username, else...

so, when using the combo (never really used them before) I would still need to use the query as the recordsource for the form. How would I delimate the records for a particular record when there NT Login was selected and what would tell the query to select all if "select all" was selected in...

Here it is. If you enter your name into the tblCustomerAssignments table and push the button on the "main" form, you will see only the accounts you put you assigned to. The problem is with the "select all" button. I have omitted any attempts I have made to reduce confusion. Thanks,

let me strip it down to the portions that I have in question and I will attach it. I may be in the am. keden

I tried to build an iif(null( [Forms]![Main_Form]![username]),"*",someform!username) expression into the query and set the someform!username as "" when the view all acounts button was pressed. I believe it is looking for a value of "*" in the data instead of reading it as select all. setting...

Ok, I have gone a different direction. I replaced the switchboard with a self made form. I created an unbound field (hidden) that will be set as current username from the the on_click of a button with caption "view my accounts". I have also set code to requery on activate of my form with the...

would it be possible (better) to create a module that will set the deliminator on the query by current user name? Then set this off when the button is 'clicked' to access the current users records?

Hello all, If I want the user to have the option to view all accounts or just the ones he/she is responsible, how would you suggest I do this. I have a form based off a query currently. I would like to use one button for the user to select "view all accounts" and another that they can chose...

Will most definitely do. I appreciate it. I will also throw in advice where my limited knowledge provides. Again, I apreciate your help. Keden