Search results

I have three tabs which the visible setting is driven off of three other fields one field drives each tab. I was running into an issue while going through each record where it could not hide a field that had current focus. I noticed this happens when i try to click through records rather...

I am trying to learn modules and while some of them tend to work others dont. I assumed you could per say nest different functions within a module without issue but advice and input is suggested as to any help to be provided. Option Compare Database Private Sub Form_Current() Call...

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 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 am new to vba so still learning and reading up. I currently utilize the below. This works fine however when i click new records in the split form view or go to next record if the Y is met the first time all records after that are invisible until i go back to the record i changed and alter...

I borrowed and modified this listbox to be able to view and select records and bring them up in the main form. However projects should be defined 1-5 5 being complete. I am trying to filter the listbox view of the 5s if there were any by a selection of a button so that when selected all 5s are...

I know you can nest a limited number of if statements but not sure what i am missing to get this work. I am ranking items based on a list but want to omit that item from being ranked if another associated cell equals 100%. I hope this makes sense this formula works...

I currently have about 20 fields on a report some with varying txt length so the box it is in changes size. Next to that column i have a set of unbound boxes for later use that are empty for user comments outside of the db. Is there a way to link an unbound field to a bound field so that when...

I didnt get much of a response last time so i figured i will try to restate this. I have one main table with 20 other tables that are linked depending on a user selection. I will basically have 30+ reports one to two per table based on a user selection from the main table. ie who the data...

A few questions. Is it possible through a query in the subform property to reference two different tables without issue? The reason i ask is once i do this none of the items in my subform show when the subform is called up. Maybe the problem is how i have the relationship setup. I have...

As i am not a vba pro I am trying to do this within excel as a formula. You can see the summar sheet up front and the data is on the second tab. I am trying to pull from the line of business ex crm prw and transaction type. where transaction type 1 =new 2 = renewal etc. on the second tab i...

I have attached a copy of the db. You can scroll through the items and even search within the policy field and note that only one policy number pulls the subform info up which is confusing me as to why the rest arent. The policy number is 1092467. If you look at the tables the data is there...

i tried to search this but wasnt sure on the phrase to search by. My issue is I have about 20 individual forms each which are unique to a table and those tables unique to one parent table. I have created a main form which pulls the universal items from the main parent tbl and matches based...

The issue i have is upon opening my form the command buttons will not locate previous records however once you input a new record it will allow the function to search and the previous and next record buttons to work(but they still dont show previous records). Once the form is closed and...

This is one of my bigger dbs that i have created. Most contain one to two tables without much issue as the form has always referenced one table. I think my issue arises from the table being empty and trying to save so after trying to force a null value the error still pops up. Is there a...