Scenario: I have a database with Member ID and DateCreated columns, which are both unique keys (meaning member id can be duplicated with a different DateCreated). I have an edit form where I load a list box form listing the Member ID and Date Created. I need to be able to double click a certain member id and DateCreated and the edit form loads with that selection.
For example,
Sample1: Member ID: 201301 Date Created: 01/04/2013...
benchpolo
Last Activity: Feb 20 '13, 06:42 AM
Joined: Sep 24 '07
Location: Los Angeles County
-
Converting a Date to Time Only
Scenario: I have 1 field REQDATE. 2 input box 1 date field and 1 time field. I have no issue pulling the date field, but I need to convert REQDATE to a time data. Format should be 12 HR format not 24 HR format. I have the TSQL below, but it is not giving the correct result I want.
Expected Result: 11:30 AM or 1:30 PM
TSQL: SELECT convert(time, GETDATE(), 101 ) as x
Please advice.
Thanks. -
@ zmbd
Thanks for the advise! that works! :) -
Do I go to the trusted section options of MSAccess 2010?
thanks.Leave a comment:
-
MSAccess 2010 Debug Break Point (F8)
I am currently developing a new database, and somehow the breakpoint (F8) doesn't not work on this particular database. The breakpoint feature in my other database works fine. Is there a settings within MSAccess 2010 that I need to turn on?
For example, I am assigning a date to my global variable and displaying it in the report on load, but it is not working so i did a break point toggle and it doesn't work.
Please... -
This is where i got the code, and I just tweaked it.
http://www.ehow.com/how_7518071_prev...-attempts.html...Leave a comment:
-
So you are saying that I shouln't do a Dim db As Database or Set rst1 = db.OpenRecordse t("dbo_tblFaile dAttempts", dbOpenDynaset)
Can you please provide a updated line of code.Leave a comment:
-
MSAccess 2010 Mulitple Login Attempt Failure
...Code:Private Sub cmdProcess_Click() DoCmd.SetWarnings False Dim rs As ADODB.Recordset Dim rsv As ADODB.Recordset Dim cnCurrent As ADODB.Connection Dim strSql As String 'verify the userid and password Set cnCurrent = CurrentProject.Connection Set rs = New ADODB.Recordset strSql = "SELECT * FROM dbo_LogInInfo " -
Missing Field in intellisense dropdown
I have a table field in SQL called extension2, and it is linked via ODBC connection in Access 2010. When I compile my code i get an error "Method or data member not found" error, but I can see field "wasextensi on2" in my link tables. Is there a configuration that...Code:Private Sub Frame219_AfterUpdate() If Me.Frame219.Value = 1 Then Me.wasextension2.Value = "Y" End Sub -
here is the section of the codeCode:curDate = Format(Now(), "mm/dd/yyyy", vbUseSystemDayOfWeek, vbUseSystem) strSql = "INSERT INTO dbo_HEDIS_Quarterly_Letter (type, memberid, language, datemailed, lettersend) " & _ "SELECT HedisType, MemberID, Language, " & Format(Now(), "mm/dd/yyyy") & ", 'Y' from members"Leave a comment:
-
TSQL INSERT Date Format
...Code:Public Sub cmdOMWUpdate_Click() On Error GoTo cmdOMWUpdate_Click_Err Dim strSql As String Dim curDate As String DoCmd.SetWarnings False curDate = Now() strSql = "INSERT INTO dbo_HEDIS_Quarterly_Letter (type, memberid, language, datemailed, lettersend) " & _ "SELECT HedisType, MemberID, Language, " & -
You entered an expression that has no value.Code:Private Sub frmCapDeduct_Click() If Me.Check32.Value = "1" Then _ Me.capdeduct.Value = "Y" End Sub
Thanks. I was able to figur it out.. Now a new issue arises ..
I have a check box with Yes and No option. When the check box was set-up the value I assigned when Yes is selected is 1 and 0 for No. I want to pass a code...Leave a comment:
-
MSaccess If ..Else. Compile Error
...Code:Private Sub cmdSaveRec_Click() If (Me.MemberID = "" Or IsNull(Me.MemberID)) Or _ (Me.AppendDate = "" Or IsNull(Me.AppendDate)) Then MsgBox "MemberID is required!", vbCritical, "Validation Msg" Else DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 DoCmd.GoToRecord , , acNewRec Me.MemberID.SetFocus -
The button is in another form (MAIN) and I want to disable it on form load when the other form loads.Leave a comment:
-
How to enable/disable button control
I have 2 button control ADD and EDIT and referencing a Data Entry form. Within the Data Entry form there are buttons ADD. I want to disable the ADD button when the EDIT button is selected in the main menu. I don't want the client adding records on EDIT mode of the Data Entry form. Make sense?
Thanks. -
but that is hard coding i want to do it using field.
Code:select diag from diagtable where diag in (select diag from #temp)
Leave a comment:
-
but it is a range. Table A contains code that are defined in the document, but Table B contains a range of code. For example, Table A contains Diabetes code 250.00, but Diabetes code is a range from 250.00-250.8; therefore, I a code that pulls the LIKE code from Table A to Table B, and the value is a mixture of numeric and text. but in this particular example it is pure numeric.Leave a comment:
-
data looks likeCode:AdmDiag 250.80 250.72 250.02 250.00 250.60 250.50 250.12 250.70 250.42
Leave a comment:
-
Using LIKE syntax in nested query
Code:[B]Item A[/B] Code ---------- 250 357.2 362.0 366.41 648.0
...Code:[B]Item B[/B] select cm.Membid ,cm.ADMDIAG from dbo.RVS_CLAIM_MASTERS cm where cm.membid in (select distinct memberid from CLINICAL.dbo.DM_CDC_Tracking_Excel) and cm.ADMDIAG in (select code from #diag a inner join dbo.RVS_CLAIM_MASTERS b on a.code like b.admdiag +'
-
Ok. I shortened the data set. It will me ID, DateFrom, Result. I need to display most recent date from. Somehow with the sql code below it is still displaying both records.
Thanks.Code:select memberid, MAX(convert(datetime,datefrom,101)) as datefrom , result as result from #a group by memberid, result Result 1052 2012-03-13 00:00:00.000 64 1050 2012-01-03 00:00:00.000 74
Leave a comment:
No activity results to display
Leave a comment: