Recent content by tmcrouse

I have a database that I just imported a table and I am trying to get the top 5 by desc order of my member count. The problem is some of the counts are duplicated as 1 but the other columns are not a duplicate. I am attaching an example of the Excel I am importing, but this is just an example. I...

How would I alter the below code to add a data and timestamp to an export? Private Sub cmdExcel_Click() DoCmd.OutputTo acOutputQuery, "qryResults", "ExcelWorkbook(*.xlsx)", "C:\users\" & Environ$("username") & "\Documents\qryResults & datetime.xlsx", , , , acExportQualityPrint msgbox ("Export...

This actually works. Then if I go into options and customize the menu, I can leave the External Data active and end-users can ODBC and don't need to see tables because they only need to use the forms.

If I use the below code, will it hide all the items in the database except the front-end forms? CurrentDb.Properties("Startupshowdbwindow") = False It would be in my load section when the DB opens to the menu form. I want to hide everything but the front-end forms the users are using. My...

My tables are normalized. I have for example state table with st_id and st_cd. In my main table, I have st_id. I changed my forms so that my comboboxes are unbound. Because if bound, they change the relationship table. The bound are my _id fields that are in the main table. I then hid these but...

I have 2 forms. The data entry form allows for new items to be entered into a main table only but the main table has relationships to other tables. I have comboboxes so the users can select from any item they wish and it is to populate to the main table, however I think it needs to only populate...

Thanks. I think I need to do a double click event for it and then create a button for the edit items.

I have an unbound listbox in my details section of my form and it will display items from the database that I have selected. There are 19 in all. If I double click the row, the edit form pops up. If I right click I can sort the columns. I want to have a single click that allows the user to open...

I know how to code to open attachments that are external, but I have attachments in a database that are stored in a main table and users can store small attachments in the field name attachment. I am just trying to figure out on my form how to create a button to open an attachment associated...

I am having quite a time getting my filter function to pass to either a report with embedded pivot chart or form with embedded pivot chart subform to work. Separately, they work fine but I want them to not pull up and show results separately. I am pasting my filter code and what I have now...

Incase anyone needs a solution for multiple multi-listboxes on a form they are using to filter a query that is not attached to the multi-listboxes but only the form and they want end-users to have the ability to filter and see the results, MajP at Tek Tips helped me solve the problem I posted on...

Ok, so now I have coded what I think should work for my listboxes and it does not. When I click it does nothing. No processing of anything. I have 11 multi-listboxes and want to collect what the user selects from each one and then use it to run my query. The query only uses 4 of the listbox...

THNX. I see do a tin with max of the date first and then connect that back to original table and join the tin and the date in the 2 tables and run the query. Worked great.

I always thought when using max it would take the maxdate as well as the item that correlates with the max date. I have the following example taxid eff_dt market 11111 1/1/1990 new hampshire 11111 1/1/1997 delaware 22222 1/1/1993...