Search results

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 am using the 2010 Access sample and it doesn't open in Form view. What button are you referring to?

That worked..... Thanks a ton

Not in the Accde version. It does nothing

Yes, there is code behind the command buttons that run the reports which tells access to Me.Filter on the main query to report on the filtered results. This is Access 2010

Okay thanks. I've followed the directions from the link that you sent me and I am not sure what code to copy/paste? Am I suppose to copy ALL of the forms and tables from this link? I created a Users table and a security table per the directions, but then what do I do?

All reports that work in my accdb file are no longer working in my accde file. I have a report center tab on the Navigation form and on this tab are command buttons that run the reports. They are no longer working in the accde version of my database.

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

Dropped...... Thanks

Ha, that's a good question. I wasn't sure if it was even possible.

The image path table has the path of the image and the employee's ID number which is linked to the employee table by that employee ID

SELECT [qselEmployeeInformation].[strFirstName], [qselEmployeeInformation].[strLastName] FROM [qselEmployeeInformation] ORDER BY [strFirstName]; This is what is in the combo box now.

The Combo box has the employee names in it, not the Department description so how whould that work?

Yes. The records are being filtered by Department description or Lowest Level department description and they are both on the employee search form which contains the combo box.

It is a field in the Image path table.

strImagePath is the control source

I found the Allow Zero Length property but was is an NZ function? I'm not sure what to do after I set the Allow Zero Property to NO. :rolleyes:

The form is filtered by two macros. When the AVE button is clicked and AVE macro set's the TemVar to a specific number and then a macro with the instructions on how to filter is ran which brings up the filtered form based off the Employee Query

It's unbound or at least it was