Search results

I tried it in several places with several methods but can't get it to work. Where do I place it?

I tried it in several places with several methods but can't get it to work. Where do I place it?

My * idea didn't work! :(

Good Point!! I just realized that on the Show All button I needed to reverse the filter. Can I just replace the CITC with and * to mean all, or is there a simpler command?

Perfect!! This worked EXACTLY like what I needed to do!! Thanks so very much!

Here is the line of code in the record source: SELECT qStaff.vStfFullNm FROM qStaff ORDER BY qStaff.vStfFullNm;

I have a form "fStaff" that is populated by a query "qStaff" with over 3000 records. The user can click a button "bCITC" which sets a filter to only show the records for employees who work in CITC. Once they click that filter button on the form to isolate the records to a subset. However, the...

I've tried it. That is what the first line does that I have commented out. It tells me the file is already open and can't be accessed.

I am trying to attach the current workbook to an email, but when I use the method shown online, it replaces the spaces with %20. I tried building the name and attaching it using the built name but get an error on that. Here is my code. Any suggestions or help would be greatly appreciated...

I have a Named Range of values that I need to lookup a value in as my SumIf identifier for the total. However the Table can have additions and deletions and then be resorted so that the direct reference becomes a different value. I am summing three different values to get a composit total...

It was an odd error, "process interrupted" or something like that... I can't seem to reproduce it now. But the SaveAs window pops open, the file name shows in the file box, but the file actually saved to the current system active drive, even though it showed it was going to save to the U:\...

For some reason I am getting an error message. Should the .xlsx be .xlsm? since this is a macro enabled workbook?

Wow.. that worked in terms of setting the directory!! But it doesn't show the vFilename that is created. I looked up the syntax thinking I could add the name in, and I tried Application.GetSaveAsFilename (vFileName) but that didn't work either. What is the trick to show the created filename...

I've done it both ways and it didn't work either way. Surely there is a way to do this. Thanks for the input! Anyone else out there got an idea?

I have a spreadsheet that I build a file name from the date and the user and then need to store it to their network folder. I have tried numerous things but can't get Excel to change the current folder prior to executing the xlDialogSaveAs command. Here is where I am... any help would be...

How would I go about sharing it with you? It is a very large database and it is split into a front end and back end. I would have to send a copy and delete all the database because it is a medical database and subject to HIPPA rules. Any suggestions on what to do?

Given the fact that I am using Multi Select List Boxes to Filter my records, I don't know how to pass that filtering to a query that could track the counts as the user clicks more and more option. I think that I gave a better description of what I have created and what I am trying to achieve...

I'm not sure how to go about this, and given your concern of subselects, I guess I would want to use a VBA Loop to count the recordset after the filter is supplied, however, Im not sure how to create that loop? Would I just call it after the last click on the Multi-select list box, or would I...