Search results

Sorry, I want to filter the records in the form, not the combobox itself.

Hi all, I have a form with a checkbox and a combo box. When I click the checkbox, I would like it to only show the specified records that are in the combo box. The current code I have is this: Private Sub chkHideComplete_AfterUpdate() On Error Resume Next If Me.chkHideComplete = True...

I have an equipment reservation database that is used to create reservations for multiple pieces of equipment for various time periods. I have a metric for "Equipment days used this fiscal year" and feel that the way I am doing my calculations is insane. I basically have 5 queries that each...

Magster06 I am curious how you are auto populating those forms? I have a reservation system that requires me to create contracts where I am simply updating dates, addresses and contact name. I have been trying to figure out for the longest time how to autopopulate them an haven't been able...

Thanks Pr2, I was just coming back to mark SOLVED! Cheers,

Hello, I have a textbox that calculates the current fiscal year using the following equation: =IIf(Month(Date())<4,DateSerial(Year(Date()),3,31),DateSerial(Year(Date()+1),3,31)) My problem is that the fase part of the equation calculates Mar 31 2013, and I need it to be Mar 31 2014. How do I...

Are you in design mode on the navigation form?

Hi All, I have a dashboard that opens with my main form and it contains many textboxes with Dcounts, Dlookups and Dsums in it. I am hoping that I can put these textboxes on a separate form that is hidden unless a command button is clicked to make it visible. I know how to do this, but my...

I put in a NZ and it seemed to work. Not sure how I never thought of that! Thanks for the advice!

Hi, I am getting an intermittent #error on an unbound textbox on my main form. The control source of this textbox is this: =1000*Round(DSum("[IndustryLeaseRate]","UniqryFiscalUsageToDateDashboardnew")/1000,0) Is there something wrong with this equation? Its just simply summing a column...

Just had an "Aha!" moment. Created a field called LeaseCost on the many side of my table relationship. This will store the lease cost for each item on a reservation for historical purposes. Also used VBA to make the lease cost field = cbo.column(4). Thanks for the help Beetle!

I used to have it bound to an expression column in my underlying query. The problem is that if I never had any dates chosen, I would get a "Field not updateable" error.

Just to clarify, here is a pic.

Sorry to hijack this thread, but I have a similar problem. My form is for reservations and it is a form/subform set up where you create top level info such as company name, reservation number, etc... and a sub form where you add items line by line, much like adding items to an invoice. In...

I think I see what you mean. Just have the reservation details table as my record source, and then place my lease cost and discount cost equations directly in the textboxes. Looking back, I think I thought I was saving time re-using the same query that I have used for other things and really...

Just to clarify, lease cost and discount cost are not being stored anywhere, they are just being calculated on the fly. The problem is that date out and date in are used in the calculation and are null right after I choose a piece of equipment for the reservation.

No prob SELECT tblReservation_details.*, tblBOM_Master.PurchasePrice, IIf([tblCompanies].[Portfolio]=0,(IIf((([PurchasePrice]*[DiscountMultiplier])/780)<10,(10*[WorkingDays]),(([PurchasePrice]*[DiscountMultiplier])/780)*[workingdays])),0) AS ZZZLeaseCost, tblCompanies.Category...

I have a subform based on a query. That query contains a couple of calculations that end up in textboxes on the subform. The problem is that the calculations require me to enter 2 dates that are on the subform. If these are not entered before the calculation is performed I get a "Cannot...

That did it, thanks alot guys!

They are both Numeric. Which quotes can I eliminate?