Yes I have tried to scan for new drives... to rebuild the the drive after replacing it... setting the device state to ONL from DDD...
I also updated the device driver and the firmware after looking at an article on IBM's support site...
Netfinity 5500 M10 Raid 5 (3 Disks) Windows NT
Recently the 3rd drive failed...
Ordered the replacement drive and installed it
ServeRaid (version 3.0.14) still sees it the old drive and will not rebuild the new disk
Any help here is greatly appreciated
Thanks
No Parameters need to be passed from the "Monthly Billing" query. I just use the "Monthly Billing" query to update records based on the Billing Date. I need to have the Daily Rate from the "Get Daily Rate" saved into a Variable then use it in the "Monthly...
I'm have never created a VBA module before this my first attempt so please bear with me
I'm currently using Access 2000
I'm using VBA to run 2 Queries
Query 1 prompts user to enter Billing Date in Table1
Begin Date
<=[Enter Billing Date]
End Date
>=[Enter Billing Date]
This outputs 1 record...
I have created a macro that runs two queries
Action:
OpenQuery Query1
OpenQuery Query2
Query1
[Table1]![Begin] <= [billing_date]
[Table1]![End] >= [billing_date]
Get [Table1]![Daily_Rate]
Query2 Update Query
[Table2]![billing_date] = [billing_date]
Calc...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.