When I email with the Docmd.SendObject command I would like to 'attach' 2 files and when I perform a Transferdatabase command I would like to Import all the tables from the database at one time (approx. 8 tables). The Help section talks about doing this for single items -- does anyone know if it can be done for multiple items and the syntax to do it? Thanks
View RepliesI have a table within my databse for which I need to know how to keep a seperate list of all of the records that have a 'tick' in a specific field. I would like the list to be updated automatically based on the 'tick' status in the original table. I also need to add some additional information - I need to automatically record the date that this information was added
View 7 Replies View RelatedHello
I am using Access 2003(11.6355.6360) SPI
When I attempt to create a new DB - by performing Blank Database I immediately get a message 'Object Library not registered'.
If I 'OK' that box and try to create a table, I can do so - create Table in design view.
When I then try to Import external data - an excel file I get the message 'ActiveX component Can't create object'.
I have looked ob various sites for help and forum information regarding these errors but have found nothing conclusive, with specidfic regard to Access 2003.
The version has been loaded on my machine about 1 year as part pf Office Professional but this is the first time I have attempted to run Access itself.
Does any forum member have any ideas as to how this problem could be resolved.
Thank You
Rgds
Paul Langham
I am currently building a database for the company I work for that is fairly similar to the Northwind Database; however it is made from scratch so hopefully some of the common problems with that database won't find their way into mine.My problem is that when I go to my Orders form, I pick a customer from the main form, which creates a record on the Orders table. When I then go to the subform to choose a product/line item, I get the error in my title ("The LinkMasterFields property setting has produced this error: 'The object doesn't contain the Automation object 'OrdersT.") as soon as a product is chosen from the drop down list.
View 1 Replies View RelatedThe error is:
The LinkMasterFields property setting has produced this error: 'The object doesn't contain the Automation object 'tblIndividual.' '
Then it also gives me the same one on another table.
I think it has something to do with the link master/child fields. I've tried all kinds of relationships with the three tables and can't figure it out.
I've tried uploading the database here but it won't. It's on my Sky Drive.
[URL] .....
I have spent the last couple of days trying to figure out how to make this work.
I have three tables.
tblIntakeMain
[IntakeMainID]
tblIncidentDetails
[IncidentdeatailsID]
tblPersonnel
[PersonnelID]
On the main form I use subforms to link tblIncidentDetails and tblPersonnel to tblIntakeMain. Both subforms can, and do, have many entries. This all works fine. What is not working is the search form I am using.
I am using Gromits most excellent Search Form. The problem is when I create a query, qSearch, to bring together the three tables I get a multiple records which makes the searches very confusing and near useless. Is there anyway around this? Is there something I am missing? Is there another search method I could use that would work in a similar way as Gromits? Please help before the Prozac runs out and I lose my mind--what little it left.
Hi everyone. Apologies if this has come up before, but the search terms I've tried here and on google keep turning up the wrong information.
At work I manage a large database with many tables. It stores data for participants in a research study. Each table stores the data for a different test, so one participant may have multiple records. Primary keys for these tables are defined by a combination of the participant and date of test fields. (Everything is dependent upon a table that stores the static info for participants, so the database is normalized.)
I want to be able to make a table that lists target participants and dates, and then create a query that looks at this table and pulls all the available data from various tables for those individuals that was recorded within one year of the target dates.
I've successfully made queries that meet these criteria while pulling data from only one table. The problem I'm having is that when I try to pull from multiple tables, each with it's own date field that needs to be used as a criterion, I end up excluding almost all the data, because most of the target participants do not have all the requested data within the target dates.
I've tried being inclusive with my criteria (using ORs), but then I end up with tons of data that I don't want and I need to filter through it, which defeats the purpose of the query.
Any advice on handling this issue, or do I basically just need to create a separate query for each table?
I'm sorry if this is too vague, but it's illegal for me to upload any of my own dataset. I could probably come up with an example if it's helpful, though.
Thanks!
I'm getting an error message (informational only):
The object doesn't contain the automation object 'ClientID.'You tried to run a visual basic procedure to set a property or method for an object. However, the component doesn't make the property or method available for Automation operations.
Check the components documentation for information on the properties and methods it makes available for automation operations.
This happens when I start entering data in the field "productname" of a subform.
So I'm assuming something in the form or in the code of the form is referring to ClientID. but I've checked it, and there is nothing referring to it anymore. Well, at least as far as I'm aware of.
This afternoon access crashed without any error, it just closed. Upon reopening the DB again, all my work of the past one and a half week was gone. Normally I always backup the data, but these past days I didn't due to christmas and still working a lot too. So I forgot.
I did some redesigning in the process this evening, deleting and adding some fields and code.
I can't get rid of this error. Can anyone help? Or point me in the right direction?
Also the DB is 3.5MB in size. While it is completely empty. And I can't imagine that some empty tables, queries, forms and a bit of code can be so much. But that's for a later time to worry about I guess, unless one of you says: this and that, maybe that works... Otherwise, I would really be very glad already if the error disappears....
I am creating an form in a database and whenever one of my procedure's run it creates this error message:
The expression ON Load you entered as the event property setting produced the following error:
Member already exists in an object module from which this object module derives.
*The expression may not result in the name of a macro, the name of a user-defined function, or [event Procedure].
*There may have been an error evaluating the function, event, or macro.
An ideas?
You'll have to forgive me I kinda new at this. I have a form with a non linked subform on it. The main form has one control on it called CustomerID, the subform's record source is from a select query that is updated by a cmdButton on the main form. The cmdButton runs an update query. One of the controls in the subform is called CustomerID, this control has no other purpose than to hold the same value that the main forms control (CustomerID) has. I want the cmdButton's OnClick event to transfer the value from the mainform CustomerID and place it into the subform CustomerID. Any help on this would be greatly appreciated.
View 3 Replies View RelatedHi there,
This is my problem i am going to try and explain myself as clearly as possiable hopefull you will be able to understand me.
When i enter my data bank through Access, a mask opens or is it a form i am not too sure but i have sent an attachment with the sceen image.
Lets say i am looking for the data of John. I click on search and i find him. Now my Mask or form has sub forms in them for diffent information, i have made a large red circle on the attached picture to show what exactly i am talking about. These sub folders contain information such as gernerall information, bussiness information etc.
All this information ... data is part of john 's dataset or data record. SO what i want to do is take his data all of it and send it to john himself and he then can edit it and send it back to me and i want to check it and if i am satisfied with the data i can update the new information automatically into my database. and i want to beable to edit it myself too. i want all his data to be like a data book of john. The editing can take place it any problem such as Accesss itself or word or excell i just wan to be able to edit and transfer my data without damaging or loosing information.
My probles are as follows:
1) how to send john's information all of it
2) how to add it back to my database both automacticly and manuelly
3) how to edit his data as a whole, not bits and pices. as if it was one long report.
Thanks i hope i was clear enough
Evening Gents.
I've created a database which is going to need a fair amount of data uploading into it (a long laborious procedure).
My initial plan to cut the work load for one person was to create 2copies of the database and split the upload in half (get two people to do it).
However, one of my tables is a parent to around 4 childs, therefore when i copy the information from this parent table in datasheet view from one db to another, it doesnt transfer it's associated data.
Is there anyway to get around this? Any advice/tips/hints would be much appreciated
(hope this has made sense, please let me know if clarification is needed)
I have a macro which transfers a fixed width file to my desktop. The name is neppow.txt. Can I have this file land with the date dynamcially populated in the name?
Example:
neppow_20070308.txt today
neppow_20070309.txt tomorrow
thanks!
does anyone know what this code would be like in DAO ?
[code]
DoCmd.TransferText acExportDelim, "My_Transform", "Table", "C: empxxx.csv"
[code]
Im stuck on a project that I have received help on before. I am trying to E-Mail a daily report created by a macro in Access 2000. It needs to go out as an excel spreadsheet, but in a format that can be opened in a Blackberry. The advise i was given was to use Transferdatabase. This is where i become unstuck. No matter what I type where i come unstuck. Is there anyone out there that can possibly advise me what to do in "idiot proof" steps?
Im afraid my knowledge of Access is limited to 2 weeks self taught knowhow ?
I need to set up an automated process to transfer data from about 25 tables from one database to another. This will happen on a weekly basis and I'm wondering what the best way to set this up is.
Both are Access 03 db files. The main database has data for a dozen or so clinics and I need to get the data for one clinic out and in to the the secondary db. The data in the secondary db will be replaced every week with fresh data from the main db. Once it is refreshed with new data the clinic will download the db from our site.
My first thought is to just export queries to CSV files and then import them in to the secondary db file. If run from a macro it could be a scheduled task. I could then import the CSV files. This could also be automated with a macro.
Any other ideas.
I've transferred a database to a new PC, with Office 2002 installed.
The forms hold some text data and a photograph.
The database loads and displays correctly.
But I cannot add a new photograph. I get a message something like: Microsoft Access cannot get the OLE something-or-other. Sorry for the lack of detail, but I'm sending this from another PC.
Is there something (on Disc 2 of Office 2002?) that I need to install after I've installed Access & the rest of Office? Should I have opted for a full installation?
After much messing around, I got rid of this error - but still no photo. Instead, the filename of the photo is displayed in the window where the photo should be.
Please help!!!
I have a database scheduled to run nightly. In this database I have a macro that runs a macro. I want one of the arguments to export "T_Update_Log" from the database to an excel file as part of it's nightly macro. When I use "Transfer Spreadsheet" in my macro, it creates a new worksheet in my excel file each night (for example: T_Update_Log1, T_Update_Log2, etc) Instead, I want it to overwrite existing one.
I have also tried "Export" command, but that throws a prompt asking if I want to overwrite the existing excel file. I cannot have any message prompts during my nightly task or else it will stop the whole process. Setting the Warnings to No does not stop this particular message prompt.
Thoughts? Thanks in advance!
A customer wants to do electronic funds transfer from an accounts receivable system that I wrote for them. The only information that I have gotten from their bank is that the data should be in ACH (automated clearinghouse) format. I have never dealt with this before, but I assumed that I would just have to output the data in probably an ASCII file. I have been searching the net, but have only seen software or services that handle this. I haven't found any definitive information on exactly what the details of ACH format are. I was also surprised not to find any threads here about this. I'm sure there are plenty of those who have already dealt with this.
Any thoughts would be appreciated.
Thanks in advance.
Hi
I have setup a query from which I have setup a macro which exports the queried data to a .txt delimited file, does anyone know how I can stop it putting Quotes aroung each field and just leave the commas in.
Thanks,
Lisa
I am creating a Transport databse and got stuck into something.
I have created a master table " Vehicle Details " which inlcudes all the details of cars. Then i created two sub-tables " Vehicles in Garage" and " Vehicles assigned to Drivers". I will be using the forms ( ofcourse :) ) to enter and edit data. What now i want to do is from a master table i want to tranfer all details of a particular car either to " Vehicles in Garage" or " Vehicles assigned to drivers" tables/forms.
Is this possible ?
Thanks
P.S. I hope this is the right section for this .
Hi,
I am new to using access, and agreed to work on a site not designed by me.
We want to host this site elsewhere but I am having difficulties backing up the access database; I can't find a way to copy the stored procedures.
Is there a way to export or save the entire database, including the stored procedures? I suspect that this must be a very common task but I could not find any info on how to do this.
Any help would be greatly appreciated.
Kind regards,
Mukti
Hi Guys,
Ok, all i want to do is that when i select a value from my combo box to be displayed in a text box, once its been selected, the value is then deleted from the combo box, any ideas????
Hi,
I work in a hospital where each ward has its own identical but UNLINKED staff database. I wanted to make a single database but the management was adamant that for confidentiality they should each be standalone. I lost this argument!
Data is stored in 7 tables: Identity, annual leave, sick leave, qualifications, etc.
Too late, someone has realised that staff may transfer from one ward to another, so the whole record needs to be transferred. What's the best way to do this?
So far the process I have come up with is:
Choose the person you wish to export from the source database
Run 7 queries to export the records from the various tables e.g. to Excel
Create linked tables in the target database to pick up these records
Run import queries.
I set up a macro to run the 7 export queries, using the "OutputTo" action and specifying .xls for the output format. But the files created don't appear to be readable by Access. In Explorer, they only have the Windows icon and are just "files".
Does anyone know a better way to tackle this problem?
Thanks in advance for any assistance.
Pat.
I work in a hospital where each ward has its own identical but UNLINKED staff database. I wanted to make a single database but the management was adamant that for confidentiality they should each be standalone. I lost this argument!
Data is stored in 7 tables: Identity, annual leave, sick leave, qualifications, etc.
Too late, someone has realised that staff may transfer from one ward to another, so the whole record needs to be transferred. What's the best way to do this?
So far the process I have come up with is:
Choose the person you wish to export from the source database
Run 7 queries to export the records from the various tables e.g. to Excel
Create linked tables in the target database to pick up these records
Run import queries.
I set up a macro to run the 7 export queries, using the "OutputTo" action and specifying .xls for the output format. But the files created don't appear to be readable by Access. In Explorer, they only have the Windows icon and are just "files".
Does anyone know a better way to tackle this problem?
ok, basically our website will input form details directly into a database. this database will be held online obviously..
once the details are inside, how easy will it be to transfer a record into a table of another database.. (our main database.. which is offline for security purposes).
im assuming it wont be too hard.. both access versions are the same.. and they can both be open at once.. etc..
can anyone shed some understanding on this issue