|Access Database Security Seminar||Comment by Inderjeet Puaar: Sorry i managed to figure it out the create links error. Simple typo error on my part.|
|Access Database Security Seminar||run time error 91 by Inderjeet Puaar: Hi Richard,
Im getting a run-time error 91 (Object variable or with block variable not set) on the create links vba code. Not sure as to why. Can you have a look please. Heres my screenshot: http://cl.ly/image/061b0M2X3x3x|
|Microsoft Access Forum||Access Report by Bea A: I have a report that has fields that grow with the data. The detail field has names and hours and can be quite long. When the report gets long enough to require another page, it skips the 2nd page and puts the info on the 3rd page in print preview. What am I doing wrong?|
|Microsoft Access Forum||Error when closing form by George T: You can't save this record at this time
Microsoft Access may have encountered an error while trying to save a record...
Seems like everytime I update a record I have to answer this YES. The record updates but its annoying|
|Microsoft Access Forum||Student Database Files by Jacob Swinney: When i download the student database and unzip the file then go to open it in microsoft 2007 i get a unrecognized file prompt. What is the problem here, why wont it let me open the file? I googled it and my search results say that the file needs to be compacted and repaired. I attempted to do so but when i did i recieved the same more...|
|Major System Upgrade||Major System Upgrade by Lynn D: I love your tutorials. Looking forward
to more on Windows 8|
|Microsoft Access Forum||I just trying to do a Multi Field Search Form as y by Juan C S: I just trying to do a Multi-Field Search Form as you showing on one of your videos on Youtube web but It is not working on access 2007 do you think is because this version is 2007 and the version you show is on 2010, well I will appreciate your help.
|Microsoft Access Forum||Access Expert 11 Lesson 5 by Sam F: When making the "Last Customer Contact" aggregate query, I can't get the last "Notes" to appear when I run the query. The "Error###" parts (Ie the records which have null "Notes" values)show up but the rest of the notes fields are just blank. I've tried copying and pasting the dlookup code exactly from the example database into mine more...|
|Microsoft Access Expert 7||Sorting by Alex Hedley: Hi Janet,
How are you adding the item to the combo?
Is the combo based on an underlying Query that has a Sort on it? You could just refresh, requery the datasource and then it will be sorted accordingly.
|Microsoft Access Forum||making ACCDE file by MUBEEZI M: Dear Kenneth,
It is possible that there is an error in the VBA of your project. Unfortunately, Access may sometimes not give you useful feedback. I would suggest that you go to the VBA editor-->Debug-->Compile. Any errors will pop up as you compile. After correcting the errors, you will be able to create an ACCDE file.
Good luck in your more...|
|Microsoft Access Forum||making ACCDE file by Alex Hedley: Try compiling it in the VBA Editor first.
|Microsoft Access Forum||2 Subforms in 1 Report by Ramona: Since this post I have figured it out. I needed to add sub reports for invoice detail and invoice location. Then add the sub reports to my main invoice report.|
|Lots of New Stuff Coming Soon||Florida move by Norma H: Congratulations Richard! I'm sure you are going to love FL. I live on the east coast in a little town called Sebastian. It's located midway between Jacksonville and Miami and 3 miles from the Atlantic. I am also from upstate New York (Albany area) . Lived out in the country (Helderberg's) , so I also know what snow is. The best to you and you family . Norma more...|
|Course List Added||Course List Added by James Fisher: Hi Richard.
when can we expect to see some new classess |
|Microsoft Windows Forum||sudden shutdown of windows 7 by Mubeezi M: dear Richard,
I have used my laptop for since Nov 2011 (about 12-16hours every day). it has always worked OK. over the past 2 weeks, it suddenly restarts, shows a blue screen and claims to be dumping some type of memory. could this be a virus? how do I get around this?
|Microsoft Access Forum||making ACCDE file by Kenneth B: Is there a limit on the number of forms, reports,macros,tables? because I get this error when i try to make a ACCDE file
This error is usually associated with compiling a large database into an MDE file. Because of the method used to compile the database, a considerable number of TableID references are created for each table. more...|
|Microsoft Access Expert 7||Sorting by Janet G: 4:36 - Combo box sort - How can I sort the people that are already listed in the combo box table - I understand how to sort the drop down list to pick from but they themselves do not sort once added to the list - I'm replicating this in my db whereby I have several "customers" attached to our "Client" - when searching if a customer belongs to our Client it would be more...|
|Microsoft Access Expert 13||Disabled Mode by Brauna: Hi again Richard,
You could ignore my question. As it turns out the database I was working with at the time was not in a "Trusted Location" It is fixed now. Thanks again.
Your tutorials are great, by the way. I have been able to create a database for a doctor's office and is now functioning very well. |
|Access 2010 Beginner 8||LimitToList by Janet Gangl: Hi Richard - 8:45 Lesson 2 Beginner 8; I've been thru all of the beginner and expert videos and am now working on my own database. I have a similar table to the lead source table except that I'm using an ID field therefore my combo box has the two fields. If I change "Limit To List" to No - I get the following error - Access can't set the LimitToList more...|
|Microsoft Access Forum||2 Subforms in 1 Report by Ramona W: Hello Everyone! Access 304 create a printable invoice, which I have done. It included Invoice Query for the totals & the created a Report.
I have added a LocationT, LocationDetailT, and LocationDetailF to my database. I created another subform based on my LocationDetailT to my InvoiceF. (Looks Great! LOL) Then I added My more...|