Dots In Filenames Throws Error When Trying To Link Tables
Apr 12, 2008
I've been using MS access to lift some text files for a number of years
I have now got an issue where by the new machinary is very clever and has alittle server to collect the data. Machine1_127.0.0.1, Machine2_127.0.0.1
Previously I picked them up via ftp and downloaded the data into a text file called Machine1.txt
Now I can run a server where by the Machine1_.txt is created locally on the processing machine
however the software included ( which I can't change) just creates text files like so Machine1_127.0.0.1 and now the link doesn't work when I create the link access throw this:
"Microsoft Jet Database engine could not find the object c:Path to fileMachine1_127.0.0.1.txt. Make sure the object exists and name and Path are correct"
If I manually copy the file and rename it to machine1.txt all is good
Any offers/thoughts or suggestions, the path is quite deep at present and that could be changed.
I can't import the files either? unless I rename them and at the moment I am doing this through the interface
View Replies
ADVERTISEMENT
Mar 13, 2006
Hi,
I have this query here:
SELECT sum(subtotal) AS final_count
FROM [select count(*) as subtotal from 1_2_06 WHERE Role='EUM' union all select count(*) from 1_9_06 WHERE Role='EUM' union all select count(*) from 1_16_06 WHERE Role='EUM' union all select count(*) from 1_23_06 WHERE Role='EUM' union all select count(*) from 1_30_06 union all select count(*) from 2_6_06 WHERE Role='EUM' union all select count(*) from 2_13_06 WHERE Role='EUM' union all select count(*) from 2_20_06 WHERE Role='EUM' union all select count(*) from 2_27_06 WHERE Role='EUM']. AS all_counts;
I save it as a query then I try and run it, but I get an error saying that the path is invalide. When I open the query to look at the SQL it looks like this:
SELECT sum(subtotal) AS final_count
FROM [select count(*) as subtotal from 1_2_06 WHERE Role='EUM' union all select count(*) from 1_9_06 WHERE Role='EUM' union all select count(*) from 1_16_06 WHERE Role='EUM' union all select count(*) from 1_23_06 WHERE Role='EUM' union all select count(*) fro] AS all_counts;
Why is this happening?
View 1 Replies
View Related
Dec 14, 2007
sql = "SELECT Table1.* INTO Table1 IN '" & sExpFileName & "' FROM Table1"
CustDB.Execute sql
where the sExpFileName contains the path of The Target MS Access DB
The Query works fine. But recently I discovered that if my target File name contains apostrophe It gives error as Query Input must contain at least one table or query
Is there any way to solve this problem. Please suggest me some way
View 7 Replies
View Related
Jun 27, 2013
I simply want to link a table from one database to another but am getting an Error -1002 with the error description: "'|' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long."
I have tried just creating a basic table with one field and linking it to another database and still getting the error. It happens when I compact and repair on close.
View 5 Replies
View Related
Jan 5, 2013
How to view the file names of attached files in Access 2010 using a Web Database, specifically the Contacts Web Database that is a template in Access.
Currently it only shows one PDF icon for all my PDF files. I would like to be able to view the file names of all the PDFs in the attachment field. While I'm certain this can't be done within the same field as the attachment box (though would be nice), I would think it would be possible to populate another field with this information.
I have experimented with different things with no luck using a new standard database for testing purposes. The closest I've come was using the SubForm/SubReport; it actually gave me the values for the attachment... see in the picture below.
But even then, it did not work and gave a error: Invalid Control Property: Control Source
View 9 Replies
View Related
Jan 12, 2005
This is complex, but here goes.
I am copying many many music cds to my hard drive. However, the song file names on the cds are track01.mp3, track02.mp3, etc. I have all the real songnames for each cd listed in the database. I need a way to rename the songs with their real names one cd at a time. My thought was to populate one table with the directory and filenames (track--) of the songs and populate another table with real songnames from the database. Then, somehow, rename the files. I'm lost. I hope someone can help!
View 1 Replies
View Related
Apr 10, 2008
How would one go about scanning a hard drive for all mp3 files (i.e. *.mp3) and importing all of the titles into a database? I'm sure the dir function comes into play, but it seems to only handle "current" directory and not sub directories.
I was just curious is all..... haven't really dabbled that much in the file/directory functions.
View 5 Replies
View Related
Oct 9, 2006
Should they implement them or not?
They are the small green rectangular things underneath a users number of posts. In most forums they are used as a ranking system judged by a users number of posts.
View 1 Replies
View Related
Jul 27, 2005
Where is the button with the three dots located in access so when i go to form desing i could add that button to the form for look up.
View 1 Replies
View Related
Aug 22, 2006
i have a subform on a form with Source Object="Query.myquery", my form is generating a sql string dynamically and assigning this sql string to the RecordSource property which works fine. But now if the user changes the width of the columns in the subform and close the form , a prompt is thrown asking if the "myquery" needs to be saved. I dont want to save the settings of "myquery" but at the same time avoid this modal dialog. If i use DoCmd.SetWarnings=False , i dont see the warning anymore BUT the query gets saved.
I am using "myquery" to just display column names in the subform when the forms loads and also without it i cant directly use RecordSource property in my code.
any suggestions?
View 1 Replies
View Related
Jun 30, 2005
im responding to the code you submitted to draw lines on a form. I am trying to change it a bit to only draw dots. I have x and y cordinates that I want to draw on the MS form kinda like a scatter graph. So I want to pass values from a table into the function LineX. Then have the function create dots that draw on the for to corespond to the x and y Cordinates. I was wondering if you could help.
thanks in advance
here is the original code
Option Compare Database
Option Explicit
Private Declare Function LineTo Lib "gdi32" (ByVal hdc As Long, ByVal X As Long, _
ByVal Y As Long) As Long
Private Declare Function MoveToEx Lib "gdi32" (ByVal hdc As Long, ByVal X As Long, _
ByVal Y As Long, lpPoint As Any) As Long
Private Declare Function apiGetDC Lib "user32" Alias "GetDC" _
(ByVal hWnd As Long) As Long
Private Declare Function apiGetFocus Lib "user32" _
Alias "GetFocus" _
() As Long
Public Function LineX(Ctrl As Control, X As Long, Y As Long, cx As Long, cy As Long)
Dim DC As Long
'device context
Dim hWndCtrl As Long
'bounding control handle
hWndCtrl = fhWnd(Ctrl)
'get control handle
DC = apiGetDC(hWndCtrl)
'get control DC
MoveToEx DC, X, Y, ByVal 0&
'set starting point
LineTo DC, cx, cy
'draw line from starting point to cx, cy
End Function
Private Function fhWnd(ctl As Control) As Long
'use getfocus to retrieve ctrl handle
On Error Resume Next
ctl.SetFocus
If Err Then
fhWnd = 0
Else
fhWnd = apiGetFocus
End If
On Error GoTo 0
End Function
View 1 Replies
View Related
Nov 7, 2007
I'm creating buttons from images I''m pasting on the forms, but all buttons are having these 3 pixels red, green, blue down in the left corner.
http://img150.imageshack.us/img150/16/accessbuttonln4.png
Any way to get rid of them?
View 3 Replies
View Related
Dec 12, 2013
After several days of searching, I haven't been able to find any threads related to this. I'm making a search form that queries a pdf library table. Once a search query is entered, the user is able to open the files from a results form. Currently, I am entering the filenames from the network directory manually into the pdf library table.
For example, I manually enter the following information into the tblPDFLibrary table that contains the fields:
Date added, Filename, File Path, Series, Class, Title.
I was wondering if there's a way to have Access query all the filenames in the directory for me. In other words, if the directory contains the filenames: AccountsPDF, InventoryPDF, CustomerPDF. Can I have Access query all the filenames within the directory and automatically add all the file names (AccountsPDF, InventoryPDF, CustomerPDF) to the Filename field within the tblPDFLibrary table? If I am able to do this, I can code the other fields to populate information because the filename contains all the other field information (except for file path but I can program it insert the UNC path).
View 4 Replies
View Related
May 28, 2013
I am splitting a database and have created the Back end already. When I create the front end and link to the tables on the back end... The front end does not link to all the tables in the back end. The list that comes up when creating the linkings does not show all the tables in the back end. What would cause this?
View 1 Replies
View Related
Sep 19, 2013
I have a database where I have a number from a client. We copy/paste it from a pdf file. The number has dots in it (1.00.00.000). I would like to create a solution that when I paste the number in the field and go to the next field, it will take out the dots from the number.
View 3 Replies
View Related
Nov 5, 2013
I have a form where I combine several fields in 1 textbox. At the end there is an amount. It should look like below:
The total cost of the products is EUR 29.342,45
I have the following formula in the textbox:
Code : =" The total cost of the products " & [Currency] & " " & [TotalPrice]
It would be great if the TotalPrice could be with the dots and coma in the correct way.
I tried to format it, but it was giving me nothing, the numbers stayed the same.
View 7 Replies
View Related
Sep 14, 2005
I need help! I've set up a database with a subform that worked until recently. I get an error message that says: The LinkMasterFields property setting has produced this error:'Invalid outside procedure'
I had added a date and time stamp for when something gets modified it changes the date/time. I even backtracked and took all that out from tables, forms, queries etc. but the error keeps appearing when I'm trying to update my subform.
Thanks,
supan
View 1 Replies
View Related
Feb 14, 2014
I have a small problem with the following command:
Code:
sTabNam = "TmpTab"
sFilNam = "C:Data.Txt"
DoCmd.TransferText TransferType:=acLinkDelim, TableName:=sTmpTab, FileName:=sFilNam, HasFieldNames:=True
The file C:Data.Txt contains 5 columns, separated by a semicolon with the first line containing the names of the columns. The concern is that when the linked table is created, I get a single column with all fields concatenated value. the following style :
Col1;Col2;Col3; : Column name
Val1;Val2;Val3; : Row value
What does do to have columns separated with the corresponding values?
View 3 Replies
View Related
Dec 24, 2005
Hi There
i am trying to link some more tables to my access front end from the sql server back end
when i select 'ODBC Databases' from the link pop up box, the pop up box just closes
any ideas why, or work arounds would be appreciated
Happy Christmas
View 4 Replies
View Related
Jun 20, 2006
Does anyone know how to link tables automatically/VBA?
I'm trying to import files from our DB2 database in which one file is created monthly and instead of manually importing / linking the files manually, I'm looking to have access link to the new file automatically.
The file names are structured as so..
ITM01 (Jan)
ITM02 (Feb)
ITM03 (March)
Thanks
View 5 Replies
View Related
Mar 3, 2007
Hi All
I enter data in a form "WIP" that is based on a table named "WIP" in the form I have a command button. When I activate the command button it takes me into another form "Materials" which is based on a table named "Materials".
The data that I enter into "Materials" is not linked to the data ie Customer details which I have entered into "WIP".
My aim is to be able to report the materials used.
I have tried variations of relationships but am obviously missing something.
Thanks in Advance
Geoffk
View 2 Replies
View Related
Oct 12, 2005
I have a database with software
ID: autonumber
Name: text
Version: text (some say Beta etc)
Possibly 200 pieces of software
I have a database of computers
ID: autonumber
RoomName: text
ComputerName: text
Description: text
I want to link them so a computer can have up to 200 pieces of software in it or just one piece.
I dont want a table with 200 boolean fields although thats how i will end up doing it if i cant any other way.
Chances are each computer will have about 20 - 30 bits of software installed and therefore the table shouldnt need to be huge.
Anyone have any ideas how i can link these and keep the second table small. Surely i can say Computer [2] has software installed [2, 4, 5, 28, 224] but i dont know how to.
Thanks
.matt
View 3 Replies
View Related
Mar 21, 2006
I have a spilt database and both ends sit on a server. The front end has a short cut on the desktop from five machines.
On one machine I can access the backend but it i try and relink the tables, the linked table manager is empty and i cannot and the "always prompt for new location" option is not available so i cannot even do it individually that way.
Any suggestions of why this would be? Is it a security user issue (though i haven't specifically set up any user or workgroup securities)
I have even tried holding down the Shift key and that doesn't work!!
Thanks
View 1 Replies
View Related
Apr 21, 2006
Is it possible to unlink and link to tables in a back end using VBA in the front end?
I need to do this or something similar because when I send updates of the front end out I may have added an extra table and thus want to be able to get the user to run an update module to link any new tables.
Not sure if this is at all possible???
Any ideas???
View 5 Replies
View Related
May 29, 2006
Anyone can help me how to link fields in different tables. Im creating a databse that has an ID. and that ID will be same with the ID on the other table.
Table 1
ID = 123
Table 2
ID = link to (Table 1 ID) and when i input characters on the Table 1 ID field it will appear or inputed also at Table 2 ID field.
Hope some ideas. Thanks
Michael
View 1 Replies
View Related
Nov 9, 2004
Is it possible to retrieve table information from an external Access db. Then append chosen tables to the current access db by linking them?
View 8 Replies
View Related
