How To Get Dynamic Location Stored In Path Variable For Transfer Text
Jul 16, 2012
I have used Transfer text cmd to export query to text in MS access. This works fine. path= "D:/test/"DoCmd.TransferText acExportFixed,"Query1",path,False But i need to change the path dyanmically as my wish when i run this query. Like i may save my txt in desktop or C: or D:. I dont want to hard code path as above.
Is there any way to achieve this? If i get the dyanmic location stored in path variable i can achieve it. But i dont know how to achieve this.
Actually i was confused
Docmd.OutputTo acOutputQuery,query1
Above query prompts me for selecting location. But transferText doesn't? why?
As this application is stored on server. If i give a static path, its exporting in Server D:/test/ But i need this to be stored in my local. This can be done only if it prompts box for user to select the location.
I have several text boxes which I can populate using the DLookup.I have images I want to display for individual records.I use a search (textbox) to input client name and this populates all other textboxes. I am trying to get the relevant image to display also using this search box. I have also disabled record selectors just tidy up the form. I have tried coding the image control on the AfterUpdate event of the search box. Full path to images are stored as JPG in my ClientTable not as OLE.
I am new to Microsoft access. I have a database moved from another computer. it is split into the backend and the front end..
However, when i click on the forms in the front end, I get an error message. It is trying to use a path from the old computer, to the database, but its on a different computer.
So, this brings me to my question, how do i change the path, to the new location
I have two different database files. One is 2010 ".accdb" format where I have created a form and the inputs to the form is getting saved as records to an access.mdb file in a shared path.Now if the users want to edit the existing record I should allow them to search their previously submitted record with a unique ID number.
I know it is possible when we have both the form and table in the same db. But I want to know whether it is possible to search with a unique ID and pull the data from different db in a shared path using a command button?
With the OutputFile set to "" so the user can select the directory on where they want to store the exported template. I'm trying to figure out if I could get the file path and the file name and store it on a string so I could use it for something else.
If the user clicks on this link then the respective file should be open..I don't want the front end users to see the entire path. So, I would like to have the names as 1234.pdf in the location column instead of M:New1234.pdf. Is it possible to hide the entire path in the backend and show only the name of the file. so that if users click on 1234.pdf then the file needs to open.
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 .
I defined a public variable and then for being able to filter a query results, assigned it to a public function. The problem is that function doesn't get the variable's value.
Set up a txtbox that will house a variable (no worries)
I want a button that when clicked to open a "MS Windows window" that allows the user to navigate to a folder. When done I need that path to be placed in the textbox I set up (Or to a variable)
Does that make sense?
I thank you all for your help it is very appreciated.
Excuse me! i would like to know how to use browse function (like in windowXP) to select the excel file i want instead of using transferspreadsheet code.
I have a folder which holds 1000s of pictures organised in subfolders, for example:
D:~AI Database Print Scans2009family and D:~AI Database Print Scans2009holiday
And so forth. In total at the moment 17 main subfolders, each of which hold another 2-3 subfolders.
I am putting together a database to bring pictures together with all sorts of details. I import the picture via hyperlink and complete the various fields. All that works fine but there are a lot of pictures! And it gets confusing to see which ones have already been entered into the database and which ones haven’t.
One solution for this is to copy the pictures that have been “completed” to another folder. I have found a way to do that:
Dim fs As Object Dim oldPath As String, newPath As String oldPath = Forms!frmPrintDetails.txtPath1 newPath = "D:~AI Database Print ScansCompleted_Entries" Set fs = CreateObject("Scripting.FileSystemObject") fs.CopyFile oldPath, newPath Set fs = Nothing
Works fine, but the problem is that I loose the subfolder structure, it copies all pictures to the same main folder. I’d like to maintain the subfolder structure and add code to create the correct subfolders and next copy the picture. With the different paths I’m lost. I don’t know how to extract the correct path in code. I’d also like to either rename or remove the picture once I have completed entry of the details. The problem I have again is that I don’t know how to code for a changing path.
Company Product Sales 1 A 5 1 B 2 1 C 7 2 A 8 2 B 1 2 C 2
I want a query to produce a table showing Products A though D which is the sum of Products A and B. Result:
Company Product Sales 1 A 5 1 B 2 1 C 7 1 D 7 2 A 8 2 B 1 2 C 2 2 D 9
I have many rows and many summations and the current union query and supporting queries are pretty messy and not easily changeable. What I'd like to do is have a third table which would hold the summed product names and the formula used to get to it (Product D, A + B) and have a query that can be dynamically based off of that table. Do I need to use VBA? Does anyone have a better idea? Any help or even a good search term would be appreciated!
I have a macro which transfers a fixed width file to my desktop. The name is neppow.txt. Can I have this file land with the date dynamcially populated in the name?
I have a text box that allows users to type a letter to a customer with a listbox next to it. The listbox is filled with data such as the customer's name, address, etc.... When the user double clicks an item from the list box, it should insert the appropriate data into the text box.
The problem is, is there a way to determine the current cursor location in the textbox so I know where to add the data?
For example, the cursor location has been determined before the text box lost the focus and now i am inserting the apporpriate data:
I have setup a query from which I have setup a macro which exports the queried data to a .txt delimited file, does anyone know how I can stop it putting Quotes aroung each field and just leave the commas in.
so i have MainForm and PopUp (which is also a form). on the MainForm there is a command button that brings up the PopUp form. on this PopUp form, some data will be entered then the PopUp form will be closed via a command button.
whats the code i would need to take a value from a control on PopUp and place it in a control on MainForm, ideally when the command button closes the PopUp form.so i know it has to go on the command button's on click event, probably before the close form code lol... but i cant figure out how to get the value to transfer over..
I have one text box with the name of nametxt and one it's label with name of namelabel. I want to relocate this text box with it's label when the button02 is clicked to the new location. Thus i have tried using this code:
Code:
Private Sub Command02_Click() nametxt.Top = 0.2083 nametxt.Left = 1.0833 namelabel.Top = 0.2083 namelabel.Left = 0.5833 End Sub
But this code is not working correctly and relocate the text box to the up left corner of form. How fix this issue.
With microsofts article, I have made to store multi options value of a list box in a text box with comma. However, since these are IDs being stored, I want these values to run a query and get results also.
But I am confused since have never used comma like in query
I have a main data entry form (frmpartquote). From this form I would like to open a new form (products) to create a sub set of records.
When I open the new form to add products to a main quote I would like to transfer the quotenumber on the quote form to the quotenumberfield in the products form.
I use the following code in the on open event in the product
Private Sub Form_Open(Cancel As Integer) If IsOpen("frmpartquote") Then partquotenumber.DefaultValue = Forms!FrmPartQuote!partquoteid End If End Sub
Now this works fine as long as the field is a number.
However I would like to use tartquotenumber as a text field
This is a price check form so it doesnt need to be saved it just needs to display the part no info and quantities with price If i enter a part no into a text box(PN1) on the main form it enters the data into a textbox(PN2) on a subform. Im using a continuous form on the subform and the master/child link is the Part No text box. is there a way to lock the first item to the first line and then be able to enter a second item to display on the next line. I have made the size of the continuous form to one line in my subform but i am only able to enter one part no into the subform because when i setfocus to the PN1 textbox on the main form it clears the first line.
I have filed that has been uploaded from excel file in this format 20110307 , but I need this filed named postdate in date format such as 03/07/2011 . How to transfer text filed into date .I use Format([PostDate],'mm/dd/yy') in update query , but the data completely disappeared off the field.
I have a problem converting text to a real date value so I can do some calculations. I have a query that brings in data from an external data source. It appears the data is stored in the external table in text format and looks like this:
20050902 15:40:41
I have tried CDate to convert the text to a date/time format, but no luck. Any ideas?
