Recent content by sucoyant

I think I may have mislead you Chance1234, I need to have the second form (which only contains the "New Record") button to show up where you click in the first form. ________________________________________ Buddha. Dharma. Sangha.

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...

PHV to the rescue... AGAIN! You are amazing. Thanks again PHV. ________________________________________ Buddha. Dharma. Sangha.

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...

Thanks to everyones help I was able to find a solution! Here is the code: Dim rs As DAO.Recordset Set rs = Forms![Real Estate Secured Lines of Credit Equiline].RecordsetClone whatToLookFor = Forms![Customer/Checkbacks]![txtAcct] criterion = "[Acct #]=" & Chr(34) & whatToLookFor & Chr(34)...

The easiest way is probably just to use it " LOL! Yep... isn't that the truth. Thanks for setting me straight... I didn't know you could do it that easily! ________________________________________ Buddha. Dharma. Sangha.

Rolliee: I'm a bit confused. Where exactly does the code go to open the new form? When a user clicks on a button in Form1(Whos recordsource is Table1), Form2(Whos recordsource is Table2) needs to open, and search for a match in the AcctNum field (from Form1/Table1), which is in both tables and...

I would like this to feed into the following line of code from the above post: DoCmd.OpenReport strDocName, acViewPreview, , strWhere 'Open the current report Where the second argument for OpenReport would consist of the ViewOrPrint variable. This probably doesn't make sense... sorry. I'm...

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...

Thank you for the replies! I'm terribly sorry, I'm not sure if this will matter, but each forms record source is different. Form1's recordsource is Table1 Form2's recordsource is Table2 I think the code that has been provided is close... I would really appreciate it if we could nail this...

Ahh, perfect! Thank you SO much Tony! I really do appreciate your expertise. ________________________________________ Buddha. Dharma. Sangha.

Hrm. I saved my Sub as a Module in MS Access, but now when I run it, I get "Invalid use of Me Keyword" Why would it do this? ________________________________________ Buddha. Dharma. Sangha.