Search results

Good Afternoon All, After some searching I have found a code that will transfer a folder from one drive to another. I have put this code on a command button, and I still get an error message "The expression on click you entered as the event property setting produced the following error...

Thanks for looking at this JHB. The browse part of the code works fine, but the export part sends it to a form / word document. What i and needing it to do is send the browsed folder to a specific part of a drive. Thanks

Good Morning JHB, Sorry for singling you out, but you helped me out so much with the search box, that im hoping you can help me out again with the last piece of my project. I have a post running in forms at the moment titled "Search for and upload a file to a specific location using a command...

I have found the attached form and this is exactly what I am after. (fBrowseDirectory)Thanks ghudson. What I would like to do is have the import button send the file to a specific location on my drive - (S:\eDNA\admin\eDNA\Engine Data) As im very new to writing and interpreting code, any...

Thanks IIkhoutx, Im really new to all of this, would it be possible to explain or direct me to where i could fine this code. Thanks

Good Afternoon All, I would like to create a form that allows me to search for a folder on my desk top, then once located i can transfer that file to a specific location on another drive, Similar to the Browse / upload function you see on many applications. I am using Access 2003. Is this...

Good evening all, I am trying to create a user log in form that will restrict people from accessing a certain form in my database. This log in form would require the user to enter a user name and password to gain access to the other part of the database. I have found previous posts on this but...

JHB, Thank you very much. As i am very new to all of this, i thought that where ever "folder name" was written i would have to put in the directory name. I have changed the code and it works perfectly. Thank you for your patience and persistence. One very happy access user... awade

JHB, I have included screen shots of the code and the folder so you can see what i am doing. I have tried different things with the code, but i can not get the specific serial number folder to open, just the folder containing the serial number to open. Thanks in advance awade

JHB, I have included a test database so you can see the code that I am running. I have tried different variations of the code to try and open the specific folder with no success. All I can get to open is the folder containing the serial number, not the specific serial number. I will upload a...

smig, I have numerous folders each containing different information i would like to create a search function for the user to type in the serial number they are after and that folder automatically opens.

If you had multiple folders in Access Programmer will your search only open 20010? This is the problem I'm having. I have multiple folders in Engine Core Folders, and the code opens the folder contains the serial number, but not the specific serial numbered folder.. Thanks for all your help so...

Thanks JHB, I finally got it to work, but it only opens the folder with all the folders in it not the one i have typed the serial number in for. The Engine Core Folders opens up, but inside that is 58 separate folders all labeled with individual serial numbers. What i am after is when i type...

Thanks JHB, I have tried the code you have provided, and i keep getting the message box " serial number does not exist, please try again" I know the folder has that serial number folder inside of it but i can not get the serial number to open the file corresponding to the serial number...

Hi JBH, I would like to have a text box which i would type in a number for example 1234. I would then hit a command button named "search" That would then open a specific folder in my computer named 1234. The folders are located on the "C" drive "C:\Program Files\eDNA\Engine Core Folders"...

Good Afternoon, I have a access 2003 database, and i am wondering if i can't setup a search function in a form that will open a file in windows explorer? What i would like to do is have a test box that i enter in a number for example: 1234 then have a button named "Search" hit that button and...

Paul and Bill, Thank you very much for putting the time into getting this sorted out for me. I appreciate your assistance. Cheers Andrew

Please find attached the query, tables and report from the database to make it easier to explain / establish what I was after. Thanks for your help so far. Cheers

Thanks Bill. My apologies but I am really new to access. Could you please explain exactly where these codes go? How do I group by agent name, is that in the Field, Table, Sort, Show, Criteria Fields and where do I add that code in the second column. I'm using Access 2003

Good Evening, I have a log in table that counts every time a user logs onto the database. Each time a user logs in it adds another entry to a table. I have built a query to display the user name and date of log in so I could display this information in a report. The report is now getting...