Search results for query: *

Yes That Is A Typo.

I am trying to use the DataReader To Access Table Records. I have done this successfully before but, now I am getting an error. I have tried it both using SQqlServer and Access Databases, using SqlClient and OleDb respectively. The DataReader Variable I declare = Nothing when I try Calling the...

I have 3 tables with fields as follows: tblInvoices InvoiceID - PK Autonumber InvoiceDate jtblInvoiceDebits InvoiceID DebitID tblDebits DebitID - PK Autonumber DebitAmount DebitType Setup In a Many-To-Many Relationship using jtblInvoiceDebits as the Junction table. Taking the...

Thanks for your help. That Works but, When I Click Apply/OK while the form is open, It stil opens another instance of frmContactList. Do you have any idea why?

If Form Loaded Then....Question I am working on a project that currently has 4 Forms 1. frmMain (MDIForm) - with options menu to launch other 3 forms 2. frmContactList (MDIChild = True) 3. frmCompanyList(MDIChild = True) 4. frmOptions(MDIChild = False) The Startup Object is Sub Main...

Does Anyone Have the Web Address to the Visual Basic 6 Reference Section on Microsoft's MSDN Site? I can not find my link. Thanks In Advance!!

I have DataGrid1 based on a ADO Recordset that displays Each Account and Some Info about that Account. So each row is a different account. In column 1 is the account Id (CON_ID). In the double click event of DataGrid1 I have placed Form2.Show and want this to display information for The...

markphsd, Thankyou for your suggestions. I'm not sure what cuneiform is. I've heard of an OCR called Cunneiform but, thats it. Can you inform me on what it is? Thanks

BRIEF DESCIPTION OF THE PROBLEM: Trying to create an appoinment scheduling program and running into a problem if on a given date there are two or more appoinments that have some overlapping time between them. If there is only one appoinment during this time, display the data in colored...

I can Not Change the RowSource Propeety of a ListBox. Main Form = frmSchedule - Unbound SubForm = sfrmDayView - Unbound ListBox = lstDay - Unbound - RowSorceType = Table/Query The code: strlstDayFill = "SELECT tbl.Time.TimeConverted FROM tblTime" With...

Does anyone have any suggestions for setting up an appointment schedular? One Idea I had is as follows: tblDate with Date Field(PK) populated by Function to x Years in the future as ShortDate tblTime with Time Field(PK) populated on 15min intervals for 24hr Day as SWhortDate, and Date Field...

Does anyone have any suggestions for setting up an appointment schedular? One Idea I had is as follows: tblDate with Date Field(PK) populated by Function to x Years in the future as ShortDate tblTime with Time Field(PK) populated on 15min intervals for 24hr Day as SWhortDate, and Date Field...

I have tried inserting the following. Still Asking for 1 Parameter. I have form open and set to a contactID. Still can't get it to work. Any suggestions. Set rs = db.OpenRecordset("SELECT tblContacts.contactID, FROM tblContacts WHERE...

When I run code that contains the following line: Set rs = db.OpenRecordset("Query1", dbOpenDynaset) I get a Runtime error 3061 - Two few parameters. Expected 2. Can anyone help? Why cant I use the query?

If I use the Split Function on the string "one two thre", Is there a way to to create a RecordsetSet with the records: one two three Then If I wanted to refer to the record "one" how would I do that. I have tried. Debug.Print rs.Item(1) and it says Method or Data member...

What if the array ellements are strings. Such as using the Split Function on the string "one two thre" delimetter = " ". I want it two return the value of 3.

How do I determine the number of elements in array?

If I use the Split function to create an array called aryName using " " as the delimitter, how do I combine the elements to give me each combination, including single elements, of the array. For example the string "oooo nnnn eeee" would be split into oooo nnnn eeee I only...

When I run my module that contains the .Edit command it gives me a compile error and then highlights the .Edit. With rs .Edit !LastName = strLast !FirstName = strFirst !MI = strMI .Update...

I have SQL Statement for a query: SELECT Trim([p_name]) & IIf([p_name]<>&quot;&quot;,&quot; &quot;) & Trim([f_name]) & IIf([f_name]<>&quot;&quot;,&quot; &quot;) & Trim([m_name]) & IIf([m_name]<>&quot;&quot;,&quot; &quot;) & Trim([l_name]) & IIf([s_name]<>&quot;&quot;,&quot;, &quot;) &...