hexagram
Last Activity: Jan 21 '08, 01:59 AM
Joined: Feb 26 '07
Location:
-
check box default color
hi guys can anybody can answer my question, i have a report and i used checkbox object then if i print that report the color of the checkbox is shaded by gray i want it to be just plain white how can i change the color of the checkbox...than ks in advance -
Private Sub cmdtest_Click()
Dim rs As New ADODB.Recordset
Dim cnn As New ADODB.Connectio n
Dim valSelect As Variant
Dim i As Integer
Dim sSql As String
Set cnn = CurrentProject. Connection
For Each valSelect In Me!List20.Items Selected
sSql = "select * from [DR_Table] where id =" & Me!List20.ItemD ata(valSelect)
rs.Open sSql, cnn, adOpenKeyset, adLockOptimisti c... -
Only the Value in the Text Box will appear, but no records appearing in the subform : (Leave a comment:
-
i use one table in 2 different subform because my purpose
is in one of the subform is the list of all product with no tags, then i will
past to my new subform and still with a complete list of products with no tags
then i will tag the product manually in the new form then save it
so in my table i captured all the list of my product wig tag or without tag,
is my analysis wont make any sense? would you...Leave a comment:
-
YEs the subform of the new form is set to the record of DR_Detail_Table ,
and there no new table for these record, it will appear in a same table (DR_Detail_TAbl e)Leave a comment:
-
This what i got if i run the query uve gave
DRF - 00001 Memory 2GB 1 RTS-0909TY-STYA No
DRF - 00001 CPU 1 WR1-0FGQE-0091 No
DRF - 00001 PowerCord 1 QDSG7689 NoLeave a comment:
-
Yes mary this is the code that you gave no errors but still duplicates the record on the subform
sSql = "SELECT * FROM [Dr_Detail_Table] WHERE ID=" & Me!List20.ItemD ata(valSelect)
rs.Open sSql, cnn, adOpenKeyset, adLockOptimisti c
rs.MoveLast
rs.MoveFirst
If rs.RecordCount > 0 Then
Me![JMTPORDETAILSUB FORM].SetFocus
Do Until rs.EOF
Me![JMTPORDETAILSUB FORM]![Particular]...Leave a comment:
-
This is the structure of my table
from table DR_Detail_Table : I have 3 records
ID Particular QTY PARTNUMBER Flag
DRF-00001 CPU 1 Desc No
DRF-00001 MOnitor 1 Desc No
DRF-00001 PowerCord 1 Desc No
In Subform View - This is the one i view everytime i run the commandbutton
and i observe...Leave a comment:
-
It has an error saying 'Run -Time Error '2105';
You cant go to the specified record
I try to comment the
DoCmd.GoToRecor d , , acNewRec and it has no errors but it still duplicating the records in subformLeave a comment:
-
Hi no errors now i forgot to change the properties of my list box into a multiselect but i have still some issues the record in subforms are duplicatingLeave a comment:
-
hi mary i tried the code i have errors
Run-Time errors '2499'
You cant use the GoToRecord action or method on an object in Design view
Then if i click Debug
It point to this code
DoCmd.GoToRecor d , , acNewRecLeave a comment:
-
Thanks NEoPA and Rabbit for the big help it works smooth and properly...Than ks againLeave a comment:
-
hi rabbit i cant find the do open event in the report where can i see that? sori im new in access : (Leave a comment:
-
Hi rabbit i tried the code uve given to me but i encounter some errors
" Compile Error : Expected: list separator or ), The error pointing to the
Set rst = Currentdb.openr ecordset(record set of report)
should i put the script on the form right? thanksLeave a comment:
-
Hi rabbit i tried the code uve given to me but i encounter some errors
" Compile Error : Expected: list separator or ),
should i put the script on the form right? thanksLeave a comment:
-
Hi guy i think its not much clear for you guys about my problems bacause i dont get any reply from you so i reconstruct my wording
this my problem i have different forms with different reports i want is if the user
is attempting to print a blank report i will allow to print but i want to put on that report a big bold word "FOR SAMPLE REPORTS ONLY" so that the user cant forge the report manually because i want all the...Leave a comment:
-
It seems that my post is not much clear because i dont get any reply from you guys i reconstruct my wording
In my Form
I have a listbox and the Value of this "column" (Listbox) is ID, the user can select a multiple id
then a subform that must display a "record" in a table then a textbox (unbound) and a commandbutton to execute
the scenario is like this, The user will select a ID in...Leave a comment:
-
Populating Listbox (Multiple Select) in a textbox and in a subform
Hi guys good day, can anybody help for my problem
The Scenario is
A Listbox (ID) - Multiple Select - everytime i choose in the list box
the following outbound textbutton and subform will retrieve in my form-
the folliwng value will get from another form
i have a code but i need to customize it because everytime i choose ID in my list box my value in subform is multiplying by row i mean... -
Print Security
Hi guys good day, can anybody help me to solve my problem this is the scenario:
All the forms must be filled up completely before printing,
The administrator want to have security in all reports,
the condition is if the user will attempt to print a blank report it will be printed but their will be a bold font in a report saying its just a "SAMPLE REPORT" so that all the reports will not be forge manually by... -
Hi mary i already solved the problem and i works properly now thank u for the big help and the idea very very much for the time thanks again... : )Leave a comment:
No activity results to display
Leave a comment: