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

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)...

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

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....

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...

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...

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...

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...

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...

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...

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, 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 ...

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...

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...

My client wanted a small form which displayed stats to reside on the top of screen. It is probably a application better suited for VB or C++, but I don't know...

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...

I have been working on a project where an employee's scans IN with a barcode ID and scans OUT with barcode. My problem is when they scan in I want to see who...

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...

Can any one help...I modified my form and tested n work perfectly well when I copied and past the table and form just the structure to the real time...it...

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...