Search results for query: *

Hi I am trying to check if there is any broken references when access starts as the reference changes in different version of Access. The code works through ok but it does not remove the missing/broken references. When I debug nothing is shown it’s just blank in the debug.print. Any help...

Writing a function that search any drive specified. In that drive specified it must search all directories and their subsequent subdirectories for a specified excel file and display file name parent drive and location found. For example 1. Search each folder for an excel file 2. If excel...

I have a problem when I need to remove the duplicate values in EstNo and EstWt when you have multiple ReleaseOp for example the 3 first lines below all showing ReleaseOp 1 should leave only the first record with the values 23 and 89. ReleaseAutoID is the Unique ID that identifies the record. =...

Dear All I hope you can Help me. I have problem I am trying to solve but to no avail. I need to display all result based on dates from three different fields(Fish Date Start, Fish Date End and NoneDate). I need to be able to dynamically build the SQL to get results as it is based on 3 Ors...

Hi The following function takes table and sends to excel. What I need to do is carry put border outside and inside for all output result. Can you please help me append code to do that. Thank you for your help Function SendToExcelDataChecks(strTableUsing As String, strTitle As String) On...

Query type: Make Table. It generates the make table using the true field names instead of using Caption as field name. For my need it must use Caption as field name. The starange thing is i have 5 make table queries and only one uses Captions as field name. Is there any way to make...

Hi I have a problem trying to perform the following: 1. add a conditional format at end in excel if Collum 1 > than colum 3 then mark red. 2. make heading bold and centered. 3.do not start excel again if you rerun query just add a new sheet if excel already open. thanks for your help. Code...

Hi All I would like to be able to search for all subdirectory that start with to letters and 3numbers and display results and display folder properties "Owenership" and date modified. below it does all directory I want it to leave out/only display results for subdirectories. # finds all...

I am trying to export a table from access to excel and transpose layout in excel. For example: Tran Op # Fish Op # Date Start Date end Catch Transfer 1 1 14/05/2011 15/05/2011 Y N 2 2 N Y Y resuly needed: Transpose to: Transfer Op #...