I am trying to get the name of the active subform in an Access database from VBA code.
If i use screen.activeform i get the name of the parent form and not the subform.
Any ideas how to get this ?
Many thanks in advance.
Andrew
Hi all,
I have a form with two sub forms and when I enter data into one of my subforms I get this error?
A Problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control.
Close the OLE server and restart it outside of Microsoft Access. Then try the original operation again in Microsoft Access.
I've checked the relationship and linked child / master fields and it looks ok. Does anyone know what could be causing this?
I am getting this error on a couple of different PC's running WinNT4 and Win2000.
Shutting down doesn't help and I don't get this with other databases. When I open the form (subform2) on its own I can enter data, just not when it's part of the main form?
I have a form with 20 identical subforms.
Is it possible to retrieve the tabindex from the active subform in the main form by using VBA?
I have a main form that controls 2 subforms. sbfActiveProjects displays a list of records that have not been flagged as complete. Upon clicking on a record in sbfActiveProjects, the details of that record show up in sbfProject. This functionality works great, except when I try to create a new record. The code works fine for getting a new record, however once I run the command I lose my ability to navigate to other active records.
Code:
Private Sub cmdNewProject_Click()
'set focus to sbfProject
sbfProject.SetFocus
'navigate to new record
DoCmd.GoToRecord , "", acNewRec
End Sub
Is there any way to add a dropdown box or something that determines that a subrecord is active/completed, and then have a way to jump straight to the one that is active by clicking a button on the record? In the example I attached, I want to be able to click on the button above the tab and have it switch to that tab and open the first record it finds that has "Active" selected.
View 1 Replies View RelatedHi Again guys,
I have a database application, front end on the local machines, back end on a server (it happens to be a mac server, but still works). Recently we upgraded to Access2007 on all systems, but left the backend in 2000 format. Ever since then we have been having issues with our users getting told "Too Many Active Users" when they try and access the backend. If all users disconnect and the reconnect it seems to be fine for a while, then after sometime it does it again. I assume it has something to do with the ldb file on the backend. It worked fine in 2003, now I am stumped. It possibly has something to do with permissions but I have no idea what.
Thanks for any help.
I have application made in MS Access 2000
I got crazy with one Active X Control on one PC. On every other PC works fine but on this one I have error "Object is missing or does not exist".
I tried delete - copy - paste couple times, unregister and register control couple time, but error is still there.
Reference looks fine, I put control on the form and everything looks great.
I tried delete control from the form and put again.
When I try to assign some data to the control I have error "Object is missing or does not exists".
It's look like my Access programm see just as read only or something like that.
Does anybody have idea why my Active X Control does not work on this PC?
Hi All
I have a small Help Desk db with tables that contain computer spec and user information. But I already have all this information in Active Directory and it seems pointless entering the information twice.
Is there any way i can get the database to lookup the information from Active directory i have no idea where to start.
Thanks
I have built an automated procedure in VBA Access 2000 that is now great (thanks to a lot of downloaded help from this forum). I use the MSCOMM active-x control to talk to an instrument via the serial port.
Question: Is that control only working because I also have VB6 installed on this same computer? It seems to me that I tried something like this a year ago and could not get MSCOMM to work in Access, but at the same time, I didn't have great MSCOMM examples to go by. I do now as I could rob them from other programs my company has written in VB6.
I have both VB6 and Access 2000, but chose to develope this procedure in Accesss because of the heavy amount of data to store (and I know VBA much better than I do VB6). I thought Access is a natural. But now I am wondering if I will have problems distriubuting this database to other service offices that may not have a machine with VB6 on it?
Do they need just plot MSCOMM32.OCX in to their system32 directory?? :confused:
I have added an Active X control to my form. The active X control is Inventor View which is for viewing 3D drawings. At the moment I can get it to work and show one particular drawing using a filepath put in the filename property.
However, I want to save the filepath for each record in the table and then change the filename property of the Inventor View to this according to the record that is open.
I have tried searching for similar threads but still can't quite get round it.
What data type should I use to store the filepath and how can I get it to change the filename property of the Inventor View control.
Thankyou in advance!
Hello,
I have a single membership table that contains two separate date fields,a "StartDate" when a member joins and an "EndDate" when an individual cancels their membership.
I would like to query this table to provide a list of active members between a given range of dates.
For example if the date is set to 1/1/06 through 1/1/06, I will get a list of all active members on that particular day.
Any help is greatly appreciated. Cheers.
Is there a calander that I can put on my form that will update to current date when I open form
Gary
I've been trying to animate in access forms by using active X controls but my access 2003 does not have Microsoft common control dialog version 6.0 and does not have microsoft animation control 6.0
theres .CAB file available from microsoft website but its self extracting not self installing so i wouldnt knw exactly which directory to place it
any ideas?
Apologises if the answer is out there somewhere but I have searched to no avail.
I have a number of Forms which the user can jump around from one to the next. All the forms remain open with the form they are currently viewing showing on top. If they make a change on one particular form then when they return to a previously viewed form I want to disable or hide certain certain controls etc.
I know this would be simple to do on the on open command but as previously mentioned as I am not closing the forms after they are viewed, if the user returns to a previously opened form then this is not picked up.
Soooo, basically I'm after something like
When the user moves from one form to another already opened form for the new form to immediately know that it now has the focus and for it to do something along the lines of on open.
Any help will be appreciated
Please can anyone tell me how to make this pages editable when displayed as a web page.
I don't know what property to set that would allow data entry.
hi all
I have a form that has invisible fields. Depending on the navigation to the form, those fields are turned on/off using the visible command.
However, the tab order on the form always takes the user to the first field visible on the form.
How can I tell access to default me a specific field first.
i.e. I have chosen to amend a training file via payroll number. I would like the payroll number data entry box to be the active field when the form opens.
Cheers
Please can someone advise me how I can link the date which I select in the calendar control to a date field in the form. I want to use the calendar instead of a combo box.
It's probably simple....but then so am I!
Help appreciated
Richard
I am working on a project where I need to monitor employees who are on vacation. I would like to run a report that would show employees who are currently on vacation, and those that have already returned. This is the information that I am looking to get from the report.
Search Dates: Entered criteria thru qry, msg windows asks for "start date" and "end date".
1/01/05 - 1/31/05
tblName
John Smith
tblEmployee#
1234
tblDate left (on Vacation)
12/25/04
tblReturn Date
1/25/05
Days on Vacation
31
tblName
Tina Roberts
tblEmployee#
1243
tblDate left (on Vacation)
1/25/05
tblReturn Date (If the employee has not returned it would give the "end date" and calculate the days on vacation)
1/31/05
Days on Vacation
6
This may seem simple but I just can't get the qry to show dates beyond the "start date" and "end date". Only those records that start within the two dates.
Any help wpuld be greatly appreciated.
hi,
when i select a button from the active control menu and want to use that button for either next record, previuos record. attach macro, print, i am sure that was part of the menu when selecting the button. i am not seeing that menu when i select the button from the active control could you please tell me why
thanks
steve
Hello,
I have a form to add data. I have a cmdbutton to output a shapshot of a report via e-mail. I have noticed that the shapshot does not capture the data I have just entered on the active form unless I don't first close the form.
Is there a way I can capture these active records?
Thanks.
I have created a form that will print the active report. I have managed to make it look for the active report, but it won't find it because there's no report active, even though I have the report open. How do I make my report be active when I open it? (In a way that whichever report I open will become the active window so that my form will e-mail the report that is currently open)
View 2 Replies View RelatedSet default controls comes as grayed out. I am in design view of form.
View 1 Replies View RelatedI know the is probably wishful thinking, but is it possible, and if so how, to link or create groups from Active Directory for use in Access.
View 1 Replies View RelatedHi,
I have an Access database built by someone else and I need to make a change.
The database works fine on the client machines but does not work on my Development PC.
What happens is when it starts up I get the initial program screen but when I try to launch any data form I get the title error messge.
However, It does however work on an older PC I have here (which has the same configuration).
I am running Windows XP with Office 2003 - this is the same thing that both the client and other PC have.
In general Access works fine on the new PC and there are no specific
Any thoughts on whats going on? I want to use the Development PC as the old one is very slow and has basically been retired.
Thanks
Please can someone tell me how to change the back colour of a control when it has the focus and then revert to the original colour when it loses it. I have 35 controls on my form, so I need a function, rather than changing the colour with a subroutine evey time.
I have searched the site and haven't found whatI want-though I'm sure this question has been asked before.
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