Search results

Hello, I have a main form with multiple subforms in tab view, right now the forms only open in edit mode, I would like all forms to open to new record mode. I know I can set the main form with the switchboard manager but what about the subforms? Help please. :) Thank you in advance. Dave

Hello, I was wondering if it is possible to create custom security permissions in access. For example I have created an employee database, with security. I would like to have it when a manager logs on, it will only display his employee's information and no other departments. Is this...

Hello I would like to create a form, that be used to enter data into multiple different tables. I would like to use tabs for each different table. Can this be done? Thanks in advance. Dave :)

Hello, I have created a database which has 9 tables, the first table being the contact information, but in all tables there are fields for firstname, lastname. Is there a way when you enter the firstname/lastname fields into the main table that it can populate the same information in to the...

Hello, can you tell me what expression to use to generate a query based on a month alone, not a year? For example, If I run the query today, it should bring up all the records for the month of November, but it doesn't matter what year the record was entered. Does that make sense? Thank you in...

Hello, I am trying to design a query that will show all records in a single month from 3 months prior to the current date. I tried the following expression >=DateAdd("m",-3,Date()) but that shows all the records from all three months prior. Anyone have a thought? Thanks in advance Dave :)

Hello, I have created a macro that will open six reports based on criteria selected by a form. How do I make it if there is no data in the report to not open or print? Thank you in advance. :)

I have created a form to fill in the criteria of a query. When I close the form, a new record is created with the last criteria. How do I set the form to use current record, and not create any new ones when I close the form? :)Thank you in advance.

I have created a macro that will open six reports. Each report gives a prompt for definition criteria, such as First Name? and Last Name? How do I get it so when I run the macro, I only have to enter the defining info only once, instead of six times individually?:)