Search results

nevermind on this.. going to just try to implement this in a save record button. the only thing that has me slightly worried is how to do this with a split form. If a user selects an item on the form what verifies that it is saved without a save button and if i put all the validation on the...

Private Sub Form_AfterUpdate() If Forms!WindOptOutV12.Other = -1 And Nz(Forms!WindOptOutV12.IndStatmentHandwrittenComment, "") = "" Then MsgBox "A comment is required when other deviations are noted." IndStatmentHandwrittenComment.ForeColor = 100 Else End If End Sub I went with this but am...

VBA as listed Private Sub IndStatmentHandwrittenComment_BeforeUpdate(Cancel As Integer) If Forms!WindOptOutV12.IndStatmentHandwrittenComment = "" Or Null Then MsgBox "Please Enter a Comment Below for Deviations listed as OTHER" Else End If End Sub I have a field above this where if the...

I have to agree on the way it processes a/b/c and I am not sure it would necessarily work however for one of mine i utilized and modified something on the web that used a timer Option Compare Database Option Explicit Dim ClockName As Integer Private Sub Form_Open(Cancel As Integer) On Error...

thank you for that.. a time saver it is.. i was going towards setting everything to onclick until i noticed that the event procedure wasnt there.. i guess i can understand the actions esp if you cut it just glad I found it as it was making me silly

I figured this one out.. seems cut and paste removed any relation to event type for those fields that were cut for my before/after update. Not sure if this cuts the reference for all types but once I put them back in it works fine now... a bug or not sure a pain in the butt

I think that is just the way that it copied over. i have attached it and it is version 12.

I have tried to find something on the web but maybe I am not searching for the right term(s). I basically setup a .visible logic statement driven off of one field when it is yes or -1. This works perfectly so I cut and pasted into the tab. Needless to say it doesnt work anymore. I even cut...

I did filter on open and it appears to work. For this you will need to alter the filter so it will show records however I keep having issues with all my visible/if statements where it tells me cannot hide item on focus. It is hard to duplicate but if i click through and have data in the...

Something tells me the answer to this is no but I figured I would inquire either way. Is it possible to filter a form by a field in the form. Not a drop down combo box filtering the form but rather I have a field setup that pulls in Private Sub Form_Open(Cancel As Integer) 'Populate the...

I just found the API get Login Name. But I thought I read someplace else that in order to use the filter that way on the form from the user name that the form itself should be driven by a query. Did I setup my initial form incorrectly by linking it to the table itself? I saw these as well...

Ok I had a heck of a time trying to get all the box names and label names to disappear so I went ahead and did tabs for one area and just referenced the tab name vs trying to note every little field. My next question would be. I have a field when it is equal to xx or xx or xx I want to make...

I agree this would be easier but with the split form and prior issues and what not I thought it would be simple to just add the filter and copy the form 6x. I also thought about using the netlogin name but given the length of time just wasnt sure how easy it would be. I would be interested to...

My next question is Normally in 03 I would split the db and the users would all utilize the same form. This time short of using a machine name or user logon name users are not supposed to be able to see or view others records. The easiest solution I could come up with is making 6 forms each...

found the issue. Have to actually reference the form instead of the me.youritem or else selecting the record in the subform wont update my visible items http://bytes.com/topic/access/answers/735432-access-2007-split-forms-subforms Public Function StreetDirectory() If...

Thanks that worked perfectly. I notice everything works fine when using the forward and back buttons in the form itself however If i utilize the split form part it is as if it skips the on form button and those cells referenced tend to stick on either visible or invisible and do not refresh...

Paul, I set this up inside by calling and then just referencing the function but neither are working. I hope this is just a "" or name issue or maybe I am not bringing it up correctly. Can you help me out on this? Public Function ComboStreetDirectory(strVariable As String, lngVariable As...

so everything else was right except my form reference when i put it in a module. Question, how exactly do i do a form specific module? I see how to do modules and class module. Wait, I think I might finally get what you are saying now. Within the form itself define the function one time...

I use the following for a module Option Compare Database Function StreetDirectoryWindArea() If Me.ComboStreetDirectoryWindArea = "Y" Then Me.ComboOptOutFormInFile.Visible = False Me.ComboOptOutFormInFile = "N/A" Me.ComboUWDocumentException.Visible = False...

When you reference form module is that the same as class module? Also is it just as simple as copying the form vba into the module without worrying about the before/after events?