Search results

Rowsource from table field of text type.

type mismatch error

It saying type mismatch when I select a record.

Hi, I have changed the data type of field "EmpID" from number to text and the query not working now. Any suggestion?

Worked Perfectly! Can you assist bit more as you can see in snapshot.

Hello, I have a statement written and getting problem in working when I changed the Field "EmpID" from number to Text. strSql = "SELECT *, Format(Date(),'yyyy')-Format([DoB],'yyyy') AS Age FROM tblRecallSheetStatus WHERE EmpID=" & emp_no & " ;" Set qdf =...

Sure, let me work on it and will be back after what I have designed so far.

Suppose I did that then how can I show the selected records on the report(records with yes values) with similar layout as showed you in snap shot.

All my data is in Access now, I want to prepare that report based on user selection.

Hi, These tests are not yet stored. It is in just report. So in excel what I do, the tests don't required I just hide the rows but don't know how to achieve it in access.

HI, Here is the snap shot of report I want. Actually not getting into your thoughts. So did I need to create a table with all tests with option of yes/no? All tests will be as fields or data in table?

But the issue is how can show all tests on form? just static text with check-box? and how to add the selected only tests to report?

Hi, I would like to get your suggestion regarding the requirements as: 1. A form will be shown with all Tests required. 2. User will click on check-box to include/exclude the test in report So how can I show a form with all tests and how can I get dynamic report based on user choice? So if...

Can you please give a look. I have attached the program.

If you please see the attached snap shot. I apply the code but it is not working.

How can apply to my combo box? Suppose my form name="frmInvoice" and combo box name is: "cboItem" How to link the code with cboItem?

It is the file got from sybase program.

hi, is there any software to convert the .db file to excel format or access?

Hi, I have small program in which I need to add option for a combo box that when user click on it, it will be easy to choose item from 1000 of items by typing its keyword and automatically item is selected in combo box and when enter is pressed it added to invoice: For example: Items are as in...

Yes sure I want discuss more about it and will open new thread.