Search results

Can you describe it in detail. What statement should I use in Current event and what will be the paramemeters for dlookup function?

Thanx, Boblorson. It worked! My problem is get solved now.

I have placed one combo box on main form. It contains the primary kyes or record. I also added subform on this form which is bind to the query. I want to populate this subform on the basis of value selected in combo box. How can I do it? I have tried_ Binding the subform to combo box by setting...

I want to bind label control or textbox control with query returning single value. How can I achieve it? My query returns single value.

Thanx, It worked!

I have master table named Emp_Master with fields Emp_ID and Emp_Name. I want to bind the combo box with name in such a way that it will display the names of employee but I should be able to use Emp_ID in background so that I can query different table using this value in where condition. I have...

Can I use left and right outer join at a time? Means I want all records from both the table, and it should put 'null' whenever value is absent.

Plz reply, it's urgent!

How can we use the single button on the form to run multiple queries? I want to run multiple upend queries on single button click, where should I write quries and code?

Actually files are confidential and I can not post that. I can explain u situation in more detail_ I want to track monthly transactions in database. I edit one excel sheet in eah month. this sheet is linked with access databse. There is another table in access databse. In that table I apend all...

My destination table contains only text fields and all of them are set to 255. I really fade up with this problem.

I have only text fields in destination table and I already set all of them to 255. This problem is really firstrating me!

No, I am not doing any calculation. I am just copying records from one table (Which is linked to Excel table) into another by running append query.

I have linked One of My access Table with Excel. I am running the upend Access query to insert record from this table(Table that is linked with Excel table) into another access table. Whenever I run this query I get error "Numeric Value Overflow" nsg box. I checked the data types of all fields...

I want to do the following task_ Obtain calander control on form. Whenever I will select the particular date, that date should be get copied into the Textbox placed on the same form. (I don't know weather calander control is there or not in access) Please Help me, It's urgent.

Thanx all of you! I understood the process!:)

ya! you are right.

I am new to the Access. I want the procedure to do following thing to make my concept understanding clear_ Adding Button and textbox on form, On button click, text in textbox should be stored in table named Master (Name (Text)) in database? Please provide me step by step procedure to do this...