Newbie - Help Getting Right Date To Append
Sep 25, 2004
This 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
View Replies
ADVERTISEMENT
Oct 24, 2004
I 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?
View 1 Replies
View Related
Sep 6, 2006
I 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,
View 1 Replies
View Related
Mar 22, 2008
Everything 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
View 12 Replies
View Related
Nov 17, 2004
Hihi
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
View 1 Replies
View Related
Jan 12, 2007
I 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.
View 5 Replies
View Related
Jun 28, 2005
I'm making a macro to output a report to an Excel spreadsheet using OutputTo and would like to add the date to the filename since this is done each day and the files need to be different. So I'd have something like "Output" as the base filename and "Output20050628" as the final filename. Would someone please help me out on this? Thanks in advance.
View 3 Replies
View Related
Jul 20, 2005
Hi all,
Am a bit stuck with this one.
I have a table "tblReviews" with the following fields:-
Learn_ID
Review_PlannedDate
Review_ActualDate
Reviewer
I have an unbound form with the following txt boxes:-
txtLearn_ID
txtReviewStartDate (Format dd/mm/yyyy)
txtIntervalWks
txtAmountOfReviews (Number)
txtReviewer
What I would like to happen is after I have completed the above fields, appends the rows to my table.
So if
txtLearn_ID = Ajwebb0982
txtReviewStartDate = 01/09/2005
txtIntervalWks = 1
txtAmountOfReviews = 4
txtReviewer = Ann
I would like to Add 4 rows to my table which should look something like the following:-
Learn_ID, Review_PlannedDate, Reviewer
Ajwebb0982, 08/09/2005, Ann
Ajwebb0982, 15/09/2005, Ann
Ajwebb0982, 22/09/2005, Ann
Ajwebb0982, 29/09/2005, Ann
I'm sure it is possible, just stumped on how to go about it. :confused:
Thanks in advance for any help.
Taff.
View 2 Replies
View Related
Nov 27, 2006
Hi Guys
Can someone please help me with this? I have an Events form which has some date fields setupdate and enddate. There is a linked events calendar subform attached. I have attached the database for you to see.
If you open the events form and go to the events date tab, I want to be able to type in the dates in the setup and end date fields, and then run a query which populates the events calendar subform. I created a date table (dates) with a list of dates and tried to create an append query (Query3) with those fields as criteria which didn't work as it wasn't recognising the parameters (but i'm guessing that is because it wasn't attached to the Events Form). However after entering the dates, I was able to append them to the events calendar only after including the EventsID field to the dates table and the query. This however means that the records aren't linked to the Events table as the EventsID field is blank (the EventsID is what links the E.Calendar subform to the Events Form). Therefore though the records were reflected in the events calendar form, it wasn't showing up on the events form.
I dont know if this makes much sense but what I basically want to do is a series of functions. Create a query which extracts a set of dates based on criteria entered into the main form, and appends them to a datasheet subform which is linked to the main Events form via the EventsID, then copies the Event ID for all the recordsets that have been added.
Is this possible? Thanks for your help in advance.
View 2 Replies
View Related
Jun 23, 2007
I have a series of events that have a start date and an end date. How do I write an append query to append an event to a table as an individual event for every day in the given range?
View 2 Replies
View Related
Jul 20, 2005
I want a query that will append a date from one table to another, however I want it to incriment by one day. Is this possible? For example:
tblTable1
07/20/2005
07/25/2005
07/28/2005
ActionQuery - tblTable1 appends to tblTable2 and incriments one day:
tblTable2
07/21/2005
07/26/2005
07/29/2005
Is there a way?
View 2 Replies
View Related
Aug 30, 2007
Hi,
Here's my problem. I have a table that is for maintenance jobs that recur on a fixed schedule, i.e. cleaning gutters yearly. I need to run an append query that will take all the information and cause it to recur a given number of times. I've gotten that to work with just a standard append query pulling data from a form.
The part I'm having trouble with is this. I need to get that append query to take the start date for the job and increment it properly based on my selection of daily/monthly/yearly recurrence for each individual occurance of the job.
Hope someone can help,
Thanks,
Brian
View 6 Replies
View Related
May 14, 2013
I have a totals query that displays the sum of what products we ship each day. A process in the system automatically assigns the date/time to a ShippingDate field when an item is marked as despatched.
The totals query allows users to view what products are shipped between a period specified by the user.
The problem I am getting is that when the user inputs dates into fields [txtStart] and [txtEnd], the query fires up but will not display any records as a start time 00:00:00 and end time 23:59:59 was not input.
I don't want users to have to do this but cannot think of a way around it. My criteria code in the query for the shipping dates is
Code:
Between [Forms]![Switchboard]![txtStart] And [Forms]![Switchboard]![txtEnd]
Can I append the start / end time onto the code above somehow or is there another method I can utilise that is probably so glaringly obvious I have missed.
Usually a query allows me manipulate a field property sheet but in this case there is nothing obvious to select like format.
View 2 Replies
View Related
Nov 26, 2013
how do you take a date from a textbox on a form into an Append query and increase the date entered into the textbox by 1 day.This is what I have so far but not working??
MealDate: [Forms]![FrmSwitchBoard]![txtweekend]=DateAdd("d",1,Date())
View 4 Replies
View Related
Jul 2, 2014
I am using access 2010. I need to rename a table when I import the a new table. But I can't get the docmd rename code to work. I also want to append the current date on the end i.e.
docmd.rename, "tblOldTable(Currentdate)", actable, "tblOldTable"
doesn't work.
View 10 Replies
View Related
Jun 27, 2013
I have a variable (dtDueDate as Date) showing as 6/28/2013. I want to append a time value to it (dtMaxTime as Date) which is 5:00 PM so dtDueDate reads 6/28/2013 05:00:00 PM. I have been going in circles trying to figure this out. My goal is to append this date to a table field which has a datetime (General Date).
View 6 Replies
View Related
May 1, 2013
I have an database that uses a couple of different date ranges, so I created a table that shows the different date ranges that may be required (xReport Dates) so I didn't have to keep manually editing queries or entering dates every time.
I have one query that appends data from one table into another based on a date range that you need to manually enter when prompted; I can't seem to get it to refer to my xReport Dates table for the range.
Its currently set up as below:
INSERT INTO 001_M_Gross_Telesales ( UpdateDate, OMSNumber, MediaRoute, ExecName, SaleType, Name,
[Reporting Campaign], [Reporting Team], [Sales Leader], [Reprting Name], [Media Route2] )
SELECT Max(L_ExecTracker.UpdateDate) AS MaxOfUpdateDate, L_ExecTracker.OMSNumber,
L_ExecTracker.Campaign, L_ExecTracker.ExecName, L_ExecTracker.SaleType, Z_Ref_Agent_Table1.Field23,
[Code] .....
View 1 Replies
View Related
Sep 25, 2015
I have a text box named "scheduled_start" on my "JobsF" form.
Now what I'm trying to do is use two append query's to move the start date contained within the text box.
*The first append query will be on the before update and put this date in the "notesT" in the "old_date" field.
*The second append query will be on the After update and put this date in the "notesT" in the "New_date" field.
I'm trying to track date changes and this part of the process isn't working. For a start I don't know how to run the query on an event. I can open the query using 'openquery' but I don't wish to open it. Re query is also an option but the query I made isn't listed when that's selected.
View 13 Replies
View Related
Aug 22, 2014
I have a form which i use for a user to select an excel file they want to import and then click a cmd button to import the file into a table which works fine, however i want to append a date into a date field from an unbound txtbx before the file is imported so it will look something like;
id;date;excel info;excel info;excel info.
View 7 Replies
View Related
Feb 18, 2007
hi Guys,
I have been looking at different post and checking Microsoft help files as well, but still can't seem to fix this problem.
I am having 2 tables. The first table is connected to a form for viewing and entering data, and in the second table i am just copying 3-4 fields from the first table.
I am trying to use the insert statement to insert records in the second table, and everytime i click on the "Add" button to add the records i get the following error "MS access can't append all the records in the append query ... blah blah blah"
However if i close the form and reopen it, and goto the record (as it is saved in the first database) and now click on the add button to add the fields to the second table/database, it works.
What am i doing wrong???
Any inputs will be greatly appreciated.
View 3 Replies
View Related
Jan 2, 2008
I´m trying to improve my appl. but I´m stuck trying to figure out how to append multiple rows on a table using the Append query.
My problem comes since I have 4 tables with the following fields:
1) Orders
OrderID (number)
CustomerID (number)
Date (date)
etc...
2) OrderDetails
OrderDetailID (number)
OrderID (number)
ProductID (number)
QuantitySold
UnitPrice
etc...
3) TmpOrders
OrderTmpID (Autonumber)
CustomerID (number)
Date
etc...
4) TmpOrderDetails
OrderDetailTmpID (Autonumber)
OrderID (number)
ProductID
QuantitySold
etc...
The problem comes since the Tmp tables are used just to record temporarly the information before the transaction is completed.
Whe the salesman at the desk finish the sale, a command button is presseed and an append query runs to transfer the data from Tmp tables to the Definitive tables. Another query (Delete) is excuuted inmediately after the append qry. and it deletes the information recorded on Tmp tables.
I need to reset the autonumber or create a field that records the line number so I can add up to the Maximum OrderDetailID found on the definitive table, but the problem is how to create the "controlled" autonumber.
Please help.
View 1 Replies
View Related
Jun 24, 2005
Great forum!! Hope I someone on here can help me!
Here's the situation. I have a Database in Excel (~3000 rows & 7 Columns)
The first Column has numbers like this (3-10-34 or 223-7-45) the other columns have names, addresses and other stuff.
What I'm trying to do is to eliminate the use of huge binders. I want to have a Blank screen with only one input box where I can type a number and retrieve a specific row from my Database. Time saving.
Now, when I'm searching, I usually only have the first numbers before the dash (such as the 3 or the 223) not the other numbers. So I cannot input 3-10-34 for instance. I can only put 3...:confused:
I've already imported it to Access and it works fine but have no idea how to do what I just described!
Thanks for the input!!
A very very green access user! :o
View 11 Replies
View Related
Oct 19, 2005
Hello
sorry if this question is answered somewhere else i did check through the forum a bit first
anyway to the question
is there a way in access 2003 so when i change a value in one table it creates a new record in another table
example
i have a table called tickets and one called fixes, when i change a value in a record in the tickets table i want a new record in the fixes table to be created for me
any help would be great
ADAM
View 5 Replies
View Related
Nov 3, 2005
Hi there,
I am not sure if i am supposed to post in this section......
--------------------------------
Using Access 2003.
I am very new to Access and have started off very well building my first project..
My help is that i would like a macro button to delete a record once you have put in to the database if that is possible also i would like a save button if that is possible...
I have put a Tab Contol on and want to change the backgound but i can't see on the properties box to change this. Is there a piece of code that allow me to do so...
Hope some one can help
Emailjunky
View 1 Replies
View Related
Nov 3, 2005
Hi There All,
I am still very new to Access 2003 and have started off very well..
Just a few help please:
Help 1. I need a macro button that will allow me to delete a record from the database via a form.
Help 2. I need a macro button to save the database if that is possible via a form.
Help 3. I have a Tab Control on my form and i want to change the background of the Tab Control but can't find it on the properties is there a piece of code i can put in to VB which will do this for me or is there another way.
Hope someone can help
Emailjunky
View 2 Replies
View Related
Aug 17, 2006
hello guys i m very new to access and i need some help!
if i had a form that contains a field like salary and i need to add all the salaries from all the records into one total salary how can i do it?
plz take into consideration that i m totally new and dumb:p in access
thank you
View 2 Replies
View Related