Hi
In MS Access:
Objects:
Tables
Queries
Forms
Reports
Pages
Macros
Modules
Groups:
...
I want to lock the Objects section, because I made the Groups in the groups section. How can I lock the objects section.
Please let me know, thanks a lot.
I need to lock and unlock a a few text fields with a CMd Button.
and i do know about the allowedits thing, but i only need to apply this to a few fields on my form.
can some one throw me a clue?
I have a switchboard form with a left menu bar similar to windows explore wi
th three sections (Configure, Tasks, Print)
How can I have each section collapsible like in window explore?
Can it be done through the VBA scripting in MS Access? If so can someone pro
vided examples?
Basically I divided each section to three parts
one part is the header which is an image and a label (name of section)
the second part is the button to click to hide/show the context of the secti
on
the third part is the text (labels that open other forms) with a background
image
something like this
http://www.viksoe.dk/code/collapsiblepanel.htm
http://www.viksoe.dk/code/screensho..psiblepanel.gif
but that will work with an MS Access form
Hello
I am using Access 2003(11.6355.6360) SPI
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.
Thank You
Rgds
Paul Langham
Hi there,
I'm trying to do a new membership database for a local group who take monetary subscriptions.
Basically, there's a form for creating a new member, with a few tabs - Contact Info, Payment Info, and one other.
Basically, in the payment tab, i've got a dropo down box to select the individual package from a packages table, another to select the payment term (Monthly, Annually), and a final one to select the payment method.
Now in there i've got a list of possible payment methods: Cash, Cheque, Credit/Debit Card, Direct Debit.
Now obviouslly, each payment method is going to have different requirememnts for what info the club actually needs. Cash simply needs amount of payment and date of payment. Cheque needs payment amount, payment date, cheque details. Card is obviously going to need the CC number, Valid & Expiry Date, Card Type, CCV Number, etc.
So basically, i want to be able to have the relevant section display when that payment method is selected from the Payment Method drop-down box.
What's the easiet way of doing this? Could i create another tab-set inside the payment tab, and then only display the one tab relevant to the selected method?
Cheers
Fatmcgav
Request from the higher ups to have several expandable sections in a form. Ideally only the title of the section would show, like when using a DAP, then the user could click and expand out the section and enter data. I tried the Tab option, but they are set on an expansion section.
Any tips on how to make this happen?
Hello,
I have not used access that much, but what I am looking to do is basically have 2 details sections within a report that will have different records in them.
I first used a subreport but that really did not work as intended. It left large gaps in between the records and just plain didnt work.
Here is a image of what I am trying to achieve:
hxxp://img379.imageshack.us/img379/9471/accesshelpnx9.gif
As you can see theres two different sections. One is for regular campaigns and one is for extended campains. There is a field in the table that has the extended date. For the compaigns that field should be blank or null and for the extended campaigns it is not blank or null.
Is there anyway to achieve this in Access 2003, if so can you tell me or describe me the steps?
Thank you!
Any way I can add more sections to my form? For example right now I have a section named "Header", "Detail" and "Footer". Can I add my own?
View 3 Replies View RelatedIs this possible? How?
View 4 Replies View RelatedI am currently building a database for the company I work for that is fairly similar to the Northwind Database; however it is made from scratch so hopefully some of the common problems with that database won't find their way into mine.My problem is that when I go to my Orders form, I pick a customer from the main form, which creates a record on the Orders table. When I then go to the subform to choose a product/line item, I get the error in my title ("The LinkMasterFields property setting has produced this error: 'The object doesn't contain the Automation object 'OrdersT.") as soon as a product is chosen from the drop down list.
View 1 Replies View RelatedThe error is:
The LinkMasterFields property setting has produced this error: 'The object doesn't contain the Automation object 'tblIndividual.' '
Then it also gives me the same one on another table.
I think it has something to do with the link master/child fields. I've tried all kinds of relationships with the three tables and can't figure it out.
I've tried uploading the database here but it won't. It's on my Sky Drive.
[URL] .....
I'm curious if anyone know's a way to access a specific data section on a tabular form. I'm attempting to have each section update a specific data item based on its position on the form, but am having problems since I do not know how to differentiate between one details section and another on the form. Any help would be appreciated.
Thanks
Using Access XP
I have a continuous form that shows the main fields in my table. In the page footer of the form I have a tab control that has 4 additional fields for each record. I want to give the user the option of “Show Details”. When the user clicks on “show details” I want to move the tab control with the additional fields to the detail row so the user can see them.
I know how to move controls with VBA by setting the Top and Left properties and how to expand the detail size, but how do I move controls from one section on the form to another section on the form i.e. from the page footer to the detail section
I have many reports that are structured differently, many are grouped by semester.
What I do now, is put a button on each grouping of the report I want to email from and use the current semester (Sem) which is also a query parameter to filter the report.
Here is my current code which works fine:
Sub EmailFromReport(rpt As Report, Optional Sem As Variant)
Dim db As Database
Dim qry As QueryDef
Dim rs As Recordset
Dim Bcc As String
Dim Subject As String
Set db = CurrentDb
Set qry = CurrentDb.QueryDefs(rpt.RecordSource)
'set query parameters
[code]....
The problem is, I need to be able to filter these queries on other criteria besides the semester.
My first idea was to use if statements to skip the records I don't want. This is messy and the report structures are different so I run into issues when using optional parameters because not all the reports are structured the same.
The best solution I have come up with so far is using a wherefilter parameter, stripping the semi colon off the querydef sql and surrounding the sql with a qrydef.SQL = "SELECT Email1, Email2 FROM (" qrydef.SQL ") WHERE " & wherefilter.
The problem is this, changes the original query, and I can't figure out how to copy a query with db.CreateQueryDef If i do db.CreateQueryDef("tempqry",qrydefSQL), I lose the query parameters.
Is there a better way to do this? If this is the best way, how do you take an existing query and make a copy of it?
I have quite a limited knowledge of MS Access (2007).
My question is; How do you use sections of one table in other tables?
For example: In tbl_One I input a users Name and Age and then say Weight, Height, BMI, etc.
Then in tbl_Two it uses the same Name and Age in tbl_1 but has other information such as Job, Skills etc.
This is not my actual database, however this analogy works, and they must be in separate tables, even though above they could all just be in a single table.
I have a database with a list of clients. One field is for their date of birth.
I have to report on equality and need to know how many clients we have within the following age groups:
16 - 24
25 - 34
35 - 44
45 - 54
55 - 64
65+
I have looked through the group and sort functions and cannot see anything obvious.
Hi,
I need to create a report for each employee in my company of all compensation information. The report is going to need to have multiple detail sections on the report for example to list all benefits specific to the employee and all beneficiaries.
I tried using a subreport to produce those detail sections that I needed but once I placed this subreport inside a box on the main report each detail I created increased the size of the box. I also thought about making the detail section a list box and writing all of the information there. Would there be a better or easy way to accomplish this?
I am also thinking I am going to have to save all of this information in a table and based the report on that table?
Any help would be greatly appreciated.
Thanks,
tones
i have a production database application in which there are many sections. every section's product stock is generated by running a complex query.
now when i want to add the result from different sections into a one combined stock , i could not design the query as it become too large and on running it produces the error "cannot open anymore database".
i think reason might be too many queries executing at same time .
so do i need to create a table from the stock queries of each section? and then add the tables to generate the combined stock query ?
I have a continuous form that shows the results from a query like:
Red
Red
Red
Green
Green
Green
Yellow
Yellow
And I wanted to know if I can some how highlight in a white/yellow alternating color like for instance starting with the three reds being white then the three greens being yellow then the two yellows being white and so on. Maybe through conditional format?
I found a post where it shows how to create a single collapsable/expandable section. I am needing to do this for 10 sections with a lot of information in between each section. The coding that this post provides does not seem doable for that many sections. How to create a collapsable/expandable subform?
View 1 Replies View RelatedI am redesigning an invoice format with access 2003 report.While coding in Microsoft Visual Basic, I realized that there are two drop down menus.
The right drop down menu has the sections as below:
Detail
GroupFooter1
GroupFooter2
GroupHeader1
GroupHeader0
PageFooterSection
PageHeaderSection
Report
ReportFooter
ReportHeader
The left drop down menu has options below.
Format
Print
Retreat
May I know where can I read up the purpose and use of different sections in the right drop down menu, especially "Report" section?
Are these sections in-build in Access 2003 or created by user?
I'm getting an error message (informational only):
The object doesn't contain the automation object 'ClientID.'You tried to run a visual basic procedure to set a property or method for an object. However, the component doesn't make the property or method available for Automation operations.
Check the components documentation for information on the properties and methods it makes available for automation operations.
This happens when I start entering data in the field "productname" of a subform.
So I'm assuming something in the form or in the code of the form is referring to ClientID. but I've checked it, and there is nothing referring to it anymore. Well, at least as far as I'm aware of.
This afternoon access crashed without any error, it just closed. Upon reopening the DB again, all my work of the past one and a half week was gone. Normally I always backup the data, but these past days I didn't due to christmas and still working a lot too. So I forgot.
I did some redesigning in the process this evening, deleting and adding some fields and code.
I can't get rid of this error. Can anyone help? Or point me in the right direction?
Also the DB is 3.5MB in size. While it is completely empty. And I can't imagine that some empty tables, queries, forms and a bit of code can be so much. But that's for a later time to worry about I guess, unless one of you says: this and that, maybe that works... Otherwise, I would really be very glad already if the error disappears....
I am creating an form in a database and whenever one of my procedure's run it creates this error message:
The expression ON Load you entered as the event property setting produced the following error:
Member already exists in an object module from which this object module derives.
*The expression may not result in the name of a macro, the name of a user-defined function, or [event Procedure].
*There may have been an error evaluating the function, event, or macro.
An ideas?
Form with three sections. I have three queries selecting different set of set in a table, I would like to show all three in a form side by side. How can I do this? I use form wizard bit it only uses one query as a source.
View 2 Replies View RelatedHi,
I create the datasheet form,
I know how to lock the field, but it lock the whole column of the field.
I want to lock the field except the last record field only.
Can I do that?
eg.
ID Field1 Field2
1___a______b
2___c______d
3___z
I want to lock the field2 except the ID=3
Please let me know, thanks.
My company has asked for an issue tracking database with the requirements that if is someone is edditing records it locks that block down until that user is done. I don't have any idea how to do it. my db is set up this way.
tables
tblPolls
tblIssues
Querries
qryPolls
qryIssues
qryFindPollsByID
qryFindPollsbyName
Forms
FrmFindPolls
FrmSearchResultsbyId
FrmSearchResultsbyName
FrmIssueTrackingMain
FrmIssueTrackingSub
The Form Issue Tracking Main has the Sub form IssueTracking Sub
Here users enter the issues in the sub form. The forms are linked by Poll ID
Is there a way to lock all the records with the same pollid in the tbltblIssues. Also to check who is editing them at the time?