Search results

Since you don't like Macros how do you suggest that I filter the employee query?

OK, let's pretend I have no code. How would you export filtered data from form view?

I'm not sure how you did the indentation but whenever I try to recreate that, Epic fail!

If [tempVars]![FilterType] = 1 then SetFilter wherecondition = Left$([FIN],3) = "AVE" Control Name = Navigation Subform Else If [TempVars]![FilterType] = 2 and so on and so forth

vbainet, Are you done helping me now?

I have no idea what that means. I am not a VBA programmer. If I were I wouldn't need help. LOL

Function mcrFilter() On Error GoTo mcrFilter_Err ' FilterType - 1 = AVE, 2 = SCE-CHA, 3 = EPR, 4 = SCE-INT, 5 = SCI, 6 = VEE, 7 = UCN, 8 = SCI-NSA: Restraints, 9 = SCE-ENG, 10 = SCE-ELE, 11 = SCE-BOD, 12 = ALL, 13 = SCI:, 14 = SCI-ARD, 15 = SCI-BPS, 16 = SCI-CPG, 17 = SCI-DEB, 18 = SCI-MFS, 19 =...

I am setting filters based on Department name. For example SCE-BOD is number 12 and it reads like this [temp vars] ! ]filter type] = 12

Option Compare Database '------------------------------------------------------------ ' mcrFilter ' '------------------------------------------------------------ Function mcrFilter() On Error GoTo mcrFilter_Err ' FilterType - 1 = AVE, 2 = SCE-CHA, 3 = EPR, 4 = SCE-INT, 5 = SCI, 6 = VEE, 7 =...

I am using a few macros. The main macro has all the filters in it and then I have Department Macros that set the Temp Vars to a specific number (1-25) that coincide with the main macro. Make sense?

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

Thanks, The Autocenter fixed the issue!

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

That worked. Rouge End Sub command...... THANKS

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

Thanks a bunch

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:

Ok then one more issue. I have an employee table that has department info in each record which in turn is linked to the department number table which is where the queries are pulling from. The info in the Department table is like this: 1250-0860 = AVE-AVE: Advanced Engineering and because there...

Uggh, that's what I am trying to avoid. I don't want a form for every query. I want one form for all queries..... Is that possible.