Search results

Fornation vs. The World Dude! I had no clue that that would work! Does that truly make your form light? I can turn ALMOST everything on my forms into Functions that I can call just like that... Does that reduce the size seriously? Or are you just guessing? If that reduces the size I have to...

Yippeee! That sounds like it will work... I don't have time to try it out just yet... But I do have a question that stopped me from trying it earlier on my own... When you create a function...eg Public Function Goof(Freak As String) Psycho(Freak) ...End Function Public Function Psycho(Freak...

Never Mind I don't have a clue what to do now... Because I created a quickie database... Created two forms... Gave them BOTH the same exact naming on everything... Click the button on both...no problem... Let me go back and re-read everything... Thanks for the help guys...

Works for You Try this... Create ANOTHER form... create ANOTHER button... Name it the same... Now have it run the same code...

Duplicates Hey! Excellent... I think you are on to something... Here is the situation... I have multiple forms... They ALL have the following: Buttons: btn_Close btn_Delete btn_InitiateDelete btn_Delete btn_CancelDelete btn_Search Listbox: lst_SearchWindow So FORM #1 has a btn_Close AND so...

Domain Name / NT Logon Challenging Snuffle, There are a couple things you could do. http://pub95.ezboard.com/fcodesmithguildfrm20.showMessage?topicID=8.topic Check that link out for capturing logon names. Another option is splitting the db and locking the back-end down to the server in a...

Ok... I am getting this error message: The expression On Click you entered as the event property setting produced the following error: Member already exists in an object module from which this object module derives. * The expression may not result in the name of a macro, the name of a...

There we go... Ok...Next question... You figured it out for me... I was creating functions like: Public Function Magic(ABC as Control) ABC.Visible = False End Function Then I would run the function like this: Private Sub buttonA_OnClick() Magic("txt_BoDiddly") End Sub And there was my...

Brutality To be brutally honest... I am not sure what you are doing with this... If I am gonna help, you gotta explain like I am a kindergartner... What are you wanting to check... Once you check it, what are you wanting to do with it... I can prolly help ya, but I need more information...

!?! Wait... Are you saying that the first part is correct...? Function TextMagic(GenericVariable As Control, Setting As String) The GenericVariable As Control ???? I keep getting undefined this or that whenever I try to do that...! If I try to send it... Call TextMagic(Me!txt_Field...

Improper Use of Null I got it... Next question... How do I pass variables to a Function? Explanation: How do I send a field name to a variable? FieldName: txt_RandomTextBox ***************FORM MODULE***************** Private Sub TextMagic(txt_RandomTextBox, True) End Sub...

Quotes If I get rid of the quotes it isn't referencing a field...It references the variables assigned to the field... For instance... If the current entry in Dept_ID is 10 Then trying to set Focus to Dept_ID would be setting focus to "10" not to a field... But the problem is coming from...

Access Wizard Private Sub ComboBoxExample_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[insertTableNameHere].[insertFieldNameHere] = " & Str(Me![ComboBoxExample]) Me.Bookmark = rs.Bookmark End Sub You...

SELECT CASE vs IIF instead...try... Function Balance(NumberArg As Double) As Double Select Case NumberArg Case Fix(NumberArg) Balance=NumberArg Case NumberArg -Fix(NumberArg) > 0.5 Balance = Fix(NumberArg) + 0.5...

I have a function stored in a module. I want to be able to run this function from several forms... Each form will have a listbox that is named lst_SearchWindow. Each form will have two labels named: btn_Delete and btn_CancelDelete. What I want to do is affect these objects. But everytime I try...

Zero-Width Field for holding Focus Tried it... MS Access says... Can't Move Focus to Control Argh! I am just going to re-think the design layout of my forms. I have been using them as manipulatable (new word) reports. Using combo-boxes to alter the viewed data, etc... Ah well... Oh, and...

Tabstop Tabgo I 'THINK' I have tried that and it never worked... MAYBE I am wrong... But it is now my habit to run everything from labels that have an On_Click() event... Isn't there anything else I can do...!!!!!?

Zero-Width Field See, and I tried that... But for arguments sake, lets say I have two objects on the form. Label#1 Txtbox#1.Visible = False Let's say you click on Label#1 to make Txtbox#1.Visible = True But, once you make your entry in Txtbox#1 I want it to .Visible = False Well, 'IF' I used...

Ok... I am creating sections on forms where I want the user to select ONE option from a listbox or combo-box and the make that listbox or combo-box invisible. All I want to ask is this: If the only thing on my form is a LOCKED/DISABLED textbox or listbox...and I want to move the focus OFF OF...

Gotta at least ask ya here Ok... I have already made changes to my database where the particular instance of creating that entry is now not necessary... BUT... I still have plenty of other related tables that will need this... So, it is invaluable to say the least. What I want to know is...