Search results

Reference List: Visual Basic For Applications Microsoft Access 9.0 Object Library OLE Automation Microsoft ActiveX Data Objects 2.1 Library Microsoft Calendary Control 9.0 Microsoft Windows Common Controls-2 6.0 (SP3) Animation GIF Control FolderTree ActiveX Control Module Microsoft Shell...

DAO 3.5 Library Reference Statement: Now that I did this, I got an error message saying conflicting references or something, but if I UNCLICK DAO 3.6 then everything is fine... Question: Is this good?

... Uh, I guess I am gonna sound stupid... Well, here goes... How do I put the DAO reference in my MDB?

UserDefined I have been, and they all say to do the following: Dim dbs As Database dbs = CurrentDb I get errors everytime... Something about UserDefined Types? Argh!

I think strAppName = <insert path to the inventory.mdb here> (eg. strAppName = "C:\My Documents\Databases\inventory.mdb") appAccess = CreateObject ("Access.Application") appAccess.OpenCurrentDatabase strAppName I believe that is the code lines you are missing... Not too sure tho... I am...

CurrentDb.Properties ("ReplicaVersion") Yes I have. I get a type error. There is something about User Defined Custom properties are located in the Document area? Something concerning Containers or Documents? If you goto help and type in "Database Properties" you run into this. In Microsoft...

I have gone into my Database Properties. I have gone to the custom tab. I have created a custom properties called: ReplicaVersion How can I capture that? For Instance... label_Test.Caption = "This is version: " & ReplicaVersion I have exhausted my brain for today. I will work on it...

Enum just NOT a number? Ok... I get Type problems when I try to: Public Enum Names nmJohn = "John Jacob Jingleheimersmith" nmSteve = "Steven Samuel Sliczensky" nmRoberto = "Robert Timothy Randern" End Enum Public Function UserDetail(username as Names) Select Case...

<PHEW> Thank the freaking maker... That takes a load off... This is the best freaking set ever... I don't even waste my time looking for answers anywhere else when I have a problem. This is the greatest idea ever. Now I do have to say, that a small membership fee wouldn't be outta the...

Pay-Site I work for City Government. We are currently 20-million in the hole on our budget. Laying people off, close to required Furlough, no money. I am barely making it as it is. I couldn't pay for anything. I use this site like a dying man uses a priest... In fits, usually screaming, and...

Index Thanks David R, I am using this merely for looks. It is on a request form. A user opens the form to request information. They fill-in-the-blanks... ANd the Department information is just a label at the top so they know that they are on the right computer. Thanks alot! It's too bad...

Ok, this is what I am moving to http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=30258 If you could check out this thread you will see maybe what I want to do... I would like to create a function with all the possible arguments I could search for using the Users NT Logon...

When you put a MsgBox in code, you start typing... MsgBox "<insert Prompt Here>",------ as soon as you enter that last comma (like above) a little window pops down... This window lists out ALL the different types of MsgBoxes you can generate... VBOk vbCritical etc... How do I set up a...

Can someone help me please? I am wondering if there is a trick to this... Something that will make this easier for my code-jumbled brain to understand or use... I have been given the following code...(by The_Doc_Man) Private Function GetUserDepartment(sUser As String) Dim sDept As Integer...

THANK YOU SO MUCH! Private Sub Form_Current() GetUserDepartment GetNTUser End Sub Private Function GetUserDepartment(sUser As String) Dim sDept As Integer sDept = DLookup("[DEPT_ID]", "tbl_Employee", "[Empl_NTLogon]='" & sUser & "'") GetUserDepartment = DLookup("[DEPT_NAME]", "tbl_Department"...

SQL From a Listbox Private Sub lst_AssignContractor_AfterUpdate() DoCmd.SetWarnings False DoCmd.RunSQL "INSERT INTO [tbl_LINK_ProjectBasics-Contractor] ( Proj_ID, Cont_ID) " & "VALUES ([Forms]![frm_ProjectBasics]![Proj_ID],[Forms]![frm_ProjectBasics]![lst_AssignContractor]);" DoCmd.SetWarnings...

Ok... This is hard to explain... I have two tables and one form I am using here. Table #1: Employee Table Table #2: Department Table The Employee table is linked to the Department table by a Dept_ID field that is in both tables. I have a function: GetNTUser() that grabs the NT Logon ID...

Ok... I am going to give an explanation as easily as I know how hoping that someone can understand what I am asking as easily as they can explain what to do... I have three tables. tbl_ProjectBasics tbl_LINK_ProjectBasics-Consultant tbl_Consultant tbl_ProjectBasics is linked to...

Ok... Question. I have a database with several tables in it. Each table has several fields, some in excess of 30 fields. I have put VERY detailed descriptions for quick verification. NOW, I would like to print out each table, listing out JUST each field and it's type and description. This way...

Danka Shane Fornation Thanks Fornation... I agree with you on that one. I am going to forgo using that for now... But, my goal is to work towards that with my next version. Thanks everyone, I am off to work... All my quirks have been fixed! Thanks to you all!