Search results for query: *

Hi there I have the following codes in on_Click event of a Button. And as you can see it’s job is to Add data to a Table in my DataBase, And It works. But here is the little problem that I have with it, In order for it to work, all the Fields in my “tableSales” must have a value for them, other...

Hi There What is the best way to make sure that a User enters a value in a Particular form, Before Leaving it to next Control? I know we can use the LostFocus Event of that control, But that can create problem if the user decides to close the form before Entering any value in it, as you know the...

Hi there I have a form with bunch of TxtBoxes, comboBoxes, Buttons, and a subform, I would like to set the value of all the TxtBoxes and comboBoxes in my Form (Not the subform) to Null. I know one way to do it is by calling each one of them like; Me.InvoiceID100.Value = Null But since there are...

Hi there I am a little confused on Error Handler in ADO recordset. Following codes Work. (so do not be intimitate by the size of it) Basically How does the Error handler work? I have some Idea about the concept of it, But I am not quite sure “for example, In a situation that we are trying to...

Hi There For Example, I would like to press 2 Buttons by pressing 1 Button, or in UnLoad Events of a form. Lets say that we have; Command10_click Button and Command20_Click button I would like that both of them to be pressed in an Unload event of my form, But here is the challenge that there...

Hi there I have an Unbound TxtBox, which I would like to show the last value of Column in a table. Do you have any Idea, that How this can be done? I know it could be done using DlookUp, But I just do not know what to use for criteria for it. =DlookUp(“SalesID”,”TableSales”,”me!LastRecord”)...

Hi There I have an application of Access as Fe and SQL as BE, And I have a Form called “sales” in it with a subform in “sales” which is called “Account Details” The account details is made of a comboBox and 3 TxtBoxes 2 of the txt boxes are called “Sc10” and “Sd110”. The subForm Default View...

Hi there I have a question about Following codes; These Below codes as you can see update a table by Name of Tablesales using ADO recordset And they work for most Part, But as you can see these codes check for the Error (# -2147217900, 3219, and any Unknown error) for all my Records, but I want...

Hi there I have a question about Following codes; These Below codes as you can see update a table by Name of Tablesales using ADO recordset And they work for most Part, But as you can see these codes check for the Error (# -2147217900, 3219, and any Unknown error) for all my Records, but I want...

Hi there I have a subform called “Products Details”in my form called “sales” . This Subform has a DefaultView of DataSheet. This subForm has a comboBox called “ComProducts” with different Products in it; Here is the challenge, I want upon opening the “Parent form (sales) and Consequently the...

Hi there I have a form with Access as FE and SQL as BE, I have some codes in my Before Events of my form. Which is working sort of fine, But here is my problem after I get my msgBox with a vbyes and vbNo option, after for example pressing the yes Button, I get the access MsgBox “off course it...

Hi there I have a form in a application with Access as FE and SQl as BE. The following line of codes (Different version of the same Line) Does not work any suggestion of what is wrong with it? I had these line in a Data Source of a TxtBox control, The Field Data Type of the comboBox Contol is...

Hi there I have a little difficulty with my codes When I want to close my form called “sales”. I have following codes in it’s UnLoad event, and it checks for the value of 2 txtboxes before it closes, And it works; Private Sub Form_Unload(Cancel As Integer) If Sd.Value - SC.Value <> 0 Then...

Hi There I am trying to stop the users of entering duplicate values in a textBox control called (InvoiceID). I came up with following codes, But the do not work for me at the time, Any suggestion? Here are the codes, that I tried; Private Sub InvoiceID100_BeforeUpdate(Cancel As Integer) Dim Msg...

Hi there I have made an App. using Access as FE abd SQL as BE, I would like to make a Demo Version of all Access App. Can It be done? Here are the details; To be Exact, I have about 25 Tables, and 20 views as of yet. Luckily, I have not started to create my Stored Procedures, Functions, and...

Hi Every Body At first let me explain the situation a bit. I have a form. Upon Opening the Form, In order to make my users to select an option in my comboBox (Indexed value is 0), I have the following Codes: Private Sub Combo144_LostFocus() Dim strMsg As String, strTitle As String Dim...

Hi Every Body Upon opening a certain Form, What is the best way to force a user to use a certain CommboBox or CheckBox before they can use any other controls on that Particular form? Another related problem, Using VB codes, how can I choose or set a value of my CommboBox? For example I would...

Hi every Body How can I force my Users to push the Tab Button or enter Button after they Enter any values in my Text Box Controls? If they do not push those buttons they should not be able to close or add a new Record. Best regards sanan

Hi Every Body Is it possible to Execute 2 Events by one Button? Let me Explain a Little, I have a Form and a in it a Subform, My sub Form is in DataSheet View, and There is a Master and Child Link Field between the 2 Forms. On My sub form there are 2 Text Boxes, I removed my Navigation Buttons...

Hi Every Body Here is the problem I am experiencing with it. First I explain the situation, I have a Form and a Subform in it. My SubForm Propertie’s default View is DataSheet. There are 2 Text Boxes in My SubForm that The Entries on them must be Equal. In Order to make my Users Enter the...