|Microsoft Excel Forum||Purchase Question by ADAM S: Yes, i used the same email address. I have looked in the Theater, logged out & back in. However I am still not seeing anything.
Reply from Alex Hedley: I've passed this onto Rich, he'll be in touch shortly.
Did you get an email confirmation with an Order #?|
|Microsoft Excel Forum||Purchase Question by ADAM S: I purchased the Beginner Level 2 courses this morning at 10:45 am. The order confirmation stated that my courses would be availible in 20 mins, however it's been and hour and 15 mins and they haven't posted yet. Can someone please advise?
Adam Reply from Alex Hedley: It should be available in the online theater.
Did you use a more...|
|Microsoft Access Forum||Stopwatch applet by David B: I need a stopwatch applet. I want to be able to press a macro button when a patient begins a task and when I hit stop have the time (to 0.01) recorded in the corresponding field. Any advice?
DNB Reply from Alex Hedley: The DateTime Seminar more...|
|Access Work Order Seminar||Purchase Order by Shallena A: I have spent a week trying to figure this out. I am looking for any suggestions on the direction i should take to accomplish what i am trying to do.
I get a Purchase Order with a list of things to complete - some are tower and some are Civil(ground) and I have an "other" category. I have to assign each of the items (there could be 20 or more items more...|
|Access Work Order Seminar||Purchase Order by Shallena Ayers: I submitted a question about my issue relating my work order table and schedule table. I thought a visual might help.
Job Form Job Table I get a Purchase Order with a list of things to complete - some are tower and some are Civil(ground) and I have an "other" category. I have to assign each of the items (there could be 20 or more items on the more...|
|Microsoft Access Forum||Filter on Report by Liza G: Created a table. There is a field with a value list. This table was made to create a form. Looking to create a report in which the records are grouped together based on which item is selected on the value menu. The grouping function pertains to "fields".
Reply from Alex Hedley: You could create a Report already grouped by those items more...|
|Microsoft Access Advanced 5||Microsoft Access Advanced 5 by Ray W: How many Access Advanced videos are you going to do before you start on the
Developer videos? Reply from Alex Hedley: I'm sure Rich mentions this in a video, only a couple more then onto the Developer, if there are any requests for other Macro topics he'll go back and add more. |
|Access Work Order Seminar||Purchase Order by Shallena Ayers: Hi Richard, In my database i am building with you I receive a Purchase Order from my customer... The purchase order has a list of services they need done (lets say there are 4 services... 2 tower and 2 ground type services). I enter each service into my Jobsite Total form (where you made the materials form). so i dropdown box and add each more...|
|Microsoft Access Forum||Automatic transaction number by Gregory C. S: I used the link in an email to see the updated post. I did not see a warning that I should log into the site before viewing the post.
I tried to post a reply but after hitting the submit button, I was told to log on. Did I waste time writing a reply or is the reply still salvageable? Reply from Alex Hedley: more...|
|Microsoft Access Forum||Automatic transaction number by Gioia H: Yay thanks i figured it out. I made two queries to get it to work the first:
SELECT DISTINCT DMax("PurchaseOrderID",'tblPurchaseOrders')+1 AS [Max], Format(Now(),"yyyymm") AS Now
Then the second one: SELECT "K" & [Now] & "" & [Max] AS NewPO
Not perfect but works. Good more...|
|Microsoft Access Forum||Auto Tab to next field by Richard L: In certain forms like entering credit card info or activation codes, there are a series of fields. For example: a credit card fields are four fields and have four characters each. in the first box I type the first four characters, but after I enter the fourth character, the cursor moves to the next field for it's four characters. How more...|
|Change to the Forums||Change to the Forums by Edward R: Security is so inconvenient. But I would be happy not to read spam posts so my word is thanks.|
|Microsoft Access Forum||Lists Access Memo Fields by Edward R: I have forms that the client submits two of them are in list form.
When data entered they are in the long text field on a single line separated by a comma.
Being they are read in as a list and the end user wants to see them as a list what is the proper way to do this?
As entered they are not in alpha order more...|
|Microsoft Access Forum||Filter on Report by Liza G: How to create a filter on text box in a report? Reply from Alex Hedley: Why not make a filter on a Form with a button to open the Report? |
|Microsoft Access Forum||Automatic transaction number by Gioia H: I'm trying to do something similar. I want to create a customer order number that would start with the letter K then take the year and month then increment from there. (K201704...) This info would populate my order text field on a form automatically. Can you help? Reply from Alex Hedley: Tip
|Microsoft Access Forum||One table or Multiple by Danmawia K: I am just beginning to learn MS Access (I am in Beginner Level 1) My question is: To make Students database Class I to Class XII Should I make different table for each Class or make one table for all? Reply from Alex Hedley: 1 Class Table with a Name, add a record for each class and use the ClassID Autonumber to make more...|
|Microsoft Access Forum||Random code generator by Ingrid L: Hello,
I am working on a project for a clinic and they want a authorization code generator. How can introduce a code generator on Access?
Thank you Reply from Alex Hedley: Seminar
|Microsoft Access Forum||Form Subform interaction by James M: I have a form/subform relationship between my Companies and Produts that I run from a Query in order to see only the products in which I have an immediate interest. The problem is with navigation. For example, if the subform contains 3 products, I have to click my "GoToNext" button 3 times in order to see the next company. How do I more...|
|Access Work Order Seminar||when i print more than 1 customers report the head by Shallena Ayers: Sorry that i didnt include this with my previous issue of the header only printing on the first customer report. But I also noticed that my sub form information from the first report is shown on all customer reports. If go to each work order and print just that work order... more...|
|Access Work Order Seminar||when i print more than 1 customers report the head by Shallena Ayers: when i print more than 1 customers report the header stuff only shows up on the first report. its like it thinks the other customer reports are part of the same report so no header info needed. I dont see that you did anything with the header one way or the other. What will more...|