Search results

The below code is on a command button and it works fine saving the report to my Documents folder. Can this be tweaked to open the File Save As window and prompt the user for a folder location? Dim strReport As String Dim strWhere As String Dim strFileName As String Dim strFolder...

Requesting advice on setting up a table/relationship. The database contains Contacts and Communications that are sent out to contacts. I believe it’s a many-to-many relationship (a communication can go out to many contacts and a contact can have many communications). So I’ve set up...

I need the Maximum value of the VCRatio column to appear in a column in the same query. I have tried DMAX, but as you know it definitely drains performance so I'd like to try using Max in a subquery and I'm reading that I need to alias the subquery since both values will be in the same query...

I did not create the code below and need to make a change to it so that the TotalPoints value (including two decimals) is inserted into the TmpUnfundedTable. Currently, it is only insert the values to the left of the decimal. Any help would be appreciated. Public Sub...

I found the below code at http://stackoverflow.com/questions/14915179/ms-access-browse-for-file-and-get-file-name-and-path. and it works except if a folder or file name has an "#" in the name it won't enter the full path and file name in the textbox. Any idea how to alter this so it enters the...

I have a main form with a subform and have set AllowAdditions and AllowEdits on the main form to No. If the height of the subform is greater than 3.1" while AllowAdditions and AllowEdits is set to No on the main form, the mouse wheel will not work in the subform and scroll through the records...

I am having an issue with a MainForm and SubForm scenario that includes filtering, running a query on the subform data and also opening a separate form to edit the subform records. Scenario #1 I have a Navigation form that includes a list of clients. When a client is clicked in the list...

Hello all, I have exhausted my searches for help on this matter. I have a main form, a tab control with four subforms on the tab control. I would like the focus to move from the last field on the main form to the first field on the first page of the tab control. I have tried using the...

Hello all, I am in need of assistance. I'm updating an old database. Each record in the database has a corresponding .pdf document that is saved in a folder outside of the database on a file server. A separate table in the database contains the location of the storage folder for all of the...