Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Desperate - Text Box Won't Let Me Type In It


I've got a label called Agent Matches. The box by it to type stuff in won't let me do that. I checked and it is a text box. My boss is after me, so please help someone! Appreciate it.

Jilly


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
How To Have Text And Not Numbers In Text Data Type
I was wondering if there is a way of only allowing text in a text field - we need to do this for validation purposes when inporting a text file into a database. I have tried input mask but this only checks when entering new data - I have tried to use validation rule like"???????" however this means that there has to be 7 letters in each field and this is not the case. - the field is for town and a couple of the records in this field have numbers at the end which are incorrect that we want the database to reject :eek:

View Replies !   View Related
I Cannot Type In My Text Box
I have two text boxes - on different forms. I can copy the text from one and paste it into the other one ok. However, if I cut (Ctrl-X) from the first text box the second one is not enabled and I cannot do anything in it. Hope you can help.:confused:

View Replies !   View Related
How To Set Text Type In The Textbox
Hi:
I repost this message.
Could you open the example, then try this steps:

Date: 3/4/2005
Name: Sana


And also,
Date: 3/4/2005
Amount: 23.00

Then you see what problems are there.
I don't know how to solve it.
Can anybody to solve it? I appreciate you. Thanks.
Thanks a lot. Thanks.

View Replies !   View Related
Type Text Field Size
Hi,

I have searched on this and it says: it doesn't matter as long as it's of type text. It matter if it's long integer..etc. I am not quite sure.

I wonder if default size '50 of fields' of type text occupies that size in memory even though the data in the field is not 50 chars.

Regards,
B

View Replies !   View Related
Trying To Type BALLANCE Into Text Field
Have an odd problem that eludes me at the moment I have table with a text field for surnames and if I type the surname Ballance into the table it automatically reverts to Balance can see no logical explanation for this at the moment funnily it does exactly the same in excel

View Replies !   View Related
Data Type For Percentages Or Text?
Is there a data type that I can use that will handle both text and numbers such as percentages? Or is there a way I can set the field type to text then convert the text to a percentage? I plan on using this field in a form so when the user inputs the info I will want to display it in the correct format. Any ideas or suggestions?

Thanks

View Replies !   View Related
Run Text Data Type Against Date
I need to run a query for a particular time frame. The only problem is that the CurrentDate field in the table has its data type set to Text.

I thought I could do something like this but it didn't work:
WHERE cdate(myTable.CurrentDate) >= #01/01/2004#

Isn't there a way to "convert" this field so that it behaves as a date field when the query runs?

Thanks,
crhodus

View Replies !   View Related
Can't Type In Unbound Text Field
happy friday to all! I may just be missing something simple here but not sure what. I have a form with an option group of radio buttons, an unbound label, and an unbound text field.
If radio button A is selected, the the label and the text field become visible. no problem with this.

when they become visible, I want to be able to enter a string into the unbound text box, and use that data to populate a query from. I know how to do this also.

No the problem: when the textbox becomes visible I can't type into it?

Any thoughts?

Thanks
Kevin

View Replies !   View Related
List Box Text Type Selection
I have an MS Access DB, that uses a list box to give users a view of the possible selections to choose among.

It works great, but the database has grown to the point there are nearly 3,000 items in the list box.

I found that if you type in the first letter, it will take you to the first alphabetically in the list with that letter.

So if I type in "A" it takes me to "Aardvark". But even this could use improvement, as typing in the first letter with 3,000+ selections means the users may scroll a few hundred to find what they are looking for.

Is there any code, or property setting that can set it up, so the users can type in the entry and it will narrow it down?

So if they type in "AS" it goes to "Assumption" rather than "Aardvark" then jumps to "Sail" (as it does right now).

Thank you for your help,

T.J. Bernard

View Replies !   View Related
Form With Text Box And Combo Box By Type
hello can anyone please help me with this form?

I have a form in which has one drop down combo box and one data entry text
box.

The combo drop down box comes from a query of all active contracts from my
contracts table.
the second box has a unit ID number which the user enters.

All information entered in this data entry form goes to a Unit table.

My contract table has three columns: Name of contract and Type (only three
types): A, B, C. (contract table) and then a column that says active or
inactive.
i.e

Name Type Status
113 A active
114 B inactive
115 A active
116 A inactive
120 C active
121 C inactive

This is where I am stuck…

When a user puts an unit id number and then selects from the listbox one of
the active contracts for the first time is ok. For example: the user entered
unit number 123 and selected contract: 113 which belongs to type A.
What I need is that next time the user put the same unit number in the text
box then the contracts he could choose for that selected unit number could
only any of type B or type C. he/she can no longer choose other type A.

so basically for every unit id number i could have only one contract type A, only one contract B and only one contract C. :confused:

Can someone give me some light in how to start this?

View Replies !   View Related
Access Text Data Type Options
Hi All,

I was doing a project for school where I had to make a text field that would only accept the options Client Type(RET - Retail, SER - Service, DIN - Dining)

I thought I did it right by having a line with the field name as "Client Type" and the input as "text" with a field size of "3". and the description I put was "Client Type(RET - Retail, SER - Service, DIN - Dining)". But it doesnt work. I saved and everything. It will let me enter anything I want as long as it doesnt exceed 3 chars. I want it to ONLY accept RET, SER, or DIN and I want it to format it so its in CAPS.

Thanks,
-- Steven

View Replies !   View Related
BETWEEN For Text Data Type Date Range
I am creating an ASP page that uses a database with a field labeled 'Date' of data type Text.

I would like the records within a date range.

I tried using the following query:

"SELECT * FROM Project WHERE Date BETWEEN ' " + strBeginDate + " ' AND ' " + strEndDate + " ' "

I was partially successful.

The database contains data from 1/1/03 to 12/31/04.

When the following range is entered: 04/10/03 - 04/21/03, the results returned are 04/10/03 - 04/21/03 AND 04/10/04 - 04/20/04.

Any suggestions on how to approach this problem?

Thanks



View Replies !   View Related
Use Multi-paragraph Text As Memo Type
I have a website in Asp, which is connected to a MS ACCESS database.
In this database, there is a text field (Memo type) which contains text. But in web site, it just shows a continuous single paragraph.

What should I do to fix this problem?

Thank you

R. Ghodsi

View Replies !   View Related
Look-up Wizard Returns Number Type Instead Of Text
I had posted this a couple weeks back but it didn't help much in the end, thanks to anybody who posted there anyway though.

I've used the Lookup wizard to make a lookup menu in one of my tables. The field I tell it to refer to in another table is a Text type. However, after the lookup wizard completes the type of the field which is uses the menu is changed to Number.

At this point it can be kind of whacked out and inconsistent, but what usually happens is if I select a value from the lookup field it refers to the auto number that I used as a primary key for the looked up value.

I created a new table, and tried to do a lookup field for for the same fields and got the same problem - I think it's an issue with the field I'm looking up.

I'm 100% sure I didn't do anything stupid like select the ID auto number for the lookup... So what's going on?

View Replies !   View Related
Desperate For Help
I have uploaded a database that I am working on it, and would appreciate it if someone could look at it and help me out, as I have gone through the forum trying to resolve my issue. There has been some topics on combo boxes and subforms and some of the posts only help me partly to my requirement.

When a user hits the button 'Enter Rate for Supplier' (which is to be double clicked, all buttons on the forms are double clicked) on the form 'Main form' a form 'Rates' comes up with a combo box and a subform. What I want then to happen is that a user selects a 'supplier' in the combo box, and then goes to the subform and selects the class and enters the rate. Note, the supplier names appearing in the combo box are entered through the form 'Enter Supplier Details' which is launched after the button 'Enter Supplier Details' on the main form is double clicked. Details entered through this form populates the table 'Supplier Details'. After entering the class and rate for that supplier in the subform the table 'Rates' is populated.

What I want to see is that after when they save and close the form, they can go back to the 'Enter Rate for Supplier' form select the supplier from the combo box and all the information that was entered previously in the subform for that supplier appears in the subform again. Then the user can produce more records by select more classes and enter rates.

So based on what I have stated above can someone please help me in making this happen. If you can also summarize how you did it, when you reply I would really appreciate it, in where your explanation could also benefit others like myself who is only an immediate. Also by all means you may keep the solution in the database for self education purposes.

Thanks so much for your help
Greg

View Replies !   View Related
Desperate In Need Of Help
I need some help on a problem that has been bugging me for the past 4 months, everywhere i turn i cannot get help for this.
I have a DB for stores maintainance and what i have is a form on which stores are ordered. What i need is a way of accounting for the stores as they arrive and adding the quantity to the account for that item. However this must take into account that items sometimes are not received together and may turn up in batches. I had the idea of having an 'On-Order' table but don't really know how to proceed. This is the last piece of my project that i need to complete and it is really bugging me. Any help would be greatly recieved.

Regards in advance.

View Replies !   View Related
Desperate !!!
Hi guys
This is a good one, so any help is most welcome . . .
A hardware company has been to a client and installed a new server.
On the old server was an Access database including a number of linked databases. Each linked database has a set of mail merge letters set up initiated via buttons and run with the help of vb code.
When the new server was installed all files were copied over as they were on the old machine, the linked databases all work as expected, but the mail merge facility is NOT populating the letters with the data from the database.

Would anybody out there have any ideas why this may happen ?
I am assured by the hardware company that the only difference between the old and new setup is the name of the server. All folders and files have been copied across as they were originally.

Thanks
ajm

View Replies !   View Related
Desperate For Help
Hi there,

I am desperate for some help on this. I'm completely new to Access and learning the hard way -

I have a mainform, with a subform based on a query. The mainform has combo boxes and a search function. When you select values from the combo boxes and click search, the subform requeries based on the selection.

I want to add check boxes that determine what fields appear in the query and I'm not sure how to go about this.

I have tried to write SQL in the query to see if the value of the checkbox is true - but have only succeeded in making ALL of the data disappear not just the field I want to 'hide'.

Is this the correct approach?

Thanks

systemx

View Replies !   View Related
Desperate Need For Some Help
Hi All,

I have uploaded a database that I am working on it, and would appreciate it if someone could look at it and help me out, as I have gone through the forum trying to resolve my issue. There has been some topics on combo boxes and subforms and some of the posts only help me partly to my requirement.

When a user hits the button 'Enter Rate for Supplier' (which is to be double clicked, all buttons on the forms are double clicked) on the form 'Main form' a form 'Rates' comes up with a combo box and a subform. What I want then to happen is that a user selects a 'supplier' in the combo box, and then goes to the subform and selects the class and enters the rate. Note, the supplier names appearing in the combo box are entered through the form 'Enter Supplier Details' which is launched after the button 'Enter Supplier Details' on the main form is double clicked. Details entered through this form populates the table 'Supplier Details'. After entering the class and rate for that supplier in the subform the table 'Rates' is populated.

What I want to see is that after when they save and close the form, they can go back to the 'Enter Rate for Supplier' form select the supplier from the combo box and all the information that was entered previously in the subform for that supplier appears in the subform again. Then the user can produce more records by select more classes and enter rates.

So based on what I have stated above can someone please help me in making this happen. If you can also summarize how you did it, when you reply I would really appreciate it, in where your explanation could also benefit others like myself who is only an immediate. Also by all means you may keep the solution in the database for self education purposes.

Thanks so much for your help
Greg

View Replies !   View Related
Desperate Please Help
I need some help on a problem that has been bugging me for the past 4 months, everywhere i turn i cannot get help for this.
I have a DB for stores maintainance and what i have is a form on which stores are ordered. What i need is a way of accounting for the stores as they arrive and adding the quantity to the account for that item. However this must take into account that items sometimes are not received together and may turn up in batches. I had the idea of having an 'On-Order' table but don't really know how to proceed. This is the last piece of my project that i need to complete and it is really bugging me. Any help would be greatly recieved.

Regards in advance.

View Replies !   View Related
Automate Data Type Conversion At Text File Import
hello once again,
I need to import a text file into an existing table in Access. The text file has been imported once and is working well and everything. However, since I had to change some of the datatypes to be able to query the table correctly, I now cannot import the text file anymore unless I change the datatype of the table itself. Since someone other than I will be doing the imports from here on out, changing the datatypes everytime is out of the question. I was looking at the TransferText event, but I didn't seem to see anything about converting data types. I can think of two options, and neither are probably possible:
1. import using the wizard. Since I didn't see anything related to the types of data, I don't think this will work...
2.import using TransferText. This doesn't seem to give me any opportunity to change the datatypes either. Is there anyway to programmatically change datatypes, or is there possibly an easier way that I'm overlooking??
thanks in advance,
*j

View Replies !   View Related
Desperate For Help- 2 Problems
Hey guys-
I am building a database for my own use- I download info from the Realtor MLS system and then run queries against it. I don't have control over user inputs whatsoever. I download the data into a DBF file- but can save it as an excel or whatever as well. I then am importing THAT data file into Access 2002. I have run into 2 problems right off the bat...

1- the Field names in the data file I am importing are very difficult to understand. There's nearly 100+ field names, so it could get confusing when I'm programming/creating queries. I'd like to change the field names upon import- or- have some way to match the confusing field names in the data file to the easier field names in the table. What's the best way to go about doing this? I tried using Captions- but they dont display the name of the field when using queries. Is there a field matching wizard upon import (maybe a set template for this) or something?

2- One of the fields I will be using to query a lot is the subdivision name. Since the users type this in, I have no way to control what they type. Sometimes they type in 'Willows', sometimes it's 'The Willows', 'Willows Unit 2', etc. Basically, I need them to be restricted into a common subdivision name upon import. I am guessing I would have a table with the 'acceptable names' in the list- and upon importing, take the ones that do not match and ask me to match them up manually. -OR- have a way to where it keeps track of every mispelled or variation of the name in a list so that it accepts/matches is up in the future without problems. Occasionally there may be a NEW subdivision name, so I would need to add it to the subdivision table. I think this is going to be the hardest part. I assume I am going to use the LIKE statement- but have no clue where to start with this. There are literally THOUSANDS of records going into this- so it needs to be able to recognize them all. Obviously I'd like to cut down on the manual overriding aspects as much as possible.

I think I can handle the rest of it, once I get past this (it's just forms and queries thereafter). But it's these 2 things I'm stuck on. Any ideas?
THANKS!

View Replies !   View Related
Desperate Autofill Help
Ok here goes

I need some help with getting my form(form 2) to autofill from another form(form 1).

Now i dont want to use combo boxes or command buttons as i only want to use the keyboard and not the mouse.

Basically when a customer phones up to get prices they tell me there account code( this is in the customer details table) and i enter it into a text box on form 1 and after pressing enter it opens up form 2(this bit i can do) but i cant get it to open the form and display the correct details from the table on the form.

p.s why is it access books tell you everything except what you want to know.

thanks.

View Replies !   View Related
DESPERATE For Someone Who Has AccessFIX
What an idiot I managed to delete a table in my access database!!!
Its a Junior Tennis Club database with all the childrens details I have downloaded and tried AccessFIX and Advanced Access recovery - Both these pices of software demos show me that the records are recoverable . Is there anyone out there who has either piece of software and would be willing to help - We'd gladly pay but to buy the software is out of our reach as a charitable organisation.

Kindest Regards Helen Oliver

View Replies !   View Related
Quantity On A Form- Desperate
Hi, im really need help, just a bit pressured to sort this out as soon as possible,

I have a form were depending on the quantity that is them amount of inputboxes appear to fill a cylinder with a particualr product. Even if there are two products, it only asks for one cylinder number, this was working previously but dont know what is wrong, please help.

I have used "For i = 1 To Quantity" "Next i" withint the code to try and pick up the quantity

Heres is my code

Dim rs As DAO.Recordset
Dim db As DAO.Database
Dim rs2 As DAO.Recordset
Dim strSQL As String
Dim i As Integer
Dim tringy As Integer
Dim Stringy As String
Dim Stringy1 As String
Dim Stringy2 As Integer
Dim Stringy3 As Date
Dim sql
Dim valid As Boolean
Dim validdate As Boolean

valid = False
validdate = False

Set db = CurrentDb

Set rs = db.OpenRecordset("tbl_transactionmaster")

For i = 1 To Quantity

While valid = False
Stringy = InputBox("You Are About To Fill A Cylinder For (Works Order Number):-" & [Works Order Number] & "..And For..(Line Number):- " & [Line Number] & "...", "Please Enter/Scan Cylinder Serial Number")

If StrPtr(Stringy) <> 0 Then
strSQL = "SELECT * FROM [tbl_CylinderMaster] WHERE [Cylinder Serial Number] = '" & Stringy & "' "

Set rs2 = db.OpenRecordset(strSQL)

If rs2.EOF Then
rs2.close
MsgBox "Not a valid cylinder number. Please re-check", vbCritical, "Invalid Cyclinder Number"
Else
valid = True
End If
Else
Exit Sub
End If
Wend

While validdate = False
Stringy1 = InputBox("Please Input The Transaction Date, (DD / MM / YY)", "Spec Gas System", Me!Text20 & "")

If StrPtr(Stringy1) <> 0 Then
If IsDate(Stringy1) = False Then
MsgBox "The date you have entered is not valid. Please enter a date in the form of DD/MM/YY", vbCritical, "Invalid Date"
Else
validdate = True
End If
Else
Exit Sub
End If
Wend

If [Batch Number] = True Then
Stringy2 = InputBox("Please Input The Batch Number")
End If

If [Expiration Required] = True Then
Stringy3 = InputBox("Please Enter the Expiration Date, (DD / MM / YY)", Me!Text20 & "")
End If


If Stringy <> "" Then
rs.AddNew
rs![Works Order Number] = Me![Works Order Number]
rs![Line Number] = Me![Line Number]
rs!CustNo = Me!CustNo
rs!ProdNo = Me!ProdNo
rs!Status = "Available To Deliver"
rs![Cylinder Number] = Stringy
rs![Transaction Date] = Stringy1
rs![Batch Number] = Stringy2
rs![Expiration Required] = Stringy3
rs.Update


sql = "UPDATE [AberdeenWOLines] SET Status = 'Filled' WHERE WorksOrderNumber = '" & Me![Works Order Number] & "' "
sql = sql & "AND [Line Number] = '" & Me![Line Number] & "'"
db.Execute (sql)

Me.Refresh

End If
Next i

rs.close
db.close

End Sub

View Replies !   View Related
Desperate - With Correct Attachment
Sorry...attached the wrong file. Here it is again.

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved