I have an MS Access application which works fine until used with XP OS.
In XP if you open a report which is based on an ODBC linked table and try to send in RTF format as an attachement you get this error message:
MSACCESS.EXE - Unable to locate component
This application has failed to start because BJABLR32.dll was not found. Re-installing the application may fix this problem.
The error only occurs for reports using ODBC tables as a data source for which you need to enter an ID and password. Other reports can be sent normally using Outlook etc.
I'm not sure if this is a Query problem or a Report problem, so I'm putting it in the General catagory. If I need to post it in one of the others, please point me the right direction.
I have set up the following:
Query A - Combines data from several tables Query B - Prompts for a text string and places it in a table Query C - Uses the text entered in Query B to select records from Query A. The field that is searched is a text field. Report A – Has an Open procedure that executes a macro that runs Query A. I also have a Close procedure that executes a macro that runs a second report based on Query A against a different table.
When I run the report on my desktop it works properly. I had a user try to run the report and she gets the following error immediately, prior to being prompted for the text.
Error:429;ActiveX component can't create object
I am running Office XP and she is running 2003 with SP2. She has not had problems with other Access reports in the same DB. Any ideas what is missing?
I'm using the below code in msaccess which used to work perfectly on the Win XP platform. I upgraded my OS to Win 7. It's now giving an error as "Runtime Error 429 - ActiveX Component Can't Create Object". I unchecked & rechecked all the library references.
Function GetNetWorkDays(startDate As Date, endDate As Date) As Integer Dim objFunction As MSOWCFLib.OCATP Set objFunction = New MSOWCFLib.OCATP GetNetWorkDays = objFunction.NETWORKDAYS(startDate, endDate) Set objFunction = Nothing End Function
Old OS: Win XP New: Win 7 Old msaccess: 2003 New: 2010 Old office: 2003 New: 2010
I got this message after I install the "SMTPSVG.DLL" that i got from http://www.serverobjects.com/comp/Aspmail3.htm What should I do?
Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x8d8 Thread 0x994 DBC 0x240303c Jet'.
I have tried to create an MDE database and receive the message "Microsoft Access was unable to create an MDE database" I deleted all unnecessary tables, queries, forms and reports and still receive this message.
My database was working fine. Now, if I have to save or edit a record, I get a message Run time error 2107. The value you entered does not meet the validation rule defined for the field or control. I am able to enter and edit new records in the table. I did not change any validation in form. Then it goes to debug mode and highlighted this code (me.recordsource=Listsql - is highlighted)
Private Sub ListSearch_Click() Dim dBS As Database Dim Rst As Recordset Dim Listsql As String Set dBS = CurrentDb() Listsql = "Select * from MasterData where employeeid ='" & [Forms]![MASTERFORM]![ListSearch] & "'"
The problem I having is if I have a computer name of a computer on our network (not the one I am running the database on), is there a way using VBa to find the details about this machine.
For example if the computer name is 'DTP002133' I can click 'start' then 'search for files and folders' then click 'computers' in the search for other items. This search will give me the computer location and comments. I would like to be able to automate this process within my database.
Not sure if this one is possible but thought I'd pick you brains...
I'm very new to Access and especially VBA. How to get started with the correct syntax for locating a file, and printing it. The file will be a PDF and if possible I would like to declare a variable for the file name (not the path) so if it is changed I can just change the variable instead of looking for it in the code. I plan to have 10 of these.
In order to act as a system, I would like to have a function or windows firstly displayed all the folder names in a drive, and then allow user to locate/select freely a folder among different folders. Is there anything for my reference or for me to start??
I have a table that was linked from a SQL Server with a file DSN. It was linked years ago so now I want to locate that specific DSN file for that specific table if possible.
I have a database I took over, that generally uses linked tables to a MYSQL servers on another machine. The Access database uses a machine DSN to connect.
There are many queries that contain references to linked tables using another name. For example, the table is "service unit" but the queries are using "SU" as a reference. I cannot find any database object with that name SU. There are many such tables referenced like this - all uppercase letters, which is a common thing they all share.
Now, the server had a file integrity issue, and now the queries that contained the SU references will not work anymore. I created a linked table and called it SU and but the queries still won't work until I edit the queries, remove the old SU table, and add the new one in. So,
1. Where those table references could have come from, if it's not a linked table? Is there a hidden location on the server, or in the access database that stores another connection method?
2. Why won't simply adding a similarly named database object work the same way? Why must I re-edit all the queries?
I got a combo box with a few columns for locating query activity. However, how can I make use of it to locate a particular record according to predefined values, for instance in a loop, to locate records. The combo box got 3 columns, just want to know the syntax to define the combo box according to some values. I need to define only the first colmun or all 3 columns??
I had a search client form. This form used to work fine, so i haven't tocuhed it for a while. Basically what happens is you double click on the client and it clones it to the form.
However just a second ago i tested the form again and an error appears "ActiveX component cant create object". I've made no modifications to anything involving this form so im bit stuck for ideas.
I also received an error message telling me to check - Visual Basic --> Tool --> Reference. That says "Missing: Microsoft DAO 3.6 Object Library". I have browsed for the file but had no luck in finding a file to replace it.
I get this error everytime i try to use any wizard in access, i have uninstalled and reinstalled acces, i looked at the MSDN and i cannot find anything that will fix my problem. I have windows XP and office 2002 if that could help with the solution.
i got this error message when i tried to create a command button... i have to do it without the wizard... then when i tried to get one of those convenient access pics applied to the button i get an error pop up Object variable or With block variable not set
...the errors only just started today... well i played hooky on friday cause of a snow storm so i guess it might be a recent microsoft insecurity update...
running XP pro 2002 SP2 with Access 2003 SP2
:( ...maybe this is the latest microsoft challenge... :mad: ...uninstalling and reinstalling access or all of ms office does not remedy the situation... i searched the forums and cant find a solution :eek: ...
I has install office XP but when I creat form I has problem: Active X component can't creat object I don't know to correct problem please suggest to me
I am trying to locate a record on a multirecord form by using Findfirst method. Here is the code.
Dim UA1 As String, UAE1 As String, UA2 As String, UAE2 As String, UA3 As String, UAE3 As String, apost as string, repl as string apost = "'" repl = "''" UA1 = Nz(Forms(ParName).Form.NAME, " ") UAE1 = Replace(UA1, apost, repl)
[Code] ....
This code sometimes works and sometimes it does not work. The field CNO is a text field of 5 characters but contains the card numbers that is numeric data or nothing.
I am trying to connect to MS Access from MS word using the following code but getting the above error message:
Code: Sub GetDataFromDataBase() 'allocate memory for the database object as a whole and for the active record Dim myDataBase As Database Dim myActiveRecord As Recordset
I am using the following code but when i run it produces the following error.
Run-time error '429':
ActiveX component can't create object.
then on debug it highlights the line
Set objOutlook = CreateObject("Outlook.Application")
I have searched online and already tried a suggestion to ensure that mictosoft outlook 14.0 object library is selected in the VBA references.
Code:
Dim objOutlook As Object Dim objMailItem As Object Const olMailItem As Integer = 0 Set objOutlook = CreateObject("Outlook.Application") Set objMailItem = objOutlook.CreateItem(olMailItem)
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.
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:-
I have main form("client Status") which contains information about client order and showing the calculations. The subform is also there for receiving the payment from client. I would like to get the sum of amount received(from sub from) and would like to show it on main form that how much amount received from a client. As payment received from client the form should be updated automatically by showing the sum of amount received.
how to take sum of particular field in subform using vba and storing it in main form field.the forms are created from tables and there is no unbound field.