Search results

I have attached a photo of the dashboard that is using all of the Dsums. Back when I developed this, I had taken advice from this forum on how to do it, which is why this was made the way it is. BTW, most of the textboxes use either DCOUNT or DSUM and all are unbound.

If it was up to me, I would suggest the company purchases a pre-made system. As it stands right now, I am in the requirement gathering stage, to find out if the design is feasable for us. As a sidenote, I am not a database designer, so that will factor in to my decision to take on this project...

Thanks Marla, that is really the reply I was looking for. When I was thinking about the forms I need to make, I suddenly had a bad feeling that I should be using all fields for all programs. Now that I know its ok to have unused fields for specific programs, I won't worry about it!

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];