What I would like to know is, how to make an Option Group that allows for multiple choices instead of one. MS explains in detail for a single choice only, or you can use their Option Group Wizard (again single choice)?
View Replieshow can i make a image appear in my form when there is a check in the check box from the table?
View 14 Replies View Relatedhaving used a query to generate data from a set of records where i can select the criteria (they are two letter abrv and are in a single field in the table but there may be multiple criteria). As I would like others to do it without using the query my first thought was a form with a series of check boxes tick for inclusion in the query or not. As i have built the query am I looking at changing that or taking it all into VB and using some code to pull the relavant 'ticks' across............ and how the hell would i do that......
many thanks in anticipation......
having used a query to generate data from a set of records where i can select the criteria (they are two letter abrv and are in a single field in the table but there may be multiple criteria). As I would like others to do it without using the query my first thought was a form with a series of check boxes tick for inclusion in the query or not. As i have built the query am I looking at changing that or taking it all into VB and using some code to pull the relevant 'ticks' across............ and how the hell would i do that......
many thanks in anticipation......
I have over 270,000 records in my database with 4 fields. And for each field I need to make sure they dont go over a certain number of characters for example field1 can't go over 20. Is there a way I can make sure that they don't go over that? When I go to design view and go to the Data Type of each field I change the filed size to 20, but if something is imported into that field that is over 20 characters long will I get a message saying it won't import? Or can I write a query to check the whole field to make sure that nothing is over 20 characters?
View 3 Replies View RelatedLong time lurker, first time poster.
I'm in need a of a check-in/check-out application for my company. We have about 550-600 employees at any given time and our turnover is about 20-30% per year. Our check-in/check-out process requires our employees to personally visit between 30-40 areas in our company (personnel, safety, credentials, parking, insurance, etc) within the first month of employment. This is currently done manually and is a huge drain on labor, especially when check-in sheets are lost, misplaced or, in some cases, forged.
I'm looking to build a database that would be intranet based, password secure (by check-in area) that would allow the new employee to present at a particular check-in, check-out site, complete that portion of the check-in/out process and then allow the person responsible for the check-in/out to enter the status into the database. At any point in the process, I would want to know the status of the person checking in/out (how long they've been checking in/out and what portion of the process have they completed).
Can this be done in ACCESS?
Thanks
I'm currently working with a form, which is in datasheet view. I have many rows which are combo boxes (yes/no), and the name is rather long. So each line (each row) spreads on to 2-3 pages to the right.What I would like to do is make the namebar, on top of every column, a little bit higher, so the name would be split into two lines, or three. Allowing me to make the width allot smaller.Here is an example of my problem:http://213.213.137.96/~terminal/columns.jpgSo my question is, can I change the height of the column name? Or is there some trick I can use?regardsFrímann Kjerúlf
View 1 Replies View RelatedHi
I have sendkey "{f7}" on loss focus.
this works great as a spell check but then I get the mesage box that spell check is complete.
How do I stop this box from occuring?
Would it be ok just to make a copy of the BE file (every so often) rather than to make a copy via code?The user can then just paste over the original if it becomes corrupt.
View 4 Replies View RelatedDoes anyone know or have an example of how to use check box's to filter out things in a form. What I want to do here is I have like 5 different locations and I want to be able to choose which of those location, whether it be one or more checked at a time and then have whatever those check boxes are checked to be filtered out.
View 1 Replies View RelatedHello,
I have a continious form containing data from the table "tblToernament".
On that form there is a combobox containing teams that are stores in the table "tblTeams".
The table looks like this:
ID | TeamName
1 | Team01
2 | Team02
3 | Team03
4 | Team04
When I select, for example, Team02 in the combobox I want that value on, after I selected it from the combo NOT to be in the combobox.
Can anybody please help me on this?
Hello, im making a database for a charity as part of my work experience and id just like someone to check over it for me. If you see any issues please let me know. Im already aware of changing text PK's to autonumber, this is a prototype so im not going to change the PK's at the min.
Any ideas, or ways to improve it?
You can find the LDM or ER-D here: (i understand that it may be difficult for you to follow since you dont know the system! But please have a go...) 17447
Thanks very much for your help.
Ant...
Hey guys..
I was working on my project again as usual, which is about transaction of cars coming in and going out (car pool system), So i created a table then a form for this. In the table, i put the option of 'Yes/No'. So, for the form, i want to create a search system which will include a search system.
My Idea:
I want to make a check box, as a search system, so when it is checked and clicked on a command button, it searches for all records with 'Yes'. and if not checked, and clicked on command button, then it searches for all records with 'No'.
Now i did my research, on google and stuff also in the access help but it ddnt help much.
To be honest with you guys, i dont know much of visual basic writing, but i do understand most of it. ( you know, when you understand one language but can speak it?? same way :o ).
So i would request some one to give me instructions on this one. It would really be appriciated.
thanks a million !
Do check boxes have to be bound to be able to save them in your forms? In other words, when you check the box and click save, does the check box have to be bound so that the check mark can be saved? Thanks.
View 6 Replies View RelatedI want to connect a single check box to a record of check boxes, so that when it is on yes (checked) all the other boxes are yes (checked) automatically. How do I go about doing this? Is there an expression I can build for it?
:confused:
Hi,
Is it possible to change the size of a check box? When I modify the height and width of the checkbox it doesn't appear to do anything.
Thanks
Kabir
Hi,
I know there is probably a simple answer to this question, but im wondering if there is a way to make the value of a "true" checkbox anything but -1. i'd like the checked box to display a positive 1 in the corresponding table, so that they may be added up for a further query.....
i am working with IIF statements now with no luck,
Please tell me how i can fix it, and if there is a simple way of changing the value to a positive number, or even to a letter or word!
Cheers!
Em
I have a access form that when a user clicks a button it runs a report for that particular record. When the user clicks this button to run the report I would like to have a check box or whatever else you recommend on the form that would become checked once the user runs this report so that they will know that they have already ran a report for this record. If they try to run it again a msg box will appear letting them know that a report has already been created but if they want they can run it again. Any Ideas or HELP?????
THANKS!!!!!!!!!!!!!!
how do you check if a check box is checked?
I have tried this but it does not work...
If Me.Check25.value = "no" Or Me.Check25.value = "" Then
MsgBox "You must agree to the terms below.", vbOKOnly, "Required Data"
Me.Check25.SetFocus
Exit Sub
End If
Hey guys.. I am trying to make my DB into an MDE file however that option which is in Tools > Database Utilities is not highlighted on this particular database. Anyone know why? Thanks!
EDIT - This features seems to be inactive on all atabases on my computer (I haven't tried another computer yet). I am using Access 2000 and running Win XP Hme. SP1.
I'm trying to make and mde file but when it runs I get a error unable to make mde. Where do I start looking into this?
Jon
Hi all
in the attachment there is two pictures for a form with interesting calendar to chose DOB
any one know how to do something like it
Thx
Hi
I'm making my first commissioned database and I can't get my head around auto-lookups.
At the moment, I'm only working with tables because I want everything properly formatted and working at the table stage before I move on to making my forms, queries, reports, and eventually the switchboard.
What I want to do is when I call up a particular ID number in a table which has corresponding data in another table, I want the corresponding data, such as names and phone numbers, to come up automatically within the table.
My database has about eight tables in it and all are linked in someway, either because I need to create lookups, or because they will eventually be subforms.
So what I need is for someone to explain an easy way to get the tables to do what I want. I've looked up the Dlookup function in Access Help but it didn't make sense :confused:
Can someone help me please? I would REALLY appreciate it.
Thanks.
B-E
Hello!
In my form I have the title of a CD which is under the name of 'CD_Title' which is taken from my CD's table and I was wondering how to show it up in a Label so when I flick through the albums the Label changes to the album that it is selected!
I need to know...please help me!
:(
I'm having a total brain freeze here.
Last week, I posted for help getting an email (with attachments) sent from inside an Access database.
With some help from my friends here, I fought through the issues and got the code in the module to work, when tested from the immediate window.
Problem is, I can't figure out how to tie it to a macro or event or anything else that will let me push a button and have it run.
I need nuts and bolts details--- how do I run this module?
BeckieO
Being an Access newbie and all I knew nothing about the maximum number of TableIDs being 2048...really I just found out about TableIDs when the error message popped up. :o
Is there a way around this, short of revamping the entire database?