Forms :: Filtering Data For Any Character That Begins With What The User Input

May 4, 2014

I am trying to filter data in a table using vba where I have a split form setup. My goal is to filter data where the user can input a character such as "a" for the "FirstName" field and have results from the table filtered with persons first name that starts with "a". Here is my code so far one of the text boxes.

Private Sub txtFirstName_DblClick(Cancel As Integer)

If Me.Filter = "" Then
'Compares the values that begin with the input values in txtFirstName
'text box from the table field name FirstName
Me.Filter = FirstName & " LIKE '" & txtFirstName & "*'"

[Code] .....

I get a error in the else statement and please note that I am linking this form to an sql server so I can not delete or modify existing data in the table.

View Replies


ADVERTISEMENT

Forms :: User To Input Data Into One Box Or Another Not Both?

Mar 10, 2013

I have a form, and on the form there is a Provider Rate which is a combo box, if the user select a zero rate, then it has the description please enter manual rate in box below. There is another box which the user can enter a manual rate.

how I can limit entry into these boxes, as currently a user can select a rate in the provider rate box and still enter something into the manual rate box. I want it so that if a rate other than zero has been selected in the provider rate box, then they can't enter anything into the manual rate cell.

View 9 Replies View Related

Forms :: Lock One Field So That Once User Input Data It Never Change Until Closed

Nov 28, 2013

I have a form in Access2000 with 5 text fields which get transferred to the table for each new record. Is there a way i can "LOCK" one field so that once the user has input that data it never changes until closed. I can already lock the field but once i create a new record the field then goes blank.

View 4 Replies View Related

Forms :: Textbox To Momentarily Show Input Character And Then Hide It With A Dot

Nov 26, 2014

Is it possible to have a text box momentarily show the character that is input, and then hide it with a dot (or similar)?

This is for password input so that users can see momentarily, but others won't be able to.

View 4 Replies View Related

Forms :: Restrict User Input In Textbox Depending On What Option User Has Selected

May 22, 2013

I am building a form in access and I am trying to find a way where user input isn't possible in the associated textbox when "No" from on option box is selected.

View 3 Replies View Related

How To Filter On Data That Begins With PI

Sep 1, 2015

In design view, how do I filter on my data so that it only shows data that beings with "PI"? Yes I know I can do this by the main screen and say select text that beings with PI but I would like to know how to do it with sql.

View 6 Replies View Related

Tables :: User Input Once Imported Data

Jul 9, 2013

I am using Access 2002.I am going to be producing a macro that imports a txt file. Once the text file is imported there will be a empty field for a date value. Nothing in the file that is being imported will have a date in it.

I would like to (if possible) to, once the file is in the table, open an input box asking the user for a date (formated as YYYY-MM-DD) and once the date has been entered and the ok button pressed it inputs that date in to all records in the date field.

View 2 Replies View Related

Formula/ Expression For Filtering Out Character Length

Jun 10, 2005

Hi there

I have some information in a database that I need to make sure sure is correct.

There should be 11 characters (numbers, text and items such as /) within this particular field.

I know that there is a number of entries that either has more or less than the 11 characters in this particular field.

How do I create a query to look for and tell me all the entries that are less than 11 characters and all the entries that are more than 11 characters?

Thanks. Hope I explained clearly

Jools

View 3 Replies View Related

Modules & VBA :: Use Different Column Based On User Input To Update Data

Jun 29, 2015

I'm attempting to build an import module so that my users can take data from different walks of life and import it into my tables. I'm doing this by setting up a module and allowing the user to specify which column data will come from when importing data. So lets say I have a field that is CustomerID in my table and user one pulls data from 1 place and in his excel or csv file, customerid is in field 1. Another user does the same thing and its in field 2.

How can i make some form of a loop that when I'm attempting to update data, i pull the correct column?

strSQL = "SELECT * FROM tblImportTable"
Set rst = db.OpenRecordset(strSQL, dbOpenDynaset, dbSeeChanges)
With rst
Do While .EOF = False
If IsNull(DLookup("DefaultValue", "dbo_tblImportTemplateDetails", "Template_ID=" & Forms!frmImport!TemplateName & " AND FieldName='CustomerID'")) Then

[code]....

View 6 Replies View Related

User Input Data In Table Using Form - Sort By Month

Mar 28, 2013

I have a table with product numbers and their cost. That table has 3 fields : SKU, Cost, Month. (The cost can change every month, therefore the list is built to have a cost / month)

I want the user to be able to input the data in the table using the form but I would like the form to be sorted Alphanumerically for the SKU numbers and then per month (in their normal order not alphanumerically).

I have a combobox (named month for testing purposes) to force the user to select one of the 12 months and the field type is Text.

Also I am unsure how to "autosort" (or apply a permanent sort) the form whenever it's opened. Will it be applied if I just set the sort and then restrict the user from seeing let's see design mode?

View 4 Replies View Related

Altering User Data Input From Lower To Upper Case?

May 22, 2015

I have a database containing a mixture of upper and lower case input. I can make upper case appear on the screen by using > in the format box in the property section for each field. This works great but the same old uncorrected stuff remains on the database. How can I get the database to store the corrected upper case data after I have entered it in lower case?

View 11 Replies View Related

Forms :: Validating User Input?

Apr 17, 2013

I have two check box controls on a form, and I would like to set some sort of validation rule to make sure that one of the boxes is checked before the form is closed. I also have many other forms with text, radio, etc. controls that I would also like to set the same rule for.

View 4 Replies View Related

Forms :: User Input Form

Jul 29, 2014

I am working on a database that uses a form requiring personnel to log in. This information comes from a user table and is something that I have added on numerous occasions to various databases. The question I have is in relations to a "lockout." How do I set it up so that someone gets locked out after so many attempts loging in on this form?

View 8 Replies View Related

Forms :: Textbox That Get Value Both From Calculations And User Input?

Nov 7, 2014

I have a form bound to a table, with a subform in there, and I have a textbox with a source one of the table's fields. I would like the value of this textbox to be calculated based on the values of some boxes in the subform, but I also wont to be able to edit the value on the textbox myself.

Is it possible to have a textbox that get its value both from calucaltions and user input?

View 1 Replies View Related

Forms :: Save User Input Value Into A Table

Mar 2, 2014

I need saving 2 input fields into a table. Here is the situation

tableA
studentID
Name

tableB
studentID
Name
Course
Fee

I have a form with a drop down list, to select studentID from tableA. I selected a dropdown from studentID to display Name, and that I tied to txtName

I then type in txtCourse and txtFee whatever value I want, example:

txtCourse = English
txtFee = 50.00

Now, I'm able to transfer studentID and Name from tableA and save to tableB, and delete the record I just selected in tableA.

The issue is, I can't save the txtCourse, txtFee as I don't know how.

Here is what I have

Private Sub Insert_Click()
Dim strSQL As String
strSQL = "INSERT INTO tableB SELECT studentID, Name FROM tableA WHERE studentID = '" & txtstudentID & "'"
CurrentDb.Execute strSQL

strSQL = "DELETE FROM tableA WHERE studentID = '" & txtstudentID & "'"
CurrentDb.Execute strSQL
End Sub

I'm stuck on how to save txtCourse and txtFee into tableB where I have Course and Fee fields.

View 4 Replies View Related

Forms :: Textbox For Order ID Input By User

Jun 21, 2013

My table have orderid along with other columns, i want to create a form where i am having a textbox for order id input by user. Firstly when user sees the form its only with the textbox and table fields, when i put the order id in the textbox the listing should be made.

View 1 Replies View Related

How To Make Input Mask Display More Than One Character

Nov 7, 2011

How to make an input mask display more than one character?I'm building a db for work, and multiple (non-IT) people will enter data. Instead of having the input mask for the date field display as ##-###-####, I would like it to display as DD-MMM-YYYY.

View 3 Replies View Related

Forms :: Creating User Record - Input Multiple Tables From Form

Mar 28, 2015

I am building a form to create a user record and at the same time i have some yes/no options which are located in other tables but when i want add a user i cannot select any yes/no options they seem locked?

View 1 Replies View Related

Forms :: Creating A Form That Require User Input To Confirm / Cancel Changes

Jun 24, 2013

I am fairly new to Access and my "changed" position at work requires that I learn much more about the software. My first challenge is to learn how to make an existing form prompt a user to confirm or cancel changes. I don't know anything about coding but I searched online and found some coded that is supposed to make this happen. I went to "form properties'' and typed this (below) in BeforeUpdate:

'If the form data has changed a message is shown asking if
'the changes should be saved. If the answer is no then
'the changes are undone

On Error GoTo BeforeUpdate_Error

[Code] ....

BeforeUpdate_Exit:
Exit Sub

BeforeUpdate_Error:
MsgBox Err.Description
Resume BeforeUpdate_Exit

After saving changes to the design, I tested by changing the record. I received no prompt.

View 2 Replies View Related

Modules & VBA :: Run-time Error When Enter Character In Input Box

Jul 6, 2013

When I enter character in input box then show run-time error with this code.

Code:
Private Sub cmdDelete_Click()
Dim password As String
If Command49.Visible = False Then
password = CStr("0" & InputBox("Enter Password"))

[Code] .....

View 3 Replies View Related

Forms :: Filtering Data Or Unmatched Data

Mar 17, 2014

I am totally new in Access VBA, plus I am trying to learn during my free time, I am able to create the following Unmatched query (using Wizard), but now I am trying to learn using VBA code

Table1
Curr CurrName
CAD Canadian Dollar
USD American Dollar
GBP British Pound
AUD Australian Dollar
EUR Euro

Table2
Year Curr
2013 CAD
2013 USD
2013 EUR
2014 USD
2014 GBP
2014 AUD

Now, what I am trying to Learn Filtering Data at Form Level

-Combo Box - Select Year (I am able to Learn using VBA code- Working Perfectly)
-ListBox1 - Show Currcode for selected year (I am able to learn using VBA code and working perfectly)
-ListBox2 - Would like to see Unmatched currcode from Table One (unable to figure-it-out how this will work in VBA)

E.g.
ComboBox = 2013
ListBox1 = (CAD,USD,EUR)
ListBox2 = should show (GBP and AUD).

View 3 Replies View Related

Filtering Date Input

Dec 1, 2005

i am trying to build a marine turbine and parts log and have a problem in satisfying a working rule.

i have 2 tables which i have attached,

table 1 shows the on / off dates that a generator was fitted to a turbine

table 2 shows a general date history of the generator, when it had checks done, fitted, etc

what i would like to do is fit the generator again to another turbine

using a continous form to show the available dates in table 2, i would NOT like to see the dates during the period when the generator was fitted previously as shown in the on / off the dates in table 1.

the working rule being that a generator can not be fitted to 2 different turbines at the same time

can anybody point me in the right direction or assist in how i can overcome this problem

many thanks in advance for help provided

View 3 Replies View Related

Forms :: Filtering Data In Fields

Oct 1, 2014

I have a form with two fields in the header meant for filtering the form data - SelectAtty and SelectClient. The query under the form is restricted based on the values selected. I also have a "button" that if clicked should filter the records (probably unnecessary but I thought it would be clearer for the user). I'm seeing two issues. Sometimes when I select a value - it doesn't appear to apply it to the query at all. When I add msgbox statements to try to see what is happening, the problem goes away (weird right). Also I run into a "no current record" error when it requeries. Mostly this seems to happen when I have two events that fire in a row and both requery. The event procedures are below and you can see where I put my debugging msgbox statements.

1. No current record fires consistently on the filter image click and (I think) always when it requeries twice (like I changed the value and then clicked on the filter).

2. The fact that sometimes the selections are picked up in the query and sometimes aren't I have no good pattern for other than msgboxes seem to actually fix it - as if it forces access to look at the values and they they show up.

Private Sub FilterImage_Click()
MsgBox "filter: " & Form.CurrentRecord
MsgBox Form.RecordSource

[code]....

View 2 Replies View Related

Forms :: Create Data Entry Form To Input Data For Field

Mar 5, 2015

I an trying to create a data entry form (IndividualsEntryFm) to input data for fields such as (First Name),(Birthdate) etc., these to be saved to the (IndividualsTbl)

I also have another table (NamesTbl) which has family names etc. The two tables are linked by a (MainID) field. I want a combo box on the individualsEntryFm so that I can select the family name. Then I wish the empty fields for the IndividualsTbl to be available to enter data.When I press the save button I then want this data saved, together with the MainID from the combo box to the IndividualsTbl.

I have set the IndividualsTbl with a (PersonID) field as an auto number each individual therefore has a unique PersonID but may well share the MainID. I'm trying to link many people to the same address.

View 1 Replies View Related

Forms :: Filtering Data Other Than Combo Boxes?

Mar 24, 2014

I am using master/child form for data entry for packings and the details for this packings (i.e. the products inside a packing is entered in subform and packing master is entered in main form ).

In the detail subform i use a productId field which has look up from 1000 products , so i want to filter that particular combo box based on different types from product master ( from which it choses the products).

How many ways are there to filter that combo box based on different types ( which i have in product master as type,design,material etc).One way of which is combo boxes on main form.

[URL]

View 14 Replies View Related

Forms :: Filtering Data Field On Main Form?

Jan 22, 2014

Is it possible to use Filter option in my form without using Query Wizard? - So that the user would be able to edit and change the other field on the same form

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved