Happy new year all - hope you had a great one!
I am kind of stuck in regards to creating a particular function on a form.
I currently have a form that allows the operator to insert details or request made by users seeking access to a software system.
It has 4 combo boxes that
Type of access ; values = read, edit, associate
Level 1 - values = 1,2,3,4
Leve 2 - values - A, B,...
jay123987
Last Activity: Jan 18 '10, 03:52 PM
Joined: Oct 6 '09
Location:
-
adding additional permissions to user form
-
ADezii,
I have figured it out,
I have used a OLE bound object on my form and linked that to a OLE defined field in the table!
This allows me to drag and drop into table instead of using a sub form!
i have then used 'me.controlname = nothing' in the onclick of the submit button which resets the control.
this seems to work however your the expect - any thoughts or downsides... -
ADezii,
As always yoru a genius!
I have got it working so when i drag a file it attachs to sub form however when i click submit on main form the main form data is saved to table A however table B which is where i would like subform data to be save i.e tblEMails saves but does not reset teh control to blank like the main form does, i have tried doing a set control to default but its not working.
Basically...Leave a comment:
-
Attaching files in access 2003
Morning / Afternoon / Goodday All,
I was hoping someone can help me in understanding the best way to attach files to a access 2003 form.
I have a database which is used to log phone calls and emails frm customers.
When a customer emails and we make a record of this in the database using a form,we then need to attach the email to the record created in the database.
I have been searching the net and found many methods but... -
Hey ChipR,
Tried following your outline above and i keep getting case default, not sure if its me or the code!
If it helps i can list out the names of each object (not sure if it will)
Combobox to insert username in = cbonames
Radio button for active users = Active
radio button for Inactive users = Inactive
Radio button for all users = All
on my users table the column...Leave a comment:
-
Access 2003 - forms and radio buttons
Hey all,
i am trying to do the following and am having problems, if there is anyway you can guide me or even point me to some material that may help it would be great.
I have created a form in access that allows users to input data and save record, the form is used for logging system faults when users call in.
when a uiser calls the operator will answer call and place the username in field1 (combo box)...
No activity results to display
Leave a comment: