I'm using a split form in Access 2007 to display the results of a query. When I view the "Other" tab on the Property Sheet for a textbox on the form, there is a Datasheet Caption property... w...
I have a query that uses the values on a form to retrieve its criteria. Here is an example of the code I put into the Query in design view to retrieve the criteria. This makes it easier for th...
Lets say I have 5 fields in a table, fields A1, B1, C1, D1, E1.
I have a form (continuous forms), that displays the 5 fields and multiple records in a tabular fashion.
How can I make ce...
i would like to be able to change the ribbon using vba.
ie.
if user = frt then
me.ribbonname = "frtribbon"
elseif user = acc then
me.ribbonname = "accribbon"
else
me.ribbo...
A person in my office came to me with an Access 2007 question. I do not have the ability to change the specs of her Database.
Easy specs:
Tables: TableA, TableB
TableA: has id, name, myM...
I tried splitting my access 2007 database to see what benefits exist but when I went into the front end I noticed I could still update the back end tables or delete the data.. I thought one of...
I have a form with a combo box that is link to a table. The combo box lists current projects. If a user types in a project that is not in the list they're presented with a message box asking...
Greetings,
(In the code section, is data from my table. And I'll up the points before closing the question)
I'm trying to filter data on a form.
I have one filter(button) that will ...
I have an input form that I click on the button to open another form for my budgets and I get a Enter Parameter Value box for 3 fields that are in my table. Why is this happening?
Ok experts I'm hoping someone has a similar sample db of my issue that I might be able to follow since I am a novice at best. We currently send out empty totes to vendors and have them fill th...
I have a primary form with a list box, when the user clicks an item in the list box the form (using VBA) dynamically creates a form with it's default view set to datasheet, adding the relevant...
Hi, I'd like to add autonumbers to a query result based on the sort order of the output. Is there an easy way to do this? Thanks.
Hii All,
i am using wss 3.0 and i needed column permission for sharepoint list. i used sharepoint boost columnpermission but it doesn't work for datasheet view . it's only work for stand...
I have the following SQL Statement on access. I want to compare only the months where the dates of each table match.
So index11 is the table with the indices and fundata is the table with th...
I have searched for a specific record in my table and now I want to open up a form to display that record.
I'm getting an error on an update of a recordset. The error message is "Index or Primary key cannot contain a null value", which would be simple to correct if the value being updated was an i...
How can I disallow users the option to use Shift Enter upon opening database so they are unable to access administrative functions?
I'm a Admin user for my database but Access 2007 don't allow me to change the Users and Permissions setting (the tool is desabled). How can I be sure that it will be possible for me to modifie...
Please see attached screenprint of the pivot chart that I made. I need to change the left axis scale to 0-4 maximum. The right axis needs to remain at 0-120 maximum.
I am using Access 2003.
...
I have Multiple Records that I want to Sum and Combine Into a Single Record in my MS Access table. For example, assume my table looks like:
Name Amount Code
------- -------...
I am a complete novice when it comes to VBA programming. I have been looking at the different ways to come up with the 95th percentile in Access, but I can't get any of them to work.
I hav...
Hi im using the following in Access 2003:
DoCmd.OutputTo acReport, stDocName2, acFormatTXT
A dialog box opens and the user canhoose the filename, how can get the path+filename that the u...
I am trying to find out if there is any way possible of putting together some sort of alerts on a form when an Access database is opened. I have a database that is used by my IT department to...
Hi,
I'm working on an Access 2007 application which allows the user to send a notification to another user.
The problem arises when i try to send an email to a user that is not in the Note...
I have a form that has users enter search criteria to search a database for computer equipment which will then open a new form showing each of the records that meet the entered criteria. The f...
