Search results

This sounds like a cool idea, and much more secure. I have no idea how to go about setting it up tho..

Sorry, I did not fully understand your link. Could you explain how I would accomplish this with single form? I am still very new to Access and unaware of most of its functionality. With multiple forms I would just name them "area_name_form", so the users would know where to go.

The Area I am referring to is more like a "Department Name", where employees will be given form permissions based on their department. This was requested to ensure employees could not alter data outside their department. This is why I have forms for each area, its was requested by the users, but...

Hello. I am creating a couple forms, one for each Area. When a user clicks on the form for their Area, I want them to only see the records related to their area. I think I should be using the "on load" event, but I have no idea how to set this up. Do I use the "Expression Builder" or "Code...

Perfect! Thankyou.

I am trying to run a report that shows all the records in my database, even the ones with blank values. When I run the report now, I am only seeing the records that have values in every field i have included in the report. How do I setup the report to show all my records, even the ones with...

I think i got it.

Well, pretty much all of it. I need a table that only holds the area and related sub_area? Then I build a query off this table? This query put data into the sub_area combo? I've been searching alot and think I confused myself even more.

Thanks! This is exaclty what I'm looking for. Could you help me make sense of the code? I am having trouble applying it to my db.

I am creating a db with tables Area and Sub_Area. In my form I have combo boxes which list the data in each table. I have been asked to configure the combo boxes so that when a user selects "Technology" from the Area combo box, only the Sub_Areas related to "Technology" will be displayed in the...

Thankyou!, that solved the problem. I was confused because they are all combo boxes in my form, I thought they would stay like that on the report.

This is a report generated from a form. I can not edit the report text boxes.

The 5th column on my attached screen shot shows the months with the selected month highlighted. I want just the selected month to be visible (July), without listing the other months included in my drop down list. I didn't have this problem until I added combo boxes to my form. Thanks

I can't figure out how to format my report so the combo box options are not displayed. I attached an image to show what I'm talking about. Any ideas?

i got it! thanks for the help.

Can u explain how to do this please. Thanks

I can't tell! How do I edit the appearance of my sub-forms? Thanks for all the help.

Ok, Thanks!

Is there a way to bind a text box to a control source that is outside of my form's record source, without using a subform? I am trying to add a text box which links to my Comments table, while the form's record source is the Events table. Thanks