Search results

I have about 40 or so textboxes that are all performing a Dsum when my form opens. The code resides in the unbound textbox and looks like this: = Nz(DSum("WorkingDays", "UniQryFiscalUsageToDateDashboardNew", "CategoryID = 1")) + Nz(DSum("UsageDays", "qryFiscalEquipmentDaysRapidProto"...

Hello, I am in the planning stages of creating a sort of project/programs management database and would like to verify my table structure. Our company is a sort of investment firm that invests in companies projects, gives grants for trade show attendance, gives grants for commercialization...

So would I! Field is a yes/no, those are control names.

Hi All, I am trying to sum the values in a textbox on a subform using a textbox in that subforms footer. Currently I have the textbox's control source to be this: =Sum(IIf([chkInvoiceSent]=True,[txtPaymentAmount],0)). This isn't filtering the appropriate records and is instead summing...

I have some code that opens and populates an Excel spreadsheets then does a save as to a specific directory and also outputs a PDF. This code is working with one small problem, I am leaving the first instance of Excel open and can't figure out where I should put the code for it to quit. Here...

Run-time error is due to the directory not being created. Thanks for the feedback!

i think i figured it out by adding "\" to the end of this: spath = "S:\Contracts\Geomatics LAB\Signed\" & Company Now I am getting run-time error 1004!!

Yes I do. Its not that I'm getting an error, its that the file is being saved like this: S:\Contracts\Geomatics LAB\Signed\University of Alberta RES-004 University of Alberta-Payment Schedule.xlsx After the first University of Alberta, there should be a \

HI All, I am trying to write some code to open an existing excel form, populate it, and save it with a custom filename in a directory that is built using variables I have declared. The only part I am having difficulty with is setting the pathname. Here is my code: 'Build path to save...

Hi there, I am trying to track down the cause of a #ERROR in one of my textboxes that has the control source set to: =(DCount("[UniqryFiscalUsageToDateDashboardNew].[BOMDescription]","2ndQryPercentageBOMUsageFiscal_new"))/(DCount("BOMID","2ndQryPercentageBOMUsageFiscal_New")) The textbox...

Hi All, I have some code that sets the column widths on a sub form datasheet. When I close the parent form, i am asked if i want to save changes to the subform, even though I never actually made any (apart from setting the column widths). is there any way to get rid of this, and maybe save...

Hi All, I have some code that resides in a button on a report that allows me to save a PDF version of this report. My problem is that if i have the destination directory open on windows explorer, i get a runtime 2501 "The output To action was cancelled" error. Is there any way to check if the...

Figured it out: Private Sub chkHideComplete_AfterUpdate() On Error Resume Next If Me.chkHideComplete = True Then 'Show every reservation with a status other than "complete" Me.filter = "[ReservationStatus] = 1 Or [ReservationStatus] = 2 OR " & _ "[ReservationStatus]...

Here is another way to put it. If I use this code: Private Sub chkHideComplete_AfterUpdate() On Error Resume Next If Me.chkHideComplete = True Then Me.filter = "[ReservationStatus] = 3" Me.FilterOn = True Else ' Me.filter = "[ReservationStatus] = 1"...

The reservation status's are as follows: In Out Complete RMA Do Not Count Information Request You are right, it should be 1 OR 2 OR 3 etc...

I must have got distracted when i made the first post. I forgot to mention the code works, but it ONLY shows reservations where the status is 1. What i need is multiple criteria that says : Me.filter = "[ReservationStatus] = 1" AND "[Reservationstatus] = 2" AND etc...

It didn't work. Combo row source is: SELECT [tblLookup_Reservation_Status].[ReservationStatusID], [tblLookup_Reservation_Status].[ReservationStatus] FROM tblLookup_Reservation_Status ORDER BY [ReservationStatusID];

I have a reservation form and I want to tick a checkbox that will filter the form based on what is in the "Reservation Status" combo box. When the checkbox is ticked, the code would remove all records that have "Complete" as a status in the "Reservation Status" combo box. The non-working code...

Hi CJ, Thanks for the feedback. My next question is how do I physically set up the form or report? Do I just place a bunch of unbound textboxes and have the data source set to the equations? Im not sure why this is stumping me so badly!

Hi All, I have a reservation form where I create equipment reservations for clients. It is set up as a form with a subform. The form is where information like company name and contact person is input. The subform is where I add items to be leased, and dates the equipment is out and returned...