Imported Query Not Functional
Aug 19, 2004
I am new to Access and I think there is a simple answer to this question, but I am lost.
I have several access databases that are the same, i.e forms,tables, but have different data in the tables.
I created a query in one and was planning to import into all the others. However, after importing the query to another database it did not run, i.e I could see the field names but no data showed. The field names and tables are the same in the import database as the export one. However, neither database has relationship, joins(relationships) are created within the query.
Can anyone please tell me why this query will not run when imported, I would hate to recreate it for every database I have to work with for this project.
Thank you
View Replies
ADVERTISEMENT
Nov 14, 2004
Hi,
I am a newbie at Access and am basically designing my first database. This database is for a short term project and is designed to track the attendance of employees at acompany. Here is a brief description of the tables and forms in question.
EmployeeInformation - this table stores records of each employee, their ID, DOB and SIN.
AttendanceProfile- this table stores records of prolonged absence periods for each employee. A given employee can have many attendance profiles, meaning that this table is linked to the EmployeeInformation table via a one-many relationship. This table will provide detailed information about the status and history of each Profile. So for example if an employee misses work for 12 days due to an appendicitis operation, the exact nature and dates of this absence would be listed as a new profile. The primary key for this table is an autonumber field called ProfileID
ActionLog - this table stores the actions taken by company employees (if any) in response to each AttendanceProfile. It is connected to the profiles table via a one-one relationship with ProfileID being the foreign key in this table. Another main field is the ProcedureNum field which will list the number of each procedure taken for a given ActionLog record. This table is needed to track what the company has done/is doing to track an employees prolonged absence.
Allow me to illustrate with an example. An employee, John Doe misses 15 days in June 2001 due to an illness in the family. An AttendanceProfile record is then made for this period illustrating the exact nature of Mr. Doe's absence as well as tracking what official documents he has submitted (eg medical note, official company documents). Another matching record containing the same ProfileID is also made in the ActionLog table describing what the company has done so far to track this absence. So if an HR employee calls Mr Doe's physician to verify this illness or sends a letter requiring further documentation, each of these steps is listed in this log for this absence profile.
Sorry for the long-winded explanation, but better now than to have to clarify myself later. Here is where I'm stuck. I would like to set up two data entry forms, to create new AttendanceProfile records and related ActionLog records. Obviously, these corresponding records are linked directly by the ProfileID field. After completing the AttendanceProfile form, I would like the user to be able to click a command button to open another form (I am avoiding a subform in this case because my attendanceProfile form is huge and I cannot conveniantly fit a subform on it) to open a new form where they can enter Procedure descriptions and dates on the ACtion log. For each new procedure the user enters, an autonumber fields automatically increments the procedureNumber for that specific ProfileID.
Finally, my question to any of you is, assuming that I have already designed the AttendanceProfile table and form, how shall I design the ActionLog table AND forms to accomplish this exact task.
Once again, sorry for the excessive detail. Your assistance is greatlys appreciated.
Regards,
Mike J.
View 1 Replies
View Related
May 2, 2014
tell me that can we use functional keys F1, F2,F3,,,,,,,,,,,,,,F12 in ms access to perform commands like saving a form data , for closing form refreshing form, clear form.Or is there any way to make shortcut keys combination like[(ctrl+s)(ctrl+c) (ctrl+A)] in access to perform action like saving,closing,clearing, current form.
View 1 Replies
View Related
Jan 10, 2008
Hi all,
I have the following issue:
In my job we work with several raw data .txt files exported from Oracle ERP system. These data include information about: inventory, sales, backorders, purchase orders, forecasts, product line.
My goal is to put information from all of these imported txt files together to create an easy to use snapshot file.
The common field between al of these files is the item description. I have an issue where records are repeated for several fields every time the same item description is showed. For example for the same product description the january sales forecast QTY is repeated on several rows because there are several orders for this product description. Is there a way to make forecast QTY appear only once but keep the multiple orders and their information?
Example of current result
http://img178.imageshack.us/img178/5659/currentsu7.th.png (http://img178.imageshack.us/my.php?image=currentsu7.png)
to achieve result
http://img179.imageshack.us/img179/5100/toachievefk4.th.png (http://img179.imageshack.us/my.php?image=toachievefk4.png)
thank you for any comments
View 4 Replies
View Related
Jul 22, 2015
I need to import an excel file with incorrectly formatted date field and it worked only to import them as text:
1 jan 2015
1 feb 2015
1 mar 2015
etc.
Using CVdate converts jan, feb, nov and dec to correct date, but gives an error message with mar to oct.
View 1 Replies
View Related
Apr 17, 2007
We are in the process of converting from dBase to Access. We have successfully imported one of our data files into Access. When we go in and try to change the field sizes we keep getting an error that there is not enough disk space or memory. Is there a general rule when doing this? We have tried decreasing the amount of records and continue to get the error. When we originally imported the file we did not set a field size limitation so all the text fields in the structure came in at a size of 255. We are trying to change them to their proper size.
If a database is 20MB how much memory or space is required to make changes such as this? The original file contains over 300,000 records.
Any help or direction would be greatly appreciated.
Heather
View 9 Replies
View Related
May 16, 2013
I have a vba code that builds a SQL String, opens a connection to SQL server and imports the contents of a SQL View into an Access table. Everything works fine, except one column "primary_account" where I store 1 and 0 for True and False. In Access 1 shows up as -1.
View 2 Replies
View Related
Apr 17, 2006
I have impotred a table of my MP3 music collection from Excel in to Access.
The Fields it contains are: "Artist" - "Album" - "Track Name" - "Track No." - & "Duration"
I would like an option to be able to list only the Artist & Albums - However, when I try I end up with a list of duplicate values for the Album field (as these relate to track 1, track 2, track , etc...)
I'm sure there's a simple solution..
Can anyone please help....
Thanks,
Alun Kane
View 2 Replies
View Related
Nov 9, 2006
Hi,
I have a table in Excel, and when I import the table in Access, some records from a specific field shows #Num! after importing, even before I imported the table, I selected the entire field in Excel and I Formated all cells to text.
The specific field hosts records in digit format[34222256], and sometime in mixed letter-digit format[M22228778], but are supposed to be as TEXT! After importing I see the first as #Num!, and the second as M22228778.
How can I get around this issue in Excel or Access.
Thank you!
View 6 Replies
View Related
Mar 1, 2007
Hi, i have a fox pro memo field that has bill of materials information in like so:EACH KIT COMPRISES
1 CR10070SW £29.60 HALLITE PRODUCT
1 RBS24690 £0.82
1 RBS354 £0.95
2 RBS345 £0.75
1 S95MMEXT £3.90
£36.77 PER KIT
I need to take out the carriage returns but keep the items delimited in some way so they all apear on the one line. These are the child parts for kits so i need to keep them on one line as i import them or via a query so i can see the parent part they belong to.
Many Thanks
View 3 Replies
View Related
Apr 25, 2008
I have imported a worksheet from excel.
I am trying to use query criteria to seach.
the feild I am trying to search was a custom 000-000-000 cell.
I have been trying to use like "001*" but am getting nothing back.
what should I do. Do I need to change the info in excel and start over?
thanks
View 3 Replies
View Related
Mar 19, 2013
I uploaded quite a bit of data from an extensive list of Word Documents. In some of the Memo fields, it imported these weird Squares. Some times at Tabs or Paragraph returns.Is there an Easy way to remove these things?
View 1 Replies
View Related
Feb 5, 2015
My "MainMenuForm" contains a button that imports a specific csv on a specific location.Someone should do this import once per day. The problem is that there is no way for me, once the import has been done, to know which records are "new".There is no unique field that distinguishes the new records from the old ones.
I was thinking of adding like a Date() field to that csv (= the date where it was imported). Can this be done automatically? So if I import a file today, the final column would be 05/02/2015If i import a new file tomorrow, it would be 06/02/2015.
View 2 Replies
View Related
Apr 1, 2008
Hi
I have imported data from Outlook. The field I am interested in is the
'Subject' Field. This contains 3 effective segments,
1 employee name
2 description
3 job and sub job number
example of text in field is
M.Heywood Completed Job No.1708 8
N.Curry Completed Job No.1477
I wish to move the employee name into another field and also the job and sub
job number. I have tried the following Right() Function but it is not quite
working as I want
Right$([Subject],InStr([Subject],"Completed Job No.")-1)
For the records above the results are as follows
No.1708 8
No.1477
What I really want is to only get the text after the .
Any help please as this is my first time with this function
Thanks
Richard
View 1 Replies
View Related
Aug 22, 2006
Hello there,
In Table A I have a field called Pin Number.
I set an input mask for this field, Pin Number.
Now I have imported a huge number of records into Table B from Excel which also contains Pin Numbers.
I need to link all fields with Pin Numbers, so my question is:
How can I change newly imported data fields to conform to a previous input mask?
many huge thanks, :)
View 2 Replies
View Related
Oct 2, 2007
Hi,
Does anyone know how I can get the imported table PATHS in VB code and current database path?
Thanx :confused:
View 9 Replies
View Related
Sep 2, 2004
I have an imported table that I created a form for (containing 400+ entries). I created a subform on it for a new table that I will be entering information to tie in with the imported form.
However, when I try to create a report, the report won't acknowledge any of the information. It's all outlined in the SQL, but nothing appears.
I did discover, though, that if I create a new entry on the imported table, that information appears on the report, but nothing for the existing data that was imported.
Please help!!!!!
View 1 Replies
View Related
Jun 3, 2015
I am importing about 1.5 million records from a .txt file into an Access database. I have the code that splits the records and adds them to the database. However, the database has a 'specialty' table that lists certain specialty codes. The incoming record has a field that is a specialty code. Any way to search the 'specialty' table for the code that is coming in on the record to be added, and then, if the record 'code' is not found, skip it, and if it is found, add it to the database. There are about 70 codes in the 'specialty' table.
View 9 Replies
View Related
Jan 6, 2014
I need to import a text file into access 10, the problem is as i understand it access has a db limit of 255 columns.
The text file is delimited by | symbols. As i tried to import, it shows me to have 267 columns and all the columns are unique and needs to be used for my work.
View 1 Replies
View Related
Oct 1, 2015
Am trying to import data into a blank database (MS access 2013). The import operation is successful. But the data in the tables gets deleted after a while. And all I can see are blank tables in Access 2013.
View 2 Replies
View Related
Jun 14, 2013
I am Extracting that data into an excel document from the fillable PDF and importing into Access.... NOW. Here is what I am trying to figure out. I have to alert the field of major changes, SO I am wanting Access to compare the document I imported last with the one I imported just now. Example. I change my contact information, I need a query to find that the information I submitted last time, is not the same as what I just submitted. My issue is, I cannot get a vision for this database. I can import these documents to a table BUT I cannot compare these line items with line items of the same table...
View 3 Replies
View Related
May 30, 2007
Hello, Could someone advise me how to fix this little problem i have when importing a spreadsheet. My app outputs two columns into a spreadsheet with the following US date formats.The spreadsheet it generates is called dates.xls, and i need to re-arrange all the dates in the spreadsheet to a British date format dd/mm/yyyy and re-save it as dates.xls from a click of a button on my form.I know i can use text to columns in excel to fix this problem, but i want access to do it for me, preferbly in VBA, as in the future i may be working with multiple columns. Thankyou for any suggestions.20070612 2007011220070529 2007031920070530 2007040620070530 2007040620070530 2007040620070530 2007040620070530 2007040620070518 2007040620070525 2007041520070521 2007041920070608 20070430
View 2 Replies
View Related
Mar 16, 2008
I am using DoCmd.TransferText to import a CSV file to a new table.
The problem is some of the fields contain quotation marks which really messes things up for me later on.
Is there some way I can go through the whole table and remove them?
Maybe a Query?
Or VBA?
View 9 Replies
View Related
Jan 12, 2006
I have imported an Excel spreadsheet into an Access database. In Excel, a line break in a cell is entered by ALT+Enter. After importing my spreadsheet, all my line breaks appear as "□" and the text all runs together (no line breaks) in the table. The "□"s are also printed in reports. I need a way to either (1) make the "□"s appear as line breaks (e.g., by changing some Access property) or to convert the "□"s to something that shows as a line break in an the Access table memo field (e.g., CNTRL+Enter). Can anyone tell me how to make this happen?
I've tried to copy/paste the "□" into the Find/Replace dialog, but nothing appears when I paste. I understand the memo field is unicode, but I have not been able to determine what the "□" character actually is. It is not the same as the only similar squared shaped character I find in the Arial character map (U+25A1: White Square). I can copy and paste the "□", if surrounded by some other text, e.g., "xxx□yyy", into a Notepad document and it shows up as "xxx□yyy". Pasting the same into a Word doc and I get
"xxx
yyy" with the line break properly displayed. I can copy and paste just the □ itself in Notepad.
View 5 Replies
View Related
Jun 6, 2007
Hi
I have a table that I am importing from FOXPRO DATABASE. When someone goes into the system and deletes a record, Foxpro does not really delete the records but marks it for deletion. There is no field to query on that I can see in the table, but when I go to Foxpro the record is "marked" for deletion.
Anyway to exclude these records when doing a query or importing the table?
Thanks
View 1 Replies
View Related
Nov 22, 2006
I am trying to find a way to have a date and time stamp applied to records that I am importing from excel. I have not had much luck, and woudl appreciate any help.
View 4 Replies
View Related