|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...|
|Microsoft Access Forum||Custom icon by Alex Hedley: http://www.xiconeditor.com/|
|Access 2010 Beginner 9||Can you change the default font by simon b: There would appear to be only two settings in Access 2013 to change the anything to do with the font.
here you can change the font size weight and make it underline or italic
But as Richard says the font type is a windows setting.
You can under Object Designers settings more...|
|Microsoft Access Forum||Displaying Decimals by Peter Brooks: I have a form where the customer enters numbers with none or up to 2 decimal places as necessary. I have set the field 'QTY' to Double in the table and numbers show correctly on the form, e.g. 1 1.25 and 1.5 etc. However, the equivalent field on the report I can only get it to show either two decimal places or round up any two decimal more...|
|Access 2010 Beginner 1||2013 and 2013 by Dale Ferg: I have purchased Access 2013 with the intention of using it to create a database to use at work. The version that is in use at work is Access 2010. Will the 2010 version be able to run what I create at home in the 2013 version?
|Microsoft Access Forum||Custom icon by michelle m: Is it possible to create a custom icon to open a data base file |
|Access 2010 Beginner 9||Can you change the default font by John Hirschy: I would also like an answer to this question for Access 2013. I cannot find an answer on Google. I would like the default font changed for the whole database, not just a text field. |