Search results for query: *

Good day all! Ugh.. I'm going insane trying to figure this out. All I need to do is open a second form where the user right clicks in a base form. By base form looks like this (Warning: Still in development): The second form really is nothing more than a button at this point, but this is...

Good day all! Is it possible to italicise a node in a treeview? If so.. how? Thanks in advance! ________________________________________ Buddha. Dharma. Sangha.

Good day all! My database schema looks like this: I made a query that included everything, but I can't add or even edit anything in the query results. What am I doing wrong? Thanks in advance! ________________________________________ Buddha. Dharma. Sangha.

Good day! I was given a task to create a database following this: Collateral Types; the choices should be Boat, Motor, Boat Trailer, Travel Trailers, Slide on Truck Campers, Horse Trailer, Jetski, Pop-up trailers Is there a way to be able to choice more than one option? Things done: UCC...

Good day! ugh, I'm pulling my hair out on this one. Instead of quitting after 10 tries, my application just freezes, and I have to give it the 3 finger salute. Please take a look at my code. Why dosen't it quit after 10 tries? Public Sub goNext(scrCheck As String, amtToCheck, Optional...

Good day all! This is probably a dumb question, but how do I make IntelliSense show the argument options for a Public Sub that I created? Public Sub EmpRep(shtGrpName As String, ViewOrPrint As String, myForm As Form) Dim strDocName As String Dim strOut As String Dim strWhere As String Dim...

Good day all! I'm trying to "Set" to a string... which probably isn't possible. Even so, how would I go about making the following code work? The comment shows where I get an error of: Run time error '91': Object Variable of With block not set. Public Sub EmpRepSelect(shtGrpName As String...

Good day all! I'm trying to figure out how to capitalize the first character in a string after a number and period. For example: 1. hello (Should be = 1. Hello) ... ... 10. visual (Should be = 10. Visual) I wrote down some pseudocode, but I'm not entirely sure if I'm heading in the correct...

Good day! I have a textbox that gets placed into a variable that's "dim"ed as a String. This textbox allows quite a bit, including comma's (,). When this string includes a comma, and I try to place it into a listbox, it seperates the sentence. For example: dim strItem as string strItem =...

Is there a way to grab the first character in a string after each space from a textbox so I can do something else with it? Example: Strip First Character = SFC John Doe = JD What Would Buddha Do = WWBD Thanks in advance! ________________________________________ Buddha. Dharma. Sangha.

Good day! I'm trying to figure out a way to dynamically create INNER JOIN queries based on the existing queries in my access database. SELECT EER_LA_Acct_paid_off.Employee, EER_LA_Acct_paid_off.Acct_paid_off, EER_LA_All_required_docs.All_required_docs...

Hello all! Is there a way in VBA to create a query, and 'save' it so it shows in the "Queries" window? Thanks in advance! ________________________________________ Buddha. Dharma. Sangha.

Good day! I'm not sure if this is the correct area to be posting this, so if it's not, feel free to move it! I have a database that consists of many reports, forms, tables and queries. Many of these are just about the same thing, with only a few minor changes. My question is this: How would I...

Good day! I have a main form and I need to open a second form by clicking on a button in the main form. Sounds easy, but here is the catch... When the user click the button, I need to check to see if that account number already exists, and if it does, open the second form to that record...

Good day! How would I go about making a form open directly above the windows taskbar in the right hand corner of the screen every time? Thanks in advance! ________________________________________ Buddha. Dharma. Sangha.

Good day all! Is there a way that I can programatically get the name of the forms that are currently open in a database? Thanks! ________________________________________ Buddha. Dharma. Sangha.

Good day! DoCmd.SendObject acSendReport, "Outstanding", acFormatSNP, strToWhom, , , "OUTSTANDING TITLE SEARCHES AS OF " & mydate, strMsgBody, No The strMsgBody contains a string of text that appears in the message body of the email. The only problem is that I have a tag that automatically...

Good day! I have a simple report that groups data by BatchID from the Batch table which consists of: Batch Table: custAccountNum BatchID BatchDate An example can be seen here: My report looks like this: (Minus the red lines, which will be explained later) Now, as you can see by these...

Good day! I have a form named ShowDatabaseUsers that contains the following. List Box: lstCompName lstEmpName Button cmdClose In the "On Open" event of the form I have code that populates lstCompName with the names of users computers that are currently using the database. The...

Hello all! I was wondering if anyone could refer me to some good websites that will get me started programming with VB and Extra! personal client... Much thanks! ________________________________________ Buddha. Dharma. Sangha.