Wed 5/16
22:22 | Access 2010 Beginner 1 | Comment by John: If I add new information into my Table. How can I Put this new information into an existing Form? Reply from Richard Rost: Forms don't hold data. Forms DISPLAY data from tables. When you add information to your table, it will automatically show up in any forms that are bound to that table. If the form is open when you add the data to your table, however, you might need to more... |
Tue 5/15
22:41 | Microsoft Access Forum | When Focus changes by Scott A: Is it possible to change control properties when when moving from control to control.
Basically, I have a form that is looped through to indicate missing information. I use a red border and green. I would like it to loop through the controls and determine if there is a value or not, and color the border accordingly. Thanks again all/
|
Tue 5/15
14:10 | Microsoft Access 222 | Comment by Jing Zhao: How can i move my old record to another table after i add a new record? Like, creat a history table. Reply from Richard Rost: Do you mean like archiving old information? That's coming up with append and delete queries. Keep watching (lessons 6 and 7 should answer your questions). |
Tue 5/15
10:30 | New Access Tip: Search Form | New Access Tip Search Form by Brad Y.: I got the search form working really easily. Thanks!
My only problem is that I can only run the search once, then I have to close the query. Once I close the query I can then run a new search from the form.
On your video you didn't have to do this. You just continued to ajusted the filters and click Run Query.
How more... |
Mon 5/14
20:15 | Microsoft Access Seminar | Comment by Richard: Yes, there is a problem with his video at around the 44 minute mark with the Flash player. Try using the WINDOWS or HTML5 player. |
Mon 5/14
19:30 | VB vs. VBA | Where is all the action by Ron Oates: I am perplexed at why no-one has commented since I did a year and a half ago, and that was the first one since two years previous??? Reply from Richard Rost: It's an old thread on an old topic. Perhaps try posting something new in the Access Forum. |
Mon 5/14
17:48 | Microsoft Access Forum | Help Needed by Mike: I failed to show how I generate the record number which I would like to reset when the year changes.
Private Sub AssignID()
ID = DLookup("ID", "tblYearDate", "")
If Me.ID = "" Then
Me.ID = ID + 1
End If
End Sub |
Mon 5/14
16:46 | Active Server Pages 201 | Comment by jeff: How do you turn on error checking feature in th bowser Reply from Richard Rost: I don't understand your question. Can you please elaborate? |
Mon 5/14
3:55 | Sorry for the delay... | Sorry for the delay by Deon R: Hi Richard,
Don't rush things; get better first, which is the most important thing and then you can get back to expanding our knowledge. Looking forward to those new tutorials. All the very best, Deon Reply from Richard Rost: Thanks. |
Sun 5/13
14:48 | Microsoft Access Forum | Help Needed by Mike: How do I:
‘This code increments a number starting with one
Me.VMD.Value = Nz(Me.VMD.Value, 0) + 1
‘This code changes the year in my table after Sep. 30th of each year
StartDate = 2012
If Date > DateSerial(StartDate, 10, 0) Then YearDate = Year(Date) + 1
If Date < DateSerial(Year(Date), 10, 1) Then YearDate = Year(Date)
How is the best way to capture more... |
Sat 5/12
20:17 | Visual Basic Forum | Visual Basic Javascript or Something Else by Moe: I use IE8 and don't like Google toolbar or most any add-ons as I feel they compromise the speed of page-loading. I turned off the 'tabs' feature b/c I don't care for it and have "reuse Windows for launching shortcuts" disabled under 'internet options'.
I can add buttons to my existing
'command bar' more... |
Sat 5/12
14:32 | Microsoft Access Forum | Nulls vs Empty Strings by Richard R: I just had a problem today that made me want to remind all of my Access developers to always check for both NULL values and EMPTY STRINGS.
I had a situation today where a customer wasn't seeing one of his courses in the course listing for his account. It was THERE. It was on his account in my database, but it wasn't showing up more... |
Sat 5/12
13:07 | Microsoft Excel Forum | Foreign language Excel by Michael Turner : Is there a defferent version of excel 2010? I bought my American version from a German cumputer store and have problems with the dates, periods, commas, and dollars signs.
Thanks Reply from Richard Rost: There are different foreign-language versions of Office. To be completely honest, I've NEVER used them before so I more... |
Sat 5/12
11:40 | Microsoft Access Forum | Averaging Various Fields by Moe: Thanks for response, Richard.
@Alex - Thanks. I understand what you mean by adding a name to a tag property, but don't know if my VBA is up to par to even begin to write a "loop." I wish there were YouTubes or an online learning center (free) where I could get a workable handle on VBA via video. Reply from Richard Rost: I'm more... |
Fri 5/11
20:05 | Microsoft Excel Forum | excel on mac by debbie westfall: I have set up two excel workbooks. Accts payable and accts payables on a friends computer. He maintains the inputing of the info into the sheets. I periodically go in fix and mistakes by using teamview software. It is now the end of year and he has put all info in the 2 workbooks and now I want to transfer them onto my computer and keep all the links I more... |
Fri 5/11
18:20 | Microsoft Access Forum | Averaging Various Fields by Alex Hedley: You could add a NAME to the tag property for each control then create a loop in VBA to sum/avg etc all the values where .tag = "NAME"
Now you can just add the tag name to any new controls and the avg will update automatically.
Don't have to update formulas then. |
Fri 5/11
17:58 | Microsoft Access Forum | Averaging Various Fields by Moe: Hello,
I have an MS Access 2007 database and form which is quite simple. I have a list of individuals and their scores (i.e. 3.2, 2.2, 4.1) on various objectives (i.e. proficiency, speed, comfort etc.). The scores fields are all formatted as single and fixed with one decimal place. The scores are in various fields (not in one column more... |
Fri 5/11
10:08 | Microsoft Access Forum | Storing calculated values by Irfan: I have built a form and in a field i put a formula for calculating GSM, GSM is calculated but not save in Table. What i do? Reply from Richard Rost: Values that are calculated on a form in a form field are not stored in the underlying table. Most of the time, you don't need them to be. When you're calculating, for example, more... |
Thu 5/10
20:05 | Microsoft Access Forum | Error Setting For This Property Is Too Long by Sean P: I am opening a rs from a 800 record table using an SQL and putting three fields into a combo box. When I have one field, life is good, when I have more than one field, I get the error as noted in the subject line. Are there limits to the number of fields or characters in a combo? Reply from more... |
Thu 5/10
16:14 | Microsoft Access Forum | Is Access the Right Program to Use by Brenda Boyd: I am trying to determine if Microsoft Access is the best tool for my project. I work at an administrative office of a large group of physician/provider offices. I need a database to maintain all our contacts (doctor offices)--some who have joined our group and some who are still in negotiation to join (or not). more... |
