I'm at the end of a long project that has one last step. I was hoping that someone here would be generous enough to help. I'm pretty much a novice at Access and am sure that my question can be easily answered. So here is the problem.
I have data that is loaded from a PDA to a form in Access. The data can then be viewed in a list box which is great. I also need to be able to save the data from the list box, using a button, as an excel spreadsheet. Is there anyone here that is willing to guide me to a solution?? Thanks in advance -Tom
I have an application at a client site which is split into two mdb files, a front end (forms, queries, etc.) and a backend (tables, data only).I have a query involving multiple tables, which creates an Excel Spreadsheet. Sometime after installing it at client site, it no longer works because the entire contents of the query itself are wiped out -- totally empty. When I open up the query in design mode, it is empty -- no tables, no columns, no select blank, empty.
I am trying to export a table from access to excel. It has a couple of columns with times in and when excel opens it just shows 00/01/1900 for all the values.
Here is my query that creates the table for exporting:
Code: SELECT tblRoadClosuresAdditionalDates.Reference, tblRoadClosuresAdditionalDates.DateOfClosure, CStr(Format([TimeFrom],"Medium Time")) AS TimeFromMod, TimeValue([TimeTo]) AS TimeToMod, tblRoadClosuresAdditionalDates.NumberOfPeople INTO tmpAdditionDates FROM tblRoadClosuresAdditionalDates WHERE (((tblRoadClosuresAdditionalDates.Reference)=[Forms]![frmProgressRoadClosures]![sfrmRoadClosuresAdditionalDates].[Form]![Reference]));
You can see a couple of my attempts to handle this data above.
I am using this code to create my excel table.
Code: DoCmd.OpenQuery "qryRCADditionalDatesFilteredExport" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "tmpAdditionDates", "xxxxxxxxxxxxxx", No
way to handle this field so that I get just the time in the medium time format appearing in the excel table.
I have a combo box with different department names in it I have a button in a form called cmdShowDept the caption "Show only one Department"
When I open the form I have the combo box set to not be visible When the Show only one Department command button is pressed I want the following to happen; The Department combo box should appear The button's text should change to "Show all Departments" in red If the button is clicked when the text is red then: the original button text should return in Black the department combo should disappear
After clicking on the button and you click one of the specific departments ie accounting I want it to show only the accounting records in the form.
I'm still learning about access, so thanks for any help anyone can give me pleeeese!!
I'm using Access 2010's DoCmd.OutputTo in VBA to export reports to PDF. The "look and feel" of the PDFs are very important, as they will be distributed to clients of my company. I'm using special corporate fonts that are legally licensed for embedding as a subset. Two are .ttf (TrueType) and two are .otf (OpenType) fonts. The ttf fonts embed fine; the otf fonts do not, and the PDF viewer substitutes something it thinks is close (but really isn't). In the properties of the fonts in Windows Control Panel, the embedding properties are exactly the same for both.
Any way to force the fonts to embed? or any other workaround? Also, is there any way to edit-protect PDFs with VBA code? Or apply any other type of PDF security such as requiring a password to open?
I am stuck with a problem where I need to create a new table from an excel file. In detail my problem is; The excel file contains an order from a customer, like below, BOM Component Qty 123 abc 2 123 def 2 234 ert 1 234 qwe 1 234 uio 1
I need to create a table from this data like; Qty Partno 1 123 4 abc 4 def 1 234 2 ert 2 qwe 2 uio
NB! In reality the components are numbers not letters. The qty for BOM is always 1 and the component 2xqty.
It is important that the BOM number is listed first and thereafter its components.
So I need to somehow associate the BOM number with its components and list them together as a group. I just cannot figure out how to do this.
I have written a piece of code in Access that creates a Excel work book. The work book is populated with the various data and then made visible to the user.
Everything is working perfectly apart from one minor problem.
When creating a new workbook excel automatically puts 3 worksheets in... If the code creates 1 or 2 sheets of data I want it too delete the sheet that is blank. This is easy to do although it always prompts the user for confirmation.
How do I delete a worksheet without the prompt?
I have hunted everywhere for the answer and can't find it anywhere, any help would be great.
Example of code:
Dim XL As Excel.Application Dim WkBook As Excel.Workbook Dim WkSheet As Excel.Worksheet
I am having real problems creating a Excel from Access. I have rea lots of threads, but none seem to address this problem.
OK, so I have windows XP, Access 2003 and Excel all running quite happily on my PC, when I copy Access databases with the verb ".Excel" in it, I can access it and update/extend as needed.
However, I have just created a new piece of VBA code in a new database and the ".Excel" extensions are not present.....
So I have
Sub openReport() Dim myXL As Excel.Worksheet Set myXL = createXlWorksheet ......... End Sub
Public Function createXlWorksheet() As Excel.Worksheet Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim xlSheet As Excel.Worksheet
Set xlApp = CreateObject("Excel.Application") Set xlBook = xlApp.Workbooks.Add Set xlSheet = xlBook.Worksheets.Add
Set createXlWorksheet = xlSheet Set xlSheet = Nothing Set xlBook = Nothing Set xlApp = Nothing
End Function
And in some databases this works correcttly, but this one database,when I type the string "Dim myXL As.Ex" I do not get the "Excel" operator presented, it is just not in the list of object functions..... any ideas?? it's sending me mad!!!!
I am new to Access and somewhat OK with Excel.I am working at a government institution, agriculture sector. We have field staff of ~150 doing different field ranges ~350. Some officers are assign to more than one field BUT no field is assign to more than one officer. (these fields belongs to different Districts, number of fields in each district is not the same)
we have four different programs namely new cultivation program (NPP), productivity improvement of existing lands (PIP), farmer capacity building (HRM) and post harvest handling (PHP). Each program has its activities lets say NPP1, NPP2, PIP1, PIP2,PIP3 etc. for an example NPP1 is land inspection, NPP2 is donating planting materials. these activities are predefined and sequential. (planting materials can not be donate without land inspection)
Officers send their progress to progress monitoring unit monthly which includes progress of each program and each activity progress for that month. My objective is to track, analyse, visualize officers progress.
These are the questions I have,As I am OK with Excel and NOT good with Access do you think I should use access for this due to any special advantage only access can give me.can I visualize data with Access?
I would like to create a database that would enable me to select various options (from dropdown lists) which I could then have tidily arranged in an email that would automatically be sent to the recipient. Before I attempt to design the facing page I'd like to know if this is an option in Access?
I am creating a combo box with a button. In the below vba code, I am getting the string from the combo box. Then, I am trying to use SQL to the corresponding distro lists in the table (same row). This VBA code below is getting a Run-time error '438' Object doesn't support this property or method and it points to the SQL statment in the debugging screen.
Code: Private Sub Command11_Click() Dim cnn As ADODB.Connection Dim rs As ADODB.Recordset Dim SQL As String Dim vFld As Variant
I'm trying to create a button who is able to send a email with an attachment.The attachment will be all the time the same file.The email address to sent to is one of the field of the database.I need a copy sent in my email address as well.
I havent used access before and need a easy way to seach through 1300 records i have created in a form. Each record has 6 criteria, some with drop down options. I would like to create a button that when you type into a box and click this button it will search all my records and bring up a list of all the records containing the key words searched for.
I am trying to create a saved export on a table i have. However i want to filter so when i do the saved export it exports the table with the filtered result only.However when i filter my table and export it and save the export. The first export comes out with the filtered results but when i go to my list of saved exports and export it again, it doesnt come filtered and its just an export of the whole table.
We have small data dumps from a webservice delivered to us daily in csv format. I'd like to create a system where we can have the data automatically imported into either Access.
My idea is this:
1. CSV is downloaded to <x> folder.
2. Scheduled Task runs script to look in folder <x>
3. If CSV is found in folder <x>, import it's data into a fixed Access db->table.
4. Move CSV to an archive folder to avoid re-processing.
Is this feasible? How complicated would it be, and how to get it on track?
I plan to create a tab in access, which has text box and two buttons on it.
when I click the 1st button "Get Me Next" it should get the record from an excel sheet. and when i click the 2nd button "Case Closed". this records should get save in an other excel file.
I have attached the excel document in a zip file. Excel documents are not an authorized file type. This is going to be used for volunteers to input the shift and day they would like to work. I want to start by requiring volunteers to contact me and I will add them to the list of possible volunteers and I will give them a unique identification number.
When they contact me I will require all the information that is currently in the excel document (first, last, supervisor, ph number) I will then add them to a list of possible volunteers.
Then I would like a form they can access via sharepoint for volunteering what shift they can work. On this form it will have a box to input their unique id number and then select a shift from a dropbox (that has not been filled and auto populates). This will add them to the schedule.
Then I need a way to pull a report that shows all the volunteers and does not include their ID numbers.
As you can see the supplied document is full for March. I also have a second sheet that is blank for April.
I imagine there will be tables for
Volunteers (no duplicates in this list) Supervisors (1 supervisor can be over multiple Volunteers) Dates/Shifts (there are 2 shifts per day, there are 2 slots per shift)
I have set up a database that houses file locations. The form that I have made shows a job # and the files that correlate with it. I would like to set up a command button that will read the file name and open it in Excell. If any one know how to do this I would greatly appreciate the help.
I have a form based on a query. Is there a way to create a command button to delete all data? In addition, when this button is pressed, a pop-up message should appear to say "ARE YOU SURE YOU WANT TO DO THIS?".
Id love to use this code, but I need it to allow for parameters. IE: I need a form that deletes job numbers x through y. How would I arrange a form to do this?
On the navigation buttons at the base of the form there is a search facility where I can type a record id but I would like to get rid of that and search records either by turning the ID field into a searchable box or by adding a button where I can press it and get a search box up.
Using Access 2013.I have a Search Form with a Run Query button. I would like to add a button that clears the criteria entered into the search text boxes. Right now to change the criteria I have to manually delete everything entered, closed the current query it had open then go from there. I have tried using the command button wizard, form operations, then refresh form data. When I click that button a window pops up "The command or action 'refresh' isnt available right now".Is this not the correct way to set up what I need? What other options should I look into for setting this up?
So I have a form that allows me to view the information associated with a specific record. Within this form is also a subform that shows additional information about the record from a junction table. I want to create a button that allows me to edit the information on both forms.