Search results for query: *

Hi all, im going insane trying to debug this on... im getting an error on the line Cat.Tables.Append(CType(objTable, Object)) error is invalid type any help is appreciated thanks tryp Private Sub createTable(ByVal dBasePath As String) Dim Cn As ADODB.Connection Dim Cat As...

CREATE procedure clx.proc_strip_markup(inout @adtext varchar(32000)) begin --% Declare all variable required used in stored procedures declare @li_asc integer; declare @ls_output varchar(32000); declare @ls_char varchar(255); declare @ls_body varchar(32000); declare @ls_setspace...

CREATE procedure clx.proc_strip_markup(inout @adtext varchar(32000)) begin --% Declare all variable required used in stored procedures declare @li_asc integer; declare @ls_output varchar(32000); declare @ls_char varchar(255); declare @ls_body varchar(32000); declare @ls_setspace...

Ive read intel p4 640 3.2 ghz CPU should maintain under 39 Celcius but ive also seen much higher numbers in articles etc. .... Is the temperature >= 40 degrees acceptable ?? system spec: P4 640 3.2 ghz ASUS P5N32 Mobo 512Mb 667 Mhz DDR2 RAM Nvidia 7900 GT Vid card Lian li case - 4 exhaust fans...

I am building a machine with a SATA drive (got it already) and am wondering if i can run a 2nd drive with it even if the second drive is not SATA ?? thanks -tryp

I am waiting on some new stuff i ordered.... Mo-Bo: Asus P5N32-SLI Deluxe NVIDIA Socket 775 ATX CPU: P4 640 w/ HT 3.2GHz RAM: Kingston 2x512Mb 667MHZ 512MB DDR2 HDD: Maxtor 7200 rpm 180 gig My question is.. what type of grafix card(s) should i get? Two 256Mb cards on the SLI or one 512 Mb...

Hi all, I'm trying to execute a stored procedure using ADODB from an acces ADP file. here is the stored proc CREATE PROCEDURE spInsert_People @FNAME varchar(50), @LNAME varchar(50), @DATEADD datetime, @RET bigint output as Insert into PEOPLE (FName,LName,DateAdded) Values...

INSERT INTO tblTest ( the_Memo ) SELECT [tbl_Data].[data_1] & ":" & [tbl_Data].[data_2] & Chr(10) & Chr(13) & [tbl_Data].[data_3] & ":" & [tbl_Data].[data_4] AS Expr1 FROM tbl_Data; IM TRYING TO RUN A QUERY LIKE THAT TO GET THIS DATA:data DATA:data in a textbox but im getting this...

INSERT INTO tblTest ( the_Memo ) SELECT [tbl_Data].[data_1] & ":" & [tbl_Data].[data_2] & Chr(10) & Chr(13) & [tbl_Data].[data_3] & ":" & [tbl_Data].[data_4] AS Expr1 FROM tbl_Data; IM TRYING TO RUN A QUERY LIKE THAT TO GET THIS DATA:data DATA:data in a textbox but im getting this...

Access query question, if i have a table with colums A , B and C ... A is text B is a boolean C is a long how would i write the SQL to do get following 2 Columns display unique A's sum column C BUT if B is false then C is a negative number Example... ColA ColB ColC CompanyA True...

I am running an access db withan access workgroup. I want to know if i can give a user rights to create/delete users. HOWEVER i have to limit the amount of users they can make.. You know...have a user cap... Is this possible with Acess or do i need to Chuck the workgroup and provide my own...

any idea how in ASP.Net (VB.net) i can do the equivalent of --In a subRoutine on Webform1 dim x as new webform2 load x x.property="value" x.show -------------------------- Help...New to ASP.Net....real Green ! ;) Tryp

Can anyone tell me how to get a sender email address from a MailItem ? Tryp

All, So far i have been able to use the outlook bjects to search and retrieve emails SENT. No Problem...works well actually... HOWEVER....... I want to search saved mail. BUT...so far cant find the folder(s) to search Help please !! Tryp

I am trying to create an MS Outlook appointment from inside MS Access using the following code: Dim oOL As Outlook.Application Dim oItem As Outlook.AppointmentItem Set oOL = New Outlook.Application Set oItem = oOL.CreateItem(olContactItem) The createItem throws this error...

in a routine i have to fill a listbox with the contents of a text property of an object X. i get this object from a method call to another object Y. i have to re-get from Y in order to iterate through the count of X's in Y. so far i have tried 2 methods of filling the listbox: 1.)...

All, Currently we are running an MS Access application (front and back end) and we are contemplating going to a SQL Server backend. I pose this question to debate... Do we stick with the same front end or switch to VB or C# or even ASP or ASP.net ? Pros Cons ??? Thanks in advance, TRYP

I have a form with a tab control. There are a few subforms on the tab control while some tabs contain only fields of the "Main" form. Whenever i am in the middle of adding a record on the "main" form and want to view info on another tab that contains a subform the main form...

aLL, WHEN I PASS THIS TO SHELLeXECUTE I GET AN ERROR FROM OUTLLOOK THAT TELLS ME MY COMMAND LINE ARGUMENT IS IN ERROR AND I SHOULD CHANGE MY SWITCH. ANY IDEAS code: passThis="mailto:guy@Web.com?" & _ "SUBJECT=test&BODY=hey&Attach=" & _ chr(34) &...

i have an access 2000 database and i want to use an alter table statement. I want to add a boolean field with a deafault set to true. can access do this or should i pick another database to do this simple process ??? tryp