Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Calendar Help
Mark Desens 
      
4 years ago
Hi Richard, I was watching your video on adding records automatically and I saw how you inputed the date on the form for several weeks automatically. Can you show how to do that with someone's name automatically with the message box. It looks simple enough but I tried several times but still don't understand how to word the vbs code to auto fill with someone's name.
Scott Axton  @Reply  
        
4 years ago
Mark -
You are kind of hopping all over the place a bit.  Posting in multiple forums with the same title. Like HERE.

You remind me a bit of the Hare in the old story of the Tortoise and the Hare.
I see that you now have some the courses finally but I don't see that you are grasping the teachings. I really encourage you become more Tortoise like.  Slow down a bit and go through the process of Knowing Access  Not just watching a bunch of videos to incorporate the next cool gadget.

I get that you have a director you're trying to please and that you have a family life -  that, you have mentioned before.  BUT - Do yourself a favor and, now that you have a good example of what you want to accomplish, re-watch the Expert 1 and 2 on relationships.  Those explain how to break up the data properly.  Re-watch the videos on Queries.  Those explain how to bring the data back together, in a meaningful way,  for us humans to read.

Scott Axton  @Reply  
        
4 years ago
Both the Calendar Seminar and the Add Records Automatically videos have the information you are needing for what you want to accomplish.  You just need the base knowledge and understanding to put it together.

We are here to help. I hope you understand we want to help you learn. We're not here to just provide you a solution to the most current problem.
Richard Rost  @Reply  
          
4 years ago
Yeah, plus I don't understand the question. :)

Can you elaborate? Maybe a screen shot?
Mark Desens OP  @Reply  
      
4 years ago
Hi Richard and guys I am trying to post a screenshot of the vba from my form but it's not loading the picture for some reason. Anyway I got as far as the msgbox asking for the name, watching videos about the docmd.gotorecord and gotocontrol  and watching different ways of how to do the code and rewatching some of the expert levels also.  
I just tried to upload a screenshot but still can't, using jpg at 253 KB. So I am going to type it in.
This is what I got so far just the inputbox. Thanks.


Code
Private Sub AddFuture_Click()

    Dim StartDate As Date
    Dim S As String
    Dim X As String
    
    X = InputBox("enter FirstName", "Enter Name")
    S = InputBox("Enter Begin Date", "Enter date", Date)
    
    If S = "" Then Exit Sub
    If X = "" Then Exit Sub
    
    StartDate = CDate(S)
    
    DoCmd.GoToControl "DateTime"
    DoCmd.GoToRecord acDataForm, Me.Name, acNewRec
    DateTime = StartDate + 7
Scott Axton  @Reply  
        
4 years ago
Mark -
I think you hit the length limit for posts.  Did all of your sub get posted?

You can't put an image directly into a current reply.
How are you trying to upload the image?  Are you using the up load images link in the original post?
Mark Desens OP  @Reply  
      
4 years ago
Hi Scott thanks for responding. I am not trying to hit any length or max out on posts or anything of that nature. The database i am making is for my nonprofit organization that i work for. It consists of only 4 forms and the calendar form that I saw on the site and a few people said lets see if we could use that. Turns out we can. Anyway to answer your question about uploading the picture, on the top first conversation on the right small letters it says upload images and link. I did use that one and still not working, don't know why. I did once before and it worked.
Scott Axton  @Reply  
        
4 years ago
I think you misunderstood.  The length of any one reply is about 1000 characters.
It appears that all of your code didn't make it and got cut off.

Are you receiving an error or file to large for up load?
Mark Desens OP  @Reply  
      
4 years ago
Hey Scott, I got no error code. I chose the file and did the upload but nothing happened. the code that you see is what I copied and pasted, that is as far as I got with it.
Adam Schwanz  @Reply  
           
4 years ago
Just throwing this out there Mark, if this is what you were e-mailing me about back in January for scheduling staff in the future automatically, this is not how you want to do it. This is still you entering one record at a time, you need a For Next Loops or a recordset to schedule out multiple records ahead.

As for your code, start off with a simpler version than add more. Do this, this works.
    Dim StartDate As Date
    StartDate = InputBox("Enter Start Date")
    DoCmd.GoToRecord acDataForm, Me.Name, acNewRec
    DateTime = StartDate + 7

Adam Schwanz  @Reply  
           
4 years ago
Also, you're not doing anything with X, the name in your code, it's just an unused variable after you set it with the inputbox

    Dim StartDate As Date
    Dim X As String
    X = InputBox("Enter Name")
    StartDate = InputBox("Enter Start Date")
    DoCmd.GoToRecord acDataForm, Me.Name, acNewRec
    FirstName = X
    DateTime = StartDate + 7

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
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
PCResale.NET
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
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/7/2026 1:14:35 AM. PLT: 0s