Search results

Public Type boObject frmAction As String frmApplyForm As Form frmCurrentForm As Form tbl_Name As String tbl_FirstField As String tbl_SecondField As String frm_FirstField As Control frm_SecondField As Control End Type...

I am building a popup menu for a form in my database. What I would like to do, is... When a user moves the cursor into a date field, I would like to right-click and drop the current date into that field... ________________________________________________ Public Function DropDate(ctl as...

I was just informed by the IT Manager here... That, if I create a database...mdb And I place it on the server...network'd And other people 'WHO HAVE A LICENSED COPY OF ACCESS'... Utilize my database... We have to pay a yearly fee to Microsoft...???? If I use their tool, create a database for...

Thanks for those who private e-mailed me...and those who have offered assistance in the postings... I think my best bet will be to wait for the wonderful school loans and get office 2000 Developers Edition from school for the wonderful school price of about $200 or so... Argh! That still means...

OCX I am just looking for documentation on the treeview... I do not have MS VB, just the VB Environment in Access 2000 on an NT based network... Any help would be appreciated...thanks...

Ok... I am gonna ask this in case someone has done it and can cut and paste the code for me... I have a form that lets users run through all the different projects the City is involved in. I want to add a section of this form (prolly in a tab control) of another form altogether that allows the...

Greetings one and all, I have just started to get confident and knowledgeable enough, to start utilizing ocx files in my VBE programming. I am dying to use tools like the Treeview in future products...BUT... I work in City Government, for a town that is over 20 million in the hole. The very...

Sample Using Treeview If you have a sample utilizing Treeview ocx Control in Access 2000, I would love a copy as well...! PLEASE!

Aha I didn't put the query name in quotes... I was afraid that referencing it as a string would screw it all up... Now I know better... THANKS!

Public Function SetGenerics(frm As Form, ctl As Control, Optional subfrm As Control) Dim strColCnt As Integer, strColWdt As String, strRow As String, strTag As String, strlbl As String Dim ctrl As Control, lblADD As Label, lstADD As ListBox, lblDELETE As Label, lstDELETE As ListBox On Error GoTo...

Rowsource = Query vs. SQL Text String That sounds great...something I can give a shot at... BUT as to your comment about saved query, I tried that route too, and it comes back with problems because I refer to my mstrfrm in the query... When I use a saved query as my rowsource, first off I...

With lstGenericDELETE .ColumnCount = 4 .ColumnWidths = "0in;0in;1in;1.3in" .RowSource = "SELECT DISTINCT [tbl_LINK_ProjectBasics-Employee].[Empl_ID], [tbl_LINK_ProjectBasics-Employee].[Proj_ID], " & DLookup("[Empl_FirstName]", "tbl_Employee", "[Empl_ID] =" & [Empl_ID]) & "AS...

SELECT tbl_ProjectBasics.Proj_ID, tbl_ProjectBasics.Proj_Num, tbl_ProjectBasics.Proj_Title, tbl_Department.Dept_ID FROM tbl_ProjectBasics INNER JOIN ((tbl_Department INNER JOIN tbl_Employee ON tbl_Department.Dept_ID = tbl_Employee.Dept_ID) INNER JOIN [tbl_LINK_ProjectBasics-Employee] ON...

I have a form that has MULTIPLE Subforms that COULD be necessary... Now I realize I could open each subform using a button on the main form...but I don't wanna... I also realize I could create MULTIPLE subforms on the main form, but that slows everything down when a form has to load up to...

Ack! I have this freaking database ready to run... But I have hit a glitch. Here is the FUNCTION I use to grab the Users NT Username: __________________________________________________ Option Compare Database Private Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal...

Never Mind I use the following function and it grabs the information... I just got back from a New Horizons (Computer Learning Lab) on VB6 and was able to finagle some of what I learned into figuring this out for myself...excitement galore... Public Function GetMasterVersion() As String...

Last Question What if I want to check a database on the server? CurrentDb grabs the current database... How do I point to one on the server?

Then something is wrong When I do Dim XXX as Database... I get User-Type not defined under 3.6 Bu not when I remove 3.6 and use 3.51 At least on my machine...

ARGH! Currentdb.properties("Your Property Name") Doesn't work in 3.6....I had 3.6 already, had to install 3.51 to get it to work...and with 3.51, it worked, but 3.6 had to be removed...

Um... If I remove the 3.51 reference... Then I can't utilize the options I was talking about at the beginning of this message?!