Thanks again Frinavale for your reply. Sorry for my late reply because I have been away from my workstation since last weekend.
I have tried the walk through, and will try to implement this into my project.
I really appreciate your advise and reply. This is a new and very useful peace of knowledge for me to learn and explore.
Cheers,
beemomo
beemomo
Last Activity: Jun 14 '12, 02:24 PM
Joined: Jan 29 '08
Location:
-
-
Thank you for your reply, Snehasis.
I have been away from workstation during last weekend. Sorry for my late reply.
I got my solution for the above post by replacing the for loop using the code below:
I appreciate your help alot!...Code:For i = 0 To dtDataTable.Rows.Count - 1 chkUser.Items.FindByValue(dtDataTable.Rows(i).Item ("UserID")).Selected = True NextLeave a comment:
-
Loop datatable and select checkboxlist item based on the datatable field values
I am trying to display value of the field ("UserID") for every row exists in datatable to checkboxlist(ma ke the checkboxlist item selected).
I used for loop, but only the field value from last row of RoleUsers table is selected in the checkboxlist.
Here is my code
...Code:Private Sub DisplayRoleUser() Dim conn As SqlConnection Dim cmd As SqlCommand Dim drDataReader -
Thanks for your reply , Frinny.
This is the first time I create the login page using form authentication. Sorry for my noobness.
I've been struggling for several to find the answer on how can i store the user's additional data. Thanks for your advise , but that would be great if you can explain how can I store user data using HttpContext.Use r
Public Property User As IPrincipal
Get
Set...Leave a comment:
-
Concatenate columns value returns by datareader
I manage to store the additional use data (username, fullname, rolecode) in FormAuthenticat ionTicket. However ,
the user has more than one role , he can be admin, poweruser , executive ,etc... can anyone please tell me how can i concatenate the rodecode return by datareader if it returns more than 1 value? so that i can put it as a string in userdatastring of the authentication ticket?
eg:
If datareader returns: ... -
Dear all,
I manage to store the additional use data (username, fullname, rolecode) in FormAuthenticat ionTicket. However ,
the user has more than one role , he can be admin, poweruser , executive ,etc... can anyone please tell me how can i concatenate the rodecode return by datareader if it returns more than 1 value? so that i can put it as a string in userdatastring of the authentication ticket?
...Leave a comment:
-
Form Authentication Ticket to Store additional User Data
I am trying to implement login page using Form Authentication in ASP.net using vb code.I follow the steps in How To Implement Forms-Based Authentication in Your ASP.NET Application by Using Visual Basic .NET. I created a function in login page :
and call it in btnLogIn_ClickCode:Private Function ValidateUser(ByVal strUsername As String, ByVal strPassword As String) As Boolean
...Code:Protected
-
Hi Nic;o),
Thank you so much for your advise. Yup, you are right, and also the unbound text box of txtRate is not working properly in report as in it works in form. Store the currency value in another table will be the solution.
Regards,
Beemomo...Leave a comment:
-
Sum the value of unbound control in report footer
This is my second post for the same question, hope this time I did explain more clearly about my problem.
I need a report that generate the total value of projects from a few foreign currency to USD.
In report detail section:
-2 textboxes bound to CURRENCY and CValue from a query.
-Another 2 textboxes (unbound control) -> txtRate and txtUSD
CURRENCY CValue Rate Value(USD)
... -
yes, i've considered that before, input the value via a form. But the purpose i let user to enter the value of the exchange rate in the report is because, they only have to enter the rate for the particular currency group after the report is being generated.Leave a comment:
-
Thanks NeoPa for your reply.
Hmm, no other way except enter the exchange rate into another table and query to get the result?
BeemomoLeave a comment:
-
Sum the value of unbound control in report
I need a report that generate the total value of project from a few foreign currency to USD.
In report detail section:
There are 2 fields (CURRENCY,CurrV alue) from query table which are displayed in bound control (text box)
To convert to value in USD, I have created a text box txtConRate, where users need to key in the conversion rate. Then there is another text box (txtValueinUSD) to calculate the converted value,... -
Thanks, ajalwaysus, it's works.
Regards,
BeemomoLeave a comment:
-
Using Combo Box to search for records
Hi, I have a single form - Customers and I wish to find out all the records which satisfied the value selected from combo box.
...Code:Private Sub cboFindFirstName_AfterUpdate() DoCmd.ShowAllRecords Me!ContactFirstName.SetFocus DoCmd.FindRecord Me!cboFindFirstName 'Set value of combo box equal to an empty string Me!cboFindFirstName.Value = "" End Sub -
beemomo started a topic Compare data between row, move to new table and lastly delete it from old tablein AccessCompare data between row, move to new table and lastly delete it from old table
Hi everyone here,
Wondering if this can be perform in access using SQL or vba.
VesselMovement table:
RNO Date_Fix TIME VID X Y HEADING SPEED
1 07/05/2009 00:00 605 5.1896 6.7198 81 0.3
2 07/05/2009 00:30 605 5.1896 6.7198 90 0.4
3 07/05/2009 01:00 605 5.1847 6.7193 0 ... -
Thanks to everyone for your clear explanations!
I am learning new things again. :)Leave a comment:
-
I found the solution at last. I created two queries (MaxPRefNo & MaxOFRefNo) to store the Max value for the Primary ID starting with prefix -> OF- and P-.
Next, I edit to the DMax function as below:
For PRefNo:
For OFRefNo:Code:NextPRefNo = Nz(DMax("Right ([MaxOfID],3)", "MaxPRefNo"), 0) + 1
...Code:NextOFRefNo = Nz(DMax("Right ([MaxOfID],3)", "MaxOFRefNo"),Leave a comment:
-
Generate Primary ID based on criteria
Hi,
I have a table name ExpenseClaim where it has a field named RefNo to store the Primary ID for each record.
In my form, I has a combo box named cboExpenseCode: -
1) If user select "Company Reimbursed", then the prefix for the Primary ID is P-xxx
2) If user select "Project Reimbursed", then the prefix for the Primary ID is OF-xxx
xxx- represent the incremental id (e.g... -
Hi Fish,
I will use DocID as bound column instead of DocNo.
Thank you very much for the helps along. Glad to be your student!
Cheers, :)
beemomoLeave a comment:
-
Thanks for your reply , Fish. Hopefully my solution will live long and happily as you said :) lol
Here I come with another problem, that would be good if you can point out my mistakes.
cboDocNo rowsource with example data:
DocNo Rev Title Status DocID
Safety Rev00 FS A Doc0002
Safety Rev01 FS B Doc0003
Safety...Leave a comment:
No activity results to display
Leave a comment: