Search results

Tks John, I have already read the article you mentioned. Maybe the problem is to open the form from another form where I select name in a listbox. The main form shows ClientID and other info. The subform that is shown in the tab shows info like ClientID, VisitID and other info related to Visit...

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...

Hello, I got it. I followed yr instructions and it it working great. Tks. Can I ask another question? I need to close the first form when I open the second one. If I put me.1stform visible.false the code goes to second form and open it, but when I re-open the first form it is still there and...

thank you Paul. I will let you know what I got.

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...

DCrake, thank you, thank you, many thanks. I did exactly what you said and that is it. All main info like name, address. etc are in the client group and the phone categories are in the details. I print just one client each time because I type info and if needed be I ask to print a report for...

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...

Thank you SOS. Now my code is working great

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...

Hello, I followed allenbrowne steps and it is working great. tk you.:) Could you explain a little bit more what do you mean by "Lock individual records"? Just to see if I can help you.

Forgive me for taking this post to make my question that I believe is similar. I am also searching for a solution like this because sometimes I start typing on previous record instead on a new one. I wish I enter a locked form and If I want to edit it I could unlock either pressing a button or...

Tks Lucas, In fact I am struggling with an aplication and each day I have another problem. I will review the whole problem and start another post.:o

hello, could you pls help me to make a string to check if a 3 key fields are already in a table? I have two ID fields, CustomerID, productID and a date field, date of sale. I understand I have to create a temp field to keep the dcount result, then before update the table I can receive a msg and...

I was just passing in the forum and saw your problem. Have you already solved? I work with Excel and I could give you some ideas about datatable in excel and crosstabquerry. If you want pls e-mail me neideb@gbl.com.br

Hi, sure your application is very popular. I am having a big problem because my application is being used by 3 different monitor and resolution and I have to create m macro for each form to move and dimention the forms for each of the clients. And, worst, my pc is different than those of them. I...

Dear Don, tks for your reply. I have received your sample and it is exactly what I need. For sure my job will be a lot better and light for me. I thank you for your help and hope this Forum be of continue success because we learn a lot from it. Best regards,

Dear Don, tks for your suggestion but I may be doing something wrong because I was not succeed in this procedure. If you do not mind pls check the following code for me. I will be very thankful. I need that this code checks if I already have the name and birthday and if it is OK I have to...

Hi Don, tks for your attention. I just printed your suggestion and will work on it. Let me ask you permission to post you back if I have any problem. Tks a lot...

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...

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...