I'm trying to export a form to another database. I've tried both simply copy/paste and using the export function. In both cases the form is copied to the other database, but my buttons go missing. Is there a way to move the form to another database and keep it intact?
View RepliesI have a code that has been successfully working, until today. I have a form which I then export as a pdf to a specific folder. I cannot understand why it has suddenly started to throw up the "runtime error 2501 outputto action was cancelled". The line is stops at is
DoCmd.OutputTo acOutputForm, "CLA Notice", acFormatPDF, varCombined
I have a form that a user fills out and the record is not uploaded to the database until the user hits the submit button. In other words, if the user closes the form without saving, the record is not inserted.
My end goal is to have the user click the button and have 3 things happen:
1) Record inserted into the database
2) A PDF of the record is saved to a per-identified directory
3) An outlook new message window opens with recipients pre-entered and the newly created PDF included as an attachment.
I can achieve steps 1 and 2 no problem. However, the way I get the PDF is by having the VBA simply print and the user selects the Adobe PDF. This does not let the VBA dictate the directory (or file name) and then makes me completely stumped for step 3.
I have decided to move away from Switchboard in Access 2010, to what I find to be more user-friendly; the Navigation Forms.
However, when I attempt to export any of the data from my navigation forms, the result is a blank Excel sheet. I can easily go into the forms themselves on the left navigation panel and export from there, but when myself or a user attempts to do this from the navigation forms themselves; well, the blank Excel sheet is the result.
How do you create a work-around, so that it is possible to export to Excel from these navigation forms?
I am fairly new to Access 2010.
I have decided to move away from Switchboard in Access 2010, to what I find to be more user-friendly; the Navigation Forms.
However, when I attempt to export any of the data from my navigation forms, the result is a blank Excel sheet. I can easily go into the forms themselves on the left navigation panel and export from there, but when myself or a user attempts to do this from the navigation forms themselves; well, the blank Excel sheet is the result.
How do you create a work-around, so that it is possible to export to Excel from these navigation forms?
I am trying to export a calendar form from one database to another.. I click on export, choose the database I want it to be exported into, and it seems to work..the form shows up in my new database, but:confused: when I click on the form I get a page of code that pops up with an error message
compile error
sub or function not defined.
how do I fix this?:confused:
I wonder if there is a way of exporting (or something) the database into an exe-file or something? I would like it to be as easy as possible to use for users that cannot control Access. In other words, I don't want to be able to be able to make changes to all the tables, querys, macros, etc. I only want the master form to start when I start the database (I use a macro for that).
Is it also possible to use it without having access installed on you computer?
I have been trying to figure out how to do this and the transferdatabase function wouldn't do what I needed. I have a table that has a bunch of records, each being a request for cad work somebody wants me to do. I change the status of each one to pending, working, or complete. Anyway I want to only keep the completed task records in the database for 90 days. After that the records will be exported to an archive database and purged from the working database. The problem I face is not getting the records I need “I used date stamps ;)” but getting the records I filtered to append the archive database table and not overwrite it. I made backups ;) of my db and am testing on those and cant figure this out. Below is the code I used to export. Like I said it overides the table rather than append...
DoCmd.TransferDatabase acExport, "Microsoft Access", _
"X:Archive.mdb", acTable, "tRequest", _
"tRequest"
MsgBox "its done"
Any ideas, pointers, stern words and a link to a post I missed, anything to help is appreciated. :o
Thanks,
Eric
:o:confused:
I'm desperately searching for a way to synchronise different copies of the same access 2003 database i created. I have tried brief case synchronisation, and I have also tried the replication manager that comes with access but they both haven't been much help.
My experience with them leads me to believe that they both work best with a LAN or internet connection.
I'm seeking a solution that will work without a LAN or internet connection. Something that will copy my tables and other required objects to a folder that i can copy and move to another pc where another copy of the database resides. It should then import the same tables and objects and hence synchronise the copy of the database.
I recently saw a visual foxpro database that has the kind of synchronisation solution i'm looking for. I think it works this way;it exports all the tables and necessary objects to a folder that it creates allowing you to copy or move this folder via portable storage device to another computer. It then synchronises by importing the tables and other objects from this folder into the database resident on that computer.
I think there might be a way to do this using macro's or VBA but alas my knowledge of these areas of access is very weak. Is there a way to recreate this functionality in access 2003 using VBA code?
code that will allow me to take data [All Fields] from a Table in my Database and Insert them into another identically structured Table in another MS Access accdb Database.I would also like to filter for records older than a month [MyDateField]
I have tried the following code I found on line. It doesn't throw an error . . . but it doesn't perform the Insert either.
Code:
Dim ws As DAO.Workspace 'Current workspace (for transaction).
Dim db As DAO.Database 'Inside the transaction.
Dim bInTrans As Boolean 'Flag that transaction is active.
Dim strSql As String 'Action query statements.
Dim strMsg As String 'MsgBox message.
[code]....
I routinely export queries etc from my development database to the 'live' master database used by users. Every so often I get the error message 'The database Mydatabase.accdb is read only'. Then I can't export anything to it. I don't know why it should suddenly become read only. How do I make the database changeable, and not read only?
View 3 Replies View RelatedI actually have an ms access database with the following format(assuming)
title1title2title3title4title5title6
1a1b1c1d1e1f
2b2b2c2d2e2f
3a3b3c3d3e3f
4a4b4c4d4e4f
for each row in the ms access database above i need to retrieve an excel in the format below
title11a
title21b
title31c
title41d
title51e
title61f
title12a
title22b
title32c
title42d
title52e
title62f
and so on....
Where I can proceed, what tool can I use??
I am exporting a single record to a spreadsheet. The code I have works fine. The problem is I want to have the spreadsheet contain the information that is in one of the forms textboxes, in this case a dogs name.
I have created a query to get the dogs name which works but I dont know how to get that query to run and then be put in the file name.
The code that I have is below
Code:
Private Sub btn_ExportDog_Click()
Dim strday As String 'The date
Dim sDest As String 'Where the file will be copied to
Dim sSource As String 'The name of the file to be copied
Dim strDogName As String 'The name of the dog that is geting exported
Dim strBackUp As String
strBackUp = "c:GPandDetectionDogTrainingLogBackUp"
[Code]...
All, using access 2010. I am using this code to make a folder upon exporting a query to excel:
Code:
sPath = "C:Directorymainfolder" & Format(Date, "yyyy mm dd") & "folder"
MkDir sPath
It works however I need a space between the date and the folder. But when I use "", it tells me path doesn't exist. get a space in the name when creating the folder.
I have a form that pulls a number of records from a number of different tables. I want to see basically the same information in a report. Is it possible to export the set up to a report so I don't have to build a report from scratch?
Thanks,
Kelly
Hello Access People,
I am sure this has been answered but i can not find it after searching all day.
I have a main form called "Main Form", then a sub form call "DPriority Assessment" on the main form i use this to filter the results, of only the data for one report shows and the results follow all works this far.
I am using a button to export the results from my sub form in to a word document, the data is copy over ok, but the page setup keeps changing from A4 to Letter, and the page changes from Landscape back to portrait, i have checked my printer setting and the setting in both word and access all looks fine.
I am not sure if some kind of code is need but i am not sure were or how to go about this. If anybody has any ideas i would be grate full or examples would be better.
Kind Regards
Alastair Lane
hey guys
i really need some help with this... i have a form that contains 2 subforms that relate to different tables in my db
is it possible to get the information entered into the form and suvbforms exported to a Word doc? if so, can someone give me the steps involved or some pointers please? im not talking about exporting reports, it needs to be the form and sub-forms
thanks
When equipment is returned to our company the details are put into an access database, then the same details are filled into a excel sheet to be printed and handed around for other depments to fill in by hand then sign. I have been asked to see if it is possible to alter the database so that the appropriate parts of the excel sheet could be filled in automatically. You can see an example below, its only the sales section that comes from the database the rest is filled in by hand.
Is it possible to setup a query that would ask for say the RER number and serial number to find the correct record then export the data to fill in the right cells; or is it easier for me to try and recreate the excell sheet as an access report and have it filled in that way.
I working in a database. I want to open another database and go directly to a specific form (not the default form). How do I make this happen? Below is what I have so far.
Dim accapp As Access.Application
Dim appname As String
Set accapp = New Access.Application
appname = "M:MPFMPF_Mgmt_Info_SystemSGLIPrepToolSGLIPrep Tool.accdb"
accapp.OpenCurrentDatabase (appname)
accapp.Visible = True
how to display images from a database in the form. The form looks approximately like Customerdetail from Northwind Access example database. Images in database I have stored as OLE object images. But how to link images with the form? Is it enough to give in properties control element source images column name? It seems like it is not.
View 2 Replies View RelatedI have tables, forms, and (will be) many data. But many data means that the file will be heavy (e.g. need a longer time to open it) and since it's located in server, meant that it'll also burden the servers when someone is accessing it. So, the idea is to make an access file consisted only of forms (and maybe tables), and another access file as the data-bank. And everytime the form is filled, it'll save the new data to the data-bank. So, it will be easier for the end-users to acess the form (e.g. saving time when opening the file).
My question is:
1) Is it really lessening the burden on server?
Because I think that even if the end-user only accessing the form, the form itself will be accessing the bank-data, and I do not see how it'll lessen all the process.
2) How to save to another database?
I used this command on VB:
Code:
Set db = CurrentDb
Can it be used to save the form's data to another access database? How?
Hi folks.
I'm new member this site.I have a problem my access project and I have request help you.
My problem. My project has two table and two form .Order (Main Table&Main Form) and Order_Subform (Sub Table&Sub Form) When i click 'Send to Excel' button in Order form it's sending data to Excel file Order.xls but it's only sending one line in order_subform to Excel Order.xls. it is not sending other line. I hope, could I able to explain my concern
Kind Regards.
I created a form which is opened by a query, it displays several fields. I need to find a way to export/add these results into a new access table. I need to do by using a button..
View 1 Replies View RelatedHi,
I have some queries in MS-Access, that I run twice every day.
I store the query result in excel, with specific name and slot-code like HSC_25-Dec-04_S2.xls
( Exmple : High_Score_Customer_25-Dec-04_Slot-2) .
First few letters of the file name is static, but I want to select the Date, Slot_Code from the controls.
I have designed the form, 'CmdExport' is the command-button name, on clicking the button I need to export query result in MS-Excel.
I need help to proceed.
Can anyone guide me....................please help me...
Regards,
i have a form and i want to export it to excel file the form will be updated someties and the data will be changed here is my code, but there is a problem with it
Code:
Private Sub Command0_Click()
Dim xlApp As Object
Dim xlBook As Object
Dim rs As ADODB.Recordset
Dim sql As String
Dim i As Integer
Dim Conn1 As ADODB.Connection
Dim Cmd1 As ADODB.Command
[code]....
I have an Assess 2007 database with a user table. This table holds database user names and user passwords an entry permission to the database. I also have a welcome form that activates when user enters the database using either of the user names and user password in the user table. Now, I would like to display the database user name (NOT THE SYSTEM USER NAME] on the welcome form of the user that enters the database.
View 14 Replies View Related