|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| ||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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. |
|
#2
|
||||
|
||||
|
Why do you feel you need an additional form to add the picture?
|
|
#3
|
|||
|
|||
|
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.
|
|
#4
|
||||
|
||||
|
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. |
|
#5
|
|||
|
|||
|
Quote:
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. |
|
#6
|
||||
|
||||
|
That's great! Thanks for posting back.
|
![]() |
| Viewing: ASP Free Forums > Database > Microsoft Access Help > Button to open new form based on id # |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|