Search results for query: *

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...

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...

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...

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...

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;) &...

I have: Parent For = frmContactList Child Form = sfrmContactList Unbound Form = frmLookUp I want to change the recordset (originally based on qrycontactlist) from the unbound form Im having problems set a varilabe, stSQL, equal to SQL statement the qrycontactlist was made of. I think this is...

I have a combo box [cmbCompany] whose: Record Source = tblCompnay Row Source Column 1 = [companyID](Autonumber) Column 2 = [company] I have column widths set to 0;1.5 so only the [company] name shows. Bound Column = 1 I have Limit to list set to Yes. In the Not in List Event I have code to...

I have a form called frmContacts that uses contact_ID set to AutoNumber as the Primary Index. This form has a subform called sfrmContactNotes in Datasheet View that I have set to NoEdits, Deletions or Additions. I put a CmdButton, Enter New Note, at the bottom that opens a form where you can...

I want to create an Option Group with two (maybe more later) options as follows: 1 = Research Site 2 = Storage Location If research site is selected I want the combo to show the sites from the table tblResearchSites. If Storage Location is selected I want the combo box to show the...

I am trying to create a filter based on tblStoredStudies.site. I have created an unbound combo with the site names able to be selected. I have created a Filter button that when click should filter the results in my subform to show only the sites that match the selection in the combo box. When...