Replies

Thanks for providing information. But still why I can do it by using reglar outlook not email by access?

Thanks

Thanks

I am sorry for unlear information. Yes, I do want the text box on the report to match the corresponding text box on the form. My problem is there’s two lines in the text box on the report. How can I match it?

Sorry again for unlear informations.

Regards

Thanks a lot.

It works.

Regards

Thanks

How about I want input data is exactly match with data in table? What I should put instead of “*”

“ID = ” & Me.txtSearchID & ” OR CustomerName = ” & Chr(34) & Me.txtSearchName & Chr(34)

What is “Chr (34)?” What’s “ID=”

Thanks

Yes. It works.

This is what I do, I have “Delete” button on the form, and users click “Delete” button, the query pops up with delete confirm message.

My another question is how can I hide query window? Just confirm message appear. Please see below my code:

Private Sub DeleteCurrentIssue_Click()

DoCmd.OpenQuery “qryDeleteData”
RunCommand acCmdDeleteRecord

End Sub

Thanks

Regards

Thanks.

One more question. I write code to run query, but I want to know how can I delete the record in query by using code???

Thanks

Regards

Yes. It deleted now. But I have to use query base on both tables, because I let user to search base on the criteria then delete the records that user want to delete. If like this case, I only can delete records from the query base only tblRequestInforamtion, how can users to look at data have in tblRequestDetial in search result.

Thanks

Regards

Thanks a lot.

But I have a problem to delete records form the query. After I click yes when Access ask me whether it is ok to delete the records, I reopen the query again the data still there. Can you help me to take a look the attached file?

Regards

Yes. It is automatically.

But in database A, I check “Enforce Referential Integrity” & “Cascade Update Related Fields” & “Cascade Delete Related Records,” of the relationship of table. After i link it in my database B, the relationship between between the tables only have “Enforce Referential Integrity” checked. I did test three times.

Is this normal or I did anything incorrect?

Thanks

If I define the relationships between the tables in the Database A (only have tables). Should I define the relationships in the Database B ( have query, forms and report) again?

Thanks

Sorry for unclear information. Let me try to explain again,

That database is set up at work for users to use. But most time I do update or change of database at home.

That’s why I put all tables (6 tables) in database A, then I put query, forms and report in databse B and I link the table from database A. If I want to bring it to home, I copy database A & B to my usb drive. When I back to office next day, I copy and paste udpate database B to network drive at work. Then I delete tables of udpate database B and relink it with Database A at work. So in this case users have accruate data.

But everything when I delete table from udpate database that I work at home, the relatinships also deleted.

So what I can do with my suitation?

Also another issue is I want users still can use the database when I doing update or charge it at the same time. That’s another reason why I put tables on the datbase A.

Regards

Thanks

Thanks a lot.

It works.

But I don’t have defaul users, I let user to select from the form. Please help!!!!

Regards