Microsoft Access Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsDatabaseMicrosoft Access Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old July 4th, 2009, 09:41 PM
logan3975 logan3975 is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Jun 2008
Posts: 61 logan3975 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 12 h 22 m 37 sec
Reputation Power: 2
Arrow Button to open new form based on id #

I have a main form where you enter in data. I want a button that when clicked will open the same table in form view to add a photo. I need this to open to the same ID # of the main form in the new form. I don't know if I am explaining this very well. I tried creating a macro...couldn't get it to work. I have another database where the button is linked to a report and the report has a query so it prompts you for last name and then first name. But I can't figure out how to do the same type of thing between two forms.

Can someone please help me? Thanks in advance.

Reply With Quote
  #2  
Old July 5th, 2009, 10:53 AM
RuralGuy's Avatar
RuralGuy RuralGuy is offline
Contributing User
ASP Free Novice (500 - 999 posts)
 
Join Date: Oct 2005
Location: @ 8300' in the Colorado Rocky Mountains
Posts: 944 RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level)RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level)RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level)RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level)RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level)RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level)RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level)RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 2 Days 16 h 1 m 19 sec
Reputation Power: 132
Send a message via MSN to RuralGuy Send a message via Yahoo to RuralGuy
Why do you feel you need an additional form to add the picture?

Reply With Quote
  #3  
Old July 5th, 2009, 11:07 AM
logan3975 logan3975 is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Jun 2008
Posts: 61 logan3975 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 12 h 22 m 37 sec
Reputation Power: 2
I don't know how else to set it up. If I could add a photo to the OLE field that is on the main form then I would rather do that. But I don't know what to do. That's why I created the button to open up that table in form view so I could add it that way.

Reply With Quote
  #4  
Old July 5th, 2009, 11:31 AM
RuralGuy's Avatar
RuralGuy RuralGuy is offline
Contributing User
ASP Free Novice (500 - 999 posts)
 
Join Date: Oct 2005
Location: @ 8300' in the Colorado Rocky Mountains
Posts: 944 RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level)RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level)RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level)RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level)RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level)RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level)RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level)RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 2 Days 16 h 1 m 19 sec
Reputation Power: 132
Send a message via MSN to RuralGuy Send a message via Yahoo to RuralGuy
Paul has one solution in his site that should work for opening another form. Your form should be based on queries and not tables directly or you will have locking problems. I've also been playing with a new ActiveX product that I like. It might be what you are looking for. I have no interest in the product other than thinking it works pretty good and is reasonable. Here is a link to the site if you want to look at it and play with it.
AccessImagine is an ActiveX control for storing images.

Reply With Quote
  #5  
Old July 5th, 2009, 11:58 AM
logan3975 logan3975 is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Jun 2008
Posts: 61 logan3975 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 12 h 22 m 37 sec
Reputation Power: 2
Quote:
Originally Posted by RuralGuy
Paul has one solution in his site that should work for opening another form. Your form should be based on queries and not tables directly or you will have locking problems. I've also been playing with a new ActiveX product that I like. It might be what you are looking for. I have no interest in the product other than thinking it works pretty good and is reasonable. Here is a link to the site if you want to look at it and play with it.
AccessImagine is an ActiveX control for storing images.


I just downloaded Access Imagine and it works great. Not sure how it works but it works. Thanks so much for your help. I am about to post two other issues in separate threads.

Reply With Quote
  #6  
Old July 5th, 2009, 01:55 PM
RuralGuy's Avatar
RuralGuy RuralGuy is offline
Contributing User
ASP Free Novice (500 - 999 posts)
 
Join Date: Oct 2005
Location: @ 8300' in the Colorado Rocky Mountains
Posts: 944 RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level)RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level)RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level)RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level)RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level)RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level)RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level)RuralGuy User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 2 Days 16 h 1 m 19 sec
Reputation Power: 132
Send a message via MSN to RuralGuy Send a message via Yahoo to RuralGuy
That's great! Thanks for posting back.

Reply With Quote
Reply

Viewing: ASP Free ForumsDatabaseMicrosoft Access Help > Button to open new form based on id #


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump





 Free IT White Papers!
 
How to Present Effectively Online
This white paper offers practical and actionable advice on the key steps that any presenter should consider as they plan and execute a Webinar or online meeting.

 
Open Source Security Myths
Open Source Software (OSS) is computer software whose source code is available to the general public with relaxed or non-existent intellectual property restrictions (or arrangement such as the public domain), and is usually developed with the input of many contributors.

 
Power and Cooling Capacity Management for Data Centers
This paper describes the principles for achieving power and cooling capacity management.

 
Scalable, Fault-Tolerant NAS for Oracle - The Next Generation
For several years NAS has been evolving as a storage alternative for Oracle databases, and for good reason: NAS is quite often the simplest, most cost-effective storage approach for Oracle. Learn about the benefits that HP's approach to scalable NAS brings to Oracle environments in this comprehensive white paper.

 
Understanding Web Application Security Challenges
This white paper discusses many common threats and preventive measures for Web application security, and explains what you can do to help protect your organization.

 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2009 by Developer Shed. All rights reserved. DS Cluster 6 Hosted by Hostway
Stay green...Green IT