Overclock.net › Forums › Software, Programming and Coding › Other Software › Linking forms in Access
New Posts  All Forums:Forum Nav:

Linking forms in Access

post #1 of 8
Thread Starter 
Is it possible to link two forms in Microsoft Access?

I have a form for rentals and a form for DVD's which both contain a price field. I want the Rentals form to be able to pick up the price of the DVD from the DVD form.

Thanks
manutdfan
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
AMD Phenom2 x4 955 MSI 790FX-GD70 XFX 5750 512Mb 8 Gb Generic 
Hard DriveOSMonitorKeyboard
2x Crucial 64Gb SSDs in RAID 0 Windows 7 21in LG Logitech G19 
PowerCaseMouse
PCP&C 510w SLI Themaltake Shark RAT 7 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
AMD Phenom2 x4 955 MSI 790FX-GD70 XFX 5750 512Mb 8 Gb Generic 
Hard DriveOSMonitorKeyboard
2x Crucial 64Gb SSDs in RAID 0 Windows 7 21in LG Logitech G19 
PowerCaseMouse
PCP&C 510w SLI Themaltake Shark RAT 7 
  hide details  
Reply
post #2 of 8
Thread Starter 
bump, anyone got any ideas?
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
AMD Phenom2 x4 955 MSI 790FX-GD70 XFX 5750 512Mb 8 Gb Generic 
Hard DriveOSMonitorKeyboard
2x Crucial 64Gb SSDs in RAID 0 Windows 7 21in LG Logitech G19 
PowerCaseMouse
PCP&C 510w SLI Themaltake Shark RAT 7 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
AMD Phenom2 x4 955 MSI 790FX-GD70 XFX 5750 512Mb 8 Gb Generic 
Hard DriveOSMonitorKeyboard
2x Crucial 64Gb SSDs in RAID 0 Windows 7 21in LG Logitech G19 
PowerCaseMouse
PCP&C 510w SLI Themaltake Shark RAT 7 
  hide details  
Reply
post #3 of 8
Quote:
Originally Posted by manutdfan
Is it possible to link two forms in Microsoft Access?

I have a form for rentals and a form for DVD's which both contain a price field. I want the Rentals form to be able to pick up the price of the DVD from the DVD form.

Thanks
manutdfan
as long as they're part of the same database you can just bring up the value from that...
My System
(13 items)
 
  
CPUGraphicsRAMOS
Intel Core 2 Duo E6550 nVidia GeForce GTX 650 G.Skill DDR2 PC2-6400 PK Series 4-4-4-12 Windows 7 Enterprise 
MonitorKeyboardPowerCase
Acer S201HL Logitech Deluxe 250 305W Lenovo 
MouseMouse PadAudio
MS Trackball Optical N/A OnBoard 
  hide details  
Reply
My System
(13 items)
 
  
CPUGraphicsRAMOS
Intel Core 2 Duo E6550 nVidia GeForce GTX 650 G.Skill DDR2 PC2-6400 PK Series 4-4-4-12 Windows 7 Enterprise 
MonitorKeyboardPowerCase
Acer S201HL Logitech Deluxe 250 305W Lenovo 
MouseMouse PadAudio
MS Trackball Optical N/A OnBoard 
  hide details  
Reply
post #4 of 8
Thread Starter 
I though so i've tried using the following code to do so but I just get a zero value.

Private Sub Text37_click()
Dim Price2 As Integer
Dim rentaltime As Integer
rentaltime = Date_of_Return - Rental_Date

Price2 = Form_DVD.Price

Text37.Value = Price2 * rentaltime
End Sub

and also tried

Private Sub Text37_click()
Dim Price2 As Integer
Dim rentaltime As Integer
rentaltime = Date_of_Return - Rental_Date

Price2 = Form_DVD.Price.Value

Text37.Value = Price2 * rentaltime
End Sub
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
AMD Phenom2 x4 955 MSI 790FX-GD70 XFX 5750 512Mb 8 Gb Generic 
Hard DriveOSMonitorKeyboard
2x Crucial 64Gb SSDs in RAID 0 Windows 7 21in LG Logitech G19 
PowerCaseMouse
PCP&C 510w SLI Themaltake Shark RAT 7 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
AMD Phenom2 x4 955 MSI 790FX-GD70 XFX 5750 512Mb 8 Gb Generic 
Hard DriveOSMonitorKeyboard
2x Crucial 64Gb SSDs in RAID 0 Windows 7 21in LG Logitech G19 
PowerCaseMouse
PCP&C 510w SLI Themaltake Shark RAT 7 
  hide details  
Reply
post #5 of 8
Thread Starter 
Now i've managed to get it picking up a value but it wont change value when the DVD changes.
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
AMD Phenom2 x4 955 MSI 790FX-GD70 XFX 5750 512Mb 8 Gb Generic 
Hard DriveOSMonitorKeyboard
2x Crucial 64Gb SSDs in RAID 0 Windows 7 21in LG Logitech G19 
PowerCaseMouse
PCP&C 510w SLI Themaltake Shark RAT 7 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
AMD Phenom2 x4 955 MSI 790FX-GD70 XFX 5750 512Mb 8 Gb Generic 
Hard DriveOSMonitorKeyboard
2x Crucial 64Gb SSDs in RAID 0 Windows 7 21in LG Logitech G19 
PowerCaseMouse
PCP&C 510w SLI Themaltake Shark RAT 7 
  hide details  
Reply
post #6 of 8
Quote:
Originally Posted by manutdfan
Now i've managed to get it picking up a value but it wont change value when the DVD changes.
Do you have it set to store the value it's grabbing to another location? That's the only thing I can think of that would make it stop being dynamic.
My System
(13 items)
 
  
CPUGraphicsRAMOS
Intel Core 2 Duo E6550 nVidia GeForce GTX 650 G.Skill DDR2 PC2-6400 PK Series 4-4-4-12 Windows 7 Enterprise 
MonitorKeyboardPowerCase
Acer S201HL Logitech Deluxe 250 305W Lenovo 
MouseMouse PadAudio
MS Trackball Optical N/A OnBoard 
  hide details  
Reply
My System
(13 items)
 
  
CPUGraphicsRAMOS
Intel Core 2 Duo E6550 nVidia GeForce GTX 650 G.Skill DDR2 PC2-6400 PK Series 4-4-4-12 Windows 7 Enterprise 
MonitorKeyboardPowerCase
Acer S201HL Logitech Deluxe 250 305W Lenovo 
MouseMouse PadAudio
MS Trackball Optical N/A OnBoard 
  hide details  
Reply
post #7 of 8
Thread Starter 
Quote:
Originally Posted by Ty Auchter
Do you have it set to store the value it's grabbing to another location? That's the only thing I can think of that would make it stop being dynamic.
No it isn't, how would I go about doing this?

thanks again
manutdfan
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
AMD Phenom2 x4 955 MSI 790FX-GD70 XFX 5750 512Mb 8 Gb Generic 
Hard DriveOSMonitorKeyboard
2x Crucial 64Gb SSDs in RAID 0 Windows 7 21in LG Logitech G19 
PowerCaseMouse
PCP&C 510w SLI Themaltake Shark RAT 7 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
AMD Phenom2 x4 955 MSI 790FX-GD70 XFX 5750 512Mb 8 Gb Generic 
Hard DriveOSMonitorKeyboard
2x Crucial 64Gb SSDs in RAID 0 Windows 7 21in LG Logitech G19 
PowerCaseMouse
PCP&C 510w SLI Themaltake Shark RAT 7 
  hide details  
Reply
post #8 of 8
To be honest I haven't used Access since 2002... I remember the ideas behind the programming but not the specifics. I'll continue to help you the best I can.

Okay... So I think I might have been confused by your previous post. When you said it won't change value when the DVD changes, did you mean when the price of the DVD changes in value or when it goes to the next DVD that's entered?

If you meant the latter then you'll need another variable and an "If Then Else" statement. Call your variable RunningTotal or whatever makes sense to you. You want it to copy the first value and hold it. If another DVD is entered then it adds Form_DVD.Price(.Value) to itself; else it goes on to checkout or whatever you have next.
My System
(13 items)
 
  
CPUGraphicsRAMOS
Intel Core 2 Duo E6550 nVidia GeForce GTX 650 G.Skill DDR2 PC2-6400 PK Series 4-4-4-12 Windows 7 Enterprise 
MonitorKeyboardPowerCase
Acer S201HL Logitech Deluxe 250 305W Lenovo 
MouseMouse PadAudio
MS Trackball Optical N/A OnBoard 
  hide details  
Reply
My System
(13 items)
 
  
CPUGraphicsRAMOS
Intel Core 2 Duo E6550 nVidia GeForce GTX 650 G.Skill DDR2 PC2-6400 PK Series 4-4-4-12 Windows 7 Enterprise 
MonitorKeyboardPowerCase
Acer S201HL Logitech Deluxe 250 305W Lenovo 
MouseMouse PadAudio
MS Trackball Optical N/A OnBoard 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Other Software
Overclock.net › Forums › Software, Programming and Coding › Other Software › Linking forms in Access