Select First 2 Characters

May 1, 2008

Hi,
I am trying to use a query to select the first two characters from a field I have created in a form. I would then like to use these 2 letters to filter out results in the query.

For example:

I have a number of sections in a document (1a - TAKE OFF, 1b - LANDING, 1c - STATIC etc.) which include associative chapters (1a.Contents, 1a.Introduction etc.).
From a combo box I select the section (i.e. 1a - TAKE OFF), I then want to filter out all the chapters in the associative section (i.e. 1a.Contents, 1a.Introduction etc) by using the first two characters of this combo box in the query.....

I hope this makes sense!!!

Cheers

View Replies


ADVERTISEMENT

Select Only First Two Characters From Table

Dec 5, 2005

I have a table which contains a nine digit number. How do I write a query to limit the restults to just the first two digits of that nine digit number?

Thanks

View 2 Replies View Related

Queries :: Command To Select First 30 Characters

May 7, 2013

I have the command to select first 30 characters in a simple select query.

View 3 Replies View Related

Modules & VBA :: Programmatically Find And Select Item In Multi Select List Box

Apr 23, 2015

I have a multi slect list box (simple) and I need to find and select an item using vba - e.g., the bound column is the ID field and I need to select a specific ID (which will be different each time) as opposed to selecting the 100th record for example. How do I do this?

View 2 Replies View Related

Forms :: Select Record On Subform To Select Default Value In Combo Box?

May 6, 2014

I have a subform containing a list of Funds and attributes such as Asset Type, Fund Manager, etc.

Currently, I have a textbox, where the the control source is set so that it will be updated with the Asset Type from the subform.

I also have an unbound combo box that contains a list of Asset Types queried from a table via row source, where user can select the Asset Type.

What I would like is when a record is selected from the subform, the Asset Type is selected on the combo box as a default value. User can select another Asset Type if required. How can I do this?

View 1 Replies View Related

List Box One Click Select/deselect With Multi Select

Aug 28, 2004

Hi,
is there any (reasonably simple) way to select or deselect multiple items from the List Box with individual clicks without using Ctrl key. Eg first click on an item would select it leaving all other items as they are, subsequent click on the already selected item would deselect it etc. I hope this is not too confusing and I would appreciate some help.
Thanks!

View 1 Replies View Related

Select Values In Multi Select Listbox

Aug 19, 2005

i have a multiselect listbox in my form.
The multiselectlistbox contains the names of different persons from tblUsers.
it's allready possible to write the id's of the names to another table (tblPresent).

But what I can't manage to do is re-select the values in another multiselect listbox. This multiselectlistbox is located on my editform.
I can display the values using a valuelistbox, but i need to see the non-selected items too..

hope someone can help me out

View 1 Replies View Related

Modules & VBA :: Getting Error End Select Without Select Case?

Sep 5, 2014

When I run the below code I am getting the error "End Select without Select Case" I figured it might be because I have the "End Select" before the "End With" however when I move the "End Select" after the "End With" I get the error "Loop Without Do".

Code:
Private Sub cmd_Update_Conditional_Codes_Click()
Dim rs As DAO.Recordset
Dim rs2 As DAO.Recordset

[Code].....

View 3 Replies View Related

Corrupt Characters

Oct 3, 2006

My client is reporting corrupt characters cropping up in fields. These characters appear as Asian Characters. They only corrupt one record.

This happens very seldom. In fact, it hasn't happend for about 2 months and today it happend again. Their was no change to the database.

Is this a network problem? Network noise corrupting data?

Thanks

View 5 Replies View Related

Characters In Query

Feb 19, 2007

Hi
I want to ask something simple but because i am new i am dont know it!!! If you try to make queries in Access, untill how many characters you can put in each query???

View 14 Replies View Related

Help Removing Characters

Feb 21, 2007

Hello,

I am totally new at this database stuff. I have been searching the archives for a couple hours and confused on how to accomplish what I need to do. I saw references to using a module but I have not used that feature yet.

I am using Access 2003. I need to remove/delete " - " space dash space, "-" and "&" from a string in one field (DGName). I'm trying to do this with a make table query

DGName
P1000
P1000 - SMLS
P1000-CA (not a type error)
UD000 - C&B
V-NET

and I want it to come out like this

DGName
P1000
P1000SMLS
P1000CA
UD000CB
V-NET

Thanks
Sean

View 2 Replies View Related

How To Extract Only The First Four Characters

Mar 20, 2007

Hi, Everyone,
I have an excel column that has building location and building name in one column, example 1245 Accounting, how can I copy the 1245 into it's own column, please help, i can do it either in access or excel. Please.

View 3 Replies View Related

Only Want To Write The 1st 7 Characters

Jan 24, 2005

users are using a hand held scan gun to enter data into a field. if the barcode is 12 characters long, I only want the 1st 7 to be written to the table.

I was thinking a validation rule using TRIM or LEN but can't seem to get it to work.

Any ideas?
Thanks

View 7 Replies View Related

Extraction Of First 3 Characters

Jun 26, 2005

I am trying to write a query to extract the first 3 characters from a character string but have no idea where to start since we usually use Select "field" etc etc

Example, for a Code ACC01, the query result should give ACC

Would appeciated any guidance. Thank!

TK

View 3 Replies View Related

Using Wildcard Characters

Oct 6, 2005

I have several queries looking up products from a table. I use a simple form to access the query and in the criteria of the field I use [Forms]![EnterCroft]![ProductName] to filter by name. (EnterCroft is the name of the form).

It works fine but doesn't like the asterisk (*) for all products.

I also want to use wildcard before and after key words in the product names, eg *cup* for anything with CUP in it's name.

How can I do this?

Thank you very much.

View 2 Replies View Related

Strange Characters

Dec 20, 2005

Hello all. Have a bit of a strange one here (and fairly frustarting). I have a table which includes a field (type memo) which holds text comments.

I have a query which includes this field. For some reason, when the comments field is empty (identified thorugh opening the table), when it is returned through the query is shows two characters, namely '@v'.

Can anyone shed any light on this for me? Thanks for reading :)

View 2 Replies View Related

Trimming Characters

Feb 25, 2007

Good Morning to all

i would like to kindly ask if there is a pre defined function in the VBA SQL of access in which it will trim a certain field programmatically

for example

Old string = Manila-MSE Building - 30.26f
New String = Manila-MSE Building

Thanks for your help

View 4 Replies View Related

Most/Least Characters Used In A Field?

Dec 18, 2007

I am sure there is an easier way fo doing this, but I am looking one at a time!!!

I want to know what is the Max and Min number of characters used in each field of my table.

I am using this code below, the max will be at the top and then scroll to the bottom to find the min, but as can be seen this is doing one field at a time and is very time consumining!


SELECT tbl05to06.Account, Len([Account]) AS MyAccount
FROM tbl05to06
ORDER BY Len([Index Key]) DESC , Len([Centre]) DESC , Len([Account]) DESC;

View 3 Replies View Related

Replace Characters

May 1, 2008

Hi, i am looking to replace characters in a field using a query, I can use the replace to replace them all but that aint what I want e.g.

I want this: ~~test~test~~~~~test~~

To become this: test~test~test

I can use replace and get this testtesttest, but I need the ~ placed back between each word.

Any help appreciated, thanks:confused:

View 7 Replies View Related

Wildcard Characters

Feb 24, 2006

Hey everyone, I've been busy creating a switchboard based on database, and I came across this issue. When I put a search through records command button, it seems that I can't use the wildcard characters, such as *,%,_ in order to find multiple records matching my criteria.

Am I supposed to "enable" them from somewhere or am I doing something wrong.

Any help?

Thanx in advance

View 1 Replies View Related

Textfield Max Characters

Oct 12, 2006

Is there a attribute for setting the max amount of characters in a textfield, I have thought about adding some code in the on keypress event, to lock the textfield once the required amount of characters has been reached, but I was hoping there would be a more simple way.

View 5 Replies View Related

Too Many Characters In A Report

Jan 27, 2005

I just discovered that the report I am trying to create has too many characters in it. I have approximately 200 fields I am trying to get a sum for. Does anyone know the easiest way for me to get this sum with out typing in each field, ie., (1jbo)+(2jbo)+(3jbo). In Excel, we can just type in =sum(A:C) and it would just add them all up. That's what I need. Is there a way to add up all 200 items in a similar fashion?

View 1 Replies View Related

Using International Characters

Mar 5, 2004

I've discovered I have a problem sending text between an Access Database and ASP page.

The database contains Turkish characters (eg, i without a dot) and the output to a web page is fine when run on a server that has Turkey for its international settings. Interestingly, the database shows the correct data regardless of environment... just the written page that screws it up.

However when the same data and pages are used on an "English" server, the Turkish characters are lost and modifyed to their closest Western cousins.

I'm not sure whether this is exactly an Access or an ASP problem... I think it's the latter, but maybe someone reading this forum has som ideas too
Since I need to use this data in a server hosted in the UK, is there any code I can add which will fool the server into reading and writing the Turkish characters correctly?

Obviously, I could set up a function on the page to convert the characters, but that seems like a waste of system resources.

View 1 Replies View Related

Querying 1st 3 Characters

Aug 3, 2006

Hi everyone,

I have a DB that has over 180,000 records with zip code as one of the fields.

I would like to know how do you query the 1st 3 characters? For example, if zip is 95127, I want to query and retrieve records for the first 951.

I seen this on another thread, but can't find it. THanks in advance guys.

View 1 Replies View Related

Special Characters

Jul 23, 2007

Hi guys,

I have a question regarding special characters that access doesn't like to see.

When passing a string to be absolved via html, if I set myHtmlBody = "<font color="#000FF"></font> it will throw a syntax error because of the # character.

How can I solve this? Thx for any help.

View 2 Replies View Related

Non-numeric Characters

Feb 16, 2008

Hi
I wish to check my phone number fields for non-numeric characters.
If the field contains 0-9 then I want to keep the field otherwise I want to replace the contents with a null.
Can you please help?
Noel

View 2 Replies View Related







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