Search results

Will this formula work on a report?

I did try that with no luck. It appears that I have to create a new query for the employee Add tab. The employee information has too many other tables linked which causes the Data Entry option to not work.

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...

For all intense purposes any one department only has one manager. My issues seems to be getting the employee ID into the department table and should I be using a Autonumber instead of the persons CID as the primary key of the employee table?

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?:(

There's always something in the filter! But thanks for the advice

VbaInet this is the code that I was looking for... Take notes for the next person that asks!!!! Private Sub cmdExportExcel_Click() CurrentDb.QueryDefs("qExport").SQL = "select * from qselEmployeeInformation where " & Me.Filter DoCmd.TransferSpreadsheet acExport...

There's nothing wrong with the limit. No one I've helped have been restricted by this limit. If a report is based on multiple queries and you need to upload one query and the report, what do you do? You make a table of the results of the multiple queries and upload that and the report. You also...

FROM TableName WHERE Would this be "FROM tblEmployee Where" ? :eek:

The export to excel is on a different thread. The photo's are being displayed on a form, not a report. The pictures come up just fine, however, when the path cannot be found I want access to revert back to the NO Image jpg, not the last found file. I'm doing my best to help you help me. It's...

If I add anthing else to the DB it will be too large to load? Of course nothing works..... The new database has "one or two tables, one form, 3 to 5 test records." My database has 13 tables, a ton of macros, about 20 forms, and 10 or so queries. It's too large Now what? I am so close to having...

I've attached a DB with the two forms that I need help with. The search form has the Picture and the Main form has the export to excel button

My database exceeds the 2meg limit. Now what. I'd love to send this to you so that you could take a look at it. Doesn't seem possible with such a small upload limit :mad:

The no Image comes up for everyone but most people have pictures so it's working properly.

In the web browser.... no, in my windows explorer browser.... yes.

I removed the afterupdate and on current code and the no pictures come up only the No Image file is displyed.

This code destroys my qselEmployeeInformation query when I run it......It removes all of the tables and relationships.

This is the code you sent me? Was I supposed to put the name of the employee table at TableName?

Yes the form is being filtered. The form is always filtered unless we are looking at ALL employees.