|Microsoft Access Forum||Access 2013 runtime by Ray W: Is there any way to install Access 2013 runtime and it not corrupt any other versions of Access runtime that may be installed on the computer?
I have customers that run my program with Access 2003 runtime and when they install a new program that runs with Access 2013 runtime the programs that run Access 2003 runtime will not run any more. more...|
|Microsoft Access Forum||Formula by Bob Lilly: Hi Alex I was able to come up with a formula that did the trick. The formula below is for the original worksheet but not for the example shown here.
|Microsoft Access Forum||Object dependencies by Michael L: Dear Alex
I imagined that Access would have a tool to give an overview of the complex dependencies and relations that we build into the tables, forms, queries and reports.
I thought that this is what the "Object Dependencies"-tool does, I'm just not sure how to interpret what is displyed.
Was hoping Richard would teach us to use this more...|
|Customer Service Policy||Customer Service Policy by Ignacio A. Zamudio: I enjoyed the basic access on youtube. Got me started. I want to incorporate my data from excel to access.The field names are not same. What is the easiest and quickest way? Reply from Alex Hedley: Check out Expert 20. |
|Microsoft Excel Forum||Formular in Excel by Bob Lilly: A B C D E
6 27 25 35 52
No1 No2 No3 No4 No5
6 27 25 35 52
13 23 29 33 42
7 24 35 34 55
I m trying to write a formula that will look at Cells A2:E2 to see if there any any cell that match the value in C6, and if so placed a 1 in column F6.
Reply from Alex Hedley: more...|
|Microsoft Access Forum||VBA Select Distinct query by Robert: Hi Alex, I did work it out with the line: Set rs1 = db.OpenRecordset("select distinct ccmodel from CarModelT where CarsMakeID= " & TempMake). The purpose was to filter the ccmodel in particular from the list of car makers (CarsMakeID). The other fields weren't necessary and they caused confusion. Robert Reply from Alex Hedley: more...|
|Digital Photography Forum||Digital Photography Forum by Jacqueline jones: Want to learn this problem|
|Microsoft Access Forum||You can t assign a value to this object by Brad J: Working through the Expert 22. On the Add product drop down box, when I hit enter, I"m getting the subject message and the detail is Error 3021, SetValue action, Arguments SalesTaxRate, Forms!OrderF!SalesTaxRate. In addition, it does not appear that the calculated fields in the OrderDetailQ for SalesTax and more...|
|Access 2010 Beginner 2||stupid question why does my form not have the do by Heather Hudson: stupid question - why does my form not have the dots in the grid? Having trouble linig up text boxes. Reply from Alex Hedley: See this Tip. |
|Microsoft Access Forum||Access 2007 by Ray W: Has anybody have trouble with using
SubForms with Access 2007? Reply from Alex Hedley: There's problems all over that release. |
|Microsoft Access Forum||Access 2007 by Ray W: I have a form that will work great in Access 2003 and Access 2010
But not in Access 2007.
Is Access 2007 worth using?
or to many bugs in it? Reply from Alex Hedley: Don't use it, very buggy. |
|Access 2010 Beginner 1||I sat back and relaxed and watch courses 1 thru 7 by Guadalupe Pinon: I sat back and relaxed and watch courses 1 thru 7. I got just one small question which has been on my mind all along. How would you setup when there's an election of whether the person is a male or female? Help! ~ Wally Reply from Alex Hedley: Add another Field of more...|
|Access 2010 Beginner 3||Phone Option Input Mask by Resat Ilgaz Demirel: For some reason I am not getting Phone option in my input masks. Reply from Alex Hedley: What data type is the Field? |
|Microsoft Excel Forum||excel vba by manilara: Dear Experts
I have multiple workbook saved in folder i want copy data from closed books and paste into mastersheet particular criteria is
sum the column F:F and average the column G:G after 20th rows
Path is C:\Users\maninata\Desktop\Personal\Excelforum\VBA\TASK_1
Find the more...|
|Microsoft Access Forum||using data from excel in access by Line: Hi,
I want to add a field to a table which link names in one field to a autofill number (like a reference number )which is pulled from an excel spreadsheet so it autofills. Any ideas how i can do this?
Thanks Reply from Alex Hedley: more...|
|Microsoft Access Forum||Encrypting database by Sivaram G: I have no idea about row level locking. Reply from Alex Hedley: Did you split the db? |
|Microsoft Word 101||I would like to know if you have anything on word by Anonymous: I would like to know if you have anything on word 2016 that is where I am working right now. I am aware of this viersion. the newer version is what I need now. Reply from Alex Hedley: The Word Course List is more...|
|Microsoft Access Forum||Enter Parameter Value by Khaja: Hi,I was trying to follow lesson 2 from payables seminar, I did the docmd open form code , but when I double click on payee name it says " enter parameter value " , I did same as shown in video, where am i wrong, please assist. Reply from Alex Hedley: Does the parameter have a name? |
|Microsoft Excel Forum||Grouping dates into date ranges by Michael G: Hi,
I've looked at VLOOKUP and Pivot Tables but so far no luck. I have a long list of dates ranging from 1/1/11 through 12/31/14. I want to change the dates into date ranges. The ranges are as follow: Before 1/1/12; 1/1/12-12/31/12; 1/1/13-6/30/13; 7/1/13-12/31/13; 1/1/14-6/30/14; 7/1/14-12/31/14. So for example, more...|
|Microsoft Access Forum||Microsoft Access Forum by Selby H: Dear Richard,
Is it possible to play a sound (piano chord) using access vba, using keyboard?
All the best
Selby Reply from Alex Hedley: Allen Browne has a tip.
Declare Function apisndPlaySound Lib "winmm" Alias "sndPlaySoundA" _