Search results

Hello, I have the following Sum IIf test: Sum(IIf(Nz([StandardTime]=0),[SumOfTime]/60*100)+([StandardTime]*[SumOfOrders]/60*100)) the first part calculates .... and is fine Sum(IIf(Nz([StandardTime]=0),[SumOfTime]/60*100) the second part does nothing ...

Is it possible to get a list of all weekending dates between 2 dates in a query? for example, 1/1/2012 and 12/31/2012 if so, how ? I've been able to get the weekending date based on 1 date but between 2 dates thank you in advance

Hello, I've battling with this query for awhile now and I think I got it to work but need confirmation that is doing what I want it to do :) Query is SELECT Sum(IIf([SumOfPlannedHours]=0,"%",([SumOfPlannedHours]/34.15*1)-([SumofPlannedHours] And [PPnRPriorityAreaName]="Admin - Working")))...

Okay .... I finally got this work to with the help of boblarson .... but its acting up and I have no idea ... I am using the following ... Private Sub Form_BeforeUpdate(Cancel As Integer) If (Me.PlannedHours) <= 0 Or IsNull(Me.SubActivityDetails) Then MsgBox ("You must enter your...

Hello, I am trying to use the following vba to generate a msgbox popup but its not working and no errors appear either ... Private Sub SumOfPlannedHours_BeforeUpdate(Cancel As Integer) If Me!SumOfPlannedHours > "34.15" Then MsgBox "You have exceeded 34.15 hrs work duration limit"...

Hello, I am trying to filter a sub form based on a unbound field value on the main form but have had no success. I have tried numerous things such as vb code, and query filters but no luck .... what would be the best approach? Thank you in advance,

Hello, Just wondering .... is it possible to update/data entry on multiple tables using a data access page? If so, how? I've been playing around and searching for examples but can't seem to get anywhere? Any assistance is appreciated :D Thank you in advance, Arv

Hello, I have a DAP that is used by many to enter data. When the user enters data one of their steps is to select their managers name. I would the DAP to send a email to the user (entering the data) and their manager once the new record they (The user) has entered in to the database. Is...

Hello, I am current designing a form the has textbox called "comments_timestamp" which is has a default value of "=Now()" I have another textbox on the same form that is called "Weekending Date" I would like to populate the "Weekending Date" textbox with the weekending date based on the...

Hello, I am trying to create a report that will display images, the issue i'm having is with empty whites spaces.... when I run the report ..... it will display images were it needs to but when there isn't a image to be displayed ... I get a blank white space .... I have no idea how to...

Hello, How can I autofill a text field a 2nd form with the same value that was entered on the 1st form? Thank you in advance Arvin

Hello, I have 2 forms Main Form - Carrierfrm Sub Form - CarrerServiceDetailsfrm On my sub form I have 2 cbo's 1st - CarrierTypeID Row Source = SELECTCarrierTypetbl.CarrierTypeID, CarrierTypetbl.CarrierType FROM CarrierTypetbl ORDER BY CarrierTypetbl.CarrierType; AfterUpdate = Private...

Hello, I have searched many forums and have come to a stand still ... yet I know that this can very easy too do .... I have a Form which has a unbound combo box, the drop down displays the list of customers. I also have a OnChange command, so that when a customer is selected a query is...

Hello, I am having some difficulty with creating a foreign key in one of my tables. The two tables i want to relate are ServiceMatrixtbl and ServiceMatrixDetailstbl. I would like the foreign key to be in my ServiceMatrixDetailstbl. I am ...somewhat comfortable with Access .... but I'm...

Hello, I have been tasked with creating an "Customer Service Matrix" which will display information such as; Customer Name, Customer Number, Account mgr, and a list of various services they are eligible for. The basic concept I have is .... there will a drop down from which one can...

I have 3 depts that I would like add,roll,join ...whatever, into one for example ...in my table i have ADSL WHOLESALE DSL Dialup When I run my query I would like them to appear under "Internet" any help is appreciated ...thank you in advance

Hello, I have a date range form that has Start Date, End Date and Preview Report command button. In the OnClick Event Prod I have Dim strDateField As String in my code that should connect to a MySQL Db, to a table that stores the UPDATED Date. The problem is I can't seem to get the form to...

Hello, I'm trying to create crosstab query and I'm running into some issues. I'm basing the crosstab query on another query...which has no problems... Here is my 1st Query which works (SQL View) SELECT tblDepartments.Department, tickets.C29, Format([C30],"Short Time") AS nTime...

Hello, I have a date range form that has Start Date, End Date and Preview Report command button. In the OnClick Event Prod I have Dim strDateField As String in my code that should connect to a MySQL Db, to a table that stores the UPDATED Date. The problem is I can't seem to get the form to...

Hello, Here is a screenshot of my query http://www.mts.net/~and0215/QueryScreenshot2.jpg it still displays the items that are suppose to be exclude ...why ? any help is appreciated thank you in advance.