Hello everybody, I use a modal popup form to enter data in a db on which there a 2 buttons "save and close" and "cancel". I'd like to prevent the from from...

I have create a CloseButton on my main form - the generated code is: Private Sub CloseButton_Click() On Error GoTo Err_CloseButton_Click On Error GoTo...

Dear all, I have a bank account that contains more than 15 numbers, whenever i am trying to make the data entry ex :4322386920125206 i am receiving that the...

Hi, this should be simple but it's still giving me trouble. I have a drop-down combobox that is referencing a table with two columns, like this: 0 No 1 ...

Can anyone give me a clue as to why I cannot move the focus? I am attempting to move the focus to a combo box set to limit to list. I am successful in moving...

Hi, I am trying to change Back Color of some rectangles, but I don't know what "code" is for which color (except black=0 and red=225) in Visual Basic....

Hi First of all apologies for posting so much code but this is rather involved and I am totally stumped. Basically I have a main form (Staff Batch SMS/E-Mail)...

How do I use SELECT to pull into a form a value from another source based on 2 values on the currenr form and record and where do I put the code? Bennie

Here is exactly what I am trying to accomplish: I have a two tables: tblEmailAddress & tblCallData I also have two forms: frmCallCenter &...

Hi - On my Access forms, I have several fields that are marked as NOT NULL in the underlying DB2 database. The "not null" is a table requirement, not a...

Hi, I'm trying to figure out how to filter a query using the following criteria: Start Date and End Date Plus Issue or All Agent or All Rep or All In each...

I have multiple unbound text/combo fields in a form. Once you input your criteria I have a command button that when you click on it based on your criteria...

My application creates a datasheet on the fly. Users make a selection from a set parameters including column names, sort order, etc and the code populates a...

I have copied a form from an inherited database to a new one. When I click on a button on the form I get the above error message, Visual Basic opens with the...

I am still new at trying to add the "bells and whistles" to Access. I have a question concerning lookups. I have a database that has two tables: BBBMembers...

Hi In my form, i've included graph that will correspond to the combo box The problem is that when other user open the form on their respective laptop, the...

Greetings - Is there a Forms event similar to the On_No_Data event with reports? I have a small form that builds a filter for a recordset. If I run a...

I am building an access database and am attempting to create a form (menu at startup) that I will use buttons to open other forms and reports. I am using a...

Hi, I have created the program (a small program) with the Microsoft Access. This program has share with 4 person/user difference PC. One as a admin and the...

Hi - I have a subform with two combos CboMechanism with row source = TblMechanism and CboSubMechanism dependent on selection in CboMechanism using the...