Search results

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

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

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

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

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

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