Code:
SELECT GetFiscalYear([InvoiceDate]) AS [Fiscal Year], fFiscalPeriod([InvoiceDate]) AS Period, BudgetCodeID, Sum(InvoiceDetails.Amount) AS SumOfAmount, (SELECT Sum(InvoiceDetails.amount)
xraive
Last Activity: Sep 26 '10, 04:15 AM
Joined: Jun 1 '09
Location:
-
Subquery to Calculate Year To Date Amount?
Hi I am trying to calculate the YTD amount and I keep getting the following error "You tried to execute a query that does note include the specified expression 'Fiscal Year' as part of an aggregate function". Can you offer any assistance?
... -
Subquery to calculate the YTD amount
Hi I am trying to calculate the YTD amount and I keep getting the following error "You tried to execute a query that does note include the specified expression 'Fiscal Year' as part of an aggregate function". Can you offer any assistance?
...Code:SELECT GetFiscalYear([InvoiceDate]) AS [Fiscal Year], fFiscalPeriod([InvoiceDate]) AS Period, DatePart("q",[invoicedate]) AS Quarter, DatePart("m",[invoicedate]) AS [Month], -
Issues with Database Design
I am currently designing a database to manage budgets at the office. The objective is to be able to track Invoices, Travel Expenses, Purchase Orders, and Contracts. All these are assigned Budget Codes and Expense Codes. This way the office can view reports on how specific budget were spent. I currently have the following tables.
Budget Codes
Expense Codes
Travel Expenses
Invoices
Purchase Orders
... -
Thank you so much ADezii for your prompt response. -
Calculating the Week Number in a given month
I would like to know if there is a function available to determine the week number in any given month.
For example March 20th, 2010 would be Week #3 -
Thank you it works like a charm. Can you explain that line.
Always appreciated ADeziiLeave a comment:
-
Thanks for looking into this. I have posted a sample DB that will show the problem. But this did also happed with the sample db on post# 246.
By the way, I am from Canada.
Thank you,...Leave a comment:
-
Calendar Question
Hi guys,
First of all I would like to say thank you for sharing this great calendar form. but i would like to point out that there seems to be an error when the calendar is populated with the dates. I have it up and running and the dates are set off. For example March 17, 2010 is set to tuesday instead of wednesday. April 1st, 2010 starts on monday instead of thursday. Is this a flaw or am I doing...Leave a comment:
-
xraive replied to Can you search a listbox by a textbox value when the multiselect property isn't none?in AccessSorry Adezii,
I currently have a listbox and would like to be able to search the records. I have a textbox setup so that when the user enters a key an item matching it in the listbox would be selected. This would be similar to the autoexpand feature on the combo box. I would like to be able to have a user type in a string and the first Item matching that string be selected from the listbox. I hope I made myself a little clear. ...Leave a comment:
-
xraive started a topic Can you search a listbox by a textbox value when the multiselect property isn't none?in AccessCan you search a listbox by a textbox value when the multiselect property isn't none?
Currently I am able to use a texbox to search through the listbox only when the multiselect property is set to none. But when I change the property to simple or extended my function doesn't work. Please see below
Function
...Code:Public Function CheckListbox(strPass As String, lstPersons As ListBox) Dim intCurrIndex As Integer Dim intStringLen As Integer intStringLen = Len(strPass) -
xraive replied to I would like to be able to retrieve the file name when using the File Dialog Propertyin AccessThank you !!!
Hi Adezii
What can I say but just Damn you're good!
I had tried thisand I was getting an error looking at your code I see what I did wrong.Code:strBuild = strBuild & lst.Column(1, i) & ";" & lst.Column(2, i)
I wish there was a way I can thank you, you have saved me some time.
Time and time again you always come through.
Thank...Leave a comment:
-
xraive replied to I would like to be able to retrieve the file name when using the File Dialog Propertyin Accesslistbox multiple column
Hi Adezii,
My current list box has multiple columns. How would i be able to make this work.
Thank you,Leave a comment:
-
xraive replied to I would like to be able to retrieve the file name when using the File Dialog Propertyin AccessDeleting selected items from a listbox
Thank you so much Adezii. I had used the split function and passed into an array but your way is much simpler.
I don't know if i have to open another question. Talking about the same File Dialog property, once a user selects multiple files I have added the file names to a list box (value list). I would like to set something up where the user can select multiple items to be deleted...Leave a comment:
-
xraive started a topic I would like to be able to retrieve the file name when using the File Dialog Propertyin AccessI would like to be able to retrieve the file name when using the File Dialog Property
Currently I only get the file path. Is there way to retrieve the file name or do I have to just use the split function.
...Code:Dim fDialog As Office.FileDialog Dim varFile As Variant 'Clear listbox contents. 'Me.FileList.RowSource = "" 'Set up the File Dialog. Set fDialog = Application.FileDialog(msoFileDialogFilePicker) With fDialog
-
Itinerary Design
HI guys,
Iam am having issues setting up an itinerary database application. My current setup is includes the follwoing tables.
Itinerary ItineraryID(PK)
TravellerID
StarDate
EndDate
Trips
TripID(PK)
ItineraryID(FK)
From
To
ReservationStat us
Flights
FlightID(PK)
TripID(FK)
AirlineID... -
Thank you Neopa I will follow your instructions.
In regards to the problem I was having I decided to create hidden text fields that store date criteria on the form. I changed the query to refrence those two date fields on the form when running the report. This way I removed the need to store the date values in my code.
Thank you,
Rezene A.Leave a comment:
-
I apologize for the messy code guys and for not using the code tags. I will in the future.
Thank you,Leave a comment:
-
open report with parameter
I am trying to pass the parameters when I open a report but the report opens with all records instead of being filtered.
...Code:Dim strReport As String Dim strDateField As String Dim startDate As String Dim endDate As String Dim strWhere As String Dim lngView As Long Const strcJetDate = "\#mm\/dd\/yyyy\#" strDateField=[SubmitDate] Select -
Duplicate Form, Subform Records
I have a problem with this. Currently I am trying Allen's code and i am not successful.
Current Design
Table1 (Main Form)
TravelID (PK)
ApprovedBY
EntreredBy
BudgetCode
ExpenseCode
Table2 (Subform)
TripID (PK)
TripTypeID
TravellerID
TripStartDate
TripEndDate
TripStatus
Can you help with this?
... -
The current setup of tables :
TravelAutohriza tion > Trips > TripEventTypes > TripEventTypeDe tails
Each Travel Authorization has one or more Trips (
Each Trip has one or more Events (i.e. Flight, Accomodation, Taxi, Car Rental)
Each Event has one or more Event Details (i.e, Departure Date, Arrival Date, Confirmation#, Room)
Does this make senseLeave a comment:
No activity results to display
Leave a comment: