Cannot Export, Import, Copy/paste, Rename Table With Data!
Feb 22, 2006
Hello everyone.
I've been in a new position for a new company for less than three weeks, and I need some help.
The Access database that we use has been in operation since 2002, and it has never been Compacted/Repaired (I asked my coworkers and supposed IT people, and they said "what's that?").
After adding *one* new field, I've reached the horrific "error 3190" (max 255 fields).
I've tried all of the following, allowing at least 12 hours for them to run, but I cannot:
export the data to Excel
import the data into a new database
copy/paste the records (because there are 12100+ and the max is 9500, I think; and because of the way the dd/mm/yy converted itself to dd/mm/yyyy)
or rename the table with the data.
In the Contacts database, in the Report Center form are 5 links on the right pointing to some default reports.I have created several more reports, and want to just copy-n-paste those links and then change the 'Tag' so it will point to my new report.Can you not just copy-n-paste a field within the same form?
When I copy data from Outlook or MS Word that contains bullets or other HTML formatted text, into MS Access text control, the HTML tags are displayed in the tables.
The memo field in the table is set to Rich Text and so is the text control on the form.
Below is an example of the data I'm copying from Outlook email:
OK, here is a weird one, at least it seems weird to me. I have a field on a table, or query result, doesn't matter which, and it looks like this:"55264"25468"4562"123etc, etc.Now I need to copy that and paste it into the notepad in Windows. When I do that the pasted data looks like this:"""55264""""25468""""4562""""123"I have looked at it on the clipboard and it also looks like the above. I really need this data to paste to the notepad just like it is stored on the table (with one double quote only). It's one of those strange sounding things, please do not ask me to explain why...I just need it like that.Why the heck does the extra quote get added to the front and one get placed on the end?Test it yourself and see.Thanks
I am trying to copy a table and paste as another name. I do this all the time with this table as it is a process I have to do. It is giving me a -1524 error. I also tried to export it to another database and it won't allow that either. I get the same error.
I have tried this with other tables and it does fine.
I have an Access database with linked tables from Sybase SQL Anywhere, via an ODBC data source. I have just linked the tables recently, all the data used to be in native Access tables. It is fairly common for members of our team to open these tables in datasheet view, and copy/paste several records to create new records, then edit a few fields on the new records. This used to work fine with native Access tables, but when we try it with the linked tables we either get an ODBC error - "primary key value already exists" or the new records show up with #Deleted.
The root of the problem is this: In the old Access tables, the primary key was an autonumber field, and Access was smart enough to assign new ID's when you copy/pasted records. In the linked table, the primary key is type "Number" in Access, and Access is not smart enough to let Sybase assign new ID's when you copy/paste records in datasheet view. Access is trying to force the existing ID's into the primary key field, and Sybase says "too bad so sad".
Of course, I could just write some quick append queries to copy/paste the data. And in the short term, that's exactly what I will have to do. But is there any way, long term, to allow members of my team to do it the "quick & dirty" way by copy/pasting in datasheet view? I have tried to change the primary key to an autonumber field in design view, but Access doesn't allow that. Is there a way to do it in code, or a way to force Access to allow Sybase to always handle the primary key field?
Does anyone know how to exclude the header information when copying a record from an Access table and pasting it into Excel. When I paste into Excel, it is also pasting the header information from Access which I do not want. I only want the data to be pasted.
I have the following piece of code for importing the .csv files from a selected folder and then renaming them into 'imported & filename' if succesful and 'failed & filename' if import failes for whatever reason (bad formating, etc.).
The problem is that the first time it encounters a 'bad' file after another, instead of going again to the Error handler, the command
gives me the default MS Access error, namely 2391. I would like it to go the the Error_handler again ang follow the course of actions and rename the files into 'failed' and 'imported'.
Here's the code:
Sub ImportActivitate() Dim strFile As String 'Filename's Dim strFileList() As String ' File Array Dim intFile As Integer 'Number of files Dim filename As String, sFullName As String, sFilename As String DoCmd.SetWarnings False
[code]....
Also, how can I make the routine stop cycling through the files after I renamed them all?
I would like to be able to copy a single record in a table and then paste this record a pre-defined number of times 10,20,30 depending on requirements. The reason I need to do this is that I want to set up a number of identical records that can easily be amended into unique records. This will vastly reduce the amount of work and time spent entering records individually.
The only way that I have been able to achieve this is to copy and transfer the master record into Excel, and then copy the row and paste it into a range of cells. Copy the range of cells back from Excel and then paste this range back into the Access table.
This works but is long winded; what I would like to know is is there a simply way of achieving this.
I have a database witch includes a continuous form (named frmExport). It could be very useful for me if i can find a way so to export data from access 2007 and then to import them into a word file.
Please note: The access data will be inserted into word table.
This code is supposed to loop around a directory of photos (named after a project), and then copy a new photos (from another directory) to this folder, numbering them and the logging them in a table tphotos.The first time a copy photos to a new directory the code works fine. And I think I had it working fine before, but now when I copy photos to a pre-existing directory that has already photos, it only overwrites the first photo, instead looking for the last photo and attributing the new photo number n+1.
I've done debug.print in the code, and it looks like is not going into If NewFileName = f1.Name, therefore doesn't compare the newfilename with the files in the folder.
Code: Private Sub cmdAddPhoto_Click() Dim fs, f, f1, fc, s Dim fDial As FileDialog Dim SourcefileName, destDir, FileExt, NewFileName, prjID As String Dim intSel, FileNumber As Integer Dim varSelFile As Variant Dim rsPhoto As Recordset Dim myDB As Database
1) for exporting an existing table with data to an seperate MDB file (filename to be given by user using a dialogbox) 2) importing the MDB file (from question 1) back into the existing table in the original database. Script does not have to worry for dublicate data.
I am attempting to automate the import of a .csv file from a given directory and copy and append it to another table in a different layout. Below is my code. The error that i'm getting is it can't fine the copyobject in the database...
Option Compare Database Option Explicit Function DoImportandAppend() Dim strPathFile As String Dim strFile As String Dim strPath As String
Hi all, I get information sent to me on email. This information then needs to be transfered onto a database. the information is always the same. name ***** Date of birth **/***** consultant ****** ward BLA ******
Is it possible to copy and paste all the information in one go from the email and paste everything into its correct places on a form with one action? This would save alot of time & effort on the users part.
To speed up my input I copy a record and paste it.
Only trouble is that I have one field in the table that is dependant on the parent table. [The customers email address which I populate with a query/combo box. There could be many, depending who the order was for.]
Q: What function could I use after the paste funtion to ammend that field automatially setting it to 'null'
Q: I looked into WM_PASTE but I'm really struggling!
I have a report (FI_ID) based in a query with the same name.
When i export this report to my desktop i need to manualy rename the filename.
What i need is a way to automatic rename my report to my text field value, called "Seq_Number" (it's a automatic number).At the end i will have 101.pdf, 102.pdf, 103.pdf in my desktop.
I want to disable the user from cutting/copying/pasting the value of a text box. What is the keyAscii of SHIFT as well as CTRL so on the keypress event for that textbox I can simply set it to a null.
I'm trying to make a report where i will have a variable number of charts. My approach is to have one "template" chart, and copy and paste it at runtime, and then alter each new chart's properties (data source, etc) to suit
My question, and i'm sorry if it's basic, is how do i copy and paste my first chart (called "Chart1") as another control named "Chart2"?
I have a textbox on a form that automatically shows the current date. Below that, I have 3 other textboxes for dates (each representing a step in a process). Often, the same date is imputed into each of these boxes. I would like to have an “Autofill” command button that would take the date in the first box and place it in the other three. This is so basic it’s hard. My usual searches turn up nothing. Any suggestions welcome.
I am a database designer for a UK Insurance company and have recently needed to rebuild our complaints database. One of the problems with the previous database was that staff were copying text from an application designed by Pacific Solutions (PACSOL). When the data was pasted into our Complaints database, it was causing some serious issues that made the database crash. This had started to affect people's confidence in our ability through no fault of our own. We then found out that this was due to the character set of PACSOL not being supported by access. What we would like to do in the new database is prevent users from copying and pasting text into the system. Perhaps by displaying an error message when they press CTRL+V or do edit - paste.
CAn i change the name of a field in a a folder from access. or better yet can i automate a file being copyed from one folder to another.
For example, lets say i have a folder named photo. i want access to find all the items that finish with a "f" and copy them into a new folder named "f_Photos"