Hi,
can form objects be grouped? i currently have numerous buttons on a form that are shown according to a button selection. my current code makes all buttons visible / invisible singularly but i wiondered if they could be grouped/ named and the get the code to make the group visible / invisible?
many thanks,
NS
If my database gets quite large is there a way to create various groups under the Queries object? What about Reports, etc?
For example, within Queries, have qryGroup1, qryGroup2, etc.
What about color coding queries?
Hello,
I was wondering...i put a microsoft doc in an OLE Object and in Pages or Form, i'd like to call the object to open up. So if i have a word doc stored in the OLE, i want that word doc opened up using a hyperlink or command button of some sorts, is there a way to do it????
Please help,
Thank you in advance!
Is there a function that allows you to select all of the form objects.
What I want to do is to select all the form objects...have the user select a # from a drop-down list. Then set the font-size property to all of the form objects to that #. Does that make since?
Is this possible?
I was wondering is anyone could help me with a problem thats been vexing me all day..
I have an Access database that has a number of Word documents stored as OLE objects. What I need to do now is create a macro within Word which, based on a few parameters, retreives these Word Docs from access and formats them into a completed document. The ordering and formating bits fine, where I'm stuck is getting at the OLE objects.
Can anyone give any advice on a possible solution?
Thanks, D
Hi Guys,
This might be very simple but this driving me crazy...
None of the objects created on my form are appearing in Form View mode but I can see all the objects in 'Form Design mode'. I checked the properties of the form and all other objects to make sure 'Visible' property is Yes. Any help to solve this is highly appretiated.
Thanks in advance.
binjos
Note: This is happening to the new forms too..
Hello,
I am a novice when it comes to the MS Access interface. My experience has been designing the database and then using ASP pages to query, update, etc. I am now in a new position where I have to modify a switchboard to point to other data sources (i.e. databases) who have been renamed. My problem is that when I open any of those databases all I get is a form (switchboard) that has links to reports. It appears to my novice eye that the switchboard is the only thing that exists within the "main" database and it points to other databases -- when I open those databases another switchboard comes up and I still cannot view the database objects. I hope this makes sense -- believe me, I am attempting to understand this all.
I hope someone can explain to me what's going on -- there has to be a database that I can open and see actual database objects by going to the top menu bar and selecting, "View --> Database Objects --> Tables, Queries, Forms, etc.
Please help!
Thank you!
:confused:
Hi!
I want to display 8 thumbnail images at a time per form of records that matched a search critera in a form. But it seems like a form is suppose only to have one record at a time? I want to have a "next 8 thumbs"-button so it gets easy to browse the pictures.
I'm very thankful if you could help me with this! Please give me some advice.
Thanks!
Best regards
Johan
I am looking for an easier way to confirm that all a queries that are in a database are being used by the database. I started going through each and every one and it is taking for ever!
I have tried the documenter and either I cannot understand it properly or it does not contain the information that I am looking for.
An example might be I have a query called qryOne. I want to see where it is being used so I am looking for a “list” that says
qryOne = rptOne
qryOne = rptSix
qryOne = rptEightySix
Obviously these are just made up names, but I hope you understand what I am looking for. In essence a relationship table for queries, forms and reports.
Thanks for your help
Any ideas on how I can get a list of the names of the queries and tables within a different database?
For example, from db1 I want to get a list of the names of the queries and tables within db2.
Thanks!
Is it possible to loop through all forms within a project and look at its controls? I was requested to change some object names to a more generic name, but I would like to find all references of the form within the Access application. Is there an easy way to do this?
I know that the MSysObjects contains the listing of all forms, but I don't know how to generically type cast a local variable to the form name listed in the table.
Does this make sense? There has to be a way to do this, but I haven't found anything in searching this forum.
Thanks in advance.
CHuck
We have an Access 2000 db, which has been used for some time and is split between a front and back end. We've come in today and tried to open the back-end, which contains only tables, and when it opens it's completely blank. We can't see any of the objects or the normal menu to access the tables, queries, etc. We can, however, import the tables into a new database, so they must be there.
Any idea why this has happened or how to stop it happening again.
Thanks.
Im unable to create an MDE file, access keeps trying and then saying that its unable to create MDE.//// Is there any other way that I can secure both my codes, forms, modules and macros from being imported into another database since I cant create the MDE file?
View 6 Replies View RelatedHi
Is there a way of finding duplicate field entries in a table and a query: e.g.
In the Sickness Query (which contains, say 10 fields), in the Section field, it says "Benefits", and in the Week Commening field, it says "15/10/06"
And then
In the Nil Return Table (which only contains the Section & Week commencing fields), they also say "Benefits" and "15/10/06"
If there is a way of finding them, how do I delete the entry that has been made in the Nil return table?
Thanks
Maria
I would like to know how to do the following:
Query 'X' is a sum query.
How do I determine which other queries use Query 'X'
I want to make some changes to Query 'X' but I want to be sure of which other queries will be affected.
Thanks
Is there an easy way to change the font-size properties of all objects on a form?
I guess the first part of this question is there any way to all the form objects at once? (without making reference to each one individualy)
This may be a fairly simple answer (and I hope it is, I really do) but I'm coming up empty searching through manuals and whatever google has on the issue, so I'll toss it out here in hopes that someone can help me.
Is there a way to add a "browse" button or something similar to an Access form field intended for files (word documents mostly)? I'm developing a process management database fror my office, and while I can master the whole "right-click-insert-object" thing, it's really more than the non-technical types in my office are going to be able to muster. Appreciate any help!
Hey guys and gals, im in dire need of help!
I have a table with two fields. A name field where I have a bunch of unique numerical data and an object field, which contains unique pictures.
I am wondering if it is possible to create a form where I can display say ten pictures (I'm assuming as bound objects) and have each of them display a different object from a different record?
Or in other words can I have one bound object displaying a picture from one record, and a second bound object, displaying a picture from a second record, on the same form?
I have tried searching for everything and any little help would be much appreciated!!
Cheers
Robbie
I wish to in a subform where you can enter a image for a item.
How do you go about having a box you click, find on your HD the image and then have it display for that record you select?
I am doing bug and enhancement development for an existing Access Application.
Periodically (after testing) I need to take my changed objects and export them to the production database.
My problems are:
1. Is there any easy way to tell which objects have been changed (is there any flag I can set at the beginning of a development cycle and then check to see which objects have been changed)
2. When exporting these objects they don't replace the existing objects in the Production Database they add a new object with the number "1" appended. If there was a form called "fCustomer Input" I end up with a new form called "fCustomer Input1"
This problem must come up with other development efforts.
Help
Thanks
hi,
I am doing a project in vb6, ado(adodc) with backend access
2000 in which a field is ole object i.e. picture of employee. the problem is I could not link this field from vb form. Pl guide me
the methods,procedures and codes (this is my first project) I can
extract other fields such as name,address,telno etc. thanks-rk
When the Switchboard comes up for my program (called SIR) there is also the typical access icon on the status bar. The problem is that there is a second icon labelled "SIR : database" which allows access to the Objects (ie. forms, reports, tables, etc.). Any ideas how can I eliminate this? Thanks ahead of time!
View 1 Replies View RelatedHi all
I'm looking for a way to update forms, reports, queries etc... by exporting them to another database with the same objects.
Essentially, I'd like to export only those forms etc... that have been modified according to the mofified date.
Any ideas are appreciated.
Hi to all you database wizards I have a problem, it is as follows
I have just put a command control onto a form and this is what happens. I type
Docmd
to this point all is ok. now when I put the .(dot) after Docmd
Docmd.
it changes to
Docmd.
the drop down box opens for about 1 sec then closes and I now have Docmd. in a red color and with no drop down box with the listed objects
Anything that I type just comes out red until the code line is finished, then it reverts back to black print and blue on the objects words
your help will be appreciated
Jabez
I currently have a small database where users input information on return parts. I have added a section to add data from testing and have made it so it greys out certain boxes when the part type is selected using conditional formatting. However conditional formatting will only allow either a data box (Text box) or the label attached to it to be formatted. I am unsure of how to grey out perhaps a rectangle I created when the part type is selected. I assume its coding which I am not the best at.
View 1 Replies View RelatedhI
I am trying to refresh an UnboundOLE objects Source Doc property through code. Basically, I have a dropdown on my form that contains a list of images (c:image.bmp, c:image2.bmp, etc..). I have added an unboundOLE object to my form that is linked to an image file with a Document Source property set to C:image1.bmp. I am trying to have the image (OLEUnbound Object)update when a user selects a different image file from teh drop down. I have put some code on the update and change events of the drop-down combo box but it doesn't seem to do anything.
Dim StrSourceDoc As String
StrSourceDoc = me.combo1.value
Me.OLEUnbound32.SourceDoc = StrSourceDoc
Me.OLEUnbound32.Requery
This does not seem o do anything
aNY iDEAS ?