Computer Support Forum

importing database in access

Question: importing database in access

I'm trying to import a database to an existing database. Both are identical, aside from their WO_NUM field, which distinguishes each record (and is primary key).

I have enough information in the database fields to make the database I want to import match. The problem is that the database is not allowing me to manually enter data. When I try a manual increment of the WO_NUM table, I am getting the following message:

ODBC-call failed.

[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of UNIQUE KEY constraint 'UC_TASKS_WOID_1'. Cannot insert duplicate key in object 'TASKS'.(#2627)[Microsoft][ODBC SQL Server Driver][SQL Server] The statement has been terminated. (#3621)

Any help is appreciated. Thank you.

Relevance 100%
Preferred Solution: importing database in access

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: importing database in access

I'm assuming you are importing the tables, it seems like you are importing the primary key also, that will cause a problem because there will be duplicates.

You can try dumping the table into Excel and strip off the ID column and then import the excel table or Paste it into the table. Access will create new ID's for it.

3 more replies
Relevance 77.9%

I am trying to import photos (.jpg) into an Access database table (via a simple form)so that I can print them out as images in a report. There does not appear to be a straightforward way of doing this as dragging and dropping the image file into the form or the table just results in a .jpg icon being printed in the report. I can't be the first person to have this requirement so I am sure there is a way of doing this. I am using Access97 on a Win2000 OS.Cheers Doug

Answer:Importing jpg images into Access database

Does click here help?

1 more replies
Relevance 77.9%

If I keep a contact database in Access, can I import it into Outlook Express to send emails? If so, how? Im using Windows 98, Office 97 and Outlook Express 6.
 

Answer:Importing contact database from Access to OE

First Export (on file menu) a sample file from OE using "Other Address book", Use TEXT (Comma Seperated Values) which is ".CSV", Excel should be the Default program if not open it with Excel so you can see the layout.

From Access export your table with the contacts and arrange the columns as they are in the exported CSV file (from outlook) It would have been best if your outlook Export has the same fields as those you want to import. The column headings should be named the same.

When done Save As .CSV (MS Dos) file type. Say Yes to Compatibility prompt and NO to save changes on closing the book because it will resave againif you say yes. do this right a way or it gets confusing then reopen it if you want to check it.

It should be ready to import into OE by Importing the Text file just as you exported it. Remember make sure your columns are correct, copy the row headings from the exported address book (OE) to be safe.
Ziggy
 

2 more replies
Relevance 77.08%

I have a client that wants to import the contact information from his Access database into his Outlook. I don't really have much in the way of programming skills, and I'm not quite sure what to do. I know that Outlook will not do this by default. Any suggestions?
 

Answer:Importing Contacts from Access Database to Outlook...

It depends on the Access database. How are you going to get the data out of it? Did the developer make an export function? If not, it would be very simple to make a query that grabs the needed information. That query could be exported as a CSV that Outlook could import.

Outlook 2007 will also grab data directly from Access 97-2003, but it has to be set up properly.
 

3 more replies
Relevance 61.09%

I would like to setup a forum on my home system that is identical to the forum that I am an admin on the web (for testing purposes). The mysql dump is about 56mb, so I can't use phpmyadmin's function to import it to my XP's database.
Usually, I set up an identical forum on another server of mine and use SSH to import the file, mysql -u username -p databsename < dumpname, but I don't know how to do this on my home XP's system
My home's system is using XXAMP for apache and mysql. Does anyone know of a way to get my dump into my mysql database? I tried using the command above, but XP says that mysql is not a command.

Sorry if this is in the wrong forum, wasn't sure if it was an XP or mysql forum category thread.
 

Answer:Importing mysql database in XP

Any one know? I was able to do it by manually splitting the big dumps, but I would like to find a better solution for future use.
 

1 more replies
Relevance 60.27%

i experienced a hard drive failure recently and the tech place that repaired it under warranty saved a bunch of email files, but they were not "backed up" from inside of outlook. (yes i'm an idiot for not having them backed up, but now i have a 500gb external hd, so this will never be a problem again!) when i try to import them into my new email set up, it can't read the file because it's not the right type or doesn't have the right extension. it seems as if i have the raw data, but not in a "back up" file and therefore it can't import. is there still a way to recover the emails?
 

Answer:outlook express database importing

6 more replies
Relevance 59.86%

I am trying to import a delimited text file and can't get the first and last names in the contact field. One or the other but not both. Any help would be appreciated.
 

Answer:ACT Database Importing Delimited Text File

mjam said:


I am trying to import a delimited text file and can't get the first and last names in the contact field. One or the other but not both. Any help would be appreciated.Click to expand...

When importing, you can map to First Name and Last name fields when creating the map... ACT! will then put them together for the Contact field.
 

1 more replies
Relevance 59.86%

This problem is actually for a coworker of mine who has Outlook 2003 and is either using Windows XP Home or Pro (not sure which OS). He had a problem with his hard drive where he had to reformat it, but before he did so, he exported his address book and saved emails into a database file (was done through Outlook 2003). Once he got his computer back up and running, he tried importing those database files back into Outlook without success. The saved emails are extremely important and need to be retrieved and he was wondering what he could do.

He was wondering if any of the following is possible? 1. Importing the outlook database files back into outlook, or 2. Being able to print out the files in notepad, or 3. Being able to retrieve and print (or even convert) the database files using a 3rd party program? I've tried posting this problem on Microsoft's help boards but only got a rude comment and was hoping someone might be able to give some help or at least an explanation why it can't be done. My coworker is very good at the hardware aspect of the computer but not quite as good with every issue when dealing with software.

Any help is greatly appreciated!
 

Answer:Problem with importing database files to Outlook

Into what kind of database file? PST?

Where are the files currently? on hard drive or cd? if on cd, copy the DB over to the computer and try opening the file.

If it's a pst, then from outlook, click on file -> open -> pst and see if it opens that way.
 

3 more replies
Relevance 56.99%

Hi,
I don't support Access, nor have I been trained in it, but I've been asked if I can help in this problem.
An Access database connects externally to a SQLServer database at login time for the application. How do I find which external database they are connecting to? I know that there is a way to go behind the forms to see the source code, but I cant remember how to do this.
I cannot find an obvious User/System file dsn on the PC to give me a clue.
Thanks in advance
 

Answer:Accessing external database from Access database

9 more replies
Relevance 56.99%

Here's the question- how do I open a form in an existing database from another db in Access 2010 using VBA and give it focus. I can open the external db and it's form but cannot figure how to give it focus. I'm trying to create a master form that will call various databases that each have a form. Seems simple, open the master menu, click on a button that then opens the called db and the associated form. Do my business exit the db and am back at the master form. I would be okay to just close the master db, all it has it the main menu or leave it open. Doesn't matter which I just want to open the called db and form and have its focus.
 

More replies
Relevance 56.99%

Hi Guys,

Im trying to write some code that will copy my access database , tables and data to a new sql server database, ive got the code to create the sql database but i need to populate it from my application

Any answers would be grateful

Thanks
Mark
 

Answer:Copy an access database to SQL server database using VB.NET

Google: import access to sql server
 

1 more replies
Relevance 56.99%

I'm building a database application in Visual Basic .NET and I want to know what is the equivalent code of this when I want to make a connection to mysql:

Protected connString As String = _
"Provider = Microsoft.Jet.OLEDB.4.0;" & _
"Data Source = " & loc & "\dbProject.mdb;"

Private cn As OleDb.OleDbConnection = New OleDb.OleDbConnection(connString)

Private ConnectionString As String = connString
 

Answer:Exporting MS Access Database to MySQL Database

You would have to have the MySQL driver for it on the server regardless.
 

1 more replies
Relevance 54.53%

I have MS Access 2000. I initially created a long book list several years ago. I recently found a template from the MS database for books that I downloaded that I like better. I have tried importing the data from the old database to the new one but with no luck. Both are in Access 2000. I am running Win2K.
Thanks
 

Answer:Transfer from Access Database to Access Database

6 more replies
Relevance 51.66%

I am working for a company that has four people (four different computers) entering data into four different Excel 2010 files on a shared drive. I would like to create a master file on my own computer for the purpose of generating reports. How do I create one Access database that includes all of the information from the four different excel files? Also, can this Access file be continuously updated as the four Excel files are updated each day? Thank you!!!
 

Answer:Access 2010 Help Merging 4 Excel Files into One Access Database

9 more replies
Relevance 51.25%

I would like to set up an MS Office Access 2003 or even 2007 file and put it online for my team to enter data into. It seems as if Google Docs, my first idea, does not facilitate MS Access mdb files.Any safe suggestions would be most appreciated.

Answer:Easy online access to a Microsoft Access database

windows live shared folder. give password into to people who can access the DB or they register accounts and allow them to access the folder

2 more replies
Relevance 51.25%

According to what I've read, Access 2010 uses the same database format as Access 2007. So this should mean I can open and run a 2007 database (with a lot of VBA code) in Access 2010 with no trouble, yes?

So why do I have the feeling that something is not going to work? Is it because I have been through to many Access upgrades?

Answer:Any problems using Access 2007 database with Access 2010?

Hi bbinnard,

If you have not purchase Access 2010 yet, what I'd recommend is....download the Trial Version and play around with it for quite a while.

4 more replies
Relevance 51.25%

I have on a Laptop, an Access 2013 program feeding an accdb database. I want to move subject database or a copy of the accdb database to a new PC with Access 2013 installed. Both computers are running on Windows 10. I considered copying the laptop database to my Kingston Data Traveler but I can't even find the directory where the database should be.

The only other thing to add Is that I programmed the record input software using Access 2003 and copied it onto my laptop with Access 2013 installed and which works fine. Later, I saved the MDB database into the Accdb format (Access 7).
'
 

More replies
Relevance 50.02%

Is it possible to convert an Access 2000 database to Access 7.0? I have an old machine that I would like to run a database on but it only has Access 7.0 for WIndows 95.
 

Answer:Convert Access 2000 database to Access 7.0?

6 more replies
Relevance 50.02%

Hi, I installed windows 7 prof, and then I installed ms office 2003. Now I am creating databases. I have never got this messages before when installing ms office 2003 on win wp. When I code and make changes, this message pops up. "You do not have exclusive access to the database as this time. If you proceed to make changes, you may not be able to save them later." how do i get rid of it? Thanks. Deon

Answer:You do not have exclusive access to the database. ms access 2003

I can tell you how to change the setting in Office 2010 (I don't have access to Office 2003, so you'll have to hunt around in OPTIONS):FILE - OPTIONS - CLIENT SETTINGS - ADVANCED - DEFAULT OPEN MODEMake sure it is set to Exclusive and not Shared

1 more replies
Relevance 50.02%

Hi, I installed windows 7 prof, and then I installed ms office 2003. Now I am creating databases. I have never got this messages before when installing ms office 2003 on win wp. When I code and make changes, this message pops up. "You do not have exclusive access to the database as this time. If you proceed to make changes, you may not be able to save them later." how do i get rid of it? Thanks. Deon

Answer:You do not have exclusive access to the database. ms access 2003

I can tell you how to change the setting in Office 2010 (I don't have access to Office 2003, so you'll have to hunt around in OPTIONS):FILE - OPTIONS - CLIENT SETTINGS - ADVANCED - DEFAULT OPEN MODEMake sure it is set to Exclusive and not Shared

5 more replies
Relevance 50.02%

Hello All,
Our company had a photo booth with an F-35 fighter jet at a recent technology show. Individuals were allowed to have there pic taken in front of the aircraft with a pretty model. Now I have over 2500 pictures and over 2500 individuals that need their pic emailed to them. I have an Access database with a name, email address and a picture. Each name has a different image. How can I automatically send each person their picture through Outlook? I would like it to automatically populate a new email with the address and corresponding pic then have it be sent on its way while I am home sleeping. Can this be done? Is there a command that can run a VB script in Access to accomplish this? I thank you profusely in advance.

Scott
 

Answer:Solved: ACCESS: Email pic from Access database

16 more replies
Relevance 50.02%

I have a URL that generates a CSV file from my website, and I want to import it into a table in Access.So far Ive managed to do via Excel as a web query, but would really prefer to do it directly.Help!!

Answer:Importing from web to Access

It doesnt seem as if anyone has any ideas on that.How about if I have a bit of code that saves the CSV file to a certain location, say, C:\My Documents.I could then import it from there, but Im not sure about the 'saving the file' bit.Anyone?

1 more replies
Relevance 50.02%

This is a weird problem. I can't believe it's even happening to me.

I am importing a CSV file into Access. Nothing fancy. Everything goes smoothly. Then I open the resulting table and one of my columns is messed up. It is supposed to contain values from 0 to 1. 1s are okay, but everything else becomes 0.

Here is what my CSV file looks like to begin with:

Code:

"297298","blah","blah",1
"298299","blah","blah",1
"299267","blah","blah",0.639929176512464
"299299","blah","blah",0.749851081872152
"299300","blah","blah",1
"300299","blah","blah",0.612143749751606
"300300","blah","blah",0.77059571596834
"300301","blah","blah",1

Am I missing something here?
 

Answer:importing CSV into Access... huh?

I believe that the import wizard only scans the first row when determining field data types. You have a few options: move the third row to the first row in the CSV file; manually specify the field type in the import wizard (Advanced button), or create the table beforehand and import into that table.
 

2 more replies
Relevance 50.02%

Hi,
I cannot import an Excel '97 file to a table In Access '97.

In the Import dialogue box the "files of type" dropdown list only gives me 2 file types to choose from. They are:

*Microsoft Access(mdb,mdw,mda)
*ODBC Databaes()

I have tried to add additional file types from service packs with no success.

Is there any solution.

Bob.
 

Answer:Importing To Access

is this new, were you able to import before?

i thought it was standard, use that feature all the time (using off2000 now, forget the off97 stuff, but used it in both versions)

perhaps that option wasn't loaded properly the first time, or not ticked off

try putting the cd back in and looking at the repair or add new components (or something similar), also make sure it's checked off to run from the computer not the cd
 

2 more replies
Relevance 49.61%

Hi, I have a spreadsheet that has a calculated field. When I import to access this field gets hardcoded as a number. It's been so long since I've done calcs in access, can I create a calculated field within the table (all data necessary is included in table). Or to calculations have to be done in query's or reports?

Thanks in advance,
 

Answer:importing to access from excel

9 more replies
Relevance 49.61%

I'm making an access front end function

It needs to import pre-existing customer details (names,addresses, etc) into the customer details table.

The problem is is that the preexisting details on excel don't have customer numbers and in my table in access this datapoint is on autonumber, thus access will not import the details, any details

How can i solve this without making the user insert their own customer numbers in excel prior to the import?
 

Answer:Importing spreadsheet to access

Hello again, you are busy.
I am not sure that I fully understand your problem, if the Customer Number in Access is an Autonumber then that is perfect for Importing from Excel.
If the Excel data had the Customer Number you would be in real trouble, because you can't write them to an Autonumber, Access has to create them.
The way that I Import Excel data is to use VBA to Import the data to a Temporary Table.
I then either use VBA, a Query or Queries to put the data in to the relevant Table Fields.
I have already posted a few versions of that method on here.
 

3 more replies
Relevance 49.61%

I receive lots of e-mail messages each day and would like to automate an export that can be imported into Access. The messages will contain data in both columnar and noncolumnar formats and must be parsed into various Access fields. I have worked with macros in both Excel and Access, but haven't really been able to find anything to help me here. Any suggestions you can make will be greatly appreciated.
 

Answer:Access 97: Importing from Outlook 98

6 more replies
Relevance 49.61%

Hello to all experts out there,
I am seriously stuck due to the beauty of Microsoft Access....
I encountered a problem creating tables with sql and then importing data from csv files using TransferText. Everything works fine except for one field, which I defined as text (in the sql create statement) but in which the csv files contain all kinds of alphanumeric strings. The entries which are not purely numeric are simply not imported (the fileds remain empty). I also tried to define that specific field as char and varchar in the sql statement, but the problem was not solved. Does anybody have an idea??
Part of my code is as follows:

Tablename = "Lim" ' varying table names
sqlCreate = "CREATE TABLE " & Tablename & "today" & "(A Long,B Text,C Text,D Text);"
DoCmd.RunSQL sqlCreate
DoCmd.TransferText acImportDelim, , _
Tablename & "today", CSVFileName, True


where my csv file looks something like this:

A; B; C; D;;
1000009; Kat; C1; mcs;;
1000009; Fld; K500;mcs;
1000009; KuGru; 8; mcs;

Problem does not occur while importing other csv files or in other fields of the current csv , besides column C. Though defined as text, only the numeric expressions are imported. So my table looks the almost the same, only that in column C, I get empty entries instead of "C1" and K500" and only the numeric expressions like "8" are imported properly. I am new to VB and SQL so I woul... Read more

Answer:Importing Access Tables using VB / SQL

hmicky said:



......
Problem does not occur while importing other csv files or in other fields of the current csv , besides column C. Though defined as text, only the numeric expressions are imported. So my table looks the almost the same, only that in column C, I get empty entries instead of "C1" and K500" and only the numeric expressions like "8" are imported properly. I am new to VB and SQL so I would appreciate simple suggestions.
Thanks in advanceClick to expand...

Hi,

You can try to put the strings between qoutes.
example:
A; B; C; D;
1000009;"Kat";" C1";" mcs";
1000009;"Fld"; "K500";"mcs";
1000009;"KuGru";" 8";" mcs";

I hope that the tip was usefull
 

5 more replies
Relevance 49.61%

I am developing a data base (Access), I want import a spread sheet that changes daily, How should i get the data and delete old data or replace the data?
 

Answer:importing files, access

The spreadsheet FILE changes daily? Or just the data? If it's just the data, don't "import" the data. Instead, LINK the Excel file as a table.
 

1 more replies
Relevance 49.61%

I am having quite a bit of trouble doing something I thought was simple! The first message I got during the process is "the first row contains some data that can't be used for valid Access field names". What does Access consider valid field names?...the field name it is rejecting is "AMPS AFTER"...I don't see that as an error in naming.
The 2nd "error" message I got was "the connection for viewing your linked Microsoft Excel worksheet was lost". What the heck does that mean?!
Any help would be much appreciated!!
 

More replies
Relevance 49.61%

I know how to do the import itself, but Access is only allowing me to import to a table. I need to import into a Query.

Is this possible?
 

Answer:Importing into Access from Excel

No. Create a macro (I'm 99% sure Access has a wizard to help you) that imports the data into the table, then runs the query.

Let me know if you need more specific help. Also, OBP may have more details for you.
 

3 more replies
Relevance 49.61%

Good morning (my time) all.
I need to build a simple access database (access 2010) I looked at the ready made templates and they don't quite meet my needs as you would expect, some however I have found some form/table that I can use like customer details and others.
In order for me to cheat a little can i pick the various tables and forms already made in other templates and import them into my database? or would i be wasting my time and just build from scratch?

Thanks
 

More replies
Relevance 48.79%

This is so annoying! I moved a batch of 440+ accounts yesterday from a spreadsheet into my database and every name that had the & symbol (Jack & Jill Plumbers) showed up with & instead of just the & (Jack & Jill Plumbers). I understand it's stating it's an ampersand so the html for the ampersand, maybe? Any idea how to make it quit though? I had to tab through the accounts and remove them manually when I noticed them in Access and would like to not do that again. Sometimes the batches I move will be 1500+. That's a lot of tabbing and backspacing!

Answer:Importing Excel to Access - getting 'amp;' after ampersands

Look here and see if it is of any assistance:http://support.microsoft.com/kb/261320MIKEhttp://www.skeptic.com/

17 more replies
Relevance 48.79%

When I import text files into Access, sometimes (roughly 10% of the time) the file records do not import into my table in the same order that they had in the text file. Does anyone else experience this and is there a way to fix this so that the records are in the same order? I am using Access 97.

Thanks.
 

Answer:Importing Text Files in Access

10 more replies
Relevance 48.79%

I'm trying to import an Excel '97 file in an EXISTING table in Access '97. I've got the same number of columns and fields in the spreadsheet and the Access table. It giving me this message after I've completed the import wizard.
'An error occurred trying to import file (filename). The file was not imported.'

It allows me to import the file in a new table. I constantly have to add new records to the existing table.
Can someone please shed some light on this. I just want to know if there's anything that I might have to adjust in my database.

Thanks
 

Answer:Importing Excel file in Access

6 more replies
Relevance 48.79%

I have never used Access before, and am just trying to help a friend out with it.. I started off with data from a .doc file that was all in tables. I converted the tables to text, and formatted them into a tab delimitated plain text file.

This is a exmple of what the raw data I have looks like.. There are 7,555 total lines I am dealing with so manually entering in all this info is not really a option.


Code:

SMITH, FRANK
4130 EAST FAKEAVENUE
SOMECITY, NY 12345 10,000.00 FOR FOOD
ABBEY, CRAIG
12 GRAMERCY PARK
4130 EAST FAKEAVENUE 44,000.00 FOR SOMETHING
LASTNAME, DIANE
12 GRAMERCY PARK
SOMECITY, NY 12345 30,000.00 FOR CANDY
SMITH, SHERRIE
4130 EAST FAKEAVENUE
SOMECITY, NY 12345 10,000.00 FOR GUM


I am able to import the data into Access, however it is not displaying it like I want it to. What I want is to basically combine the 3 rows of information into one.. For example have the name, address, city, state, zip, amount of money, and what it was for all in one row. When I import it is creating a row for each line(not that there is anything wrong with that technically its just not what I want in this situation.).

This is what I would like each row to look like..


Code:

SMITH, FRANK
4130 EAST FAKEAVENUE
SOMECITY, NY 12345 10,000.00 FOR FOOD


Code:

ABBEY, CRAIG
12 GRAMERCY PARK
4130 EAST FAKEAVENUE 44,000.00 FOR SOMETHING


Code:

LASTNAME, DIANE
12 GRAMERCY PARK
SOMECITY, NY 12345 30,000.00 FOR CANDY

etc...

And not... Read more

More replies
Relevance 48.79%

Is it true there are limitations to the size of Excel spreadsheet I can input directly into Access.
My excel spreadsheet is 350 columns, and 575 rows. But access won't accept it.

Any ideas for me?

thanks
Penny
 

More replies
Relevance 48.79%

Hi allI have imported a word document in to a form so it shows up as an icon.This was done from design view of the form. Insert - object. Then selecting, "create from file", and selecting my specific word document to import into the database. My problem is now thast I don't now how to make a command button or a link to this now imported word file. At the moment, the file is just sat in the form but i have no way of opening.ANy help would be greatly appreciated.

Answer:Opening an OLE object in access after importing

All sorted

1 more replies
Relevance 48.79%

If I keep a contact database in Access, can I import it into Outlook Express to send emails? If so, how? Im using Windows 98, Office 97 and Outlook Express 6.

Thanks in advance.
 

Answer:Importing from Access to Outlook Express

You can export the database table to a text file by clicking FILE --> EXPORT in Access. After choosing the save name, save location and changing save type to .txt, the text export wizard will allow you to define how the fields are delimited. When prompted, export the fields as delimited and using commas as the delimiter. Once you have exported the table to a Text file you can import it into Outlook Express by choosing FILE --> IMPORT--> OTHER ADDRESS BOOK --> TEXT FILE. Then just follow the wizard steps to map the fields in the text file to the fields in your address book.

Rollin
 

1 more replies
Relevance 48.79%

I thought i used to be able to import a spreadsheet into an access database and be able to select which row it starts from - all the import and link seem to want to start @ row1.

any ideas, how to start from row12
 

Answer:Solved: importing Excel into Access

7 more replies
Relevance 48.79%

I'm having a problem trying to import an Excel spreadsheet into Access. It's a huge spreadsheet, with names and addresses. It's 7350 entries long. The categories are Name, Address1, Address2, City, State, and Zip. I only have trouble with the Zip column. I get errors regarding the data type of the cells. All info is imported to the table, except for the zip field form roughly 1/4 of the records....and it's always the same ones. I'm tried changing the data type (Format Cells) in Excel. I've tried number, text, special (zip codes), and nothing seems to work. When I go through the import wizard in Access, each field is listed as text, except for the zip field. Regardless of how it's set in Excel, it always shows up as "double". Am I missing something here?
 

Answer:Access 2003 Importing from Excel Help

Have you tried inserting a dummy record into your spreadsheet, and filling the zip field with letters instead of a valid zip?
 

4 more replies
Relevance 48.38%

Hello everyone.

When I import data from an Access DB into excel format, the numbers field doesnt work so I cant for instance do a sum for total number of hours spent on a job.

I can use the tick on seperate cells which enters the data to number, but this would take far too long. I have also tried to right click on the collum header and format cells to numbers but this also doesnt work.

So my question is this. Is there an easy way to reformat the cell data to number, or for excel to do this automatically on import?

Thank you
 

More replies
Relevance 48.38%

I have additional questions related to posting techguy.org/1044936. I am using Word and Access 2010, however the Word files are in .DOC format. Using code and comments found on various websites, I am able to import data from Word into an Access table. I am using bookmarked legacy form fields in Word, matching the fields in the Access table. However, I can only import from one Word document at a time and the complete name of the file has to be entered into a message box. It would be easier if there is a way to import all Word documents in a folder. Anyone know if that's possible, and how to change the code?

If not, any suggestions how I might import the data and link it to another table? Currently, all of the data is imported into one table (Quarter1) with a one-to-one relationship to another table (Organization). For now, since the number of records to be imported is small, I manually enter the primary key from the Organization table into the Quarter1 table. I thought I could have a drop-down list display to choose the organization (thus creating the foreign key), but have not been successful yet. I've tried importing to a query, but that hasn't worked either.

Thanks for any suggestions.

The references I am using are listed below. Posting 1044936 also suggested Microsoft Visual basic for Applications Extensibility 5.3 and Microsoft Active X Data Objects 6.0 Library, but I could not find them.
Visual Basic for Applications
Microsoft Access 14.0 Object Libra... Read more

Answer:more questions on importing data into Access from Word

I would input all the document "Paths" to a table and use that table to then open them.
I would think that you would need some kind of check when opening the word docs to ensure that they haven't been imported before, maybe a date?
How do you know which Organization ID to use?
 

3 more replies
Relevance 48.38%

Importing Excel 2000 speadsheet (8655kb) into Access 2000. An error occurred trying to import file. File was not imported. Click OK. Had open blank access database and tried to import and received this message. I tried saving the excel file as a dbf III and then open the dbf file and received this error: Unexpected error from external database drive (10019). I have also tried insert, table, new table, import. I am trying to covert our excel speadsheet into an Access database. It is harder then I thought. Thanks for your help.
 

Answer:Access 2000: Error Importing from Excel

Try this.

http://databases.about.com/library/weekly/aa123100a.htm?once=true&
 

2 more replies
Relevance 48.38%

Hi,

I have been searching for a while about importing text files automatically into my database.

I was thinking of having a hidden form with code attached the looks in a folder on a network drive and to make it more difficult i need it to look every 5 seconds.

So when my external program exports the files to Y:\Dispatch\Export\100045.out access will pick it up and import the data to my access table

I hope this can be done and someone can help me.

Thank you
 

Answer:Importing text files automatically into ms access

16 more replies
Relevance 48.38%

Hi All,

I need to design a form where by clicking Command Button, it should open Excel Spradesheet saved on (e.g. c:\abc\test.xls) and should select each row from the spradesheet and insert / update (depending the record exist in the table) the record in the table.

If any one has done similer stuff before do let me know.

Thanks in advance,

VVS
 

Answer:Importing Excel Sheet to Access Table through VBA ?

Although importing Excel sheets has it's issues (mostly numeric fields that have alpha characters), there are several ways you can accomplish this.

If you're doing it frequently, I'd just link the database to the spreadsheet. That way it's imported whenever you reference it. It's always there (assuming someone doesn't change the name or the column references). To link to the spreadsheet just click on File, Get External Data, Link Tables; then change the 'Files of Type' at the bottom of the dialog box to Microsoft Excel .xls and select your file. That's about it, you can reference it as a table. Note: I don't recommend updating that table from access, however. If you have hidden columns or rows, the results can be amusing.

Another option would be to use a macro. You can reference the macro in a button. The macro action command you're looking for is TransferSpreadsheet.
 

2 more replies
Relevance 48.38%

Hi all

I am frequently asked to make minor changes to one or more reports in my customer's database.

When I do this, because he is non-technical, rather than me have to travel to see him and do the import from my "Update Patch" to create the new version on his machine, I have been wondering if I could create a DB simply holding the updated or new reports (etc) Then I might create VB in my customer's DB under a Utilities area to:

- Import all of the reports from this "Update Patch" MDB file
- Delete all of the original reports that are being replaced
- Rename the imports (remove the "1")

Of course this might also apply to updated forms and queries.

Has anyone done this reliably and is prepared to share their code and wisdom please?

I'm looking for ideas or inspiration!

Thanks

Chris
 

Answer:Access 2003: Importing new or updated reports

6 more replies
Relevance 48.38%

I have done this many times before with no problem but in testing 20 Excel files and only getting 15 to import, question is why. Get error message that Excel cannot import the file .."error occured: (unspecified). Tried importing as a named range - no luck. Import as link works OK but that is not what is desired and an error table (nothing in it in particular), is also created.
I have checked the data in my students' spreadsheets and they all look perfectly fine.
Ideas?...Thanks

Jim
 

Answer:Solved: Problem importing Excel into Access

what is different about the 5 that won't import? do any of the first rows begin with text when in the others they don't? Are there blank rows? Importing can be very tempermental, visually it may look like numbers but they may be Text datatype. check your datatypes, Eg create a new table by importing one of the 5, and then compare the datatypes to see what is different. Then make changes accordingly.
 

3 more replies
Relevance 48.38%

I'm having a little trouble with creating VBA code to import csv files. I get a new csv every day to import into an existing table in my access database, and I wish to create a code that will import the specific file for a day with the press of a button on a form.

All the files have a similar name: YYYYMMDDHHNNSS_TimeDetailYYYYMMDDb.csv. The way that I wish to search for the file to import is by typing a date into a textbox on the form and searching for a matching date for the YYYYMMDD portion of the file. I've tried a few different codes, but I keep getting a message saying "This file cannot be found. Please check the name and try again". It's strange because I can import it just fine when using the manual access option.

Is there any advice that you can give me?
 

Answer:Importing csv daily files into access 2007

I suggest to import a file with the simplest name, for example, 1.csv. In case of success, the next step is obvious.
Good luck,
Chereda
 

3 more replies
Relevance 48.38%

I have an Access 2003 form in which there is a bound object box. I set the Source Doc property on form open to import an Excel line/bar chart form an Excel file into the bound object box. It works fine, with one exception: when Access imports the Excel chart into the bound object box, there is a considerable amount of white space between the right edge of the chart and the right edge of the bounding box. Is there a way for me to eliminate this extra white space. I've saved this chart as a picture and copied it to a Work document and to a Powerpoint slide without this problem.
 

Answer:Access 2003 Importing Excel Graphs

If it is an Image, you could use an Image Control from the Toolbox and set the Size Mode to Zoom.
You can also "Embed" a Graph in the form by using a Bound object.
 

1 more replies
Relevance 48.38%

Hi guys,

I am looking for a bit of help. I am unable to import an Excel worksheet into an existing Access table that already has a set template. I am pretty sure that I have the right formatting, however, when I import the file, it leaves a message saying "An error occurred trying to import file 'xxxxx.xls'. The file was not imported". This does not tell me why I was unable to import it, but simply that I can't. If anybody could possibly fix this, it would be greatly appreciated.

I am importing sheet 1, of 'Invoice Import File.xls' into the Invoice table of the 'IQB' database.

Thanks,

Matt
 

Answer:Error importing Excel worksheet into Access

Sorry, I can't seem to attach the files corresponding to problem.
 

1 more replies
Relevance 48.38%

I have a flat file that I need to import.
I have set up the specs to tell it what column begins each field etc.
Click OK - it seems to like it - I can see my information previewed but when I click finish to complete the import

"The Micorosoft Access database engine could not find the object {my file name}. Make sure the object exists and that you spell its name and path name correctly. If '{filename}' is not a local object, check your network connection or contact the server administrator"

The file is sitting on my desktop - and not corrupt (able to open in notepad no issues)

Not sure what is going on.
 

More replies
Relevance 48.38%

Hi there,

I have two databases that are exactly the same, but one is more up to date than the other. I would like to import one of the tables from DB1 and combine it with the same table in DB2, getting rid of duplicates.

I have tried using the 'Get external data - import' option which imports the data but places it in a seperate table.

I have also tried copy and paste but no joy there either.

Any help would be much apreciated. thank you.
 

Answer:Access 2000 - importing data problem

6 more replies
Relevance 48.38%

I have an unusual requirement, which I hope someone can help me with.

My table has 9 fields, of which the1st 3 (a text, a number, & a date) are key items.
The tables design contain these keys to ensure that duplicates cannot be posted when users are using a Form for data entry.

Each month, I will be receiving excel files from remote locations,
which have been produced by exports from similar tables.
I want to import these excel files into my table, overwriting any existing data.
Because of the keys, I can only do this by first deleting the existing data.
But is there a way to bye-pass this deleting stage ?
If I try to import without first deleting the existing data, I get this message :

Microsoft Office Access was unable to append all the data to the table.
The contents of fields in 0 records were deleted,
and 2 records were lost due to key violations.

So establishing keys not only prevents duplicates at data entry,
but also prevents overwriting during imports.

I fully understand why this is, but, for my specific purpose, I am looking for a fix.

Hope someone can help !!
 

Answer:Importing to an Access table with Primary Keys

Unless the 2nd and 3rd keys in your table are foreign, you shouldn't really need any more than one key as primary in your table.

As for deleting data, you could always write a delete query.
 

2 more replies
Relevance 48.38%

Ok I have one more question-a few people have other versions of Access in my program and need to use the database that I created in Access 97. A few people tried and couldn't open it. Is there an easy way to converting this so they can use it on their computers? Thanks for the help.
 

Answer:Access 97 database in Access 2000?

Access should prompt them to either open the DB file or convert it to the newer version on startup. If it doesn't you can open the newer version of Access and go to Tools > Database Utilities > Convert Database.
Warning: Everything in your DB may not convert properly so be ready to do some work if this happens.
 

2 more replies
Relevance 48.38%

Hi everybody! I have a problem with my MS Access and can&#8217;t use the wizard for creating database objects (forms, report, table, queries, etc). Whenever I choose Wizard option to create those database objects, I get the following error message:

Microsoft Access can&#8217;t find the wizard, or there is syntax error in the Declaration section of a Visual Basic module.​
The wizard you need may be missing from the libraries key of the Microsoft Access section of the Windows Registry.
To make sure that the wizard is in the Windows Registry, run Setup to reinstall Microsoft Access, and the compile all Visual Basic modules in the database.​
I reinstalled the MS Access as instructed in the message, but I don&#8217;t know where to find and compile those Visual Basic modules. I also don&#8217;t know how to get to libraries key of the Microsoft Access section of the Windows Registry.

I tried to reinstall the software by using two different versions of software CDs (MS Office 2000 and XP) and both failed to solve the problem. I also tried unsuccessfully to access Add-Ins feature from the Tools menu in order to add the missing component. Please help me!

ishak
 

Answer:Can't access MS Access database Wizard

Funny I had the same error last night. I ran Setup from the CD (from RUN prompt) checked off the access wizard. Then went and did what I was doing, it still asked to install the feature but it worked that time.

If that does not help the is an MS article, basically, if you are in "Break mode" of a module that could also cause it.

http://support.microsoft.com/kb/208204/en-us
 

2 more replies
Relevance 47.97%

Hi;

Please I need your advice, is it possible to create an automated procedure via Access's Macro or Module to import the tables from Interbase DB to Access 2002. I can import the table manually but I am trying to make an automated import function via Macro or VBA or SQL, that way tables are always updated without user interaction. Please is it possible to implement that?

Thanks very much
 

More replies
Relevance 47.97%

Daily I receive an html email that contains multiple tables in the email
There are two table's whose data I want to import from that email. The only development tool I have is VBA

Importing the data is not the problem. The problem is that the resulting table is in a format that I can't use. I want every record to contain a name, but at the moment there will be a name and five empty fields beneath it for the same column. I want to fill those empty fields with the name above. I'd also like to fill in the same date for all records of a corresponding day for which I'm doing the import. I will be importing the data daily

Can I do that with VBA?
 

Answer:Access: importing data and manipulating resulting table

15 more replies
Relevance 47.97%

Hello Everyone,

I have the iPhone 6 plus. I am using windows 8.1. I am having a problem where after I import my photos-videos I get an access denied error (Image example below) when trying to erase the photos after import.

To get the import started you have to plug in the phone via USB. Then in file explorer you right click the icon and select the importing option. Setup the options etc. and select import. Everything works great up until it starts to erase the files off the device and then I get that error displayed in the image below.


Any fix for this? If not, anybody that can point me in the right direction is greatly appreciated.




Thank you!

Answer:Access Denied error after importing photos from device

Try changing the location where you are saving the photos.

1 more replies
Relevance 47.97%

A friend was trying to show me how to use Access today and she said one thing I could easily do is create an access file with all my addresses in outlook (which I could later use to make forms). I have the addresses exported to CSV but there are businesses (of varying categories - legal related, business related, customer related, etc) and there are individual customers. The businesses, naturally, don't have any names filled in for the first name/last name categories in Outlook, and my friend said she *thinks* this may cause issues when importing to Access because it sorts alphabetically. Will this be a problem? She said I could create multiple versions of contact lists but that sounds a bit complicated (with some businesses falling into multiple categories, for instance) and as she said herself she's a bit rusty and she just thinks it might be a problem, I wanted to check before proceeding either way. Thanks and I hope this isn't too vague!
 

Answer:Solved: Access - importing a CSV file w/blank fields

6 more replies
Relevance 47.97%

Its been about 9 years since I last worked with either access or excel and now im trying to fix a database that seems to have been corrupted.

I had to emergency save data from a dying access database into an excel spreadsheet.

I tried to rebuild the database and import the data from the spreadsheet but wherever there was a line break in an address field, it was replaced by a lovely square symbol. I discovered that in excel this is what happens to data that was word wrapped that is no longer word wrapped. It seems the option to word wrap isnt available when i try to reenter the data into the new access database.

There are 9000 entries so its not possible to go through each one individually to remove the squares...

SO im looking for an expert who can explain so an idiot will understand to help me out with some things.

1) how to remove these squares en-mass without damaging the data or changing its meaning

2) how to set it up so that the data with squares still make sense as an address incase of mail merge or how to resume the word wrap thing in access

3) how to import data into access without datafields being deleted when they dont meet the input rules (even tho theyre set up identically to the database the info came out of) or how to change input rules without losing data.

I'm sure there are loads more things but this is all i can think of for now.

Please help. Its been 9 years since i last had to do this kind of stuff and I cant remember a thing.
 

Answer:Word wrap issues importing from excel to access

Welcome to the forum.

1) Copy the little square then hit "CTRL"+"H" on the keyboard to bring you into Find/Replace. In the Find What: section paste the square ("CTRL"+"V"). In the replace section type in a space. Then click on the "Replace All" button.
2) If those fields have multiple line addresses they should be migrated into separate fields.
3)If you import into a new table it should allow you to import all the fields. The only problem you might have is the field names which Access gets particular about.

Can you post a sample of the data with mock or fake values?
 

3 more replies
Relevance 47.97%

Greetings forum,

I have an Access database main table that I try to update at least monthly with an Excel spreadsheet feed. The spreadsheet formatting is always the same, with occasional additions or deletions of rows...those changes are what I am trying to update the database with. The rows represent personnel and their personal information. People come and go...blah, blah, blah.

The problem is when I run the new reports and save them in Excel. I save them in the same place and rewrite over the old file with the same file name. Then I try to import external data into the Access database using this overwritten file as an append query. It worked the first time I set it up, but when I try to use it again as a saved import, I get an invalid file name for the overwritten file. Microsoft appears to be adding a hidden appendage to the file name when I overwrite the original file.

Has anyone had experience with this problem before?
 

Answer:Solved: Importing Excel spreadsheet into Access problem

I haven't heard of this problem.
Perhaps you could tackle it differently. I normally just import the file to a temporary table (which requires no save import) and then use an Append query to add the records to the table and then a delete query to clear the temporary table.
 

3 more replies
Relevance 47.97%

When I'm importing an Excel spreadsheet into an Access DB the import wizard gives me a dialog box stating that the subscript is out of range. Importing rows is 66 lakhs. we are not able to import at a time that excel file. I'm working with Office 2010
 

More replies
Relevance 47.97%

So I am completely new to VB and coding. As in I understand the logic and understand how to read it, i just cant write it (much like how I am with Spanish, go figure) Anyways, I have a relatively simple project I am working on but it is tough for me because I suck at writing code.

Basically I have a file that is fixed width.

My Issue: dealing with a standard file that contains headers and footers as well

I am assuming I would need to write something that would say open file, etc, etc, then it would state to read in the first line and after that there would be a Do While Not EOF loop but it would need to be NOT EOF +1 because I would need to end the loop at the 2nd to last line so that I can read in the footer as well. I know that I can do this simply by doing an import spec in access but the incoming file will frequently change so I need to do it in VB so that I can modify the columns and add in new data etc. So if someone could basically help me with a simple coding framework, how to first read in the file, how to read in the first line of data, then create the loop, read in the whole line (because I can then write it specifically to my file), and how to do the footer, I know I can do the rest. I am one of those people who works well off of examples so Im just looking for a good blueprint/framework from someone. Your help is greatly appreciated. Thanks.
 

Answer:Importing a Fixed Width Text File into Access using VB

14 more replies
Relevance 47.97%

I know:
A) I am probably doing this wrong. I am certainly doing SOMETHING wrong.
B) There is undoubtedly a faster/easier/better/more reliable (choose one or more) way

So I decided to ask the experts. I have an Access database of woodworking magazines that I am slowly populating. I thought it would be easier to just fill in the information in Excel (I'm pretty experienced with that) and then just import it into the Access table. That way I could kind of quality check the data before I put it in the database. Usually I just do one magazine at a time, save the Excel file and then import it into the Article table in the database (all are attached). Two things go wrong. First, when I import it, I always get an error message saying Access couldn't import the whole table and 0 records were not added. I don't understand that at all, because ALL the records always are added to the table. But, the other problem is that the first column in the Excel file, the magazine title (or at least an abbreviation thereof) is always blank in the Access table. I have to go back and populate it every time.

I have attached a zip file with a pared-down database and a populated Excel file. Can someone look at it and tell me how I can improve this process so I don't get error messages and do get all of the data I put in? Thanks.
View attachment DB Problem.zip
 

Answer:Solved: Problem with Importing Excel Records into Access

10 more replies
Relevance 47.97%

Hi,

I have a real problem!!! I have a text file with no delimiters that I need to import into access 2003. I know the field lengths and end position, but this will need to be done several times a week, and the files are big, so i don't want to have to keep specifying all the field lengths etc

Any ideas?

Cheers
Di
 

Answer:Importing text file (no delimiters) into access 2003

9 more replies
Relevance 47.97%

I am an employer and would like to know something very simple.

I am a member of hotjobs.com as an recruiter and I keep track of the status of resumes in a database.

I can get a list of 10 resumes and cut and paste them into one .txt or .html file but then I have to cut and past first name, last name, etc. into my database. Is there a way to automate this task and save myself some time?

Please let me know...
Mo
 

Answer:Need Help - Pulling Text off of a Resume site and importing it into ACCESS

umm from what i can say, try file-then get external data and import it from the html format, mine as well give it a try.
 

2 more replies
Relevance 47.97%

Using Word2010 and Access2010, I am attempting to build VBA code that will automatically import word form field data directly into my database table.

I have copied code found on the net and modified very slightly.

I am pretty confident I have the word side of the puzzle setup corrrectly.
The Access side using VBA has ben throwing a number of errors.

I have modified the statement in
Code:
[COLOR=black][FONT=verdana]cnn.Open "[/FONT][/COLOR][FONT=Calibri]Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\Users\XXXX\Documents\Testing .accdb;".[/FONT]
That got me a step past not being able to open the word file, assume that is correct. Not sure of the required references, but here is what is curently checked. I suspect there may be a mismatch between my provider statement and the references.

Visual Basic for Applications
Microsoft Access 14.0 Object Library
OLE Automation
Microsoft Office 14.0 Access database engine Object library
Microsoft Word 14.0 Object Library
Microsoft Office 14.0 Object Library
Microsoft Visual basic for Applications Extensibility 5.3
Microsoft Active X Data Objects 6.0 Library
Microsoft Office Runtime 1.0 Type Library
Currently I am getting the error "424: Object required". No luck finding the source of this.

I attach that code below in hope someone has a tip that gets me moving again.

Code:
[/FONT][/COLOR]
[COLOR=black][FONT=verdana]Sub GetWordData()[/FONT][/COLOR]
[COLOR=black][FONT=verdana] Dim strDocName As String
... Read more

Answer:Importing Word form data into Access 2010

I am not familiar with your code, but I do have code that works, however it does require the use of a Word Doc with "Bookmarks" set.
 

2 more replies
Relevance 47.97%

Is there any way to extend the functionality of Lightswitch to interact with an Access .mdb or .accdb file. I have looked all over the place for expanding the functionality of it but all I can find is the same old tale of "With the final version" which it would appear to be a lie. Migration to SQL Server is also not an option. Any thoughts would be accepted with open arms because at this point I have a boss that says fit this square into this triangle and it ain't working. Thanks again.
 

More replies
Relevance 47.97%

I have an email account with Earthlink and used to use Total Access on my old laptop, with Windows XP. Now I have a VAIO laptop with Windows Vista (64 bit).
I want to import my old messages, but I don't see a choice for importing from Total Access. Is there any way to do this? The only choices (of format) on the drop down menu are for Microsoft Exchange, Outlook, Outlook Express 6, and Windows Mail 7. I see nothing for Total Access. Am I out of luck, or can anyone help me with this?

More replies
Relevance 47.56%

I have two separate access database files that I cannot access. when I try to open either one it says unrecognized database format. When I tried to compact and repair, it says the same thing. how can I get back into these databases?
 

More replies
Relevance 47.56%

Hi

I have a MS Access database with forms, reports, queries, switchboard & so on. I would like to move it to a web server... since it is used by multiple users on one network it is getting a bit slow..

Any suggestions for an easy way to do this and keep everything working

Thanks in advance

Ryan

More replies
Relevance 47.56%
Question: Access database

Hi

I have a requirement to allow the user to do a 'compact and repair' from the system I have developed. I have looked at some code online and tried the following:

https://www.experts-exchange.com/viewCodeSnippet.jsp?codeSnippetId=10-28247792-1

but this is failing with the following message

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

Any ideas why this is failing? or is there a better method?

Cheers
Code:
using JRO;
private void CompactDatabase(string Path, string Database, string Password="")
{

string Database2 = Database + "1";
string oldmdbfile = "";
string newmdbfile = "";

if (Password != "")
{
oldmdbfile = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Path + Database + ";Persist Security Info=True;Jet OLEDB:Database Password='" + Password + "';";
newmdbfile = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Path + Database2 + ";Persist Security Info=True;Jet OLEDB:Database Password='" + Password + "';";

}
else
{
oldmdbfile = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Path + Database + ";";
newmdbfile = "Provider=Microsoft.Jet.OLEDB.4.0;Data Sou... Read more

More replies
Relevance 47.56%
Question: Access DataBase

I have an access database, one of the forms I am working with has a subform. I want to be able to print part of the main form, and parts of the suboform. I can do this by inserting the form key number and the subform key number, then it prints what I want. What I am looking for is to be able to be in a clients record and push print and without having to enter anything it prints the fields in the form and the subform that I have in a report. I hope this makes sense. Is there a macro that I can put together to do this?

Thank you in advance for any help. .
Chad
 

Answer:Access DataBase

The simplest way although it may not seem like it, is to do the following:
Create a Join Query that includes both tables/queries (whatever your using), and create Joins on the 2 Key fields (related), this query should then become the control source for you report.
Now in the new query go to the field that contains the data you will be selecting on the form. eg the ID for the Main form

In the criteria row right click and select Build, find your form and find the Id field control name. The syntax will be:

[Forms]![FormName]![ControlName]
Now if you don't already have one, place a button on your form that opens the Report or query, it should only display the records for the selected records.

This called "Filter by Form"
Any problems let me know I or some one else can walk you through, it works I use it all the time.
 

1 more replies
Relevance 47.56%
Question: ACcess Database

I have this access database that I got from another company and I would like to use it but I would have to customize it to fit my needs. Is that possible
 

Answer:ACcess Database

7 more replies
Relevance 47.56%
Question: MS Access database

I am developing an Access database, one of the uses for which will be mail merging letters and mailing labels. The database records all contain an Area field, which contains an area code in the range 1-10. I've created a query which allows the viewing of records for specific areas (i.e. it filters the data so I can see just area 1, just area 2, etc). Instead of having a separate query for each area I put [Area?] in the Criteria for Area on the query design so that a box appears when I run the query into which I can enter the area code I want, click OK, and then that area is displayed. This all works fine.However, when I come to try mail merging, the query is not visible in the list of ones I can select in Word! If I make a query without the [Area?] variable in then it works OK (i.e. if I specify "1" as the area criteria).Can anyone advise what I'm doing wrong?

Answer:MS Access database

Searching around on the internet, I found a solution to this.Within Word, you have to go into Tools > Options > General Tab and select confirm conversion at Open. This, for some reason, displays a different menu when you select the database as the source for the mailmerge, from which you can select a DDE connection which then gives you the full list of tables and queries from Access.

1 more replies
Relevance 47.56%
Question: Access Database

Hi

I have a DB that I did. It works fine except when I click on a cancel button on a text box and then it gives me the error shown below. Im totally lost as to why its doing this. If anyone can help I would appreciate it. Even just pointing me in the right direction. I posted it as a zip file on this site

http://www.geocities.com/jbfen/index

the password is horror (and sorry for subject matter of horror movies)
 

Answer:Access Database

Listen...I looked and can't find anything wrong with it. I recreated the button (find by director), and it appears to work fine...just tells you the macro has been cancelled.

This isn't the first time I've been unable to find something wrong with something in Access...I'm pretty sure it's not uncommon either.
 

3 more replies
Relevance 47.56%
Question: Access database

I am trying to produce an access database for client names and addresses to be entered using a form but I want the establishment address to be automatically completed if the establishment name when entered is in an existing table of names and addresses. I want to store the address in the new client database table and be able to add a new address if the establishment name does not already exist.

I have tried various ways of doing this including dlookup, and on afterevent with no success. It seems a very logical thing to do but I cannot get Access to do it. I would be grateful for any help.

Many thanks
 

More replies
Relevance 47.56%

ok , i finally got a site , with some ex. for loading jpg into ACCESS,

http://members.tripod.com/accdevel/imaging.htm
http://www.lebans.com/loadsavejpeg.htm
ok now without eating any1's head, i have to create a small catalog, with itemcode and pic of the item,both have to be related ,so tha I can search , for itemcode adn get the picture....

now both of above ex. codes are free and can be changed, so any1 cna help me out here,who konws access in advance , modify the scripts above if they can , so taht I am asked for like item code and pic.......

!!!!!!
 

More replies
Relevance 47.56%
Question: access Database

I have a database where I enter part number description, and cost. I also have another database that is updated all the time with this information in it. I would like to be able to link or however you do it. I would like to lets say put in the part number and then when I push enter or tab the description and cost field populates.

any help would be great.
 

Answer:access Database

you can link by selecting the table tab in the DB window and then click NEW followed by selecting Link. Then search for your other database and select the table you want to link to.

You will now have access to all the fields, it is the same as a table now except you may have sharing issues if the table is opened on the source DB.

You can use this linked table just as a regular table to make reports forms, queries etc. so you may not need the table you created with the same information as it is redundant.

So you can make a form with your linked table with a combo to select the product.
=========================================================
I don't know to what degree of detail you want or how much you know so if you need more help just post back.
 

2 more replies
Relevance 47.56%
Question: Access Database

I need help in creating a database that can be searched.

3 Items are needed...

A 2 digit year entry
A 6 digit numerical entry (need to be able to enter less digits)
A 4 digit numerical entry (need to be able to enter less digits)

I need to be able to search the 6 digit number and have it tell me what 4 digit number is associated with it.

I am hoping I am making this clear...

for Access 07 or 03? (the previous version)

TIA

Tom
 

Answer:Access Database

16 more replies
Relevance 47.56%
Question: Access Database

When entering a form..the page normally start with a blank page/form..what code can I use in Macro or Visual Basic..to have the form blank..when entering the form..so that you can just add..new data..instead of having to click on add new data..
 

Answer:Access Database

First, this is really the wrong forum for this question. It should either be in Applications or Development. I only saw this post because I was checking on a post I made here before but I don't usualy visit this forum often.

If you want a form to open ready to take new data, set it's Data Entry property to Yes. (You'll find that property in the Data tab of the forms properties.) If I misunderstood the question, post back and give more details.

Good Luck!

[This message has been edited by YSB (edited 08-10-2000).]
 

2 more replies
Relevance 47.56%
Question: Access Database

I have an issue with an access database. When I print out a report one of my columns only prints out 4 out of the 5 digits. This happens with 2 machines. On other pcs the 5 digits appear in output of the report. I have checked the resolutions of the pcs and they are the same. I cannot figure out why only 4 digits appear out of the 5.

Can anybody help?

thanks
 

Answer:Access Database

It may be the version of True Type Fonts that are involved, can't you just increase the column width slightly.
By the way you getter better responses for Access/Excel questions on the Business Applications Forum.
 

2 more replies
Relevance 47.56%

I have a database for an engineering project that has 3 main tables. These are the ProjectCode, the Area and the Costs
The ProjectCode has multiple Areas and the Areas have multiple Costs. Data entry to the Costs table includes a [ProjectCode], [Area] and an [Amount Aus]

My Area Table has all the area / project code combinations entered as these all have an individual budget figure that needs the costs to compare to

I want my database to be able to sum up the [Amount Aus] in the costs table and update the field [AmountAus] in the Area table, but only for the costs that match the [ProjectCode] and [Area]

Area Table
AutoIDBudgetAusAmountAusAreadDescriptProjectCodeArea4$900,700.00 Crushing1125$1,939,820.00 Process Plant Design 015$1,413,854.67 Milling126$953,957.33 Flotation137$450,176.00 CIL148$356,532.00 Elution / Recovery159$140,000.00 Reagents1610$254,666.67 Plant Services1711$362,757.33 Concentrate Handling1812$1,096,594.67 Village / Camp12026$32,609.33 Village & Camp02013$2,662,938.67 Mining Services12114$0.00 Gold Recovery12215$3,312,594.67 Plant HV Power Distribution12316$449,604.00 Communications12417$584,370.67 Construction Tools / Equip12518$740,558.67 Travel12619$1,270,021.33 Plant Buildings12727$42,493.33 Budget Re-validation02820$0.00 Meetings & Administration12921$1,270,021.33 Roaster14122$0.00 Waste Heat Recovery14228$32,609.33 Waste Heat Recovery04223 Power Station14329$70,852.00 Power Station04324$0.00 Off-Gas14430$30,916.00 Off-Gas044

Cost T... Read more

Answer:Access Database Help

Database

I have attached a word document that shows structure as the tables didn't work on my thread
 

3 more replies
Relevance 47.56%
Question: Access Database

I am using a form to enter data that is updated to table. The problem is that the calculated fields in the Form do not update in the table while everything eles does. Can anyone help please.
 

Answer:Access Database

Generally, calculated data isn't stored in tables. There is no need for it. If you calculate data, you use it in queries or reports . . . when you create a report, you base it on your query, not your table.
 

1 more replies
Relevance 47.56%

We use Accessdata base to keep track of all our orders. All of sudden two days ago, I go to the "main switchboard" and I get a blank order entry form. In that form, there is a small clickable box and when I click on that it says "The expression On Click you entered as the event property setting produced the following error: The expression you entered has a function name that Microsoft Office Access can't find. *** The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]. ***There may have been an error evaluating the function, event or macro."

I have no idea what this means. Please help.

thank you,
renee
 

Answer:Access Database - HELP!!!!

The first thing to try after taking a backup copy of the Database is a "Repair & Compact" of the current one. You should open Accees, not the database and then choose Tools>Database Utilities>Repair & Compact. Choose the current database to repair and Compact and save it under a new name. Open the newly named, repaired database and see if it still has the same problem.
 

1 more replies
Relevance 47.56%

My son is trying to design a booking system for time slots completely in Access as part of a college project. We are having trouble in making the availability of a slot conditional on it not having been booked already.We have designed a booking form which offers timeslots in the form of a combo list box. We are able to apply validation to eliminate multiple bookings, however we would like the booking form to only offer available time slots (and not to display those already booked). Any ideas how this can be achieved please?

Answer:Access database - help please

I don't know if the following link will be any good to you but it seems to cover a similar topicclick here

4 more replies
Relevance 47.56%
Question: Access Database

I am unable to pen my database. It gave me an error message saying it is corrupted. I tried to do repair it but I was unsuccessful.

HELP
 

Answer:Access Database

Don't you have any Back-ups?
Try opening a "new Blank" database and on the Main Menu, File>Get External Data>Import and then point it the corrupted file just to see if it can be opened that way.
If it can then on each set of Controls (tables, queries, forms etc) click selct all and then OK
 

1 more replies
Relevance 47.56%
Question: Access Database

I have this access database that I from another user which I want to customize so that I can use it. The form has about 28 records with a yes or no fields. Now what I need to do is add more records as I have stuff to add that will require the user to ans. with a yes or no answer. My problem is that I am unable to add more questions (lines or record). Is there a way to do that?
 

Answer:Access Database

8 more replies
Relevance 47.56%

i think this is the place to post my questions. hear goes.....

my sup wants me to design a database to log network equipment with their corresponding users. now i plan to do this in m$ access 2003 and have created all the necessary fields so far and customized them to what they ought to be.

question #1 what should i do next??
question #2 give me some ideas please of how to really get this database app going please.
question #3 how do i make it seem like a program for the end user.

please help.
if you got any questions please feel free to ask.

Answer:database in access.

create a form by using wizard

3 more replies