Search results

One Last Note: Function This following function was NOT written by me, but I use it to work form the users NT Logon. ************************************************ Public Function GetNTUser() As String On Error GoTo Err_GetNTUser 'Returns the network login name Dim strUserName As String...

Front End -> Back End experience I have had... I have split my databases. I keep a Master Template Front End on the server. I also maintain the backend on the same server, different location. I have created another Front End for the sole purpose of capturing the users NT Logon and their Name...

Still No Kudos... I have put together quite a little db and still no kudos... ho hum...ah well...

KUDOS AT LAST! My Combobox is populated by this UNION QUERY: SELECT [SkID] AS [PreID], [SkName] AS [Prerequisite], "Skill" AS [Type] FROM tblSkills UNION SELECT [vanID] AS [PreID], [vanName] AS [Prerequisite], "Vantage" AS [Type] FROM [tblVantages] ORDER BY [Prerequisite]; Then, I...

Complexity Galore I do have tables... I am including a gif of my relationships. The two union queries are off to the right. Pat, you being the guru guy, you wouldn't be willing to look it over and give me some feedback? I respect your opinion ALOT and would be quite happy if I could get the...

UNION Queries SELECT qryPrerequisiteSelected.PreID, qryPrerequisiteListing.Prerequisite, qryPrerequisiteSelected.Type FROM qryPrerequisiteListing INNER JOIN qryPrerequisiteSelected ON (qryPrerequisiteListing.Type = qryPrerequisiteSelected.Type) AND (qryPrerequisiteListing.PreID =...

SELECT [SkID], [SkName] AS [Prerequisite], "Skill" AS [Type] FROM [tblSkills] WHERE [SkID] = (SELECT [preSkID] AS [SkID] FROM [qryLINK_Skill-Skill] WHERE [qryLINK_Skill-Skill].[SkID] = [Forms]![frmSkillsAddEdit]![SkID]); What did I do wrong...???

Actually...let me explain Ok... Actually, I am building a db for a game system I play. I hope to move my database skills to gaming web apps eventually...but that is another story. The App has two tables. One is for Character Skills. (eg., Driving, Computer Operation, etc.) One is for...

I FIGURED IT OUT!!!!! SELECT [SkID], [SkName] AS [Prerequisite], "Skill" AS [Type] FROM [tblSkills] UNION SELECT [vanID], [vanName] AS [Prerequisite], "Vantage" AS [Type] FROM [tblVantages] ORDER BY [Prerequisite] ASC; This did it... As I select something from the list, I will merely...

I have two tables. table 1: -> tblEquipment Fields: -> EqID - Autonumber Field -> EqName - Name of Equipment table 2: -> tblServices Fields: -> SrID - Autonumber Field -> SrName - Name of Service Now then, to my problem... How would I create...

Actually... What I found to work for me... Was: rs.Fields(fldSelect) Thanks for the assist tho, that was driving me nuts...

Public Function lstSearcher(fldSelect As String, tblFrom As String, fldWhere As String, txtIsLike As TextBox, lstFindHere As ListBox) Dim db As DAO.Database, rs As DAO.Recordset, strSQL As String Set db = CurrentDb strSQL = "SELECT " & fldSelect & " FROM " & tblFrom & " WHERE " & fldWhere & "...

I have a Public Function that I use to close ALL my forms. My problem is...I also have a Function that Hides the access Window. So if the last form visible is closed...then Access still runs, but it is empty...argh! Well, I want to add a line to the close function to check for all open forms...

WAIT A SECOND! DLookup can pull more than one answer back?!?!? If your expression is >= then you could get more than one reply! I didn't know this...! Grrrr

Question: I use labels with OnClick events INSTEAD of buttons. I do this because I have had too many databases that get hosed because the average user tabs to the wrong button and hits enter...or...they leave the focus on one button, switch records, and hit enter...also hosing a record or...

Doh! Yeah...sorry ritch... What I meant to ask was: How would I call a function using two forms for the boObject? ------------------------------------------------------ Public Function test(test as boObject) DoCmd.Open test.frmForm(1) DoCmd.Close test.frmForm(2) End Function...

Question: If I create a usertype: Public Type boObject frmAction As String frmForm(1 To 3) As Form tblTable(1 To 3) As String tblField(1 To 2) As String frmField(1 To 2) As Control End Type And I want to assign: FrmXYZ and FrmABC to the frmForm element, how would I do...

Yippee! Pat, first try after implementing your option worked! I was using DoCmd. Quit to close down. Now, Application.Quit acQuitSaveAll First try, it's working...!!!! Thanks Brad, since I am not sure what you mean by your conditional formatting...I have to assume I am not doing it. Thanks...

Ok... I am closing my db using vb code. The problem I am having is: Sometimes (and sometimes not), when the db closes, I have a floating .ldb file of the db that sticks around. You can't delete it (sharing violation) and you can't open ANY other db's while it exists. It goes away if I reboot...

Dim frm As Form, subfrm As Variant, sbfrm As SubForm, trgt As Object, rst As Recordset Set frm = Form_mstrfrm_ProjectBasics Set sbfrm = frm!subfrmData_CCFN Set trgt = sbfrm!CCFN_No subfrm = sbfrm.SourceObject Set rst = subfrm.Recordset rst.Delete The line: subfrm = sbfrm.SourceObject is a...