|Customer Testimonials||Kid in a Candy Store by John Davy: I started watching the SQL 3 videos as soon as I downloaded them. I love them! I am like a kid in the candy store with your videos. I worked for the state education department for 30 years supervising teachers and you are the best I have ever seen. You are smart. You are masterful with Access. Most importantly - you are a great teacher! You more...|
|Microsoft Access Developer 12||Microsoft Access Developer 12 by Richard R: test|
|Microsoft Access Forum||Access Short Text Field Size by Gerald Y: In Access Beginner 3, Field Properties 1, where we talk about wasted space:
It should be noted that for data in a text field, Access does not reserve space beyond what is necessary to hold actual values.
See https://support.office.com/en-us/article/set-the-field-size-ba65e5a7-2e6f-4737-8e72-36b93f966a33 at the bottom of more...|
|Microsoft Access Forum||divide two queries to get percentage by jannette j: want to join two queries so i can take the count of one query and divided by another query to get the percentage of work orders that were completed.
the numerator query:
[code]SELECT Count(MaximoReport.WorkOrder) AS CountOfWorkOrder
WHERE (((MaximoReport.WorkType) In more...|
|Microsoft Access Forum||Microsoft Access Forum by david P: In Exper7 we learned about ManytoMany relationships. I am wondering if that relationship will work using the same table. Such as a CompanyXCompany. The reason I ask is how to perform a partnership with a company in CompanyT and a Partner from the same CompanyT. If I select a partner from the sub form, I would like to see the reverse show more...|
|Microsoft Access Forum||joining queries to one by jannette j: i need to get some help with a doing some calculations with a lot of
criteria into percentages.I have many of queries were simply to come up with a number that is a count of records with a specific criteria, to be used later in a calculation. Because those criteria are so lengthy, and change with each variation of the data i use more...|
|Access Work Order Seminar||dbl clk by Matt: 10:40
you don't need to check because your picking a Value when you dbl clk the list box so can't eliminate the IF statement in the dblclk event? Reply from Alex Hedley: If memory serves its because you can double click a list box without actually having a selected/highlighted value so this is in place to make sure a value is passed to the necessary part. |
|Microsoft Access Forum||Drop Down by Keith A: DROP DOWN List made by field lookup wizard works great. But.... If I try to do a query on using that field as a filter - it won't work as the value is a number - not the text from the list. Reply from Alex Hedley: Have you tried using the .Column property to get the value you need? |
|Microsoft Access Forum||Join Queries by jannette j: I have 11 queries that each of the quers have two one for numerator and another for denominator how can i combine all to create a crosstab query for a report.|
|Microsoft Access Forum||Access 2013 by Nelson Wallace: I think I am almost passed my use by date when it comes to learning but I am enjoying the challenge. I have come to a standstill while developing a program to keep track of my dividends on a financial year basis to tax purposes. By the way I am in Aus so we use En date format not US.
The problem is although I have the ticker code as the first field. And more...|
|Microsoft Access Forum||Join Queries by jannette j: i have two queries I want to join so i can get the percentages from each department of completed work orders but not sure how to go about it. I know i want a join and a crosstab query so i can display the results in a report.
The first query calculates the numerator,
SELECT Count(MaximoReport.WorkOrder) AS CountOfWorkOrder, more...
|Microsoft Access Forum||Wizard by Susan W: The input wizard does not seem to be working for me. What could I be doing wrong? Reply from Alex Hedley: How is it not working? |
|Microsoft Access Forum||Word Automation by Joseph M: I have a word document that I kick off using an access macro " run application" the document opens fine now I want to automate it so it will start printing on open. Any ideas? I also would like to word doc to close are return control to access. Reply from Alex Hedley: Have you tried recording a macro in Word and see what happens when you more...|
|Asset Management Seminar Part 1||Part 2 by Mary Phillips : I see Part 2 was intended a long time ago. Is it still a possibility? If so, when could it be expected?
|Microsoft Access Forum||Enforce Referential Integrity by Ariel D: Hi,
I'm currently working with Access Expert 8: Lesson 5-Order Detail Subform. I'm building up the relationships for the three tables: CustomerT, OrderT, and OrderDetailT. However, when I build the relationships for the OrderT and OrderDetailT and click the "Enforce Referential Integrity, then click OK an ERROR message more...|
|Microsoft Access Forum||Correlate the selected date by jannette j: I need to correlate the selected date range in a form with the proper recordset. I think it can be done, but I would have to play with it a little to get the code right. There are built in functions in VBA to get the week number from a given date it would then just be a matter of the VBa is there any VBA that can do this more...|
|Microsoft Access Forum||Blank Record by Richard A: Is there a way to use a button on Form 1 to open Form 2 and go to a blank record? Reply from Alex Hedley: See this thread. |
|New Releases||New Releases by jannette j: when is new courses come out|
|Microsoft Access Forum||Using the enter key to kick off an action by Joseph M: Have you ever done a session where a user might fill in a text box with a name and then kick off the search using the enter key instead of a special button? If so what lesson was that in, if not...could you do one? Reply from Alex Hedley: You can add a shortcut to the button, just use a "&" more...|
|Access Web Data Sync Seminar||Mobile Wunderground Code by Kristin Williamson: I sent my first email too quickly. When building my own form using the wunderground site, L1 = 14346, L2 = 14471, D = 145. So my MsgBox is 145 characters. I'm trying to find another website to use but so far no luck.