sorry found the answe on the net.. my googling skills arte down without my coffee
http://forums.codecharge.com/posts.php?post_id=41003
basically missing the cascade update, and the other one
sorry if this seems like spamming...
evildracko
Last Activity: Dec 23 '10, 04:17 PM
Joined: Jul 22 '10
Location:
-
evildracko started a topic The record can´t be deleted or changed beacuse table <> includes reled records?in AccessThe record can´t be deleted or changed beacuse table <> includes reled records?
first a write error prompt
Title: Write Conflict
Text: This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made. Copying the changes to the clipboard will let you look at the values the other user entered, and then paste your changes back in if you decide to make the changes.
Options:
<Save REcord> <Copy to clipboard>... -
try a macro on the form close the [...] macro buiilder
then use requery and specify this field without the if
just an idea hope it helpsLeave a comment:
-
first make the image a gif with trabsparent background...
then in front of said form, add a imagebox preferabbly called image frame
and set the value of picture to none
in the code try
...Code:Private Sub Detail_Format Dim strImagePath As String if (Watermarked condition) then strImagePath = <Path for image> Me.ImageFrame.PictureLeave a comment:
-
... what i can tell is that to reste autonumber ina access is "CurrentDB.Exec ute "ALTER TABLE tablename ALTER COLUMN ColumName COUNTER(1,1)"
so try changing the data type to Counter...
hope thhis helpLeave a comment:
-
perhaps a join or union condition
might work.. ts been a while since doign this give it a goCode:select part number, select([col1 union col 3] from table name a) as Col, select([col2 union col 4] from table nam b) as Col from tablename, tablename a,tablename b
Leave a comment:
-
Macro REquery might be handy
just put the control on the row source
after update Name of macro requery
and data row source
**[db name]!"[Forms]![formname]![control]
this is the part im not sure how to doLeave a comment:
-
Solved
solved by creating a new column with the page number... not clasy but working
basically inside de sub form made it so that there can not be mote than N columns and making on the value on new column to number page and created a Child master and sorting and grupoing through that valueLeave a comment:
-
Solved
solved by creating a new column with the page number... not clasy but working
basically inside de sub form made it so that there can not be mote than N columns and making on the value on new column to number page and created a Child master and sorting and grupoing through that valueLeave a comment:
-
solved by creating a new column with the page number... not clasy but working
basically inside de sub form made it so that there can not be mote than N columns and making on the value on new column to number page and created a Child master and sorting and grupoing through that valueLeave a comment:
-
Me.Top is negative, how can i correct it?
um hi, i am using MS Access 2003. i am creating a report with an embebed sub report.
It and the detail section that is in have the can Grow property. ok now in this code
...Code:Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Dim strImagePath As String Dim strImagePath2 As String On Error Resume Next If (Me.Extra= -1) Then -
a way to change "can grow" to force new page in subreport/detail?
Hi, since last time I have still note been able to solve this one, im starting to get frustrated, does anyone know if there is a way to force a page break on a sub report instead of the can grow function.
I mean, when it grows, the detail looses some information [it has an embebed sub form on it] of the detail section, I’ve tried, repeat section, creating a new image frame… kind of lost here thanks in advance -
Problem with Report/Subreport/Image
Hi, longtime lurker first time poster.
I am developing a Db for school on assambling planes etc... well i have my tables
Model
Pk MID autonumber
Model Name txt
Model Type txt
Pices
Pk PID autonumber
Piece Number txt
Piece Description txt
this are the only ones that are independent.
Index
IID primary key
MID FK to Model...Last edited by Niheel; Jul 22 '10, 07:42 PM.
No activity results to display
Leave a comment: