Start Of Month
Oct 4, 2005Hi
This is probally really easy........
I have data with dates like 15/05/2005, 30/09/2005.
I need to convert the dates to 01/05/2005 and 01/09/2005
Can anyone help!
ADVERTISEMENT
Create Reports Showing All Start Dates By Month
Dec 8, 2014I have a table that has the following:
ID
Program Year
Program
Start Date
Midpoint Date
Internship Date
End Date
I have successfully created queries to create reports showing all Start Dates by Month no matter what program and similar reports for all the other date queries. What I need it to do is list everything happening within a month and sort them by category. How do I do that? I've attached the database so you can see my queries as well as the main switchboard reports associated.
Queries :: Rolling 12 Month Query - Keeping Track Of Orders Placed For Given Part Number By Month
May 5, 2014I 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.
Calculate Variance Of Payment Month On Month - Values Comparison
Mar 19, 2012I 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.
Matching Current Month With Month In A Table
Oct 18, 2005I 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
Forms :: Calendar Scrolling Month By Month
Aug 9, 2013Using 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 RelatedMonth String To Numerical Month
Oct 13, 2006HiI have a field that is text which holds the month in form "oct" etc. I need to pass the numerical value of that month to a function so how do I create an expression that will change it (in this instance) to 09.kind regards in advance.peter
View 5 Replies View RelatedMonth By Month Query
May 17, 2005please help me
i have a date field called open & i need to generate a query to count all entries by month, so far i can get all cases each day, but i'm unable to get the query to count them just based on the month & year..
any ideas please
Where To Start?
Dec 19, 2007This is my first project using Access so take it easy on me. I'm trying to convert the Excel application to Access since I think Access is more flexible/powerful. I'm not sure if this requires programming (VBA-over my head) or just need some complex formulas to get the mission accomplished.
The objective is to be able to copy and paste data from a customized form directly to Access. These data will automatically be added into a summary sheet based on volume and amount.
Thank you in advance.
AccessNewby
Where Do I Start?
Feb 8, 2008Im looking at creating a database which includes some sort of diary system but I havent got a clue where to start, how to structure the tables, etc.
I am new to our company so I am looking to streamline some of their processes. Basically there are 4 people in our department and at the moment we use Excel as a mini diary system for our work on a day to day basis (our company uses Lotus Notes not Outlook and the diary system is a load of cr*p, plus also I want to integrate this into a database I have already written for our developers). Going down the page we have a section for each week which contains 4 rows (1 for each person). There is then 5 columns in each section which represents Monday to Friday. Our office administrator then goes in each month and updates the dates manually for the entire month.
Do I need to have a row in my database for every day of the year or is it done in weeks? I did a search for Access diary threads but there doesnt seem to be much info and the example one on iSam seems to have been taken off :(
Not Sure Where To Start.
Dec 7, 2006Hello all,
I am new to Access and I could really use some help to point me in the right direction. I want to organize my tables properly from the start so I do not run into problems down the road. If anyone can give me some advice on topics to read it would be a big help. Here is what I am doing so far.
My database must record warranty claims. A customer could have multiple warranty claims with multiple parts that failed. Each part can be linked to multiple failures but in a claim one part and one failure must be selected.
Example: A motor can fail in many ways but I need to know how it failed for this customer.
I would like to be able cascade the combo boxes so when a part is selected the failures related to that part are updated.
TblClients
ClientID AutoNum PK (1-many with tblMain)
CustomerName text
Address text
(rest of the customer data fields)
TblParts
PartID AutoNum Pk (1-Many with tblMain)
Part text
PartDescription text
TblFailure
FailureID AutoNum Pk (1-many with tblmain)
Failure text
FailureDescription text
TblMain
ClientID
PartID
FailureID
I guess my question is when I make a form based off TblMain, do I need a partfailure table to let me cascade my combo boxes?
Thanks for any help,
Mark
Forms Start
Jun 8, 2005Is there a way to set where the different forms will start, like location wise on the screen, when they are loaded?
View 1 Replies View RelatedSQL Server... Where Do I Start?
Jul 20, 2005I've downloaded and installed the new SQL server 2005 express edition CTD (June ed.) along with the Express Manager.
How do i get an access database into SQL server?
Now that it's installed, what next? When i try to upsize, it asks me to choose a server, and gives 3 options, and i'm not sure where they come from. Where does this list come from? are they previous installations of the MSDE on my computer? are they servers that ar available over our LAN?
i read that the default name if an instance of SQL server express is SQLEXPRESS but that's not on the list...
do i need to create a new instance of SQL server on my computer to house the database?
I really just want to try it, to see if it's something we should do, but i can't get it to do anything at all. i don't know where to start...
I've done some searches, but nothing tells me where to start. I'm getting really frustrated with this....
Please help me...
New Challange, Not Sure Where To Start
Jun 12, 2006Good day all. A bit of back ground, I've built a data base (with much help from the folks here) to track the training of my people. Someone way higher then me has decided to completely revamp our field training. There are now two "tiers" based on rank and training level. My first thought is to make two seperate tables for the information in each tier. What I would like to do is make the training specific to each tier show up on the form that I use to track this training based upon the persons rank. Ie an Airman would only show the tier one tasks and a Master Sergeant would show the tier two tasks. I'm thinking this could be done with a quiery but have no idea how to go about it. Any input or suggestions are welcome. Thanks in advance, Tim
View 6 Replies View RelatedStart Up Options
Sep 5, 2006Hi,
I unticked all the boxes in the Tools > start up window. I closed my database then reopened it. Now, I can't put these settings back again as I can't see the Tools tab.
Any help will be very much appreciated.
B
Worning On Start Up
Apr 3, 2008I have created one access application which will reside on server and many users will access it from there local PC. But whenever we start the application on local PC, it displays worning message that "Code is unsafe , it may harm your PC do you still want to run the code?" and another message box asking same question.
CAn we supress this worning? CAn we design the application in such a way that it will not ask such aquestions and will open application immidiatly when we double click the file.
Please reply ASAP. It's very much urgent...
Start And End Dates
Jan 18, 2006I have a query that is generating two colums, one the states the Start Date and the other that States the End Date. I need to display another column that displays the time difference between the two. Any ideas how?
View 10 Replies View RelatedStart And End Date
Apr 20, 2006How would you make two prompt boxes which ask for the start and end date so you can select all the data between the two dates...
[Start Date?] And [End Date?]
E.g., 01/01/2006 And 07/01/2006
So I can select all the data between that week. I also need to use this for the remaining weeks in January and February. This is really simple...gah. Thanks guys.
Does Not Start With A Letter
Oct 15, 2007Hi All:given a table with, let's say, Job Numbers that start with a letter (such as RES2345) or just plain numbers (such as 253180001 or 9817) how can I set the criteria in the query to just give me jobs that start with a number?I first trimmed the field to eliminate blank characters and then I used the Not Like "A - Z" but it still gives me jobs with letters at the beginning of the name.thanks for all your help in advance. :D
View 1 Replies View RelatedMsg Box Before Macro Start
Dec 14, 2005Hello,
I have a button that runs a macro to delete records in 12 tables. I want to create a message box before that macro runs warning that you are deleting records in 12 tables and are your sure you want to run the macro.
I need a message box with an ok and cancel button. Where do I put the msgbox funtion in this code?
Thanks !!
This is my code:
Private Sub cmdRunDeleteMacro_Click()
On Error GoTo Err_cmdRunDeleteMacro_Click
Dim stDocName As String
stDocName = "mcrSemesterStartRecordDELETE"
DoCmd.RunMacro stDocName
Exit_cmdRunDeleteMacro_Click:
Exit Sub
Err_cmdRunDeleteMacro_Click:
MsgBox Err.Description
Resume Exit_cmdRunDeleteMacro_Click
End Sub
Start-up Query After Log-in
Apr 23, 2008In my db I have a password log-in for each user. During the log-in process, I have a query set to run:
Code:SELECT tblSetOut.LogNum, tblSetOut.WoNum, tblSetCont.SetContName, tblSetOut.OrdAssign, tblSetOut.WoStat, tblSetOut.ThirdParty, tblSetOut.DateIn, tblSetOut.DateOut, tblSetOut.ThirdTimeIn, tblSetOut.ThirdTimeOut, (DateDiff("n",[ThirdTimeIn],[ThirdTimeOut]))/60 AS [Release if Greater than 24]FROM tblSetCont INNER JOIN tblSetOut ON tblSetCont.SetContInitials = tblSetOut.SetContInitialsWHERE (((tblSetOut.WoStat) Not Like "released" & "*") AND ((tblSetOut.ThirdParty)=True));
It opens up in read-only form that the user can print or exit out of.
What I need to happen is for the query to run based on the user's log-in name. There are three tables involved (tblSetOut, tblSetCont, and tblSecurity). The tbl SetOut and tblSetCont are joined at the field SetContInitials. The tblSecurity (field SC_NAME) is joined to tblSetCont at SetContName.
For the life of me, I cannot figure out how to capture the log-in name to filter the query.
Thank you in advance
Camille
I Can't Start Access. Please Help.
Jun 11, 2007This may sound a bit silly, but my Access 2003 refuses to start.
I recently re-installed Office 2003 after a fresh installation of WinXP. Word, Excel etc work as normal. This is the message that comes up when I attempt to start Access:
"Please wait while Office 2003 Prof. Ed. configures. Required data is being determined"
after that nothing happens.
Any ideas?
Please note that I'm using the German versions of OS and Office. My translation probably doesn't match the original message.
Thanks in advance.
Batch File To Start DB
Nov 10, 2005Hi
I want to use a batch file to start the DB. This will check if the Front End is on the users machine and if not copy it over.
It will then check what version of Access they are running and use the appropriate shortcut to open the Database.
This all works fine except that the Batch File does not close down until the Database is closed. Is there anyway to close the Batch File automatically while the database is running?
The Batch file I am using is
@echo off
rem *************************************
rem ** Batch file to copy FE **
rem *************************************
rem ** Copy Database **
if not exist "c:DB" md "c:DB"
if not exist "c:DBFE.mdb" copy "NetworkPathFE.mdb" "c:DBFE.mdb"
if exist "C:Program FilesMicrosoft OfficeOffice10MSACCESS.EXE" goto Office10
if exist "C:Program FilesMicrosoft OfficeOffice11MSACCESS.EXE" goto Office11
if exist "C:Program FilesMicrosoft OfficeOfficeMSACCESS.EXE" goto Office
:Office10
"C:Program FilesMicrosoft OfficeOffice10MSACCESS.EXE" "c:DBFE.mdb" /WRKGRP "NetworkPathSecured.mdw"
goto End
:Office11
"C:Program FilesMicrosoft OfficeOffice11MSACCESS.EXE" "c:DBFE.mdb" /WRKGRP "NetworkPathSecured.mdw"
goto End
:Office
"C:Program FilesMicrosoft OfficeOfficeMSACCESS.EXE" "c:DBFE.mdb" /WRKGRP "NetworkPathSecured.mdw"
goto End
:End
Exit
Any ideas?
JC
Autonumber - Specific Start
Oct 20, 2006I Have Chosen To Use Autonumber, But I Do Not Wish To Start From Number 1. I Wish To Start From 2345.
How Can I Do That?
About Tools->Start-up Option
Apr 13, 2007*Can anyone tell me if or how to reffer to the options from Tools-->Startup in VBA code? I`m asking that because i want to open a database in different ways
taking in account the logged user.
*And another question: in access 2000 is possible to make .mde files? Because the option is dissabled in tools--> database utilities menu.
Many thanks,
bogdan
Start Position In A Table
Sep 1, 2007I have a database table which is basically a calendar containing 4 columns (i) the date, (ii) special info about that date, (iii) morning volunteers and (iv) afternoon volunteers.When I go to this table the cursor is positioned at the very first date and i then have to scroll though record after record to get to the current date.How can I get it to remember the last date used?I am using Vista and Access 2003
View 6 Replies View Related