Forms :: Enter Couple Of Alphanumeric Groups Into A Field On Input Form

Apr 3, 2015

I would like to enter a couple of alphanumeric groups into a field on an input form. After I enter an alphanumeric group, I hit the enter and the data will add into the field and refresh to empty box ready for next entry. If I continue to enter another group and hit enter, the next group will be added to original field with a comma and a space in between. build the VBA in after update event to accomplish the task.

View Replies


ADVERTISEMENT

Forms :: Automatic Alphanumeric Increment Field

Mar 5, 2015

I've got most of what he wants sorted but this last task I am completely flummoxed. All of his projects are allocated an ID (named Project Reference), starting from P010010 and increasing by 1 each time. I've made a form that allows a new project to be recorded by entering all the details and hitting the 'record' button, but he wants the Project Reference field to be automatically filled in each time (understandably), increasing by 1 from the last record.

So if the last record was P010311, then when the form opens the Project Reference should automatically be P010312.

I've looked into this and found many guides talking about DMax and DIM and strCriteria and whatnot, but no matter how many of them I follow and try to adapt to my own database I can't get it to work at all.

The table the ID comes from is called General, and the field is Project Reference. The ID should automatically be filled into a text box called txtRef whenever the form opens and a button to add a new record is pressed, being 1 higher than the previous ID.

View 1 Replies View Related

Forms :: Alphanumeric Data In Field - Multiple Auto Number

Dec 27, 2013

I have a table having the following fields:

StaffNo TextField PrimaryKey
Name
....
...

The data in StaffNo will be alpha numeric, like AKA-111, AKA-112, LMN-100, LMN-102

Here AKA and LMN describes the Sites where employee is working.

On Add New Employee, When user enter AKA- in StaffNo, on exit the next number on that site should be generated. i.e AKA-113.

View 8 Replies View Related

Forms :: Unlock Different Fields On Form When Check Couple Is On?

Jun 22, 2013

On mij registration form I have the option to fill in the name and day of birth, email and GSM number of the partner off the main contact.

But to keep the form nice and clear, I only want to make the fields acceseble when the checkbox from [couple] is checkt OK.

How to make the fields and the Box around it Light Gray, so its very clear it issn't clickable.

The main coller is white BG and Green strokes. (see attachment) When the field [paar] 1 (couple in englisch) is OK then the fields in de eclips 2 are available And I want the collors of the stroke 25% black and de fields disabled.

View 2 Replies View Related

Forms :: Setting A Field On Form To Only Allow Text Input

Jan 9, 2014

Is there a way to setup the format on fields to only allow text inputs, no numbers wanted. I know I can do this at the table level but is some cases numbers are ok. So I want to code it so I can control when numbers are ok and when there not.

View 1 Replies View Related

Forms :: Prevent Duplicate Entries Of Field On Input Form

Nov 24, 2014

I have recently started working for a new company and have inherited a nightmare of a system!

I have basic knowledge of Access and have been asked to stop duplicate entries under the same PO Number.

I have tried using DLookups by looking at other posts on the forum with no success.

The input form is called Purchase Order Entry, with the field called PO_No. The table is called Orders, with the field called Purchase Order Number.

I have tried to make the Purchase Order Number in the Orders table, the primary key but an error that it cannot contain a null value appears.

The Purchase orders may not be entered into the database in numerical order also.

View 14 Replies View Related

Calculated String Input Field In An Input Form.

Jan 30, 2005

Hello,

I need to create a field in an input form that is simply the concatenation of two other text fields. I have tried all sorts of things, but when I look at the data in the table that field.

I have a field called ID that I want to be created like this:

=Format([UniqueID],"00000") & "-" & [Mosque]

This works well in my output fields, but does not work the same way on the input form. It needs to be based on the currently input values from the current record. Anyone have any ideas?

Thanks in advance,
--Robert

View 3 Replies View Related

Forms :: Web Form Option Groups

May 13, 2013

How to create a Web Form and include an option group (5 or 6 radio or check boxes)? I really need the page to layout all of the options (not in a drop down). This will allow users compare answers on the fly looking at the form.

View 2 Replies View Related

Forms :: Form Auto-populates Date Field - Want To Add Check Box To Enter Alternate DATE

Nov 1, 2013

We use access to enter our service tickets in at work.What we have are three date fields.

Call Date
Start Date
End Date

We are 24/7 operation.Currently all 3 just autopopulate with the current date.What i would like to do is ADD a CHECKBOX next to each Date Field.And make it work like this.

1. let them autopopulate as they are currently
2. if you end the call AFTER MIDNIGHT (the next day). CHECKING the box would automatically populate yesterdays date in each of the fields that has the check box CHECKED

View 3 Replies View Related

Forms :: Couple Of Forms With Combo Boxes That Look Up Data In Queries

Sep 4, 2013

I have a couple forms with Combo boxes that look up data in queries. I noticed in testing that I could accidently type a "~" (and other characters) in the field and once I do, it causes a runtime error that shuts down the entire app (as opposed to letting the user backspace out of it or resetting the field). Before I put in some "Before Update" code to prevent the system from crashing, I want to make sure I am on the right track. I have already set the combo box to just show the list, not allow edits, limit to list, etc. Is there a way to prevent the user from doing this either by preventing the keyboard from working on combo boxes (not preferred) or by trapping it before the system crashes? I would think I could validate with a recordset, and create my own path out for the user, but I was hoping the combo box would have sort of done that work for me.

View 1 Replies View Related

Sorting An Alphanumeric Text Field

Sep 30, 2005

I have a text field in a table that contains an alphanumeric code. i.e.

DEL998
DEL999
DEL1000
DEL1001
SUN998
SUN999
SUN1000
SUN1001
SUN1002
etc.

I want to run a query to find the highest number for a particular alpha code. In the example for DEL I would want the query to return DEL1001.

I have created a select query that asks for the alpha code, selects all codes starting with that code, sorts them in decending order and only displays the first record.

The problem is that because the field is a text field the numeric is not sorted like a number. So in the DEL case the query returns DEL999.

Any ideas on how I can get a result of DEL1001??

Thanks for your help

View 1 Replies View Related

Make A Field That Was Numeric / Alphanumeric

Feb 5, 2015

I have a database I have worked on for the sister company of the place I am employed.I have a field I am trying to make alphanumeric that has been numeric. (PO Number on the main form). I had make it alphanumeric a couple of months ago, but it disabled the Edit Customer Information button on the bottom right of the form to where I cant enter shipping addresses and things like that. It should be able to enter multiple shipping addresses.

I need making the PO Number field button alphanumeric and making sure it doesnt mess-up the Edit Customer Information button. I have attached both versions of my database. The GM at the sister company would also like me to create a Spin button where you can take an old record and keep all of the previous information on it, except it gives it a new Work Order# and you can change the date to something newer.

View 4 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

Queries :: Input In Enter Parameter Value Pop Up Box

Mar 13, 2013

Every time I run a query that I have created it asks me to input Expr1 and Expr2 in an enter perameter value pop up box. I don't enter anything, just click okay and the query runs as expected.

Is there a way to get rid of these? (and maybe more importantly, why do they appear?)

View 8 Replies View Related

Importing Alphanumeric Data Into Text Field

Mar 31, 2008

I have searched this forum but didn't find the answer, I hope I'm not the only one with this problem.
I have two text fields in a table that are updated through an excel file import. In the excel file, both fields contain data that is mostly numeric, but there are always about a quarter that contain letters as well. When I go to import the excel file, it sets to null any value in the fields that contains letters. If I sort the excel file in descending order for the field, it will import, but I have two fields that do this, so this brings more problems. Does anyone know why you can't just import anything in any order into a text field?

View 14 Replies View Related

Sort Alphanumeric Field - Code Problem

Dec 1, 2006

hi
i found this code here and it works IF the number comes first and is preceded by a letter
123AA

but it does not work if the letters come first
AA123

here's the code

Public Function GetString(WholeString As String) As String
Dim i As Integer
Dim Temp As String
Temp = CStr(WholeString)
For i = 1 To Len(WholeString)
If InStr(1, "0123456789.", Mid(Temp, i, 1)) = 0 Then
GetString = Mid(Temp, i)
Exit Function
End If
Next i
GetString = Temp
End Function

Public Function GetNumber(WholeString As String) As Double
Dim Temp As String
Dim i As Integer
Temp = CStr(WholeString)
For i = 1 To Len(Temp)
If InStr(1, "0123456789.", Mid(Temp, i, 1)) = 0 Then
GetNumber = Mid(Temp, 1, i - 1)
Exit Function
End If
Next i
GetNumber = Temp
End Function


the probelm is with this line but i'm not sure what it is

GetNumber = Mid(Temp, 1, i - 1)

(i also get runtime error 13) but my data is in the same format as the example i downloaded.

any ideas anyone?

thanks in advance and thanks to the person who created the code

View 1 Replies View Related

Forms :: Enter Parameter Value On Unbound Field

Nov 27, 2013

I'm using Access 2013.

My scenario is: I have a Form to add Job Logs. This form has a cascading combo box with Clients filtering Projects. However, the Clients Combo Box is unbound, Projects is bound to the ClientProjects ID. I had to do this instead of have a key for both Clients and Projects in my Job Logs table due to the fact that Clients and Projects have a many-to-many relationship.

For Adding Job Logs this is fine.

My Problem: I have separate forms for viewing and editing Job Logs, and naturally, because Clients has no binding, every time I run these forms Access brings up the 'Enter Parameter Value' Message Box. I have tried a VB script to assign the Client ID based on the ClientProject ID value stored in the Projects combobox, on Form Load, however it still asks me to enter the Parameter Value and just writes the code in the combobox. Here's the Script:

Private Sub Form_Load()
Me.SelectClient = "SELECT Client ID, Client Name " & _
"FROM Client Projects Query " & _
"WHERE ClientProjectID = " & Me.SelectProject.Value
End Sub

Also, the Projects Combobox is also empty.

View 11 Replies View Related

Tables :: Validation Rule To Change Field To Alphanumeric Only?

Dec 6, 2013

What would I need to enter into the validation rule to change the field to alphanumeric only?

View 3 Replies View Related

Change Field To Alphanumeric (text) From Number Type?

Nov 13, 2014

I have an existing form where users type in information and it generates a couple of reports. In one of the fields, Customer PO Number, the user enters a number from a customer. Up until yesterday all of the customers we have been dealing with have used numbers only for their PO numbers. However, we have a new customer that requires alphanumeric PO's. Is there a simple way to change this field from a number to alphanumeric without having to redo each form, report and/or query. I am using MS Access 2010.

View 9 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 :: Macro To Enter A Standard Text Response In Any Field?

Apr 18, 2014

I am filling in a database using forms, and I would like to be able to add standard values to any field using a macro/VBA code I don't want to set up a different macro for each field though - I have around 40 different fields (to elaborate, it's a mark database for student projects, each field is a different thing I am commenting on. I want to quickly add 'Missing' or 'Good' to a field - but I also want the option of free text instead.).can't figure how to do it in MS Access.

View 2 Replies View Related

How To Use Inputted Field In A Form To Enter Automatically In Another

Jun 10, 2015

I have a form where I select either "Male" or "Female" via tick box. If male is selected I would like it to automatically enter "he" in my table in another field so I can use this info in a Word template letter.

View 2 Replies View Related

Forms :: Adding Sequential Alphanumeric Record To A Table?

May 18, 2015

I have an Access table with records that have a two letter, two number alphanumeric identifier (AA01, AA02 etc)

I am trying to create a form whereby, when the user types in the first two letters, the next sequential number from the table is generated.

The letters can be totally random and selected by the user, but the numbers do need to be sequential.

View 1 Replies View Related

Forms :: Sort Alphanumeric Fields Where Number Of Digits Not Always Same

Mar 13, 2013

I want to know if there's a way to sort alphanumeric fields where the number of digits aren't always the same.

Example: I have the following: 2a, 10a, 3a.

Currently, it sorts: 10a, 2a, 3a.

Is there a way to get it to sort 2a, 3a, 10a without adding a 0 before 2a and 3a?

View 5 Replies View Related

Forms :: Can't Enter Data Into Blank Field On One Side Of Outer Join

May 21, 2014

I think I have just finished designing my database and I tried to test it and I couldn't enter any new records as it says "Can't enter data into blank field on "one" side of outer join" whenever I try and enter info and I don't know much SQL to work out what has happened. It probably causes this too but I also cannot select check boxes.

The form where I try and enter the info is called Crisis_support_workers v3. I have attached my database so you can look at what I have done.

View 1 Replies View Related

Forms :: Count Of Records Between Value Of Two Fields - Enter Total In Bound Field

Aug 8, 2013

I have two fields on the main form and I need a total count of records between the value of the two and then enter the total in a bound field on the main form

View 1 Replies View Related







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