Inventor View Active X

Nov 20, 2007

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!

View Replies


ADVERTISEMENT

Active / Live View Of PDF File In A Form

Aug 18, 2014

I have a table with 4 Fields:

Drawing Number
File Link

Attachments
Description

I basically want to have a live preview window of the "File Link" attachment in that current record. I have heard it's best to use a Web Browser Control when doing this, but I cannot get it to display the currently attached pdf file in that field of that record.

Is there a way to edit the link properties of the Web Browser Control so that it dynamically detects. The file location of the attached file in that field? There will only ever be one attachment in that field, as this will be a live pdf view of the drawing to which that drawing number was assigned

View 1 Replies View Related

Forms :: Text Boxes Showing In Design View But Not Display In Form View

Apr 19, 2014

I have a Form which I have linked correctly to a subform. The Text boxes are showing in the Design view but are not when one switches to the Form View. Labels for Fields are visible in the Form View. Have even created a new subform and that will also not display the Text Boxes.

View 1 Replies View Related

Forms :: Unable To View Object Properties In Form Design View (Access 2010)

May 16, 2014

Why the ability to view the properties of an object within a form is not available when you double click on it in design view?

I was happily working away double clicking on a command button to edit some code when for some reason the next time I tried to edit it did not open up for me.

I was unable to access it even by right clicking on the object & selecting properties as that also appears to be disabled, not greyed out or anything but just does nothing when selected.

Have I inadvertently changed a setting somewhere that prevents the properties from being displayed?

View 3 Replies View Related

How Do I Show The Subform As Form View Instead Of Datasheet View :confused:

Jul 19, 2007

See title :)

I have seen that in some sample db's rightclicking the mouse showed the menu with an option to check or uncheck the dataview option, unchecked the formview was applied, but when i 'just' import the subform, i cannot find somewhere the possibility to change from dataview to formview.

Maybe someone can help me with this, probably very simple(?), question?

View 4 Replies View Related

!!??? All My Forms Are Blank Under Form View - But Fine Under Design View!!!

Jul 13, 2006

Anybody ever heard of this before? I open a form, and it is empty, just a blank window. I open the same form in Design View, all appears well. :mad:

View 2 Replies View Related

Field In Design View Not Showing In Table View

Jul 2, 2007

I have a table called NewTransactions_tbl that I have been using for some time. I am trying to add a new field called CustomerProjectNumber. It's not being displayed when I look at the table view. I've attached an image showing the settings for the field. I am probably missing something obvious.

Any ideas why it is not showing?

I am using Access 2000.

View 7 Replies View Related

Forms :: No Filters - Cannot View All Records In Form View

Aug 27, 2013

I have 4 tables and around 440 records but can only view up to 417 in the form I have designed. I have been adding new records via form and it has been added to my main table, but when i try to view it in form view - the record is not available to view. What do I need to do to correct this problem?

I have checked that there are no filters, data entry is set to No, Auto deletions, additions and edits are set to yes.

Also to mention it seems that the problem has arisen since I set up some new queries, there is a one to one relationship between the tables!

View 1 Replies View Related

Forms :: From Pivot View To Filtered Datasheet View

Nov 14, 2013

I want to "zoom" to the underliyng data from pivot view. When in excel someone doubleclicks a field in a pivot table, it automatically creates a table containing all the lines that field were made up from. I want to achieve the same behaviour in Access.I started to think towards a VBA coda, that could be initiated from the form's double click event. It should go to datasheet view with the prpoer filter criterias.

View 1 Replies View Related

I Want Datasheet View... Why Does It Keep Showing Form View?

Apr 6, 2006

I have a form which is opened with a filter from another form. For some reason it views the form in form view, although it was set up as datasheet view. I even went to the form properties and the default was datasheet and i made it not to allow other views. This still didnt solve it. I want it to be in datasheet view because i want to show multiple records at the same time.

If u kno how i could resolve this please offer ur help

thanks

View 6 Replies View Related

Go To Active Subreport

Apr 6, 2006

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 Related

Too Many Active Users

Mar 9, 2008

Hi 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.

View 10 Replies View Related

Active X Controls

May 3, 2005

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?

View 2 Replies View Related

How Can I Get The Name Of The Active Subform

May 23, 2005

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

View 5 Replies View Related

Link With Active Directory

Apr 26, 2005

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

View 1 Replies View Related

MSCOMM Active-X Control

Jul 22, 2007

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:

View 6 Replies View Related

Selecting Active Members

Jan 18, 2007

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.

View 2 Replies View Related

Updatable Active X Calander

Mar 9, 2005

Is there a calander that I can put on my form that will update to current date when I open form

Gary

View 2 Replies View Related

Missing Active X Controls

Apr 28, 2005

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?

View 1 Replies View Related

Identifying The Active Form

Jan 17, 2006

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

View 8 Replies View Related

Active Data Pages

Jan 20, 2006

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.

View 1 Replies View Related

Active X Error On Subform

Feb 13, 2006

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?

View 1 Replies View Related

Make Fields Active

Apr 3, 2006

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

View 3 Replies View Related

Active X Calendar Control

Mar 2, 2005

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

View 11 Replies View Related

Active Records Between Two Dates

Mar 20, 2005

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.

View 6 Replies View Related

Active Control / Button

Mar 5, 2008

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

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved