Newbie Date As Part Of File Name
Mar 22, 2008Everything works great but I want to save the backup file with a unique name, like EX: myfile INTx.xls where intx = the date "Now", maybe, am I looking at this wrong.
Thanks Bob
ADVERTISEMENT
Save Report As PDF - Adding Date Retrieved From Query As Part Of File Name
Nov 6, 2012I'm trying to save a report to my Desktop as a pdf - adding a date {that I am retrieving from a query} as part of the pdf file name.
I get a
Run-time error '2501' - The OutputTo action was cancelled.
(See screenshot).
Here's the code I'm using. So far - all I've tried to do is run the function from the Visual Basic Editor.
Function SaveReport()
Dim strSQL As String
Dim strPath As String
Dim strFilename As String
'Get the ReportDate.
[Code] .....
Date Problem - Part Constant - Part Now()
Nov 3, 2006Hi everyone,
I have refined my query from previous threads to involved a module function. This calculates more acurately no of working days between dates and takes into account a holidays table. (All credit to Arvin Meyer on the module:) )
However because the Leave Year starts at the 1 July and finishes 30 Jun I need to compose the date for any current year Year(Now())
Enclosed scrdmp shows my query design. I can easily get it to work as you see it, but obviously as each year rolls over, the year needs to change.
Have looked at many posts but can't find what I'm looking for. This one will get me over the hurdle.
Many thanks,
General :: Make File Name Part Of A Field Value
Jun 13, 2013I'm trying to split up the filename into four separate fields. Here's an example of the filename:
123112 427900 55261 1156833.jpg
A 12312
B 427900
C 55261
D 1156833
The values A, B and C are always the same number of characters. The last value, D, changes in size. It can be anywhere from four characters to twenty. But it always starts at position "20" as with "1" in the case of the 1156833. The extension, jpg, is of no value.I might also add my programming ability is close to nonexistent.
Newbie Question - File Extension For The Form?
Dec 11, 2006Hello. I have a mdb access file. When I open it, I can see lots of tables. How on earth do I open a form? Do I need another file, if so, what extension should I look for on my computer?? I really dont want to create a new form, since a person who did it has told me that its all have been already done. I just need to open the form and enter the data in. Thanks for any help!!!:)
View 1 Replies View RelatedHow Do I Get Out Part Of A Date In A Query??
Jul 17, 2007Hey People,
Is it possible to take out part of a date in a query and put it into a new column, e.g.
if one field is : "Date"... with entries such as 12/05/07.. etc,
is it possible to have another column "Month" that has the specific month in the date column.. e.g the one above will have "May".......
anyone have any idea about this...
cheers.
Selecting Part Of A Date
Mar 9, 2005I have a table with the field "Date". The date is in the format mm/dd/yyyy.
I would like to create a query that selects only the year of each record, and disregards the month and day.
Is this possible?
Tricky Question - Form Part Data Entry, Part Not
Dec 16, 2004I have what I think is a difficult problem to overcome...
I am designing a form to create an invoice. The user will select a workstream and a date range in form frmInvByHrs. Within this I want two sub-forms, one is frmInvByHrsTsht and the other is frmInvByHrsBill. I want the first one to display all the staff and their hours done, and the second one to be in data entry mode where you can enter the hours you want to bill. Each sub-form is based on a separate query.
Is it possible to do this? ie. to have one sub-form in data entry mode, and the other not? It seems to me that the data entry mode is controlled by the MAIN form regardless of the sub-form settings!
If this is not possible, do you know how I can acheive this?
Thanks
S
Modules & VBA :: Calculate Part Information Difference As Per Date?
Nov 21, 2013How to implement a functionality into my access database. The related tables required for this functionality can be found as an attachment.
When the information has been entered into the tables by the user, I would like to calculate the difference between the information for each part within the same table. The main columns for which the difference have to be calculated are: [RefObsInfo->RefSources] and [AltObsInfo->StatusAltSource] and [GenObsInfo->GenSources]. The values for these fields are restricted to 3 or 4 different ones. I also would like to show if the GenEstAvailable columns are changed, but that's for later.
In order to calculate this difference a query has to select for each Part the information related to the last date AND a date which has been specified by the user (with the previous date as max). For this the user is asked to give a from date, which she/he can select from a combobox. This combobox has a standard selected value which is the MaxDate-1, i.e. the previous date. The difference should be calculated from the previous date to the last date. I would prefer to give each (predefined) difference a specific action to show the user the difference in a matter of seconds.
Queries :: Using Part Of Date As Query Criteria From Combo Box?
Apr 4, 2013I have a query with a date field that is formatted mm/dd/yyyy. I have a combo box that is formatted as mm/yyyy. I need the choice from the combo box to be the criteria for the date field in the query. the combo box has to contain the month and year only (which it does now) and the query must return mm/dd/yyyy. I have tried a few statements and the closest I got was a between statement that added 30 days to the combo box selection but that's not really accurate.
View 2 Replies View RelatedNewbie Needs Help Getting A Date.
Oct 24, 2004I am using a MFC dialog window to retrieve data from an Access database.
My code, that does not work, looks like this:
CFacilityWorkshopSet set;
CTime date(1999, 1, 11, 0, 0, 0);
set.m_strFilter.Format("Workshop.StartDate='%d/%d/%d' ",
date.GetMonth(), date.GetDay(), date.GetYear() );
set.Open();
When I hook this exact code upto an identical SQL database, it works perfectly.
However when I use it with my Access database, I get the messagebox error:
"Data type mismatch in criteria expression."
Can anyone help me correctly format the query statement so that it will work?
Newbie - Help Getting Right Date To Append
Sep 25, 2004This is my first stab at this and I'm obviously overlooking something. I'm trying to do a recurrent date append to an Access calendar db. I'm trying to take the field varStartDate and add 7 to it for the # of weeks recurring. Works great. I type the var out and it is appending correctly BUT when I look at the db, it is putting the ORIGINAL START_DATE and not the RecurDate var. What am I doing wrong?
TIA!
Lisa
Dim strSql
startDate = CDate(Request.Form("varStartDate"))
IF Request.Form("numWeeksRecur") > 0 THEN
Weeks = Request.Form("numWeeksRecur")-1 ' *** Subtract week from total week for first Command.Execute
For recurDate = startDate To startDate+7*Weeks Step 7
fldStartDate = recurDate
fldStartTime=Request.Form("varStart_Time")
fldEndDate=Request.Form("varEnd_Date")
fldEndTime = Request.Form("varEnd_Time")
fldeventTitle=Request.Form("txtEvent")
fldevt_grp = Request.Form("txtgroup")
fldlocation = Request.Form("txtLocation")
strSql = "INSERT INTO events (start_date, start_time, end_date, end_time,eventTitle, evt_grp) VALUES fldStartDate, "
'FOR DEBUG ONLY
Response.Write(fldStartDate) & "<hr>"
Response.Write(recurDate) & "<hr>"
'Response.End
MM_editCmd.Execute strSQL
Next
END IF
Date Problem.... Newbie
Sep 6, 2006I have a form in which users enter a start date and an end date to reserve meeting rooms. The restriction is that the dates have to be within one year of today's date. The message box saying the same should come up & restrict users from entering the dates. How do I accomplish this?
Thanks,
Convert String To Date - Please Help Newbie
Nov 17, 2004Hihi
I have a field containing data in this format
01Apr04:12:34:56
for example
It is not recognized as a date by Access, so it is stored as text
I need to put it in any general date/time format, like
dd/mm/yy hh:nn:ss
I also need that Access actually reads it as a date/time (not a string) to be able to merge with other data, then sort chronogically.
How can I do that (please no code, only query if possible, i'm really a newbie...)
thx!
caroline
Newbie Question About Date Ranges
Jan 12, 2007I must be having a bad day, as I can't get something really simple to work. I have a query, that amoungst other things, I want to select all records between two dates. For instance, the table has a 'ScheduledDate' field, and I have set up two parameters in the query that prompt for 'From' and 'To' parameters.
In design view, I have tried the following in the 'criteria' box for the 'ScheduledDate' field;
>=[From] <=[To]
This doesn't work ~ can anyone point me in the right direction. I've searched the forum, perhaps not using the correct keywords?
All help appreciated.
Add 1 Year To Year Part Of Date
Mar 14, 2006I have a query based on payment date which I have extracted the Year part as a seperate Field StartYear, but I want to now add EndYear which just adds 1 year to the StartDate. e.g. EndYear = StartYear +1. Anyone kow please I know i's proably simple but I keep getting syntax errors.
View 3 Replies View RelatedPreserving File Date With Ftp
Nov 24, 2004I am using the shell command to call dos ftp in order to download and upload files that I then import into my db (Access 2002). This is working great. I would like to check the file date before I import the file data into my db so that I do not import duplicate records. Unfortunately, the file date is modified when I grab a file. Is there a means to preserve the file date using the dos ftp utility? If not, is there some other way to do this in code so I can automate the procedure? The code I am currently using is:
'******* Code Start *****
'This code was originally written by Dev Ashish
'It is not to be altered or distributed,
'except as part of an application.
'You are free to use it in any application,
'provided the copyright notice is left unchanged.
'
'Code Courtesy of
'Dev Ashish
'
Public Sub sFTP(stSCRFile As String)
'Usage Example:
' call sFTP("C: emp est.scr")
'Sample SCR File for NT/Win95 FTP
' lcd "c: emp"
' open ftp.someserver.com
' anonymous
' dash10@hotmail.com
' cd public
' binary
' get dead.letter dead.letter
' bye
Dim stSysDir As String
stSysDir = Environ$("COMSPEC")
stSysDir = Left$(stSysDir, Len(stSysDir) - Len(Dir(stSysDir)))
Call Shell(stSysDir & "ftp.exe -s:" & stSCRFile, vbNormalFocus)
End Sub
'********** Code End *******
Thank you for the assistance.
-Kevin
Change Name Of File With Todays Date?
Dec 18, 2012We are getting in files from a vendor that come in with today's date and different extensions and prefixes such as BA0003.20121217.pdf or MYLOOKUP.20121217.psv where the only constant is the date, there are over 100 files that I need to change the date part to today's date. I would like to find all the data before the first period and all the data after the last period and replace the date part with todays date.
View 1 Replies View RelatedModules & VBA :: Deleting File Based On Date
Feb 12, 2014So I currently have a module which automatically backs up my database to a separate file everyday on open of my database.
If is it possible to create a function which will allow me to delete these backups after a certain amount of days (eg 30 days). They all have different file names based on the time that the backup was created but have the same extension of "*.accdb". I ask because it stores EVERY backup so the storage space required will soon build up unless manually deleting the files which is not what my client will want,
I have tried using the "Kill(pathname)" function but have had no luck yet!
If possible, I would like this to be done automatically either on open or on close of my database.
Would this be done with a module?
Modules & VBA :: Export Table To CSV File By Date
Nov 20, 2014What I would like to achieve via code on a button. From the table orders
Code:
orderDate orderID ref name amt vat
02/02/2014 56789 01 magdi 600 100
22/06/2014 12122 01 magdi 654 100
22/06/2014 65897 02 simon 250 159
22/06/2014 12345 02 simon 156 140
23/07/2014 56781 01 magdi 400 250
01/08/2014 12457 01 magdi 250 900
01/09/2014 56787 02 simon 126 500
02/09/2014 56781 04 peter 400 250
02/09/2014 12345 02 simon 450 122
02/09/2014 65897 04 peter 250 231
02/09/2014 12122 05 hargr 654 100
02/09/2014 79457 05 hargr 254 200
I need to create csv files from the above based on unique date and ref and with filename showing date and ref. So from the above we should get 9 csv files in this format
02/02/2014-01.csv
22/06/2014-01.csv
22/06/2014-02.csv
23/07/2014-01.csv
01/08/2014-01.csv
01/09/2014-02.csv
02/09/2014-02.csv
02/09/2014-04.csv
02/09/2014-05.csv
How to produce the above result ...
General :: Xcopy With Date - New File In Folder2
Apr 4, 2014How to add the date to the new file that is copied with the code:
xcopy /s C:UsersGeneDesktopFolder1DBMain.accdb C:UsersGeneDesktopFolder2
I have looked everywhere, copied various codes that said it could be done, but I still can't get it to work.
What I want to to have the new file in Folder2 be DBMaind_DateAndTime
where DateAndTime would be the Date and Time that the copy was made.
Modules & VBA :: Save NOW (Date And Time) Into Event Log File
Oct 16, 2014I want to save NOW() (i.e. Date and time) into an event log file. But I just cannot work out the syntax. My insert statement works fine without the date field in, but fails on a syntax error (3134) when I include it.
strsqlac = "INSERT INTO EventLog ( EventTime, User, EventType, EventMessage, DocRef, AutoSeq, CoCode ) " & _
" Values ( '" & Now() & "', '" & GlobUser & _
"', '" & Mess2 & _
"', '" & Mess1 & _
"', '" & Docref & _
"', " & AutoSeq & _
", '" & CoCode & _
"' );"
... it's the first column, EventTime that is the issue. I have tried several different ways of wrapping it in the VALUES () without success.
My database field EventTime is defined as a General date which Access 2007 tells me will give me date and time. That's what I want.
The Value formats I have tried (currently showing as 'NOW()' above, are ...
#NOW()#
#'NOW()'=
'#NOW()#'
and (as I say) 'NOW()'
Modules & VBA :: File Date Modified Property In Textbox
Jun 19, 2015I have a split database with a frontend that I semi-regularly update (when one of my users finds a bug I never would have thought for looking for). On my menu screen i have a text box that says: "Last Updated: ##/##/####".
At the moment I manually update the date every time I update the frontend.
Is there a way I can use the DateModifed property of the .mdb file for the frontend as the date in my textbox using VBA?
Queries :: Unusual Date Format In Text File
Jan 5, 2015Someone decided to be clever and send a text file with a stupid date format, is it possible to show off a little here and get a working date format, it's a text file I am working with: Dec 18 2014 01:12PM.
Not that is an exactly cut/paste so spaces are as they are here, ideally would like to get 18/12/14 13:12.
Modules & VBA :: Retrieving Last Modified Date From A File Uploaded In URL
Feb 3, 2014Vbscript/vb macro code for retrieving the last modified date of a file uploaded in a URL.
I am able to get the file but wanted to get the last modified date of it.
General :: Obtaining Creation Date Of Excel File
Apr 10, 2014I want to use the create date of a file which is stored as a linked table in my Access 2010 database. I have attempted this by creating a query (qrysysObjects) using the MsysObjects and that gives me the filename of the linked tables, well almost - a few are csv files and this does not have the file name in the database field text, but I have found it in the foreignname field except it is name#csv rather than name.csv so I can't simply concatenate this in a query.
I know there is a function called FileDateTime which you can use in vba or a query but can you use a variable with this rather than the actual path name? I tried this in the query qrySysObjects but it said unknown function.