Search results

Access 2010, Navigation Form. I have an Employee Add form as a subform on a Navigation tab. The form is based of the Employee query. The Data Entry property is set to YES but the form is bringing up the first record in the query instead of the NEW blank record that would allow the addition of a...

I am using Access 2010. I have created an employee database. Here are my tables; tblEmployees tblDepartments tblTitles tblManagers I want to make some employees managers and assign multiple departments to them through a form. Within this form I'll need to be able to see ALL assigned...

Access 2010 I've been using a ACCDE file format for a while now and when I make changes to my Accdb file I overwrite the Accde file but now it won't allow me to log in. I can't get past the log-in screen in Accde version but it works fine in Accdb version. What gives?:(

Will a datasheet view From allow command buttons? When I add a command button and then go to Form view only the datasheet is displyed. What happened to my command button?

Access 2010. I want to add a command button that exports my the data on my datasheet view Form to excel. The issue is that the data is filtered with macros. Below is VBA code that allows my reports to run off the filtered data, can I apply this same idea (me.filter) to the export to excel VBA...

I have a database that was working fine and when I saved the file to accde the Reports stopped working? Is this always the case or am I missing something here?

How do I enable the Acces Log in pop up for all users? Or do I need to create a form for that?:D

I have a form that is based off a query with filters running on it. I added the "Create Outlook Contact" button to the form but it isn't working. How does one program command buttons to read the current record being displayed on the form? :mad:

How do I get a combo box to be filtered the same way that the form that it resides on is filtered? My form is filtered with a macro and then I added a combo box to it and the dropdown menu is displaying ALL of the data instead of the filtered data. ACCESS 2010

I am using Acces 2010 and I created a Navigation pane. For whatever reason the Layout view is no longer available in the view dropdown. How do I get it back? I want to add more tabs and that action needs to be done in layout view. Please help:cool:

How can I add Photos to each employee's profile? Is there like a a feature that allows attachements to records within a table? Please help:)

I am using a Navigation from to show reports in a Subfrom view and I want to create a button that says open the current repot.... How do I write the code to get the button to open the report that I am viewing in the Navigation subform?

Currently, I have Macros that filter my employee query and I am looking to apply those same filters to the reports. How can I achieve this?

I am trying to count the number of classification types for employees in a report. The types are NBU, SBU, CON, SRA, and HBU. Each employee has a classification and when I run the count code on a report it's counting ALL employees with a classification. I want to count the employees that have...

How do I create a button that exports the filtered data on a form, which is based of a query, to excel. I have a query that retrieves ALL of the employees in my database but the data if filtered by department. I created buttons for each department that filters the "ALL employees table" by...

How do I tell access to open the FORM dialog view in the same screen that Access is running on? I have dual screens with my laptop screen and my secondary screen and when I open access in the secondary screen the form dialog opens on the laptop? Is there a way to tell it to open where access is...

When I run a macro from a command button that filters data I am getting en error "Invalid Outside Prodecure", error number 40036. When I run the macro step by step it works fine. How can I fix this?:confused:

I have a navagation form with four tabs. One for Employees by department, another for employee changes for that same department, another for employee adds of any department, and a report center tab. I also have a Main Form with all of the different departments labaled on command buttons. Each...

I have a department number table in my database and I want to add new department numbers from a imported table. How is this accomplised? There are 256 department numbers in my existing table and 272 department numbers in the imported table. How do I add the new ones only?:confused:

I have created an employee database for many different groups (departments) to use and I'd like to create a button that restricts or filters the data from the employee table for particular departments. Exampe: I have a form with all of the different groups labeled with cmd buttons and upon...