The original file is about 7.5 megs I did the compact and it brought it to about 7.2...I then zipped it and got it to around 2.2 megs... The upload here is 363kb ? Theres no way I can get it that small. Any suggestions ?
I posted it at savefile.com it is 2.23 megs...sorry couldn't make it any smaller...
1. ) I am trying to get the clear button to clear the subform at the same time it clears the listbox, toner box and the paste box...currently it clears everything but the subform... I would also like the subform to show up blank when the program is first run.
2.) How do I base a list box on the query that fills in the subform ? The subform has the ability for the user to input data into the "input" field then it does a calculation and gives the results in the "results" box. I would like a report to be run and able to print when this is completed
The file is accessible at this link just click download. http://www.savefile.com/files/94838
Wow...I know thats a lot to ask but, i'm stuck and can't figure it out... New at this access stuff...
Can someone help me please. I have designed a product management database for a friend. He would like to be able to upload pictures of his products onto his database to be viewd later. So on the products form, I'd like two command buttons (I guess), one to define the file path and another to open that file path.
I have an existing database in access now I need to add records (10000 rows) in this table from excel. When I try to do an import from Excel to Access it gives me an error. Please Help!!
I have converted 6 Excel spreadsheets to one CSV text document distinguished by their sheetnames. Where I am stuck is trying to import that CSV file into 6 separate tables in my Access database. Does anyone have any ideas how to do this using VBA. I am still a newbie at this, so any help would be appreciated.
hello good day. hope im inthe right place. can someone point out to me if there is a way to do a file upload using ms access 2003 and not just stor the file path...thanks
I have an access mdb file and just added a new field to one of the tables.
I also have several spreadsheets with bits of information that I would like to use to update the newly created field for each record.
Not sure what is the best way to approach this. Can I use a query that will look into the spreadsheet and copy the specified cell to the newly created field using an if statement? or
Do I need to get all data into a table and upload as a new table in Access then use query to update the records?
Please keep in mind that I do not wish to append new records, I need to update existing ones.
The above represents my thoughts on how to approach this task, I would appreciate any help.
I must also state that I am totally new to access and would appreciate as much detail as is possible in the response(s).
I have uploaded data from excel to acces and found some data issues in columns in Acess tables.It has '?' mark in some data in the filed.This is mainly becuuse some excel cells got carriage return in the cell. Can I fix this issue strightway in access column without update excel to remove space and carriage returns in there and then upload again.
I am new in database design . I did a database by access 2010 which contain form and tables and i want to split it to backend and frontend and then make then in website
I'm trying to upload a csv file into an Array then add records to a table. I have the following code which gets the information from a csv file which works fine.
Open filePath For Input As #1 Do While Not EOF(1) Line Input #1, MyData
Problems: 1. When i try to load this into an array , it does not return all the information. It will if a smaller amount of data is sought. For example if only 1 months month of data is requested. Is there a maximum data limit that can be parsed into an array with this method?
2. I'm not quite sure how to parse individual lines (records) to update a table in access. I have provided the code that I'm trying to use to accomplish this below. From code below am I doing this correctly?
3. For each record that is created in the database I would like to add a ticker string to the record for later querying. Can this be done and am I on the right track from the supplied code?
Private Sub ImportData(filePath As String, ticker As String) 'On Error GoTo Errorhandler Dim arrData() As String Dim MyData As String Dim i As Integer Dim Db As DAO.Database
I am working on a project where I need to upload selected data from multiple sheets of an excel file. Here is an example of what I want.
1. I want to create a table in Access with around 10 columns 2. Column 1 should be populated with the date field found in A2 cell of sheet 1 of the excel file 3. Column 2-5 should be populated with the columns B2-E200 in sheet 2 of the excel file. 4. Columns 6-7 would be populated based on values from columns 1-2 of the table. Basically Column 6 should be Column 1 date plus 60 days. 5. Column 8-10 would be user generated after the excel is imported and the user should have the ability to attach around 5 files to each row.
I am Oracle Guy & new to Ms-Access. I want to load the data from Ms-Exell into Table in Ms-Access automatically through Procedure / Macros. How to do this process?. Help me, if anyone knows.
I have a excel file and want a button in the sheet which would transfer a certain range of data in a defined excel sheet to an existing access db table. How to do about doing that.
I am working on a project where I need to upload selected data from multiple sheets of an excel file. Here is an example of what I want.
1. I want to create a table in Access with around 10 columns 2. Column 1 should be populated with the date field found in A2 cell of sheet 1 of the excel file 3. Column 2-5 should be populated with the columns B2-E200 in sheet 2 of the excel file. 4. Columns 6-7 would be populated based on values from columns 1-2 of the table. Basically Column 6 should be Column 1 date plus 60 days. 5. Column 8-10 would be user generated after the excel is imported and the user should have the ability to attach around 5 files to each row.
I cannot seem to find a way to upload several rows of data to one column in Access!I have about 9 columns already in the table which have 900 rows each. These include names, numbers, address etc.I was asked to add a column on next to the 9 columns with corresponding User ID such as 0093457FX (Which I really do not want to add manually).Every time I try to upload an excel file the data either goes below the current data from the 9 columns on the new column and does not match the current data set, or it does not show up at all.
I have a user that uploads a spreadsheet weekly. I want to assign a unique id to each record that is the current date plus the start and end date for the data they are loading which would be the week prior plus a counter.
For example: Data from the week of 5/4-5/10 is loaded on 5/12.
Record one would be 050414-051014-1 Record two would be 050414-051014-2 Record three would be 050414-051014-3
and so on. How do I accomplish this in my table design? They will be deleting the prior week data and pasting the new data so the table design will not change.
I work in a school where teachers have to archive their assessments and other documents monthly. Currently they email them to a set email address but I was wondering if it would be possible for me to make something with access whereby they can do this. I'd like to make a form where they selected their name and then attached a file, this file would then be saved in an area I would have assigned that persons name to, does this make sense? I want it to be very simple so just a name section from a dropdown then a file upload section and done.
I have created a file sweeping program in Microsoft Access via VBA in a few modules. The program simply reads certain files in certain directories, and determines if, when, and where to copy those files based on certain user inputs.
One of the features I would like to add would be to upload the files that meet that criteria to a conventional FTP server requiring a username and password. However, the last few days of research all tells me that it is not possible to perform FTP functions in Microsoft Access or in VBA.
I am just wondering if that statement is really true? I figure the worse case is that windows has its own version of FTP.exe that you can execute in a DOS window ... would one be able to perhaps create a command line execution via VBA? Any simple ideas or is it not worth the trouble trying to FTP upload some files via Microsoft Access with VBA?
I would like to create a form that allows me to search for a folder on my desk top, then once located i can transfer that file to a specific location on another drive, Similar to the Browse / upload function you see on many applications.I am using Access 2003. Is this possible??
How to use VBA..... I have set up a simple database to enter data into then upload to a client web portal.
I have a form to enter the data and the table this data goes into has a check box at the end which I want to have ticked/checked/True after I have exported.
I have created a query that shows me all data that is unchecked (not yet exported to an xls)
I have created a simple export macro that sends the query result to an .xls
I want the macro to finish by checking the "export" checkbox once I have done this....
I am using Access 2010 attached is a screen dump of what I have so far....
I am attempting to split my Access Database and will upload the back-end portion to a SharePoint site. No matter what I do, I continue to get a "Not a valid file name" error.
I recently upgraded a DB from 2003 to 2013 and ran into the following problem.
I have a button that opens a file dialog box and allows the user to upload a file to a predetermined location (and store the address as a hyperlink). I borrowed this code from someone else on here and modified it slightly.
In any case, the button still works, but now when it opens it doesn't have an option for "All files" under file types. So I can upload MS Office files, text files, etc., but not PDF files which are by far the most common types my users upload.
Private Sub Command35_Click() Dim dd As Integer Dim fileDump As FileDialog Set fileDump = Application.FileDialog(msoFileDialogOpen) dd = fileDump.Show Dim Yourroute As String Dim yourrouteName Yourroute = fileDump.SelectedItems(1) yourrouteName = StrReverse(Yourroute) yourrouteName = StrReverse(Mid(yourrouteName, 1, InStr(yourrouteName, "") - 1)) FileCopy Yourroute, "us170fp00dataWBO_Tool_RoomDrawings" & yourrouteName Me.Drawing_Link = yourrouteName & " # us170fp00dataWBO_Tool_RoomDrawings" & yourrouteName End Sub
I have created access2K application with 4 clients (forms+query+macro+reports) residing on workstations and database on server. I have created MDE of 3 frontends but unable to do so on one computer. When I goto Tools->Database Utilities->Make MDE File... (Disabled) Its disabled I cannot continue so no error message. Any idea? Prodigy
I have created a query (Weekend) from 2 other querys (BCV & Daily Sales). The BCV & Daily Sales queries work fine but when they are added together I am unable to add new records. I only have 1 line of data that can not be updated. I thought it was a relationship problem and have been and double checked all the relationships but can't see an error. Heres a screen shot if it will help!
I have a data entry form via which I want to add records to a table. However, when I've entered data in the last field, the cursor remains there and the system just beeps. I added a command button on the form to go to a new record but when I click on the button i get the following message:-