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
I have a table with a field with names set to text data type and i want to change it to number data type but when i do it in design view the data get lost. I want to know if there is a way to convert the data in the field as number type and keep the data in the field.
View 7 Replies View RelatedI 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 1 Replies View RelatedI 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 5 Replies View RelatedHi,
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
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 3 Replies View RelatedIs 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
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
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
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
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?
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
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
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
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?
In my database I have the following:
1)Projects table:
- Project ID - Number field (Primary Key)
- Project Name
- Location
- (other fields)
2)Working details: (this table has a form based on it and it's used to enter data by users)
- Project ID (this field has a lookup for the same field in the first table)
- Project Name (this field has a lookup for the same field in the first table)
- (other fields)
My problem is : in the second table, Project Name field has "Number" data type because the relationship between the table is on the Project ID which is number field. I want the Project Name to be "text" data type in the second table.
How can i do that??
i have multpile yes/no check box i want if i check on one the name of this check box is written on another one.
so i neeed a code for loop of check boxes and i need a code i.e loop all check boxes if any is true then put name field in {new field}
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
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.
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
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
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.
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 RelatedHey 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!
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.
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