Search results

I wish I could read records in two tables (two DBase but same fields) and update missing records. I already have a module but I am having intermitent errors. I would appreciate your help. Thanks a lot

I have placed this question in another post but maybe it was in the wrong place. I imported some fields from another database and my memo field displays some caracters like <div>_____</div>. Also there are some strings ending by <br> and others. I know that chr(13) and chr(10) means carriage...

Hi all, Here is a piece of code I have to check if PW is OK. I do not know why it says that PW is not OK when I use Capital Letters. Can anyone help? I believe my problem is here but not sure.:confused: ... For K = 1 To Len(Me!PW) strPW1 = strPW1 & Asc(Mid$(Me!PW, K, 1)) strPW2 = strsPW2...

Hi All, I decided to start a new thread because I could not find a solution in the previous one. First of all I thank Joe for his SearchFor, SearchResults sample he offers for this community. It is really the best. I am using the refered code to search for Name of Exams based on QrySearchAll. I...

Hi, I created a form to select client name. Double click on list box selection and wish to open another form that has a subform in control tab number 2. I could not find any help in previous posts. Tks for any help. Here is the code: Private Sub SearchResults_DblClick(Cancel As Integer) On...

Hi All, I have a table to track visit of sellers. I open a form to create new record. I wish to close this form and open another one based on a query that shows all records related to visits of this seller. Could any member help me on this code? Private Sub BtnSeeVisits_Click() On Error GoTo...

Pls, see if you can help me on this: I have a client table with PrimaryKey, clientname, address, date of birth. Another table with PrimaryKey, phone numbers like Celular, work phone, home phone. I want to show all these info in the same report page. I created a query with these two tables and if...

I have this code in a form. I do not know why when the table is empty, I mean when is a new record the tab goes to the second field that is a date. Is there any way to adjust this code so that if it is a new record it run the code accordingly. Open the form and get focus to CboNameExam? I work...

To Pat Hartman if it is possible. I went through several posts and finally I found something that will need my needs. This post shows my problem but since I am not good in procedure writing I ask you if it is possible to send me an example of this solution or direct me to the right place where I...

Pls Help I have a database where I update info of patients. In The first visit of a patient I input his weight and height in a form and save this info in a table. Next visit sometimes the weight and height are the same so I think I would have a module or procedure to check if this field has...