Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
 
Home > Forums > Developers
 
Access Developer Forum

This is a Forum for students in my Access Developer courses. Yes, you can still post questions in the comments section of the individual courses, but I will be using this Forum to post general notifications, ideas for future lessons, etc.

I recommend you subscribe to this Forum if you're interested in getting these kinds of updates. I'm not going to send out individual emails for everything.
 

Click Here to Post a comment and start a new discussion

 

Inputmask Upload Images   Link 
Abraham Breuer 
28 days ago
Is there any way how i can change an input-mask with VBA?
i tried to make a logon and mask the users password, but i want to be able to have a on click event that unmask the password format to the original text Read More...
Abraham Breuer
28 days ago
Please ignore spelling i have tried it  with inputMask
Kevin Robertson
28 days ago
Try
TextboxName.InputMask = "" to turn it off
TextboxName.Inputmask="Password" to turn it off
Add a Reply
ComboBox Rowsource Upload Images   Link 
Abraham Breuer 
2 months ago
Hi!

I have set up a form with 2 Comboboxes 1- CustomerCombo 2- SalesRepCombo,

then used the after update event:

   Private Sub CustomerCombo_AfterUpdate()

      SalesRepCombo.RowSource = "SELECT SalesRepID, SalesRepFullName, FROM SalesRepCustomerQ" & _ Read More...
Abraham Breuer
2 months ago

Abraham Breuer
2 months ago

Add a Reply
Add Records One Time Upload Images   Link 
Abraham Breuer 
3 months ago
in dev18 lesson 4, you learn how to edit new records to an unbound form using recordsets,
my question is if I want to add let's say 4 records at ONE TIME to my table with just one
Click on the add button, is this the same method or more complex?
Scott Axton
3 months ago
Abraham -
Check out this video and the extended cut for Add Records Automatically.
https://599cd.com/blog/display-article.asp?ID=1445

Richard doesn't use recordset in the videos but it is pretty straight forward and you should be able to loop through adding records with recordsets.
Richard Rost
3 months ago
Yep. A simple append query will work.
Add a Reply
Many to Many Upload Images   Link 
Edwards Christopher 
3 months ago
Hello,

I watched Richards Many-to-Many video. I want to add another layer to the many to many relationship where depending on the group assigned to the customer, certain trainings will be available in the sub form. I am at expert level 3 so this is already beyond me. Can someone point me to a resource on this site or provide guidance? Will I pick this up in expert 7?
Richard Rost
3 months ago
Can you be a little more specific? Do you mean if the student is, for example, in the Physics group (major) he only sees Physics classes?
Adam Schwanz
3 months ago
Yea unless your talking about something else. A many to many junction table is all that you need. One table with classes and another with the students. Now if your saying you want to filter your results down, that can be done in numerous ways. I dont know how your database is setup but if you have the customer and classes table setup. I would just add a field to the customers table that you could enter in a major. Then you could make a one to many relationship between major and the classes. You could then limit what courses are offered to him by his major.

You could also just use a filter or where clause, or you could just manually assign the classes to the student with the junction table. Access always seems to have lots of ways to get to the same end result. Just depends how your tables and form is setup now and what you want to do.
Add a Reply
Vba Syntax Upload Images   Link 
Abraham Breuer 
4 months ago
Hi Richard

I am currently going through the developer lessons, I love them its brilliant,
I would like to ask you if you can put on your tech help list to explain everything about syntax in VBA, Read More...
Adam Schwanz
4 months ago
Im just imagining this being far far beyond a tech help video. Maybe even beyond a seminar. There is so much to review, i don't even know if you could go over this being so broad. I would recommend continuing the classes and most of all practicing it yourself. I used to have problems remembering stuff but working with it everyday makes it a lot easier. You get used to it really quickly that it becomes muscle memory to just throw them in where they are needed.

A couple times of why doesnt this work? Maybe i need a & in front of the field? Yep that was it  Really nails it in to remember that next time.

With the & sign your usually adding a field or text to a statement. With  your usually saying this isnt a function or integer  i want to say a string. But they have sooo many other uses.
Scott Axton
4 months ago
Adam Breuer -
   I  agree 100% with Adam Schwanz reply.  There just isn't any amount of watching videos or even reading hand books that are a good substitute for actually doing the work.

Unfortunately the best teacher is often fixing your own errors.  I (we) could take a look at some code and tell you right away you are missing a quote or you need an & but you won't learn from it.

That said different people learn different ways.  I suggest getting a spiral note book an actually writing down some of the tidbits that are important to you.  Don't type it in.  Writing things down helps "insert it into the brain"

For instance - using your example above:
  & is an operator used for concatenation.  Used to bring together two pieces of text or to join the text values in two field names.

Add a Reply
DMax DLookUp CommissionRate Upload Images   Link 
Abraham Breuer 
4 months ago
Hi Richard
Just finished the Dev4,
the technique you use to log the commission rates for each rep into the commisionT is by appending one order at a time,
how about when I want to append multiple orders at a time for some period of time, for example, a quarter of a year, and after calculating the orders then dlookup the commission rate? Read More...
Richard Rost
4 months ago
You'd need a loop. I'd recommend a Recordset.
Abraham Breuer
4 months ago
thank you for your reply
I will need to have patience until getting to Dev16...
Add a Reply
Developer 27 Finished Upload Images   Link 
Richard Rost 
5 months ago
In the can. Over 4 hours of stuff. Enjoy!
Add a Reply
VBA in VSCode Upload Images   Link 
Abraham Breuer 
5 months ago
Does anyone know about vsCode if it's a good place to write VBA code?
Have a look at the screenshot it looks to be a neet place for VBA...
What do you say about it???
Abraham Breuer
5 months ago

Richard Rost
5 months ago
Looks kinda neat. I haven't used it. That's more up Alex's alley. :)
Add a Reply
Create Sequential Numbering Upload Images   Link 
Despina Karayanni 
5 months ago
Hello,
I am working on creating sequential numbering in an order database. Here is the problem I have. I enter data in the orderF form, and as soon as I close this form, the OrderT table has been appended (it shows the new entries), but when I open the OrderF again, it is blank (it doesn't keep the data). Can you advise why this may happen? Thank you in advance.
Despina Karayanni
5 months ago
In the meanwhile, I replaced the form, which functions as it should. However, I keep wondering how could this have happened!
Richard Rost
5 months ago
Very strange. Sounds like you got some errant code in there somewhere. Many times I've found solutions by just scrapping a form and starting over. :)
Add a Reply
Added QR Codes to D27 Upload Images   Link 
Richard Rost 
5 months ago
I added the QR Code video to Developer 27 as well. Probably not going to do too much more with them, but I do cover the new WebBrowser control which I haven't shown much in the Developer lessons (more in this is coming) and the URLDownloadToFile function which is completely new and lets you grab a file from a web site. Very cool stuff.
Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
 
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.
 
Subscribe
 

You may want to read these articles from the 599CD News:

8/1/2021Error Messages
7/31/2021Hide Inactive
7/29/2021Event Enrollment
7/28/2021Membership Database
7/27/2021Quick Queries #5
7/27/2021Loop Thru Fields in Table
7/26/2021First Monday
7/25/2021Missing Months
7/24/2021Center Vertically
7/23/2021DCount
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: microsoft access developer forum  PermaLink