Read Only Effect In Query...

Jun 22, 2005

Hello,
I'm having a little problem with an Access Query. Simple table design, with relationships as normal, using a junction table for a many-to-many link.

Table1
Field: Area (Text)
Field: T1_ID (AutoNumber)

Table2
Field: T2_ID (AutoNumber)
Field: Value (Double)

Table3Join
Field: Area_ID (Long Integer) *Rel: Table1.T1_ID
Field: Value_ID (LongInteger) *Rel: Table2.T2_ID

Table4
Field: T4_ID (AutoNumber)
Field: Area (Number) *Rel: Table1.T1_ID
Field: Description (Text)

Query1
Sources: Table4, Table3Join, Table2, Table1
Fields: Description, Area, Value

SQL:

SELECT Table4.Description,Table4.Area,Table2.Value
FROM Table2 INNER JOIN ((Table1 INNER JOIN Table4 ON Table1.T1_ID = Table4.Area_ID) INNER JOIN Table3Join ON Table1.T1_ID = Table3Join.Area_ID) ON Table2.T2_ID = Table3Join.Value_ID;


However, with this design as it is, I cannot "edit" the Description field, or change the Area field. The entire Query becomes read only. Why is this? And how should i re-write this to allow me to use the relationships which Link Table2.Value to the appropriate Table4.Area (and display them both in one query), while allowing me to edit all the sub fields.

Thanks
Jaeden "Sifo Dyas" al'Raec Ruiner

Using: Access XP 2002 (10.4302.4219) SP-2

View Replies


ADVERTISEMENT

Mouse Over Effect

Jul 4, 2007

Hello, I have two images (img1 and img2) and I want to have img1 visible when the form opens and when I run the mouse over img1 it changes it to visible = False and img2 is visible = True. Also when I mouse off the image it changes back to img1… How is this done? Thanks!

View 8 Replies View Related

If/Then Effect Only Current Button

Oct 25, 2005

I am trying to write code to change the color of the text on a button on a continues form. I only want the button for the specific record, that meets the requirements of the if/then, to be effected. The code below will change the button for every record if one record meets the requirements.

If Me.datPMDueDate = Date Then
Me.cmdAccessMaintenance.ForeColor = 65280
Else
If Me.datPMDueDate < Date Then
Me.cmdAccessMaintenance.ForeColor = 255
Else
If Me.datSMDueDate = Date Then
Me.cmdAccessMaintenance.ForeColor = 65280
Else
If Me.datSMDueDate < Date Then
Me.cmdAccessMaintenance.ForeColor = 255
Else
Me.cmdAccessMaintenance.ForeColor = 0
End If
End If
End If
End If

View 5 Replies View Related

Queries :: ORDER BY Statement Seems To Have No Effect

Oct 15, 2014

SELECT Count(Query1.Route) AS NumberofReRoutes, Query1.Route
FROM Query1
WHERE [Start Date] <= #9/30/2014# AND [End Date] >= #9/1/2014#
GROUP BY Query1.Route
ORDER BY "NumberofReRoutes" DESC;

The last line seems to make absolutely no difference. I can change it to ASC, or I can remove the line entirely, and nothing changes. I need these sorted by the NumberofReRoutes field, but this method isn't working!The output at the moment is two columns: Route, and NumberofReRoutes.

View 3 Replies View Related

Hyperlink Roll Over Effect On The Access Form

Nov 11, 2005

Hello,
I have a MS Access form with a few hyperlinks on it. I have tried to achieve effect similar to hyperlink roll over effect on a web page: when mouse pointer goes over a hyperlink it changes colour, etc.
Unfortunately, all I could find was MouseMove event:
Sub Label_MouseMove
Label.ForeColour=vbBlue
End Sub

But in this case hyperlink stays blue even after mouse pointer leaves it. And I would like hyperlink get back it's initial colour.

Thank you

View 2 Replies View Related

Textbox Values Not Valid Because Of Misterious Side Effect

Feb 26, 2007

Hello the problem I am having is that when I imported data from excel, it somehow placed carraige return at the end of the text box ( this is what I believe), this is a problem because in that field is a drop down box and it complains about my value not being valid. I press the del key behind the value and it doesnt complain. Can anyone help me?

View 1 Replies View Related

Tables :: Change In Sharepoint List Not Taking Effect?

Jul 24, 2013

I am importing data from a sharepoint list on to Access 2007, as linked data where any changes I make on Access is made to the list and vice versa. However, I recently made a change to one of the column types and this change is not being made on Access. I have changed a column type from choice to single line of text but I still see the list of choices when I access the list on Access 2007.

I have refreshed the list by right clicking the linked list and pressing refresh list. The list is set to not cache the list and is not set to work offline so cannot see why the change is not being made. I don't want to mess with the list be removing it and re-adding it as I have multiple queries set up which are being fed in to an excel file I use to create reports from the data. I have no knowledge of VBA, so there is none of that being used on Access.

View 1 Replies View Related

General :: Effect Size In Multiple Linear Regression

Jul 4, 2012

I have (from SPSS) many multiple regression analyses, and each one of them has about 7-8 independent variables. I need to find the effect size-in particular I want to have effect size above 1% and statistical significance p<0.001. I am familiar with p, but I cannot understand whether effect size is b, beta or R square and how to interpret it.

View 1 Replies View Related

Forms :: Strange Font Effect While Running Through Records

Nov 28, 2013

It is a strange effect I get when switching among records.

In a form I have a TAB Control with some pages, when I open the form everything is ok:

But, when switching continuosly among records, the font becomes strange, looking like being bold.

It seems to happen only when using TAB control or, if you prefer, only on every TAB control's page except for the first one. Tried on different pc with different resolution.

View 2 Replies View Related

How To Revert Query From Read Only.

Nov 27, 2006

Hey

I'm having trouble reversing my query from read only. I set the query to read only at first and then decided to reverse this process. However, when i switched back to rewritable mode, the query still dosen't let me edit, add or update data.

Why is this so?

Thanks

View 1 Replies View Related

Read Only, Can't Change Records In Query

Jul 26, 2005

Ok, been puzzled by this one.
I have a form with a subform in it. The subform is based on a query. It shows all my active staff. On the form i have a button that (atleast i would like that it does that) when clicked it sets the field "selected" on true on the subform.

The code behind the button works just fine, but i always get an error stating, can't change data, database or object is read only. Funny thing is, when i click on the checkbox "selected" in the subform behind each staff member, i can set it to true. Why does it not work? I tried it with selecting the query itself (qerWerknemersActief instead of tblWerknemers) and also not working. Here's the code, hope someone has a clue. Oh, in each form everything is set on yes except adding records, so it's not that change records is set to no.

Dim db As DAO.Database
Dim rs As DAO.Recordset

Dim strSQL As Variant


strSQL = "SELECT tblWerknemers.Id, tblWerknemers.Werknemer, tblWerknemers.Selectie, tblWerknemers.Actief " & _
"FROM tblWerknemers " & _
"WHERE (((tblWerknemers.Actief)= True));"


Set db = CurrentDb

Set rs = db.OpenRecordset(strSQL, dbOpenForwardOnly)
Do Until rs.EOF
rs!Selectie = True
rs.MoveNext
Loop

rs.Close
Set rs = Nothing
Set db = Nothing
Call Form_frmBeheerDeelnemers.Requery

View 6 Replies View Related

How Do I Crete Read Only Fields In A Query?

Mar 6, 2007

My problem is as follows:

User group 1 enters information into a table via a form.

This information then needs to be signed off by user group 2. I have created a query which shows the information in fields 1 to 10 which I want to be protected so they can only view this and not edit it and then have a couple of fields at the end where they can enter their name and any comments.

Simply my question is can I have a query with some protected fields and some un protected or is it one or the other? If this is not possible please suggest an alternative.

View 2 Replies View Related

Query Criteria Read From Table

Dec 6, 2011

if there's a way to apply a list of items as criteria in the order listed? Say I've got a list of sales reps and I want a macro to run a query repeatedly, populating one rep from the list at a time in a field called Sales Rep.

View 8 Replies View Related

How To: Access 'Query' Screen In Read-only Mode

Oct 25, 2007

Hi to all,

I would like to ask here for advice on MS Access 2000 application.
When a user logs in, he should be able to use the Access 'Query' screen in read-only mode. In other words, he should be able to generate queries by selecting tables and columns, or using the wizard, but the results of those queries may never have any influence on the data in the database. So: SELECT queries only.
Users should be allowed to execute those queries, but are not allowed to access the tables, forms, or any other items directly.
Is there a way to achieve this?

Thank you


Ori

View 1 Replies View Related

How Do I Update Data Related To A Read-only Query On A Form?

May 22, 2006

Hi all, I'm so tired of looking... please help me!!

I have an Access Data Access Page based on a query which is not updatable.

The query is based on a many-to-many table (e.g. OfficeProducts with foreign keys for OfficeID and ProductID and an Amount field). The query is not updatable as I have included outer joins to the Office and Product tables to get all their records back.

(I'm not sure if I've done this the best way, but need to be able to list all the possible Products for each Office whether they use them or not.)

I want the user to be able to update the Amount field, so e.g. if it is currently set to 50 to be able to change it to 40, or if it is currently null (as there is no record so far for that OfficeProduct) then to insert a record into OfficeProducts with the OfficeID, ProductID and Amount value entered.

I thought this would be straightforward by creating a new textbox in the same section as the current Amount field, calling it NewAmount and letting the user update this, fire an event trigger to either update or insert into the table, and refresh the query and record on the form/DAP so that Amount shows the newly updated/inserted value.

I have been searching for ages... cannot locate either the best event or events to use for this nor the code to enter!! Please please help!!!!!
(This is actually for a charity helping people suffering from emergencies in developing countries, not OfficeProducts, so your spot in heaven will be reserved if you can help ;) Thanks)

Jen

View 4 Replies View Related

Queries :: Query Will Not Read String From (dummy) Textbox

Aug 25, 2013

I have a two-column list box where the user selects multiple Test Names and Test Measures. Through VBA, I loop through and create a string of the selected items and store into two seperate variables, one for each column. I concatenate with the "In" and some parenthesis to end up with the following:

In(ELA,MEAP,Star Math)
In(DRA, Math, PercentileRank)

I place each of the In statements into two seperate dummy text boxes on the form. Then I point the query criteria to these text boxes.

When I run the query, I get nothing. However, if I copy and paste the In statements above from the text boxes directly into the query criteria, I get the desired results.

I changed the code to create an "Or" statement (e.g. "ELA" OR "MEAP" OR "Star Math"), but still the same issue.

why the query will not read from the text boxes on the Form?

View 4 Replies View Related

Queries :: Updating Dates - Query Turned Read Only

Mar 28, 2014

I have a query that i use to update dates relating to jobs and at what stage of development they are in. It worked fine until I started to pull in some data (Prism) to update the user when the project is planned in to sample and when mass production starts (the field this is displayed in is not enabled). when I've incorporated this it I have no longer been able to update any field and my query has turned read only.

SELECT dbo_NPD_Container.PENumber, dbo_NPD_Container.JobNumber, dbo_NPD_Container.ProjectTitle, dbo_NPD_Container.Status, dbo_NPD_Sales.InitialQuery, dbo_NPD_Sales.InitialQueryDate, dbo_NPD_Sales.SpecificationIssued, dbo_NPD_Sales.ApprovalRecived, dbo_NPD_Sales.TuDrawIssued, dbo_NPD_Sales.TuDeliveryDate, dbo_NPD_Sales.TrialRequestIssued, dbo_NPD_Sales.SampleDate,

[Code] .....

View 2 Replies View Related

Modules & VBA :: How To Export A Query To Excel If Access File Is Read Only

Feb 26, 2014

I have an access program that is stored on a SharePoint site. I want to be able to export report to the computer even if I just open the access program as read only. Here's my code:

Code:

Private Sub btnExport_Click()
On Error GoTo btnExport_Click_Err
Dim db As DAO.Database
Dim strSQL As String
Dim qdfTemp As DAO.QueryDef
Dim qryFilter As DAO.QueryDef

[code]...

View 2 Replies View Related

Cannot Be Read: No Read Permissions

Dec 19, 2007

I have a brand new database in-the-works that is causing me headaches. For some reason, if I create a query and then exit and re-enter the database, I cannot re-open that query. I get an Error 3112 (cannot be read; no read permission on <name>) and to contact the administrator or creater of the database.

I'M the creator and the administrator on this thing - so why can't I get into the darn thing? I haven't added any security features. This has never happened before on any database I've created, so obviously, it's frustrating.

Any ideas?

View 3 Replies View Related

First User Allow To Read And Write / 2nd User Only Allow To Read?

Sep 2, 2014

Will like to check, i have a access database which can be open up by a few users.

How can i only allow the first user who open up the database to read and write the database and the follow users who open up the access have only read access?

View 4 Replies View Related

Read Only...help!

Sep 20, 2005

I've just attempted to develop my first Access database which I've tested and seems to work well. I've copied it to use at another location but can only open in "read only", eliminating the ability to do further development or editing. How can I copy or open this database at another location?
Thanks,
EP

View 2 Replies View Related

Read Only

Nov 3, 2005

How can I provide "read only" access to a specific user?

View 1 Replies View Related

I Need Some Help! Please Read..

Jun 30, 2007

Hi All

Pretty new to all this Access stuff but have to know how to do it for work! Doh! So heres what im trying to do...

We have a database in work that we keep all our info on our clients, but it is very out of date and the questions do not correspond with the answers we recieve from clients now etc.

I've started making up a new database as we are unable to change/edit the old one as the person who made it, left no note of the password!

I've created a switchboard page to direct the people to the specific parts of the database (e.g. there is one set up with a query to find people on a waiting list and all they do is click that and it displays their details).

Im wanting to make up a bit that you can send them out a letter, like we have set up in work. What happens is we click the button to 'Send Appointment Letter' and it goes into another sub-switchboard sort of thing and we pick what kind of letter ie first appointment, second appointment etc.

What I need to know is, how to narrow the letter down to a specific date. ie, in work a dialouge box comes up asking me to put in the date the person has their appointment on and then it displays a Report (I think) in Access which is in the shape of a letter with all their details on it including name address appointment time, date and venue.

I want to know how I would first of all:


Create the Report?? if thats what it is for the letter
how to put their information into the letter?
how would i find i get the dialouge box to come up and ask me to input the date ?


Im really quiet unsure and would really appreciate some help!
Hopefully someone out there actually knows what I mean lol!
I've got plenty of more questions by the way. If you can email me your answers please at jamesy.higgins@ntlworld.com. If you would like me to send you a copy of the database to try and work out how to do it, dont hesitate to contact me. I will email it as it is too big to fit on this post (500kb) Doh!

Please, if anyone could help me that would be great. Just even if they try and do something to it and send it back to me?

Anything is worth a try:confused: .

Thank you !

View 1 Replies View Related

DB Read-only?

May 9, 2007

So my problem is this,
when I wish to add users to my db through asp
I get an Eror message that says I can't update
because the db or object is defined as read-only
but when I checks it, it's not a read-only.

please help. T_T
this is important for my internet test at school.


I forgot to add that I looked at other threads
and I can't seem to understand..
I don't have a security tab in proporties

View 4 Replies View Related

Read Only Databases

Aug 9, 2005

Forgive me if this is in the wrong forum, so MODS, do what you will.

I'll come out and admit it right now, I'm a newbie here and have just started using Access2003. I'm in a city government so I need other users to be able to view and access my database, BUT I don't want them to be able to edit or change things. I want to be the Owner/Administrator of the database and no one else. I want to be the only person that can make changes.

Is this possible in Access 2003? Can other users only open it in Read-Only format but when I open it, it's editable?

Any info would be greatly appreciated. TIA!

--Adam

View 2 Replies View Related

How Does This Works? Please Read

Aug 23, 2005

There is an Access application somewhere in shared drive.

100 users open this application using a batch file which copies this database on their c: . They start using this database and the master database gets replicated real time. I am not sure if all the database are replicated as it is copied everyday ( so that each one of them has latest version of the application )

Is it possible ( I know it is :) ) but i am not able to figure out how it is happening.

Please help :confused:

View 2 Replies View Related







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