Fri 4/19
8:49 | 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... |
Tue 3/12
8:57 | Microsoft Access Developer 12 | Microsoft Access Developer 12 by Richard R: test |
Sat 2/16
15:14 | 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... |
Thu 2/14
11:36 | 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
FROM MaximoReport
WHERE (((MaximoReport.WorkType) In more... |
Tue 2/12
17:36 | 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... |
Tue 2/12
13:48 | 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... |
Sun 2/10
21:52 | 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. |
Mon 2/4
16:43 | 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? |
Mon 2/4
12:54 | 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. |
Sun 2/3
20:19 | 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... |
Fri 2/1
10:57 | 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... |
Tue 1/29
12:21 | 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? |
Sat 1/26
11:02 | 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... |
Wed 1/23
21:12 | 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?
Thank you. |
Wed 1/23
21:06 | 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... |
Wed 1/23
10:54 | 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... |
Wed 1/23
8:20 | 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. |
Tue 1/22
14:04 | New Releases | New Releases by jannette j: when is new courses come out |
Tue 1/22
13:22 | 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... |
Mon 1/21
16:22 | 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.
Any ideas? |
