hey,
i want to create a on runtime. i know hoe to do that ... what i don't know is how to make the form format to be the same as the form it was called from.
i want all the visual attributes to be applied to the new form.
thanks
refael
Hi all,
I am new to all this database stuff and new to your forums so please be gentle :P
I have a database i have made, only a small project atm but filtering by form is a big part of the workings of the database. Now as i understand it the filter is not included in Access RunTime2000 is there any way to create a form to simulate the above filter ?
Thxs in advance
Adam
I have a form that contains a field with an On Click event procedure to send the value in that field to a corresponding field on a subform attached to another form. Does that make any sense? The On Click procedure looks like this:
Private Sub FieldNameonCurrentForm_Click()
Forms!frmMainFormName!fsubSubFormName.Form!txtFiel dName = me.FieldNameonCurrentForm
End Sub
I’m not quite sure what I am doing wrong. I am getting the Run-time Error ‘2465’ and it is pointing out that it is unable to find field ‘fsubSubFormName’. I have double (and triple) checked the names and I have not misspelled the names of the form or subform. Did I set up the event incorrectly? Could it be that I am not calling the subform the correct way? Any ideas? .....
Hi.
As you know it's not possible to set the "BorderStyle"-property of a form during runtime.
But thats a kind of functionality, i need to use in my Access 2003 application.
I need to 'simulate' the value "none" during runtime, that means that there is absolutely no frame/border around the form.
Design-mode is not possible, because i need to use a MDE file.
So i dealed with the APIs and nearly got it.
But i always have had a kind of very thin 'sunken'-frame around my form.
I also played with the extended window-styles, but the result was that i got a 'raised'-frame around the form.
Over all i really got wired in my head.
Maybe someone already did that too and can post the right api-calls / styles here?
I would be really thankful, because i quit that now after hours...
Regards,
AtzeX
I was trying from a button on my form that will go to and bring up the desktop. I want it so I can put this database on anyone's computer and the button will work.
I am using this and it works but only on my computer.
Application.FollowHyperlink "C:UsersBryanDesktop"
I also tried this
Application.FollowHyperlink "C:Show Desktop.scf"
And
Application.FollowHyperlink "C:WINDOWSSystemShow Desktop.scf"
Both gives Runtime error 490 cannot open specified file.
I am currently creating a form which includes a command button to update a field in a table to show Today's Date, at the time of running a query I am still yet to write.
I have the following code for my Command Button, which is returning the Runtime Error 3464 (Data type mismatch in Criteria Expression):
Private Sub cmdAddTodaysDate_Click()
CurrentDb.Execute (" UPDATE tblMyTable SET TodaysDate = " & Date & " WHERE tblMyTable.ProductCode = " & Me.txtProductCode)
End Sub
The query above seems to be having issues matching the text from the 'txtProductCode' textbox to the table field 'ProductCode'.
I created a small database with a user login form, along with a password reset form. Running it in my sandbox as an accdr file, the password value resets just fine, but on my test machine with the Access 2010 runtime installed, the password reset form doesn't reset the password. I will try to describe the state of things as of this point.
1. The LoginF presents with a combo box for the user to choose their name, and a text box to enter their password. The code below is on the After Update of the password text box.
Code:
Private Sub txtPassword_AfterUpdate()
'Check if user has been chosen
If IsNull(Me.cboUser) Then
MsgBox "Please Select User Initials", vbInformation, "Warning"
[Code] ....
2. The password reset form has two text boxes for the new password and to re-enter the same, as well as a command button with this code.
Code:
Private Sub cmdResetPassword_Click()
If Me.Password = Me.PasswordTest And Len(Me.Password) & "" > 0 Then
DoCmd.RunCommand acCmdSaveRecord
DoCmd.Close
DoCmd.OpenForm "LoginF"
[Code] ....
As I say, this works as an accdr file, but not in the actual runtime environment.
I'm trying to open a recordset in vba and I'm getting the 3061 runtime error,Expected 1.
I'm trying to open a recordset with a query that uses a reference to a form control.
Code:
searchtable1 = "qInVisio_RSV"
Set rs = db.OpenRecordset(searchtable1, dbOpenDynaset, dbSeeChanges)
This is the sql of the query:
The highlighted parted is the form referance ( I know it's obvious, just for easier spotting )
Code:
SELECT dbo_FOLIO.FOLIOID, dbo_FOLIO.KIND, dbo_FOLIO.RSVID, dbo_FOLIO.CHKIDATE, dbo_RLIST.ROOMID, dbo_ROOM.ROOMNO, dbo_AGN.LINAPRG
FROM (dbo_ROOM INNER JOIN (dbo_FOLIO INNER JOIN dbo_RLIST ON dbo_FOLIO.RSVID = dbo_RLIST.RSVID) ON dbo_ROOM.ROOMID = dbo_RLIST.ROOMID) LEFT JOIN dbo_AGN ON dbo_FOLIO.AGNID = dbo_AGN.AGNID
WHERE (((dbo_FOLIO.KIND)=101) AND ((dbo_FOLIO.CHKIDATE)>=[Forms]![frmCleaningPlan]![DTPicker]));
also as you can see it's a datepicker control, so the value is a date...
Hi,
The company have MS Access 2003, Office XP Professional with Front Page, and Office XP Developer. But, we don't have license on Office XP Professional with front page, others have license.
I installed MS Access 2003, and Office Xp Developer on my company machine,
when I use Office XP Developer to create the package/access runtime for my clients, it must refer to Office XP Professional with front page to create Access Runtime. But, I don't have license for Office XP with front page, whereas I have license for Office XP Developer.
So, after I finished creating the package,
Is the Access Runtime legal in rules distribute to my clients using?
Hi All,
Just a quick one.
I have access 2003 installed, which I use to make systems ( doh )
Anyway, I have just installed Access Runtime on the same machine so that I can test my databases on the runtime version to make sure that all works ok.
However, I have installed several times now, but I can not find runtime anywhere to run it...
Can you not use runtime if you have full blown access installed ?
Or am i just having a blonde moment ???
Thanks in advance.
Max
Hi there,
I'm using the FILECOPY command to copy a specific file on the C drive to a CD.
I have been testing this for ages and it's been working fine. All of a sudden, I am getting a runtime 75 error. WHY???
Thanks in advance,
Paul.
How and Where can I get the Access Runtime ? (as I want to distribute my application to other users who do not have Access installed). :confused:
I'm using Access 2003.
Thanks.
I have an application developed in Access 2000. Can anybody help with my search for the access runtime licence so that I can distribute to many users (who may not have access)? I have been told I need Visual Tool Extensions for Office but cant get an evaluation to check it works with my app.
OR, does anybody know a source (cheap obviously) of MS Access 2000 - users who dont have access only need 2000 to run this app.
Any help greatly appreciated!
Hi all.
I have problem with form for viewing pictures. If I use apllication using full MS Access I haven't any problem. I can see BMP, JPG, GIF ... But if I open appllication using runtime I cannot open JPG file. Runtime show error to transfer picture to GIF or BMP. Where is the problem?
I have MS Access 2002 version, I create one mdb file and then put it on the sharing drive, I install Access RunTime on my client machines, they can run the mdb file on the sharing drive.
Another way,
I used Office XP Developer Edtion to create package and then install the package on my client machines, they can run the mdb file.
Here is a question,
Why do we need Office XP Developer Edition to create the package? Because we just install Access Runtime on the client machines, then they can run the mdb files.
What is advantage of creating the package?
Hi Everyone
Ive created a database using the file system object that creates folders, moves files from one folder to another, etc.
This works perfectly on my home pc, but when i try to install it on the server at work I get the following error message:-
Runtime Error 429
Active X component can't create object
I've had a look on the net and appears that it only happens on certain computers and I wondered if anyone had any quick fixes that they had come across over the years.
Thanks in anticipation
Kindest regards
Tony
So I made a little db using A2k3 to use @ work. We have OpenOffice.org 2.0 @ work and not MS Office. Since I knew Access better than OO's db program, I used it and was going to just take it in and use it after it was finished. Well, I didn't realize that unlike OO's Word, PowerPoint and Excel versions, it's Access version does NOT open it's MS equivalent - Access db's. It'll link to them and use data, but all tables, forms, reports, etc have to be designed in the OO environment. Geez!! So I looked @ getting the Access Runtime. It's a bit expensive from what I read (about $200 if I read correctly). I have a couple questions. First, is it really that expensive? Second, is there another solution to this problem? Third, I read that the 2007 runtime may be free. Is that so? If so, will it work backwards - with a 2003 db? Thank you, thank you, thank you.
View 1 Replies View RelatedHi,
if I don't buy office Developer software, I just download Access Runtime 2002 from the Microsoft website, and then install it on the client machines. Do I commit the company rules? Do I need to buy unlimited license for Access Runtime before installing?
Hi,
I have full version MS Access, and Office Developer Edition to disribute the Access RunTime for my clients.
I don't want to create the package (adp file), I just want to create the package for Access RunTime, and then install it into my client machines, we want to run the same adp file on the network sharing drive. Then, it's fine. But, how do I install the supported files into my client machines? Because the supported files attached to the package (adp file), if we install adp file into the client machine, it will install adp file and the supported files, but we don't want to install adp file, we just want to install supported files.
How should I do?
Hi
I am getting Errors: 0,20,91 at the same subroutine
What could be the reason for the error?
Thanks
Hi my friends...
I need help..
I have program compiled in Access 97 runtime installed on my Windows XP computer.
When I installed this program on account TOM (Administrator) then program run and work great.
When i changed privileges for TOM (not be admin anymore) to restriction account then i have problem witch this program
URL
Program still working, but if I want to use some function in this program i have this error:
URL
I don't know why ?
In installation folder, and c:program filesMicrosoft Office Runtime 97 and c:windowssystem32 user TOM have ALL rights.
Can anybody help me ?
Sorry for my English,, i still learn it.
Best regards for all
"Function is not available in expressions in table level validations"
I keep getting this message when trying to update the value of a text box when using the following code
Forms!frmFinanceProposal!Text940 = Me.Text253
Would someone be able to explain what this message means pls!!!
Good morning
I had yesterday off work and have come back to a nightmare.
The database we use doesnt work the way it should anymore.
There is a switchboard which gives us the option to show a booking form...Worked fine until someone did something to it yesterday.
When I click on the command button to load the form I get an error saying that there was a runtime error 2001 " You canceled the previous operation"
How do I fix this??? I so confused.
I have tried opening the form other ways but it appears to be locked and wont open.
Please if someone could share some light!!!!
TIA
I am developing an application in access xp (2002) and want to distribute it as a runtime application. I do not have the Office xp Developer version and thus need to buy the MS Office Developer. It is still available and if so, where can I buy it? Or can the Visual Studio Tools for the MS Office System make a runtime version from access 2002?
Any help would be appreciated.
Niels
I have Office 2000 Developer installed on my workstation at work and need to create an executable to deploy to other workstations that do not have MS Access. I'm using Access 2000 and the few that have the runtime installed already have Access 97 runtime.
When I execute the Package and Deployment Wizard I click on the checkbox for "Include Access Runtime". When it creates the package, however, the runtime is not included. I have verified that the runtime is on my hard drive. The CAB file is only about 10 Mb - the same size it was before I tried to create an executable that included the runtime module.
Any suggestions on what I am doing wrong? The size of the module created by including the runtime is not a concern at this time. I just need to get this application deployed for a mission-critical analysis task.
Hello,
I have a question about Access runtime. We have some users at work who don't have Access on their machines, but we would like them to be able to use databases we have created. My suggestion was to purchase Visual Studio Tools for Office, which will give us Access Developer Extensions and allow us to distribute runtime versions of our databases.
However, the pcs here at work are pretty well tied down in terms of installing anything. E.g. no registry changes are allowed, unless you are an administrator.
So my question is - what is actually involved in installing the Access Runtime. Can it be achieved simply by copying the relevant files (ACCESSRT.* ?) into the office directory, or is there more to it than that. Will I be able to get my databases up and running myself, or is it likely that I will need the help of the Technology Department to get the Runtime installed ?
Thanks for any advice,