I have been using Access for many years, but have come against a problem which I can't fathom.
I have a database with a field for "Organisation Type" which contains all the various options which can be chosen by the user.
However, when I'm in a field, it refuses to show that list in alphabetical order, defaulting to an order I don't recognise which is most unuseful as it makes it almost impossible to find the right item, especially for a novice user.
I thought this was perhaps because the form was based on the database table, and this didn't allow sorting.
So, to test my theory, I created a query based on the table and added alphabetical sorting to that field. As soon as I use the query as a basis for the field, I find the problem remains.
Hi, I may be dense, but I cannot find an answer to this question anywhere. If it has a simple and obvious answer, my apologies.
I have created an index with a field called "Surname" -- I need to know how to force Access to alphabetize the names disregarding the apostrophes (or a space) - for example, O'Brien. The way it works now, all the O' (s) go at the beginning of the Os (O'Brien, O'Malley, O'Neal, Oakley). I want it to go - Oakley, O'Brien, Oddfellow, O'Malley.
Is there a way to do this and still display the apostrope? I feel that I could set something for the field in the design view, but for the life of me I can't figure it out.
In one table I want to limit the options of one field depending on what is chosen in another field.
Field Type has two options: Receivable and Payable.
I want field Sybtype with this limits:
If Receivable is chosen in Type field you will only have CreditCard & Lockbox available in the Subtype field. If Payable is chosen you will only have Cheque & Transfer to choose. Shall I have two separate tables? or only one table with Type and SubType as below? but then how can I make the above work?
Type SubType Receivable CreditCard Receivable Lockbox Payable Cheque Payable Transfer
I need help on creating a form for users to enter data for their projects' progress about 10 projects totals.
Among other data, I have difficulty to have data enter on these 2:
**On budget: have 2 check boxes: either 1/Yes and 2/ No **On Schedule: have 3 check boxes: either 1/Yes and 2/No and 3/N/A
If I use GROUP OPTION frame for each On budget and On Schedule, whatever value Yes or No (or N/A) they will be the same for all 10 projects!! :-(
Also, I would like to FORCE the users to enter the value for those On Budget and On Schedule for each project before they move on to the next project and so on...
What I am trying to do is create a form with 2 drop down boxes (A,B,C,D) &1,2,3,4...) what I want to do is make it so if you select option A in the first box only 1,2&3 are available in the second box but if you select option B 3,4&5 will be the only options available.
I am trying to make a checkbox with different graphics since the checkbox can not be resized. I thought I could stack images on top of each other and toggle between showing and hiding based on if the checkbox was checked. This actually works, but I wanted to hide my checkbox, so I hid it behind my images. This didn't work. So I brought it to the front and made it invisible. This didn't work either. What can I do? The checkbox is linked to the table, but I want the graphics to show thumbs up or down and not see the checkbox.
I'm wanting to get a very, very pale shade of gray as the background colour for an Access form, as well as for several text boxes on it. This is so that users can distinguish editable regions (white bgs) from uneditable ones (light gray bgs).
The default colours that pop up in the menu choices are too dark for this. I've tried using a tiled image for the background of the form, which works fine. But I'd like my uneditable textboxes to be selectable (so users can copy data) whilst being that colour too, which can't be done.
Therefore I'm looking for either the number code for a very very light gray colour (Access' default lightest is "12632256") or some sort of translator tool to let me know how on earth these numbers relate to anything in computing -- I mean, what do those numbers represent? Are they html=no, hex codes=no, rgb values, no... I mean, how is Access coming up with those numbers? I've tried just getting a light gray using trial and error and can't figure it out (even ended up with lime green at one point - very nice on the eyes lol).
I have a form that has a field called Project Name where a user types the project name. We have certain abbreviations we use for a building making it hard to search in the future.
I know we can set the autocorrect option on Access Program but that will effect all MS applications.
Is there a way to have a certain field or for have these autocorrect options?
How to create custom menus in Forms in MS ACcess 2010. For example, I have a form fmrMainMenu. At the top of the form I want to create a menu labelled "Reports" that when clicked or hovered it displays a list of sub-menu options of all the Reports available in the database. Once the user makes a selection the report is generated. The functionality that I am looking for is similar to the old menu options like File, Edit, etc., in MS Office.
I have a form with about 30 controls. I organized it carefully so that all the controls show on a single page. It actually looks really good. However, several of the controls allow multiple values. These appear as a check box showing up beside each item in the list from which these controls take their information. When I run a Filter by Form process, the form flawlessly pulls the data from the table that I'm seeking, and the check boxes are visible, both the ones with checks and without. In a few cases, in order to fit everything onto one page, I have most of the related list hidden, and use scroll bars. This works really well for data entry and for editing individual records.
Where it DOESN'T work like I want it to is in situations where the checked item(s) in the multi-value control don't show up in the box on the form without scrolling. In the table where these multi-value fields actually live, what shows up is just the code for each option, a simple numeral, with commas separating any multiple values. Is there a way to make my form show only the selected codes like in the table? My suspicion is that I'm going to be told no, that the best way to do this is to use a report and query.
I have a ComboBox which looks up the records in a query. The query contains the names of current employees. The table upon which the query is based lists Employees and their start date and finish date. The Query is based on finish date being Null (ie they're still working here).
In the main form which details tasks, I would like the ComboBox to just list current employees (which it does as it's based on the query) but when an employee leaves, their name is deleted from all previous records.
Is there a way to keep the ComboBox options limited to current staff, while also keeping the names of previous employees in the form?
I checked the table which the form is based on and it still has the values, so I'd like to show in the form too as that's what people will be working on.
I'm trying to use a cascading combo box to filter the options that can be entered into a second combo box.
In frmBabies, a Mode of Delivery is selected from 8 options. 4 of these are "normal" deliveries and 4 are caesarean sections.
A second combo box selects the Indication for Operative Delivery. The table tblIndOpDel contains options for normal as well as caesareans. I would like to filter the indications so that the user cannot enter an indication for normal delivery for a caesarean section.
Both tblIndOpDel and tblDelMode have a foreign key to tblDelModeCat, which categories deliveries as normal or caesarean.
I'm stuck on how to proceed from here. Sample database attached.
I'm a new user of Access and I'm required to input a survey into access. The data collected is being analyzed afterwards and therefore there cannot be any alpha content in the original table so I assigned multiple choice options numbers to correspond to the answers. In form view however I need the drop down boxes to spell out the answers, not just the numbers so the interviewer can read them out, I've seen this done on other similar surveys..I also tried going into form view and editing the drop down choices but that changes the table values.
I have created a front end and put into production for my users but I want to reduce the amount of menu bar options they see so someone cant click on a button wondering what it does and mess something up. What is the best way to reduce the amount of options a user sees on the menu bars when they open the front end of the db?
I have created a member data base form in Access2010.
That has been populated with 366 member records
I have two text box fields that are currently free type fields, Member Type & Member Status.
What is the best way I can change these to show only the relevant options:
i.e. Member Type ( Full, Family, Pensioner, Life. ) Member status ( Current, Lapsed, Deceased)
I have tried to right click the field but the "change to" option is greyed out & not available.
I have also tried to insert a combo box or list box to show these options. The "use control wizard" option has been highlighted but when I drag either a combo box or list box into the form. the wizard does not activate.
I am working on creating an access database for tracking physical assets linked to locations. I need to make a combo box list to show items other than the current location of the asset. Basically I need it to refer to last enery of the user and define the new possible entries. so we have a unique relationship between location and asset. The assets and location will always remain fixed and there is never going to be any addition. I am creating a web form so that it can be uploaded into sharepoint.
I was using access 2000 to build a small office app. It will be on a network and will generally be used by only 2 or 3 people(max). I was wondering if the default jet technology would be good enough for this. If it isn't, what should I use? I looked at other options such as msde and ado but it's a bit confusing when you're new to this stuff.
I'm trying to create a database for a taxi-type service that runs on thursday, friday and saturday nights. My question is: Is there a way to save the database at the end of the night separate from the previous nights, and so that the database is empty for the next night, but reports can be viewed for all of the nights combined?
ok I have an access db which is all on access. the dbase has been operational now for 3 years and working well however, do to business needs and changes I'm trying to figure out a better way to collect and share data. So the backend of the database is stored on our local office server when users log on to enter or review data they must be in the local office. We now had the need to access the database remotely from customer sites. Now the way this works is we use a local dialer to connect to our company's network and then are routed to our local server (you can imagine how slow this is) it is impossible to operate the current database this way. So I have been reading different posts and different options (front page, sql, asp etc.) What I would like to do is convert my dbase to a program which can allow input and review of data both remotely and locally without a huge speed loss. What is the best approch for me?
I unticked all the boxes in the Tools > start up window. I closed my database then reopened it. Now, I can't put these settings back again as I can't see the Tools tab.
I'm by no means an expert when it comes to using access and its many controls that are avaliable to use on forms. Thats why I've come here to seek your help.
I have a database that has been created by someone who has now left the company and it needs a little work done to it.
The ideal thing we would like to get working on form, is that we would like a number of options to be greyed out and only accessable when another option is ticked.
I'm not sure how to group these options together, nor an I sure how make them active only when an specific tick box is ticked. Any help would greatly appreciated on this matter.
:o Please help... I am trying to get the following results. If the Qty is less than 99 bag 10 per, if the qty is between 100 and 999 bag 100 per and if the qty is greater than 999 bag 200 per.
I ned to create a form that asks the user which reports they want to preview/print. I see it as a set of tick boxes with one saying all, then a print button. Im not really sure though, can someone offer some advise or maybe an example?
Hi, How do i create an option inside the form, such that when the user ticks this option, it will print the form in this particular report. If user ticks another option, it will print the form in another particular report format... Thanks...
