izyrider

try Date_Acquired = [COLOR="Red"]#[/COLOR]" & dtpDate.Text & "[COLOR="Red"]#[/COLOR] , WHERE izy

i have not experimented with that, but with 99% confidence i would say that a click is captured by a single control only. is this click-all-overlapping-controls something you want to happen or something you don't want to happen? izy

are you sure? you are declaring your parameters (!! all your parameters): in the sproc as varchar(50) in vb as varchar(actual-length-of-the-text) and it could be worthwhile to revisit your db design (or is it your sproc design): [COLOR="red"]"@Birthdate varchar(50),@CivilStatus varchar(50),@Nationality varchar(50),@Occupation varchar(50),@Age varchar(50),@Sex varchar(50),@Religion varchar(50),@Date_Admitted varchar(50),@Date_Discharged varchar(50),@Time_Admitted varchar(50),@Time_Discharged varchar(50),@Room_ID varchar(50)"[/COLOR] …

your [B][U]values[/U][/B] are NOT in format dd/mm/yyyy! **NOT** Access datetimes are actually numbers (years dot fractional years since Access-defined Beginning Of Time (sorry if i forgot what Access-BOT is)). you cannot reliably talk SQL to the Access database engine (JET or whatever) using dd mm yyyy. it will work fine …

yes. it goes something like this: [CODE] UPDATE sometable SET thisfield = LEFT(thisfield, 11) + '10/' + RIGHT(thisfield, 3) [/CODE] if the third '/' is not always the eleventh character and is not always followed by three characters you will need to work harder on the substring concatenation (perhaps CHARINDEX() …

Hi, I have a Windows Form frmMain() holding seven more-or-less unrelated UserControls, "ucFlopsy", "ucMopsy", "ucCottontail", etc... I say "more-or-less" because each of the seven UC has three similar public read/write properties: IsLocked (a boolean indicating if the following two properties are "Locked") IsLockedID (if IsLocked=True then IsLockedID is an integer) …

contains? as in "123", "12", "23" all [U]contain[/U] 2 if that's what you want: SELECT t.* FROM tbl AS t WHERE t.strval LIKE "*2*" if LIKE "*2*" wont fly then experiment with variations of quote (' or ") and wildcard (* or %). e.g. LIKE '*2*', LIKE "%2%" etc It's …

I have a combo populated with: [code] With Me.cboOwner '// populate cboOwner .DataSource = dtMyCos .DisplayMember = "CoName" End With [/code] DtCos datatable contains: CoID int CoName string So far so good! Then I have a second combo cboIssuer that needs to contain all the items in cboOwner **PLUS** an …

Hi, I have a DataTable oDT. oDT is populated from SQL Server with 6 columns including a column "bAAA" of varbinary(200) I have a function fx(ByVal byteArray As Byte()) as String I would like to add a calculated column to oDT something like this: [code] oDT.Columns.Add("sAAA", GetType(String), fx(bAAA)) 'bAAA is …

Hi, My first post, please be gentle. I have 64 booleans - all must be displayed on a single screen as a series of checkboxes ([B]no[/B] - I don't care about the 65th bool, [B]yes[/B] - it [U]must[/U] be a single no-scroll screen on the UI). As a VBA-refugee, I …