Ok I worked out how to insert into my table, but the INSERT statement that was once working is no longer working!!! Could someone look at the following insert statement and point out a Syntax error? I have NO string values coming in.
strSQL = "INSERT INTO Calendartbl([RepID],[Datefld],[Unavailable],[Available],[UnavailableReas on]) VALUES(" & Rep & ",#" & DateInsert & "#," & UnAvail...
maverick10gk
Last Activity: Aug 30 '07, 05:09 PM
Joined: Jul 25 '07
Location:
-
Ok so I think I figured out how to parse the dates out into an array. Can someone check this code to be sure I am on the right page? Also from this can anyone give me an idea how to take the date value from the array and use it in a SQL insert statement? Thanks!
...Code:Private Sub Command12_Click() Dim DateArray(31) Dim DateValue As Date Dim EndDateValue As Date Dim i As Integer i = 0 DateValue
Leave a comment:
-
Insert data based on a range
Hello All,
This post and my previous post are the last pieces that I need to tie up before my DB tool is complete.
What I am trying to do here is to allow a person to select a date range, their availability, and at the press of a button the dates within the specified date range along with the selected availability will be inserted into a table I have called Calendartbl. This table holds the following: entryID(Auto number),... -
Go To Record
Hello All,
I am having trouble customizing a Microsoft Access Form. I have a calendar control that sits in a subform with a date field and a check box for available and unavailable. The main form is the selected employee. What I would like to happen when a date is clicked is this:
Check to see if the selected rep already has information for the selected date and if so go to that record.
Or
...
No activity results to display
Leave a comment: