Mikepf

In the expression IIF[SSN]=50,99,[SSN]) when I enter 60, all works well. But if I enter 50, I get "The value entered doesn't meet the validation rule for the field or control". BTW, SSN is defined in the table as Number (Long Integer). What's the problem?

Hey All! I'm currently creating a database for a payroll system. I have a table consisting of Occupation_ID (primary key), occupation_description, normal_rate and then 3 different overtime rates. I've created a query to calculate the overtime rates for the different overtime rates, i.e. [code]UPDATE Occupation_Rates_Table SET occupation_rate_overtime_1 = Occupation_Rate_normal*1; [/code] …

[INDENT]Hi! im a student needing help for my thesis project. im currently working on a supply chain management system. [/INDENT] [INDENT]i have created a sales form wherein you can input the customer order. adding the customer and product information and subtracting ordered product quantity works. im having problems with my …

Form1 searches table1 for a key. Go to Form2 and store key (not visible). Then read table2 using this key. If NO match, just enter new data and close Form2 to save to table2-this works ok. But if there IS a match, click on NEW Record icon at top of …

Form1 searches table1 for a key. Go to Form2 and store key (not visible). Then read table2 using this key. If NO match, just enter new data and close Form2 to save to table2-this works ok. But if there IS a match, click on NEW Record icon at top of …

I have successfully created a command button on a form to do a search on a primary table for a key, entered data on the form and saved it into a second table. However the key for that second table does NOT get saved (but does show on the form). …

Please tell me the necessary code to read a first table for information then search a second table. If no match, add a new record to the second table. Thanks!

Hello all, I have this program where I look through all the rows in the excel file I use... Cells(1, 1).Select Set rngTPT = .Range("A1:A650") but I dont want to have a range limitation. How can I go through the file but not give it a limitation? I was trying …

I am started a new with VB6 Access project. I am connected database with ADODB, DSN Method that Code Given below. '================In module ============== '============ Connection With Database =============== '============================================= Public CNN As New ADODB.Connection Public RS As New ADODB.Recordset Public cString As String Public Sub Main() Set CNN = …

Hi ... I am totally new to vb programming.I have to do something like this for this i am not having any idea,kindly help me. I have two excel files-- file one has data like thi--- 601A 600 580 780 48 300 33 601B 600 580 780 48 300 601C …