Search results

I'm sorry, but I have no clue what you're trying to accomplish even if your code does work, the description just wasn't enough for me to catch on. For my sake: What are you trying to do, on which event(s)?

Might be able to create a public function in a module and simply pass Me as a parameter in the load event of each form.

Depends on your top form's design tbh. Does it use a record navigator or is it a static form that manages its data passing manually with code?

Oh ok good :)

Here is an idea I just quickly wrote. Not sure how it works lmao. Private Sub Form_Resize() Dim spacer As Integer: spacer = 50 txtOne.Width = (Form.InsideWidth / 2) - lblOne.Width - spacer txtTwo.Width = (Form.InsideWidth / 2) - lblTwo.Width - spacer * 5 lblTwo.Left =...

[LABEL][TEXTBOX][LABEL][TEXTBOX] and you want the text boxes to scale with the width of the form's width correctly?

I also see that you're doing a TOP 1... Is all of this just an attempt to get the currently logged in user's name?

Just set your LDAP Query to specify the group.

Try this out for starting off with. :) From an old project I was tinkering with. Private Sub Form_Load() 'Use ADO and LDAP to return all users in Active Directory Dim objRecordSet As Object Dim objCommand As Object Dim objConnection As Object Const ADS_SCOPE_SUBTREE...

I don't know how much this can help but you can try this function I wrote, and maybe the link on this post may help you even further. Follow this link.

How much wood, would a wood chuck, chuck if a wood chuck could chuck wood? A wood chuck would chuck as much as a wood chuck could, if a wood chuck could chuck wood...

How much wood, would a wood chuck, chuck if a wood chuck could chuck wood? A wood chuck would chuck as much as a wood chuck could, if a wood chuck could chuck wood...

Honestly its just pure lazyness to not format your data so that it is understandable enough for us to help you. Fill in the blanks please... [field1, field2, field3] 1 GWA 1 1 GWA 2 1 RJC 3 1 GWA 4 1 TE 5 1 IW 6 1 PY 7 1 RJC 8 1 PJ 9 1 GT 10 2 RJC 1 2 GWA 2 2 RJC 3 2 GWA 4 2 PY 5...

I suppose we'd have to be designing for the happy medium between performance and user experience. :P

Yes, but encapsulated in what would already be used. It would be questionably better if it was just calling the Sleep 1000 * seconds, but not while we're using the same Access VBA function, variable and object overheads as we would with manually coding the process purely in Access.

actually his would be calling a function that practically does the same thing as the routine calling it. Almost doubling up on resources I would imagine.

Something like this? If I understand correctly? SELECT table1.* FROM table1, ( SELECT VendorSearchName AS [search] FROM table2 ) AS [search_query] WHERE table1.VendorName Like '*' & search_query.search & '*'

I've always used this, but I'm sure these fellas can improve on its effectiveness. Public Sub Pause(ByVal seconds As Long) Dim time As Date: time = Now + 0.00001 * seconds While DateDiff("s", time, Now) < 0:: Wend End Sub

Omg hahahahaha!

Something that I had happen to me recently is: I had written the code for a database that built its tables based off of the data within hundreds of thousands of engineering data text files. It had to create its tables and fields on runtime. The result of this was a database with 1.34 million...