margot
Last Activity: Jan 15 '08, 05:14 PM
Joined: Sep 7 '07
Location:
-
Thank you, through the macro builder can I have a clear option that after the data is updated the fields will be clear?... -
Thank you, I was able to do it through micro builder. However how can I clear all the fields after the data was updated.
Thank you in advance....Leave a comment:
-
Thank you, but I created the button using the macro builder. So how can I add this feature? Thank you...Leave a comment:
-
Add a button in Access
Hello, I have created a button that adds data to a table. However I would like that when I press the button a message appear saying that data was updated. Can someone help me? Thanks in advance. -
Yes, but I want to bring that number to the actual form. How may I do that?...Leave a comment:
-
Automatic botton Access
Hello, I have a question I have a form call Add record. The user needs to fill out several fields and then after pressing the Add button it will add the record to a table. I would like to create a textbox within the form so that when the user adds the record it would keep a number for that record. So basically the button needs to generate an automatic number for each new record. Do someone has an expample code for this case. I needly badly. THanks... -
Thank you so much!! I have not have time to test it, but I will get back to you as soon as I do it. Thanks again, you are the best....Leave a comment:
-
Yes, I want to do the opposite. So I guess my code is wrong. I want it to return a student ID, based upon an entered first and last name....Leave a comment:
-
two combo boxes Access
Hello, I have a "data entry form" with several text boxes and list boxes, combo boxes.The user is suppose to select a student first name from a combo box and a last name from another combo box and the Student_Id textbox should be updated after the user made the selections. I have written the code below but it does not seem to work properly. Can someone help? Thanks in advance.
[code= vb]
Private Sub txtStudent_ID_A fterUpdate(Canc el... -
Thank you is all fixed now....Leave a comment:
-
two combo boxes Access
Hello, I have a "data entry form" with several text boxes and list boxes, combo boxes.The user is suppose to select a student first name from a combo box and a last name from another combo box and the Student_Id textbox should be updated after the user made the selections. Im not sure what is the best way to to this. Do someome has an example code for this case. I need it badly. Thanks in advance. -
Thank you so much, it works great....Leave a comment:
-
Listbox and open report
Hello, I created a listbox with companies names and when the user selects a company a report is generated based on the company 's name. I created a Function below and then I created a button that will call the function and the report will be generated. If I dont select any field the report is generated showing all fields; otherwise I get this error. "Enter Parameter Value" and If I type the company it will run the report. However I do not... -
I understand why I got that error and I do not get it anymore; however, it still does not work property. Now when I run it a window pop ups and says "Enter Parameter Value" and If I type the company it will run the report. However I do not need the pop up window. Plesase help.
Best,
Margot...Leave a comment:
-
Thank you JKing I tried the code that you suggested; however I get the same error. For some reason I get the same error. Hope you can help.
[Error]
Sintax error (Missing Operator) in a query expression.
'([Sender_CompanyN ame]=Dell)'
[/End]...Leave a comment:
-
Thank you sir. It works great.
Best....Leave a comment:
-
Report Based on a List Box
Hello, I created a listbox with companies names and when the user selects a company a report is generated based on the company name. I created a Function below and then I created a button that will call the function and the report will be generated. If I dont select any field the report is generated showing me all fileds otherwise it gives me an error that it cannot find the company name. Can someone help me?
Thank you in advanced... -
Make selection from two list boxes
Hello, I have two list boxes; the first one has First Names and the second list box has Last Names. I want the user to be able to select the first and last name from each text box and a Report will be generated. I wrote the code below, but it does not work. Can someone halp me to figure this out. I need it badly.
THank you in advance.
[Code=vb]
Private Sub cmdName_Click()
Dim pstCriteria As String
... -
Ok thank you Sir. I will try to fix it....Leave a comment:
-
Thank you Sir, howeve I am not sure I understand what you mean with the code below. Thanks again.
[Code=vb]FieldName In ('Value1', 'Value2', 'Value3')[/Code][/QUOTE]...Leave a comment:
No activity results to display
Leave a comment: