I want to add a form that will let me take a clients unique Key and change it to the # that i want and with the click of a button have it cascade to all the other tables. with relations ships set it wont let me make any changes. any ideas on how to tackle this.
View RepliesI am trying to change the button color on a subform if a related form data changes.Main form is products with a continuous subform with serial numbers of products i.e, serial number, location, price and a button to add addtional issues if there are any for this particular serial number (this will open up another form related to the serial number so I can add an issues if there are any).The reason I would like the button to be a different color is so I can quickly see if there are any additional notes been added to the serial number. Just in case you may ask why not add the field to the continuos form is that the issues and be quite lengthy and there may be lots of serial numbers on the form
2346 location warehouse price 29.99 (button - green)
2347 location shop price 29.99 (button - red)
I have not done much work in later version of Access. Now I found if I change a design in one form and similar forms (names are different) which are linked to the same tables got changed as well without openning them up and making changes. Is this something new with Access 2003?
Thank you very much for help.
What I want to do is following.
In form ASSIGN(fields are takedate and inout) ,if TAKEDATE is different then 0 then set value of inout field to 1
My VBA knowledge is poor cause i dont think this should be hard
thanks in advance
Is it possible to switch log on
ie from within a db, opened as one username and password decide want to run db as other user , rather than close the db and reopen it (entering new usrname and password) , can I build a form where you just enter the new username and password, and continue running the db as the new currentUser?
Thanks Paul
Hi, hope someone knows the answer to this one...:p
We started a new business and built a db for expecting our work to happen a certain way, but now find it's very different and need to change the structure before it's too late to fix. Can someone please take a quick look at this idea & tell me if it's likely to cause major problems down the road?
People send in applications for specific groups/clubs. We thought they would arrive separately, so we set it up to enter each application and then add them to the Group listing one by one. TblApplication is a many-many with tblGroup, with junction tblGroupAppl. (People can be in more than one group.)
As we go along, however, we are finding the opposite: all the individual applications are being sent together by the club and so now we could actually turn this into a simple 1-many with tblGroup as parent and tblApplication as child. It seems like it would be much easier with queries and such if that extra step could be eliminated.
If I go through and put the GroupID on each record of tblApplication, can you see anything I might be inadvertently wrecking with this approach?
Any ideas/suggestions would be most appreciated!!
Thanks, this forum is amazing.
I am using access 2003 and have a database with over 1500 rows
I have many queries and reports relating to this database
One of my agencies changed their name and I want to know what is the best way to change the name in the whole database, including queries and reports
Hi,
I have a form with a subform that is set to continuous.
I have a field [Info][.RemovedP]. What i want is if RemovedP = -2 then i want the bg colour of JUST that record to be changed.
The default is blue, so what i will then get is blue bg for all the records accept if the RemovedP ='s -2, it will then be red.
Hope this is clear enough.
Thanks
k0r54
Hi,
I have a form with 6 field boxes - What I want to do is - on change of any of the fields value will change the background colour of all the fields in that record.
When I go to the next record all the fields will be their original colour until I change the value in any of the fields again - however if I am browsing the records - no colour change takes place.
I do not know how to code this:confused: - I would appreciate any clues to solve this.
Many thanks
Cliff
Hi all
Is there a way to capture all my changes to a database into some kind of change log??
Just wanted a little help please. I have about 100 option boxes on a form and I want to be able to change the names of the option box and its label. I want to name them from 1 to 100 sequentially. (i.e. option1, option2 ...).
When I create the controls it automatically names them option0, option2 etc. and label3, label5 etc.
I was going to change them via some code but I don’t know how to refer to a control in a form from design view.
Can anyone help please?
Thanks
Red
I need to change the reference "Microsoft Access 9.0 Object Library" in Access 2000 with the "Microsoft Access 11.0 Object Library" but I can't de-select it 'cause it's used by the program. Another problem is that I tried to import the 11.0 copying the file and when I select it from the panel control it seems to import without problems, but when I search it in the list, the 11.0 doesn't exist.
How can I import it?
I have a basic question
I want to change the forecolor of a text box when another text box or possibly a Yes No box is true.
Can you tel me the correct way to code this.
How would I go about changing the primary key to a different field in a table? :o Thanks for any help!
View 2 Replies View RelatedHi
This is going to be very simple so someone !!!
All Iwant to do is change the name of my database.
Currently it is called 'Test' and I now want to call it by the proper name.
I have changed the icon name that is displayed in Windows Explorer and also on all the forms within the database properties window.
However the name 'Test' still appears at the top of the main Access window!!
How do I change this so that it says the new name?
Any help would be appreciated.
Thanks.
How do I reassign a new PK for may tables.. they're already related and there about 2,000 records on the Main Table and like 6000 records on the related table.... I used a wrong PK and I want to create a new (long Integer Auto-Number) but I don't want to lose what I've done already.
View 7 Replies View RelatedI am creating a database that is going to import excel files once a week. Most of the data will be the same every week, but some may change slightly or new records may be added. I need to create a query that will show all the changed/new records that are imported from the excel file. i would prefer to use as little code as possible if at all. I am pretty much a novice when it comes to queries so any suggestions would be appreciated.
View 1 Replies View RelatedCan you help me.
I have about 2000 records with Part Number XXXCOGxxxxx. This Should be C0G. Ex:
SPN
RPE122COG101K
RPE122COG681K
RPE122COG101K
RPE122COG681K
GRM40COG100J
GRM40COG100K
GRM40COG101J
GRM40COG150J
GRM40COG220J
GRM40COG221J
GRM40COG271J
GRM40COG470J
GRM40COG471J
GRM42-6 COG100J
GRM42-6COG220J
GRM42-6COG472J
What to write a query to change just the COG portion. Can you tell me the formula?
Thanks
Chris
Hi:
In SQL:
How to change the variable name?
For example:
query1:
I have a input, which is [Please enter the value 1:]
Then,
I want to use this query, but different values.
I want to put [Please enter the value 2:]
In SQL, how can I write?
Select [Please enter the value 1:] As v1, Please enter the value 2:] As v2 from combine
Union
Select * from query1
Union
Select * from query1 where [Please enter the value 1:] = [Please enter the value 2:]
Hi
How is it possible to change row in query column title?
I have query which look like this:
[number] [start time] [end time]
1224345 12.6.2007 13.6.2007
I want that my query should look like this:
[number] [start [end
time] time]
1224345 12.6.2007 13.6.2007
Hi,
I have an option group on my form. In my query it uses numbers like 1, 2, 3 and so on.
Is there a way in the query to show say Done where 1 and Not Done where 2 and so on.
On my reports I use the following
=IIf([Status]=1,"Not Satisfied",IIf([Status]=2,"Partially Satisfied",IIf([Status]=3,"Satisfied",IIf([Status]=4,"Waived",IIf([Status]=5,"Client",IIf([Status]=6,"Attorney Consult",IIf([Status]=7,"Attorney Approval")))))))
I am exporting the data to EXCEL and the numbers mean nothing to the end user they want to see what it represents.
Thanks.
Fen How
The DB this info is pulled from stores the NAME field in all caps.
My query returns the name like= JAMES JONES
Is there something I can do to change the name format to James Jones?
SELECT
[OPEN CASES].CASE,
[OPEN CASES].[MEMBER#],
[CLIENT TABLE 2].NAME,
[CLIENT TABLE 2].A1,
[CLIENT TABLE 2].A2,
[CLIENT TABLE 2].ADD INTO [MEMBER CASE TABLE]
FROM [CLIENT TABLE 2] INNER JOIN [OPEN CASES] ON [CLIENT TABLE 2].MEMBER = [OPEN CASES].[MEMBER#]
WHERE ((([CLIENT TABLE 2].RELATION_CODE)="C")) OR
((([CLIENT TABLE 2].RELATION_CODE)="S") AND
([CLIENT TABLE 2].MEMBER_CASE_STATUS)="A"))
ORDER BY [CLIENT TABLE 2].ADD;
In the form that I am working on, I have a number of text boxes that are filled with a query telling me which people are scheduled to work a shift. I also have a text box (I may need to make this a sub form, but would prefer not) where I want a list of all available employees for the specific shift to show. When I click, I want to see the list, so that I can make changes if needed and only chose those employees that are available for the shift.
I have:
Private Sub Ctl8a_4pb_Click()
Me!txtAvailEmployees = "SELECT tblAvailabilities.Date, [First]+" "+[Last] AS [Full Name]
FROM tblAvailabilities INNER JOIN tblStaff ON tblAvailabilities.EmployeeNum = tblStaff.EmployeeID
GROUP BY tblAvailabilities.Date, [First]+" "+[Last], tblAvailabilities.Shift1
HAVING (((tblAvailabilities.Shift1)=-1))
WHERE tblAvailabilities.Date=[form]![frmScheduleEdit]![CalDate];"
End Sub
I get a syntax error. Is is even possible to pass SQL in a manner as this?
If it is, where would I be messing up?
Greetings
I am grappling with a problem with some code I have put into On Change of a field
I set up the field with the following code;
Private Sub Location_Enter()
Dim sqltext
sqltext = "SELECT tbl_Data_Vessel_Barrel_Position.Position "
sqltext = sqltext & "FROM tbl_Data_Vessel_Barrel_Position WHERE (((tbl_Data_Vessel_Barrel_Position.InUse)=No)) "
If IsNothing(Me.Location) Then
Me.Location.InputMask = ">LL00000"
Me.Location.RowSource = sqltext
'Me.Location.LimitToList
Me.Location.Requery
End If
End Sub
This works fine as but the On Change command I use;
Private Sub Location_Change()
Dim db1 As DAO.Database
Dim rst As DAO.Recordset
Set db1 = CurrentDb
Set rst = db1.OpenRecordset("tbl_Data_Vessel_Barrel_Position")
rst.Index = "PrimaryKey"
rst.Seek "=", Me.Location
rst.Edit
rst!InUse = "0"
rst.Update
rst.Close
Set db1 = Nothing
Set rst = Nothing
End Sub
Must assume that the field has been changed is some way.
Can anyone spot or suggest how to rectify this problem.
Thanks
~rbinder
Hi all,
I'm trying to use a sql query to change the access field datatype. I'm trying to use a case statement to overwrite the values.
Select value1, [CASE WHEN value2 = 'True' THEN 1 WHEN value2 = 'False' THEN 0 END CASE] as 'value2'
FROM
Table WHERE ID=1
The problem is that it is prompting me for a parameter, i'm not sure what the best way to do this.
Thanks,
Jake
how do I create on on click event to change a label in form view so that a user can customise a form??
View 9 Replies View Related