I am exporting a table to a text file using a specification. Comma Delimited, no text qualifier. Now, I don't know if this makes a difference but the file is decent size (over 1000 records). The data within each record is exporting fine (about 78 fields) however, I have what is a major problem.
About a third of the way in the exported file are 70 records that have exported 60-70 records too early. Those 70 records are in order themselves but they just somehow jumped the gun(if that makes sense). This is a big problem because this file is going to be uploaded to the mainframe.
Just as an FYI the only VBA I have in my whole database is one pop-up message box. Everything else is run with macros. This one table does not have any primary keys since this is the table the information is oringally imported into and is moved from here. What I want is the information to look like it is in the table.
If anyone has any ideas I would really appreciate it. I'm going nuts and so is my mainframe programmer trying to figure out how we're going to get around this.
You people are great - lots of help. What I need to know now is --- I input information regarding jobs that we do at my company. I have a customer table, employee table vendor table and invoice table - these are connected thru relationships but the job is eventurally closed. What expression or command do I use to move it to a closed table. I have to keep this information somewhere. Thanks!
currently on my db it stores data on various projects, and these projects are sorted by a status of on hold, on going, or finished. What im trying do is move only the projects that are finished but still keeping a record of them so we can view them in the future.
i was thinking maybe i could move the finished projects into another db? but not sure how to do, or is there a better way to achieve this?
Hi :) I am creating a program in VB.NET with an access 2003 database. This program will be in 2 physical locations. This is a program that sells tickets. At the end of the day I need to be able to get that days sales data off the remote location and update the main location with that information. This will be sales totals only. The user will plug in a thumb drive to move the data from one machine to the other. Due to the physical layout and other considerations this is the best option. The only action I want the user to have to do is to place the thumb drive in the USB port and hit the “down load” button. Then on the main location the user should be able to just plug in the thumb drive and hit up load. The database needs to be updated with the data from the remote location. What is the best way to do this? Thanks in advance.
I have a simple database with a form that displays the contents of a table called Products. I want to be able to delete items from Products but these should be move into ProductsArchive table and I will then create a seperate form to view Products that have now been removed but were once currently live if that makes sense?
I would like to write some code that on the form when the user clicks on the delete button it will just move the data relating to that record into the ProductsArchive table.
I have read a couple of threads about what I am trying to do on other forums and I wanted your views please.
Basically I have to Forms, on form one I have a basic quote generator which will output a specific value in a textbox in form one. If that quote is accepted I would like that value to be feed through to a field in form2 which is linked to a table. I have a button "Accept quote", on form one which opens a new record in the table feeind form 2.
When pressing F11 to access the data base window, somehow I have docked it in an awkward position on the screen where as the top of the box containing the minimise, maximise and close button are not visible, how can I drag the data base window to the position I want i.e in the centre of the screen? :confused:
I have a form on my database called frmFloorRun in which a user inputs a line number on the main form, and then in the subform they enter what will be running on that line for that given day.
Everything seems to work beautifully except that when a user clicks on a line other than line 1 and clicks the refresh button, the first item scheduled to run on line 1 will move to whatever line the user is currently on.
To replicate this issue: simply open the database (i have slimmed it down so that only the floor run portion is included).
Open the form [frmFloorRun] observe the first line item on line 1 (that should be what the form opens to by default).
Now click on any other line by selecting it from the dropdown (yes I realize it is a combo box, but even when I remove that combo box and enter a line number manually, the issue persists).
After selecting another line, click refresh and that first line item from line 1 will move to whatever line you have selected. This is a huge issue for our company.
Also, I have included the report that is based on this form. It simply proves that the line item does not just move on the form - it moves in the report too.
The data I have in excel is basically everything about the "site". In access this cant be stored in one table.
What's the best way to move data from excel into access across multiple tables? I was hoping I could create a query and assign the columns from excel to the columns in the query. but I cant see an option for this.
I am treying to move data from an Excel worksheet to Access. My code is below. My program does not like my "Set rs = OpenTable("GL")" line
Option Explicit
Public Const gconConnection = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source='C:usersc156281my documentsPLANPlan New.accdb'" Public rsData As DAO.Recordset Sub PostData() 'TryPostAgain: 'On Error GoTo BadPost
I want to reduce the first column to unique records, and have the second column listed on the same row. (I'm assuming I'll need Access to do it.) Is there a way to produce a table like this?
1 A B 2 A B C
The final result would need to be something I could put back into Excel.
Now what I am trying to get to happen is using a YES/NO box, Say i have a "part" in the parts table when i click the YES/NO box, to have the tick to say it has been sold, I want that line to move to the Sold Parts table. is this even possible?
I have this file that I created from work,(.pdf). I converted it into an excel spreadsheet. I am now trying to move the data around and am having trouble, I have tried to use ACCESS to do this but I cannot figure it out.
Is there any way I can flip the rows with the columns?
I am new to access and all of this and trying to create a database to record livestock (budgerigars) I have put in the reletive informnation for 2 generations but would like to beable to click on a record in forms view and for the grandparents to be automatically inserted. Something like a family tree.
Also I would like to be able to double click on a entry which shows as a parent in a form view, and for the database to go directly to that entry and bring it up onto the form.
I hope someone can help and that I'm making so sense
(anyone know a good book that would help me understand all of this)
Moving to new computer, both under Win XP pro, Access 2003. New computer is MacBook Air running Parallels. Transferred Access database via an external hard drive. Now the data shows up as Read Only. Is there a procedure to run down the cause and make the data accessible?
I used this way to export data to Excel worksheets, and do some formatting on the Excel sheet
Set objXL = CreateObject("Excel.Application") objXL.Application.Workbooks.Add Set objActiveWkb = objXL.Application.ActiveWorkBook ................
It works fine. I have a question. When I run the function, suppose it takes 15 mins to export data because there are many records and calculations. During the 15 mins, if the user open the Excel file, it will break the process of export data to Excel from MS Access. So, how can I prevent the user break the process/prevent the user to open Excel worksheet?
Does anyone know what would cause records in a table to change their sequence? I have a table that I clear out. Then I append a header record. Then I append the detail records. The table always is populated correctly. But sometimes, when exported to a text file, the header ends up down amongst the detail records. What would cause this?
I am new to access application need some help, I have a table with around 100,000 rows and i want to export this to excel in two separate sheets of 50,000 each , i tried applying filter to see if i can pick some unique values was not successfully, pls advise on this how this can be done
Hi all, I would like someone to tell me how to export an access table to excel spreadsheet. this main table has relationships with several other tables when i export the data i get the id# that references the data from that specific table not the actual data that i want, it seems it should be easy to do , but i have struggled with it all week .. would really apprieciate some help
I am new, as you can see this is my first post. I have been reading different posts, but couldn't find a solution to my problem. Actually, I have created a table and around five forms, now each form is connected with that table. I can input the information through those forms into the table, now the only problem is this I want to transfer the information into differnt forms using the combo drop down menu, when the selection will be made it will transfer the information into the other or it will freez it into that form.
for e.g. I have made new, active, deal etc forms, I have made a drop down menu using combo which has these options in it as these are not only the forms name they are processes too. As the new deal comes in, it will be kept into new process for 30 days, after 30 days it should be moved to deal forms automatically, how would that be possible. And I want that to be frozen in that form. Other question is, how is it possible to hide the table from users, that they wont be able to make changes into table. Third question, once the info is inputed into the form no user should be able to delete that or overwrite it. And my last question is in regards to security, how is it possible to keep one user login into the database at one time, so no other user can login into that database or make changes.
I’d like to export ADDRESS field into a cell (or cells) in an Excel spreadsheet based on the DATEkeyed-in a specific cell. There may be numerous addresses for the same date.
Example: Spreadsheet Cell B7 = 6/12/05
Returns from the tblConstDate Access Table into a cell (or cells) in the spreadsheet: 1206 Wisconsin Ave. 1224 Wisconsin Ave. 1313 Wisconsin Ave.
