I have a combobox with month names (january, february...december). This combobox sets the selection criteria for query.
1.How can I set the default value of combobox to actual month?
Thanks
edolelkes:)
Hello,
I am importing a table into my access database from an oracle DB. The date field comes in as text (20060604 - for June 04, 2006). I am trying to build a delete query, macro, expression or anything else that searches all the records in that particular field and delete those particular records that have the actual month date. (ex:all the records that have 06 (for June) in the middle). Any help will be much appreciated.
Thank you
Hi,
I currently have a form that creates a report based on a query that takes in a start date and an end date.
What I would like to do is to create comboboxes that will let the user choose a month and year for the report.
Is there a simple way to choose an entire month in access? I've tried using the Month() function to no avail.
The SQL statement for where I select the start and end date is below:
WHERE ((([tblData].[EntryDate])
Between [Forms]![frmByRange]![BeginningDate] And [Forms]![frmByRange]![EndingDate])
Any help would be much appreciated!
Hi,
Anyone know how to create a combo box that has unique month and year entries from a table (month in one column and year in another - i.e. 2 columns)?
I've been able to get the textbox of the combobox to output the correct format using a custom format but it does not affect the combobox data. Also, I'm not sure how to separate this by two columns...
Any help would be much appreciated!
I am trying to create a database that will keep track of the orders placed for a given part number by month. Currently, my table houses the part number, and the ordered amount for the past three years by month (there are thirty-five columns for every part). My column headings are ORDER_MAY_2013, etc. I would like to set a query up that will look at the column headings and pull the amounts ordered for each part for the past twelve months. In other words, I have three years of data in my table. In my query, I just want one year. However, I don't want to have to rewrite the query every month so that it will pick up the new data. Is there a way to accomplish this?
Is there a better way to build this database? I thought about just have four columns in my table - PART_NUMBER, ORDER_MONTH, ORDER_YEAR, ORDER_AMOUNT. The only problem there, is that every part (there are about 450 parts) would have to be listed 35+ times. That seemed too redundant to me, so I built the table this way. However, now I am having trouble querying against it.
I have a MS access table with 12 numerical columns for 12 Months payments for our customer base.
I need to calculate variance of payments month on month and identify set of customers who have made huge payments.
Not even sure where to start so if this isn't a query question, please point me in the right direction.
I work in a plant that has a number of cranes. Each crane should be inspected each shift (three shifts per day), each day (less Sunday).
I have exactly what I need to capture the inspections being done. Inspections are identified by crane #, shift, and date.
How do I determine if an inspection hasn't been done? How do I compare the inspections that have been entered against the standard of inspections for each crane, each shift, each day?
I am below average with Access on my best day so please type slowly and be specific. Thanks for any help you can give.
Forrest
Hi,
This is my first post here and I seem to like the activity on this forums. Now to my issue.
I have a table with schedules: Event and it's schedule in actual date:
Ex.
Event1 1/1/2007
Event2 5/1/2007
Event3 7/1/2007 (MM/DD/YYYY)
and I have another table which has the event name, time steps and numbers:
Ex.
Event1 1 1000
Event1 2 1500
Event1 3 1500
Event1 4 2000
Event1 5 1500
Event2 1 1000
Event2 2 1500
Event2 3 1500
Event2 4 2000
Event2 5 1500
Event3 1 1000
Event3 2 1500
Event3 3 1500
Event3 4 2000
Event3 5 1500 (I kept the numbers same for all, time steps are monthly)
Now, I can't think of away to write a query to link the dates and the time steps, eventually reaching to some output as this:
Event1 1/1/2007 1000
Event1 2/1/2007 1500
Event1 3/1/2007 1500
Event1 4/1/2007 2000
Event1 5/1/2007 1500
Event2 5/1/2007 1000
Event2 6/1/2007 1500
Event2 7/1/2007 1500
Event2 8/1/2007 2000
Event2 9/1/2007 1500
Event3 7/1/2007 1000
Event3 8/1/2007 1500
Event3 9/1/2007 1500
Event3 10/1/2007 2000
Event3 11/1/2007 1500
Thanks, let me know if there is anything not clear. Pointing me to the right direction to do this helps a lot since I am kinda lost.
I am creating a PDF version of a Report so that I can send it as an attachment. I use the following code to do this:
Private Sub EmailWorkOrderQuote_Click()
On Error GoTo Err_EmailWorkOrderQuote_Click
Dim stDocName As String
Dim mFilename As String
Dim mEmailAddress As Variant
Dim mCompanyName As String
[Code] .....
I first create the report with a specifically generated name and save it to a folder.
I then do a SendObject to send the actual email. Unfortunately, it generates its own name for the file that it attaches and I don't think it is possible to specify an attachment.
Anyway, how to include the name of the PDF report in the actual report preferably in the footer.
In a table I have a field that gets its value from a lookup with multiple columns. Is it possible to query information in the columns rather than the actual value.
Here is an example of a single field value in the table I want to query (this would be in a drop down box in the table):
ID | Name
1 Nick
2 Nick
The actual values are the 1 and 2, but I would like to query the name 'Nick'. How would I do this?
I am using a datasheet to show company info -
I have a field countyID which is a code field and a lookup table County
I want to show the text for county on the datasheet, should I base the datasheet on just the company table and use a combo to get the county text - or should I have query that brings in the county text.
Could the experts tell me the "correct" way of doing this?
What are the performance issues of the two methods. Is which method I choose dependent on how many records are in the lookup table?
Thanks Paul
Hi,
I have a crosstab query that groups by week to obtain columns for monday to sunday. Is there a way to obtain the actual dates that these columns represent?
Any help would be much appreciated.
I am currently using the =Weekday([Date]) formula to show which day of the week is it, but is it possible to show the actual day not a number?
Eg instead of "1" it shows "Sunday"
Cheers
I have entered one entry in to the database with the correct values (this is record 6) and everytime I enter a new record, the data is the same (I'm using a drop down list) it will automatically appear in the box. But when I goto the table that the data is stored in, each field just has the reference to the first record that the data came from.
Looks a bit like this:
ID Server Name Pattern Engine Program
6 LN1HOME 4.735.00 8.500-1002 5.58.0.1185
7 LN1WORK2 6 6 6
Is there a way of seeing the origonal data in those fields other than the Record ID Number as a reference. :confused:
I know its a lame question, Im just is a learning process at the moment.
thanks in advance.
I need to figure out the amount of days between two dates that do not exist in my database...I use this calculation to do waivers...I was able to build a table and put in the two dates and then build a query which calculates the days between the two but I wanted to know if I could build a query that prompts on a [start date] which I would enter and then prompts on an end date [end date] which I would enter to get the number of days between...is that possible?
I had...
WaiverDays: [Enter start date]-[Enter end date] but it did not let me run...I added () and it still did not run...
Hi.
I am setting up a database to run a shop. In my 'Orders' form, i have a subform of the order details (The item (combo box), price, quantity and subtotal (price*quantity).
In the form in which the subform is displayed, how can I display the total of the subtotals? Is it easy, could anyone show me roughly what i need to write?
Many, many thanks,
- Smiffezo.
I want to send an e-mail with a report as attachment.On the internet i have found two options, and both are not the best solutions.
1. option
Code:
DoCmd.SendObject acSendReport, sReport, acFormatPDF, sMailAdres
With this construction I don't have enough control over the mail, and worse, I get an Outlook message when the mail is sending which I have to answer.
2. option
Code:
Dim oMail As MailItem
Dim oAtt As Attachment
Set oApp = CreateObject("Outlook.application")
Set oMail = oApp.CreateItem(olMailItem)
DoCmd.OpenReport ReportName:=sReport, View:=acViewPreview, WindowMode:=acHidden
Set rpt = Reports(sReport)
[code]...
with this construction I have to enter an existing report.pdf on my filesystem (bold line), but I want to pass the rpt object straight to the mail as an attachment.
I am working with Access 2007. I have a little problem building the iif statement within a query criteria in [Actual Date] which is the following:
iif([Actual Date] Is Not Null And [Document]=0;>#01.01.2012# Or Is Null;999)
When I enter this I get no records out of about 8000. The table fields behind the query are in the right format (date/time and number).
How can I make that my access send an email to a user if there 7 days until en employee's birthday.
View 5 Replies View RelatedI have a query (Inventory Transactions Extended) in which i am trying to caculate current stock.
I have a form (Inventory Transactions Form) where i either add or remove Inventory Items.
I have used this statement to create a new field (Actual Quantity) to calculate current stock based on stock been added and removed:
Code:
Actual Quantity: IIf([Transaction Types].[Add/Remove]="Addition";[Inventory Transactions]![Quantity];-([Inventory Transactions]![Quantity]))
for some reason it does not work. It is not calculating current stock. If i remove stock it shows a negative amount based on the amount i removed, and when i add stock it shows a positive amount based on what i added
I have attached a sample.
[ATTACH][/ATTACH]
Sample.accdb
I inherited an Access 2000 (2002?) database that uses a textbox behind another to change the background color based on two different fields.
The Format property is set to: "[Green];"[Yellow], the Data ControlSource is set to:
=IIf([chkCheckedIn]=True,1,IIf([PassExpired]="NO",1,-1))
I understand the IIF(), but what's happening with the crazy characters? (It works the text changes from yellow to green). I tried replacing it with conditional formatting on the actual data control. That only changes color when I click on the control. The above shows the color all the time.
I'm very new to access, but see it has potential for a big payoff for a project I am doing. Currently, I'm stuck summing across the columns for Step 1 EC (est completion) - Step 8 EC. This may be a poor design on my part from inputting the data in the table. But all of these jobs being a stochastic process with always different steps in machining, I don't know how else to do it.
With all that being said, I would like each Piece Part to have a sum of days at the bottom of estimated completion and actual completion. Again, it must show the total for EACH part.
For example, as shown in the access file in report under "Piece Parts Report" the first part (No. 2 Aluminum Base Plate), it goes through 3 steps... with the steps being 1, 5, and 5 days respectively. I'd like for it to show at the bottom a total of 11 days for that part to be manufactured.
="Summary for " & "'Location' = " & " " & [Location] & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")"
NOTE: I need the number of the location to convert to the name instead i.e. 6 to Delaware.
I have a table full of dates of meetings through out the year...
Example
tMeetingDates
16th August 2005
18th September 2005
19th October 2005
23rd November
-----
i also have a report that i print out each month that has the date of the meeting on it... i currently edit the date manually.
I was wondering if there was a way to automate this facility, so that the report looked to the table of dates and looked for the current Months Date that is stored i the table.
i then want this date to be displayed in the Report.
So in this instance if i am running a report for tomorrows meeting being the 19th October it would display that date in the report....regardless of when i run the report...
Obviously if i run the report on the first of November because the month has changed it would then display the date of the November Meeting...
we only ever have one meeting a month!!!!
Please help
Andy
Using Access 2010..I have form with a date on it. For this control I have show date picker set to "For dates" and lo and behold I get calendar! I can scroll through this calendar month by month. Great if I just want to go back or forward a month or three. What I'd like to be able to do is scroll through the calendar year by year. Can I do this with the method I'm using at the moment? If not is there a way round it that isn't over complicated?
View 6 Replies View RelatedHi There,
I have got this form, consisting of 1 form (that needs to add a new record to a table everytime) and 1 subform, that needs to show the last three records of the table.
My problem is that I cannot get it right, now both forms (form and subform) are showing the details on just one record. If I open my subform it shows me all the records of a table, but in as soon as I view the form as a subform I shows me only one record.
Any help is welcome, I attached my db, just in case....