|Access 2010 Beginner 4||index the NumEmployees and Discount Rate by Joe Beniacar: Hi Richard,
Why would you not want to index the NumEmployees and Discount Rate fields in this Customer Table, too? (conceptually) |
|Microsoft Access Expert 16||I would like to copy multi fields from one table t by Scar: I would like to copy multi fields from one table to another table with the selection from only one combobox. where can I find info on this. |
|Microsoft Access Forum||NZ function fails in report by Peter Brooks: I have a report that extracts data from a table on a job by job basis. When the data is collected I have to make a number of calculations where a number of fields will contain a currency value, but some will will be Null, (Given how the customer uses the program these must be Null and not 0).
I am using the NZ function more...|
|What Access Topics Do YOU Want?||How to move Access to Azure by Gary Samuels: I've moved an Access/SQL database to the Azure Cloud. I have setup Azure Storage with public containers to hold documents and images which are displayed in a form or opened by hyperlink with the associated application. Downloading isn't to hard but how the heck do I upload using only VBA?|
|Microsoft Access Forum||Rules Engine by Gerald W: I need to build a rules engine database. I have search the internet for an example DB, however,I cannot find anything on the subject. Right now we have a buch of excel workbooks with business rules and control over the updates to the rules, who changed the update, when it was lasted updated, or any other nformation such as messages that should present when a more...|
|Access 2010 Beginner 3||Date Function by Joseph Beniacar: Hi Richard,
Would the DATE() function update the cell with the new date "each" time you close it down and reopen it another day? |
|Microsoft Access Expert 11||Open Form Multiple Conditions by Alex Hedley: If [ContactID] and [CustomerID] are on [ContactF] then when you open the form [CommunicationF] have their "Default Values" set to
|Weekly Access Hangout||Weekly Access Hangout by lauro c: weekly access hangout is a great idea but since we are all busy and our time frames may not fit, you can do so Rich on your own convenience and just post it.. if you can staggard the time at different time of the day based on previous subcribers' recommendation and just post the time.
Then you can probably save the encounters as an archive more...|
|Microsoft Access Expert 11||Open Form Multiple Conditions by Lynda C: Hi Richard
There are three forms involved here.
My CustomerF - which has all my customer info
My ContactF - which shows people and their positions within the relevant CustomerF e.g Esme Cole - Sales Manager, Keith Cole - Property Manager etc
and then I have my CommunicationF - which reports all communication more...|
|Microsoft Access Expert 11||Open Form Multiple Conditions by Lynda C: Hi Again,
I mean when I am on the customers contact form, I want to click a button, that opens the CommunicationF, and have both the ContactID and CustomerID fields populate with the relevant details from the ContactF.
|Access Work Order Seminar||Access Work Order Seminar by Lynda C: Hi Richard,
I am still having problems with the schedulingF returning errors. I believe this is to do with my location settings and the date format.
I have downloaded your student database, and it is returning the same error.
When I type in the begindatetime field, I get the following error:
Run-time error '3075':
|Microsoft Access Forum||Creating buttons to open forms by Stefanie M: I went to Property Sheet and changed its format to "No" visible.|
|Microsoft Access Expert 11||Open Form Multiple Conditions by Lynda C: Hi Richard, I'm wanting both fields to drop in on the CommunicationF by default |
|Microsoft Access Forum||how to set up table by Cherylynne: when you say set up a share table i am not sure why as I do not need the shares only the name and address of the shareholder which I have when I set up the share holders. So still not sure how this would work for me even if I do set up a share table as some people have shares in 2 or more companies and I do not want to send out 2 or 3 emails more...|
|Microsoft Access Expert 10||IIF Function by Brian Farley: So for the homework, I put the IIF function for the quote and paid as fields on the report instead of part of the query.
Any Con to doing that, other than you can't get to that field from another report?
Is there a limit on how many fields you can have in a query?
|Microsoft Access 327||Comment by Richard Lanoue: Yes I would like to see partials...
|Microsoft Access Forum||Displaying Decimals by Peter Brooks: I tried that Richard, but it still shows 1.50 when the form shows, correctly, 1.5 |
|Microsoft Access Expert 11||New Record at Top by Lynda Chase: Hi Richard
Is there a way to get the 'new record' in a continuous form, to appear at the top, rather than the bottom of the list? |
|Microsoft Access Forum||Custom icon by michelle m: Thanks Richard, I have made the icons in paint but cant seem to save them with the ICO file extension. Will google it. Thanks again|
|Microsoft Access Expert 11||Open Form Multiple Conditions by Lynda Chase: Hi Richard,
My customer table is linked to a contact table that shows the 'managers' of different locations.
I am trying to add a button to my customercontactF which will open up my communications form with two where criteria (customerID and contactid) So i can not only see customer communications, but communications more...|