On all my databases I uncheck the "display database window" on the startup menu and for the most part it works great.
However, when the database is selected from the recently used list off the file menu the database window shows and how do I fix that?
Hello everyone, I have some experience with access but am having difficulty at the moment with a command. This is what I am wanting to do;
I have some checkboxes which when checked I want a separate field to display a number. i.e. When 'Taster' is checked 'Overall Price' will show '£225' but also when 'Meal' is checked 'Overall Price' shows '£500'.
Access 2010 - In datasheet view, some of my yes/no fields display according to the format set in design view (yes/no, true/false, etc., or -1/0 if no format specified). But a few fields that I have added since originally creating the table show up as check boxes.
I cannot find any discussion of how to force the checkbox display or even figure out where that is specified. This same behavior carries over to DS forms as well.
How can I specify a checkbox display style instead of Yes/No etc?
Hi, in my web page, i would like to user to see a ticked checkbox should the database = True however, i cannot seems to be getting it. Would anybody be able to help me out?
strSQL = "SELECT DeptHeadA FROM Employee WHERE EmpId = '" & strEmpId & "'" nRecDHA = GetRecordset(strSQL, arrDHA)
if arrDHA(0,i) = True then arrDHA(0,i) = "Checked" else arrDHA(0,i) = "" end if
I was wondering if i could get some help here. In the startup under tools option in the menu in Access 2003., is there any way of coding it so it would display windows database, allows display status bar and other settings there?
Currently, i have unchecked pretty much everything except "Access special keys" when setting up a certain form to be a startup. By default, we don't want to see all the tables in the windows database but rather the actual start up form.
what we would like to do is to allow only the certain group of people to be able to view the windows database without using "hold on to shift key" button to access to windows database.
I have several new employess on my facilites Access Database however their Monitor Displays are on differnet settings and the databse window is to large for their monitor, how do I set the database to open to their personel settings?
I have set my options to protect my Db. I have unchecked "display navigation bar", "allow full menus", "allow default shortcut menus" and "allow built-in tool bars". After restarting , everything else is missing but the nav bar just wont go away. I have retried many times but, no go. I have even tried to change user levels on my login but it does not have any effect either.
Also, On my split Db FE, i created a new table 'USysRibbon' to set a default ribbon without the "options" function, but I can not see the new table on the tables nav bar. I remade the table, but it says it already exists. Why can't I see it. All the tables in my FE have the blue arrow next to them to show the redirect.
I am looking for a way to either display through a query with an expression or any other alternative that someone may have to display the last 100 records entered maybe based on date entered or something.
At the moment i have a query and report going form start date to end date but would also like a query/report that will just show me the last 100 records entered.
I have a small access 2010 system. The database design was not good (replication of data all over the place) so I have been tidying up the design but have hit a few problems.I am using a form which contains amongst other things a customer name. The customer name used to be part of the enquiry table, and was picked up directly from there. I have replaced this with the key to the customer table.The only way I have managed to pick the customer name up is to change the control from a text box to either a list box or a combo box. I then have to set column count to 2 set the widths to 0 and 3 to hide the 1st one (the ID) and then set the bound column to 2 to show the customer description.
This is fine up to a point BUT the format controls on the list/combo are different from the text box so I can't replicate the back style and back colour (I had transparent and no colour respectively); the back style has disappeared and how to make the back color as "no colour".Also I end up with 2 little up and down arrows (for the list box) or ma bigger arrow for the combo.
how to display the user's record or database after he/she login in on the system. Currently I have a database where in the user enters his username and password. But the I dont know how can I make his records display after login.
Am trying to display images on a form in a split database. I add the attachment field to the associated form's table and add the attachment control to the form but cannot get the image(s) to display on the form (the control remains blank). I can add the image(s) in table view (and display them) but double clicking on the form control also does nothing.
I think I must be doing at least the basics correctly as if I try the same thing to an earlier, non-split version of the database, all works as expected.Are there additional steps required to do this thing in a split database?
I want to create a country info database. For example, Qatar (country) and the Driving info required when driving in qatar and the visa info required.
I would like a form with drop down options and when i selected which country and then driving or visa, at the bottom it would display the specific info based on my selection in a memo field lets say.
I have a question regarding the display of a list of numbers that are stored into a field of my database. Currently the numbers are comma-delineated which is fine with me, but I was wondering if there is a way to change the display of those numbers on the form so that it is easier to read.
Example:
current format - 1,2,3,4,7,8,9,10 desired format - 1-4, 7-10
I have created a Db in MS Access 2010 and under Options > Current Database I have done the following:
- Used drop down to select a form I want to display on opening - Unchecked display navigation pane - Unchecked allow full menus
This works how I want it to, perfectly. I then send it to a client who also has MS Access 2010 and when they open the file the form I have told it to open doesn't open, the navigation bar is displayed (with the form I want to open highlighted) and the full menus show but are locked.
What's going on? Is it some security setting the client has that isn't letting the opening procedure execute properly?
I am trying to display on a form the average number of lines/records per hour that a person is adding to the database.
Trying to work with Dfirst and DLast I'd subtract the time of the most recent record from the time of the first record entered and then divide the number of records to display the average per hour in a text box.
My colleague has a multiple table database and uses lookups for some fields. The simple query was to extract 3 fields and display all records from those fields. The result of the query was that the selected fields were listed first followed by all other fields which are usually not displayed.
How do I write a QBF query such that when a check box on the form is clicked, the name of query runs based on the name of that checkbox. I have a form called, QBF_Form, which has a series of checkboxes. Each checkbox has a name. I have a table, "Type", and I would like to run a query based on the information on the form, ie. when I click a check box, the query gets the name of the check box and runs the information based on that.I know the basic qbf is:
[Type] Like [Forms]![QBF_Form]![Type] & "*" Or [Forms]![QBF_Form]![Type] Is Null
But I don't know how this would work if I have a check box for values in field "Type" in my table.
Iwant to suppress the message "The macro or function set to the Beforeupdate or ValidationRule property for this field is preventing Microsoft Access from saving the data in the field". The message is correct-Iwant to prevent updating the checkbox if certain conditions aren't met. Any ideas? Thanks
I have a form that has a business address, business name and business number. I have a checkbox in the form, if they click the checkbox i'd like to have it copy the fields above to anther a field. What do i have to do in order for that to work? I've never did anything like this...Can someone please help
I have successfully created a mailmerge in word 2000 using an access table for data.
There is an access field which is a Yes/No Checkbox and it does not display the way i need it to in the merged document. Instead of seeing a ticked or unticked box i see o 0r -1. Can anyone please help me?!
I am no great computer wizard and would appreciate fool proof help!!! :(
I installed Microsoft Office 2003 on my computer. It asks me to register the product otherwise not all functions will work properly. I was curious so I didn't register it and started an Ms Access Application. Interestingly, when I clicked on a checkbox in a form , nothing happened. After registering the product and going back in to the mdb the checkbox worked just fine. Any one ever seen this before or know what causes that?
I want to make sure that only one check box can be checked and also to make sure that on is selected, i.e. to display a warning that one is not check if someone is going to save the record. Any ideas guys?