File Search Functionality
Nov 2, 2005
I have a form that imports an excel spreadsheet and manipulates the data into a database friendly format. My issue is that I have hard coded the test file name in the DoCmd.TransferSpreadsheet command.
What I would like to do is to allow the end user to go and click on the file and then have access pick up the file name and run the process. Is there some Active X control that allows the user to go search for the file they want to import? If so, is there any functionality to such a tool whereas I can have the user click on the file and instead of opening it, I can simply capture the file name to use in my module?
OR… does anyone have a better idea of how I might go about what I am trying to accomplish? I hope I explained my situation clearly enough…
Thanks
Gary
View Replies
ADVERTISEMENT
Jun 25, 2013
I have a search box running the following code on After Update. I would like the search box to use a contains functionality instead of its exact nature currently.
Ex. "Address Number" could be found by typing "Num". Currently I have to type "Address Number" in full exactly as it appears in my table.
Code:
Private Sub txtSearch_AfterUpdate()
With Me.RecordsetClone
.FindFirst "[QstnText]=""" & Me.txtSearch & """"
If .NoMatch Then
Beep
Else
Me.Bookmark = .Bookmark
End If
End With
End Sub
View 3 Replies
View Related
Dec 17, 2013
I'm using Allen Browne's search form in an application for demographic purposes.
The form is working fine, but the user is asking for a new functionality. He wants at lease 3 state combo boxes so he can filter that [State] field for at lease three choices and the way it is build now he can only have one. I tried the following code (with the corresponding text boxes in the form), but it didn't, the result was no search at all.
Code:
If Not IsNull(Me.txtState01) Then
strWhere = strWhere & "([State] Like ""*" & Me.txtState01 & "*"") AND "
End If
If Not IsNull(Me.txtState02) Then
strWhere = strWhere & "([State] Like ""*" & Me.txtState02 & "*"") AND "
End If
If Not IsNull(Me.txtState03) Then
strWhere = strWhere & "([State] Like ""*" & Me.txtState03 & "*"") AND "
End If
In the Allen Browne's documentation he explains about using the AND and OR's and I tried a few combinations, but the result this time was no record found at all.
View 2 Replies
View Related
Nov 17, 2014
About a year ago I created a search form based on Allen Brownes Search model. Working fine, but the user wanted added functionality, see here, after a few tries the users didn't wanted the option anymore because they were in a hurry to deploy. But now their management is asking again for a wider scope in that state search.
I made an example model. It works fine, but only if I always have some value in the [State C] option, if left blank it won't work, a Run-time error 3075, will pop up.
I have tried many combinations of parenthesis, but, haven't got any luck.
View 8 Replies
View Related
Jan 31, 2013
how to create file explorer like functionality in ms access.
1 -I need to be able to browse files within specified directory and only. I can't alow users to browse any other directories.
2- I also need to be able upload (copy/paste) folders and files in that directory
I looked at different solutions and found a solution which might work on this foum link below.
---access-programmers.co.uk/forums/showthread.php?t=102667----
The treeview working for browsing specific directory, but i need to enhance it to allow to copy files and folders in that directory.I use MS ACCESS 2010 and not very proficient in programming.
View 5 Replies
View Related
Nov 1, 2013
I'm a newbie and using Access 2007.
I have added functionality that creates a report, saves it as a PDF, and then sends it to a customer via email as an attachment. The PDF file is saved to a folder and is named to include the Customer's unique customer number and the date and time the PDF was created.
For example, if the customer number is 09 and the date was 10th October 2013 and the time 09.00am, the file name is 0009101020130900.pdf.
What I want to be able to do from within the database is to have a button, that when clicked, will display all of the Pdf's for only customer number 09. The customer number will be based upon a field in the customer record.
View 4 Replies
View Related
May 28, 2014
In the access form I want to add a button with a special functionality.
After clicking "Select file" button special window should be open (or something else). It should give user a possibility of files locating (doc, pdf, rtf, txt ...).
After selecting the file and confirm the choice in the table "File_location" in database path to the file should be saved .
View 4 Replies
View Related
May 24, 2013
I have search the web and came across something pretty similar to what am looking for (URL...), unfortunately this database sample does not work with my Access 03, so I cant really play with it.
What I want to do is have 3-4 Paths save on my form to folders on our office server, this is were we keep client files. I like to have the ability to search for individual folders by either client ID or name or even partial name if possible too, knowing that it may display more than one folder for the employee to pick and open.
I have included a picture of the form ...
View 2 Replies
View Related
Dec 3, 2007
We just started using Access 2007 in the past few weeks (upgraded from 2003). One of the functionalities that we are missing is the ability using the Alt+Tab to go directly to an open table or query under a specific Access Database that is already open. Now I can only switch between open Databases and then I have to use my mouse to Toggle between open queries/tables etc. Is there a setting that would allow this, or is this functionality just gone? (I am still using XP, but the functionality is not there on Vista either)
View 1 Replies
View Related
Apr 25, 2007
Hi, I have a command button that opens a pdf file. However i will be distributing the database as a runtime package and need to account for people having different versions of adobe reader so need to search for the filepath string where Acord32.exe is found. This is the code I have but I am stuck! Ay help aprpeciated!
Private Sub Command4_Click()
Dim stAppName As String
Dim stPathName As String
Dim fs As Object
Set fs = Application.FileSearch
With fs
.LookIn = "C:Program Files"
.SearchSubFolders = True
.FileName = "AcroRd32.exe"
.Execute
????? stAppName = .FoundFiles
Set fs = Nothing
End With
'specify path name for version of adobe acrord32.exe
'stAppName = "C:Program FilesAdobeReader 8.0ReaderAcroRd32.exe "
stPathName = GetIniSetting("C:WINDOWSSSI_DL3_PROGRS.ini", "DIR", "REPORT_FILELOCATION") & "HOOF.pdf"
Shell stAppName & stPathName, vbMaximizedFocus
End Sub
View 1 Replies
View Related
May 31, 2007
Hi,
Does anyone know how to perform an exact match using file search. The code I have below searches for the users AcroRd32.exe file (I have done it this way to allow for different versions of the reader). The problem is that foundfiles returns also AcroRd32info.exe ie FoundFiles(1). i only want to search for the prior!
Set fs = Application.FileSearch
With fs
.NewSearch
.LookIn = "C:Program FilesAdobe"
.SearchSubFolders = True
.FileName = "AcroRd32.exe"
If .Execute > 0 Then 'check if there is such a file
stAppName = .FoundFiles(1) 'then define this as the applicate string name
stAppName = stAppName & " " 'append a space or file string not correct
'specify path name for location of file.pdf
stlocation = GetPrivateProfileString32("C:WINDOWSSSI_PROGRS_DATABASE.ini", "DIR", "DATABASE_FILELOCATION")
stpathname = stlocation & "file.pdf"
Shell stAppName & stpathname, vbMaximizedFocus
Else
'if no file is found then need to instruct user to install reader
MsgBox "You need to install Adobe Acrobat Reader to open this file", vbExclamation
End If
End With
Cheers to any help..
Tania
View 2 Replies
View Related
Aug 15, 2013
How to write some code that will search a known drive and folder structure for a tif file and on finding it, open that tif file.
The known drive/folder structure is as follows:
M:CustomerSatisfactionStdDGImages
or it could have the full path as follows:
prdfs01QUESTIONSCustomerSatisfactionStdDGImag es
and then there are the following folders which contain any number of tif images:
01_Q
02_Q
03_Q
04_Q
05_Q
06_Q
07_Q
10_Q
11_Q
12_Q
13_Q
14_Q
17_Q
18_Q
19_Q
20_Q
21_Q
23_Q
24_Q
28_Q
29_Q
30_Q
31_Q
32_Q
33_Q
34_Q
35_Q
36_Q
37_Q
38_Q
39_Q
AR_Q
HE_Q
SKY_SKY3B
I would like to have a button in a form that the end user clicks and they then enter the name of the tif file they are looking for and on pressing enter the file is searched for and if found it is automatically opened up for them to see, if it is not found then a message "File Not Found" is displayed.
I Believe that I will need something like this:
Code:
Dim FS As FileSystemObject
Dim filenum As Integer
Dim tmp As String
Dim Folder As Folder
Dim subFolder As Folder
Dim File As File
[Code] .....
It's when I get to this point that I've got stuck, I don't know how to structure the code required to do the search and on finding the tif file open it.
An example tif file I might search for is: 0H214_2CJ0001905.tif.
View 11 Replies
View Related
May 3, 2006
I am building a database for a client that tracks construction drawings. The client came today to check on progress. Just before he came, I changed the start-up properties to hide the database window, menus etc so it would look more like the finished product.
Problem was, I lost alot of the functionality and had to change it back to demonstrate:( . Is this common and can anyone explain why? much appreciated
View 2 Replies
View Related
Mar 12, 2007
I want to have a program where the balance of an account is always updated and stored in a column. In oracle I would use pl/sql, does Access have a similar capability?
Also I want to be able to add and subtract date types, for example, to get entries from the last month. Oracle date type can do this, does the Access date/time datatype do this?
View 8 Replies
View Related
Apr 4, 2008
I'm having a problem with my database filesize getting larger with the more searches i do. At first i couldn't figure out how it was getting so big, but then i tried a few things and came to the conclusion that every time i do a search it increases its filezile.what made me notice this at first is that the file size of the original copy of my db is 13MB, but if i Save As a different name, like Assets_Backup, then the size of the new file is only 2MB, and after i do some searches it increases again.here is a file with just my search form and search query so you can see the code for them. i removed everything else to shrink the file down, which also made the search form not function properly, but i thought the design and code might be enough.is there something that i can change to keep it from remembering every search?thanks for any help.--------------------after searching the topic a bit more i've found that compacting the database will shrink it down to 2MB, but is this something that will have to be done on a regular basis, or is there a way for it to do it on its own?
View 5 Replies
View Related
Feb 28, 2014
Previously in Excel / Access 97 / 2003 I made a little tool that would search for files in specified locations - I modified the code so that it would search for files based on what was entered in cells.
I believe a lot of the old code doesn't work in Access 2010 and it seems like a lot of the old file searching code I used to use no longer works.
Is there code available that searches a directory and lists results?
View 1 Replies
View Related
Aug 7, 2014
I'm building an application to record engineer input in Events (jobs) for an engineering company.
My main tables are Products, Builds and Events, together with fifty or so reference and ancillary tables which aren't really relevant to this particular head-scratcher.
A Build is derived from a Product and an Event is applied to a Build. An Event includes a sale, a service, a warranty repair and so on. Over time, multiple Events will be logged against a Build.
I have a searchable Events form (Search_Events), containing a subform (Search_Events_sub) whose contents dynamically change to reflect data entered in a variety of unbound fields in the main Events search form. Needless to say, the glue that holds things together is the Event_ID field.
On my Search_Events form, I'd like to place two buttons (Rpt_Event_client and Rpt_Event_internal) which will allow the user to print either a client or an internal copy of the event in question. The reason I want to use separate buttons rather than one button for both copies is that it's quite likely that different engineers will work on different parts of an Event's build, test and sign off process, and will want to print off and annotate the internal report, whereas only the final report will be sent to the client. Also, there will be some slight differences between the visible fields on each report (time and materials logged etc).
So far, I've managed to get the Rpt_Event_internal button to open the relevant Event report in preview mode, using the following on the button's 'on click' event:
DoCmd.OpenReport "Rpt_Event_internal", acViewPreview, "", "[Event_ID]=[Forms]![Search_Events]![Sub].[Form]![s_Event_ID]", acWindowNormal, ""
(In the subform, Event_ID is referenced as s_Event_ID because I'm using an nZ function in most of the search fields so that the results filter dynamically)
So far, so good: this works fine. However, from a usability perspective, and based on the fact that this will be the most-used feature, I'd really like to be able to have the button do the following:
- print the relevant report, based on Event_ID as above to a PDF file
- synthesise the filename of the report along the lines of "Event_" & [Event_ID] & "_Client_Copy_" & [Date()] & ".pdf"
- and to then have the standard 'save as' Windows location browser/file explorer dialogue box appear so the user can choose where to save the file. I don't want the filepath to be hardwired, rather I need the users to be able to decide where to save the file.
I'm using Access 2013.
View 3 Replies
View Related
Jul 24, 2015
My database is in database where we do the editing and using Access for query reports.
Upon importing from External Data Link to the data source by creating a linked table: the table was created but running a query yields the above error.
View 1 Replies
View Related
Jul 23, 2006
Hello Access Gurus,
Our application can be broken into several modules, and we want to be able to shut off all modules, but then activate them by entering an Activation/Authorization code for each module.
The issue is that I'm fairly new to Access, and have never done this type of functionality. Is there anyone out there that has done this and can give me some guidance? I would greatly appreciate it.
Thanks in advance.
View 4 Replies
View Related
Dec 23, 2006
Hi experts in MS Access!
Need to know if I can open a MS Access 2000 (large) mdb-file in MS Access 2003 Professional without loosing any functionality? Is there a working way around this behaviour of MS Access 2003? It seems now, when comparing from MS 2000 openings some functionality got loose when I open the same 2000 file in Access 2003. Working environment is MS XP professional and all security patches for Office 2003 Pro and XP are applied.
Regards.
Engstrom
View 3 Replies
View Related
Jan 29, 2007
This being my first post, id like to thank everyone who contributes here.. ive been watching this site for a while, and its been a simply amazing source of knowledge.
Now that the sucking up is over, HELP! 8)
Im developing a database that is going to take over tracking point to point connections between servers and switches in our data center. The system that the users currently use now is a simple flat excel spreadsheet.
Im wondering if there is a way to allow users to enter data in a format that they are familiar with... Tables 'look' the same but unfortunately for the people that I work with they dont (seem to) have the mass editing capabilities that they current work with.
Im using access 2002 currently at work, shortly I will be on 2003. Ive tried to play with the excel add ins that are included with my version, but I havent seen any way to directly link the excel add in to a table in my database, and definately havent found a way to pick and choose information to be manipulated in the cells (via code) in the excel interface.
Id really prefer not to have to have users use excel outside of the database in any form. I am aware that I could probably achieve what I want via importing excel files in the background and what not, but this doesnt achieve the goal that i am after, which is migrating the users out of excel and into access.
I hope I have explained myself thoroughly enough. If anyone has any input on a direction that I should look it would be appreciated. Im not the best with access, however I would consider myself intermediate to expert with coding and whatnot.
Thank you!
View 2 Replies
View Related
Jun 21, 2007
Hi,
Hope someone can assist me with this question:
Let's say I have a Table with many Product IDs records..
Product ID (Number)
Hyperlink Field (with a Hyperlink to an external Excel file)
What I would like to do is to create a Hyperlink that not only will it open the Excel file but it will also search and select the Product ID (in Excel) of the record on which the Hyperlink was clicked in Access.
Is this possible or am I just wishing too much?
View 3 Replies
View Related
Oct 19, 2005
I have a number of combo boxes linked to respective individual tables, for example tool combo look up the tool table which is composed of ToolID and Tool Type.
I want to be able to add additional tools directly into the combo box on the form when I come across a tool type that isn't in there already. However, my current combo tells me that I can't as I am trying to enter an item that isn't in the list.
So, if I then change the option on the combo on 'Limit to List' to No from Yes, it then gives me an error about column widths that need changing.
I don't want to do that but I do want to enter directly - can somebody point me in the right direction please.
View 12 Replies
View Related
Mar 3, 2015
I've developing a little Project and have some issues after splitting a db.
I have some forms in wich I want to see some tables with the "+" sign on the rows so I can go to their linked tables. The problem that I have is that everything works perfect until I split the access file.
View 5 Replies
View Related
Feb 6, 2014
A client I am working for wants a calendar to interact with their database forms, I am thinking outlook would be the best bet, as a table and form to make my own in access would be overly complicated. Is there any way to embed a calendar from outlook within an access form?
View 1 Replies
View Related
Jan 11, 2015
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 possible??
View 5 Replies
View Related