Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by pewilson

  1. pewilson

    Remove/Add UserControls from Main Form

    I have 5 other usercontrol forms that are being used. That is why I chose to reference the current UserControl to the ItemPanel that way I could pass the ItemPanel through the RemovePanel procedure. Paul paul_wilson74@hotmail.com
  2. pewilson

    Remove/Add UserControls from Main Form

    I am having trouble getting one usercontrol to remove and adding another usercontrol onto my main form. This was working like it was intended just last week I have included the code for the main form "frmMain" and the code from the report Search usercontrol "ucReportSearch". The code fails when...
  3. pewilson

    User based Security similar to SQL Server Security

    I recently was moved onto a new project team and one of the areas I need to research is User based Security. The client wants to manage the Users, Users Groups, and the settings permitted by each user group. They don't want to mange through database security (SQL Server) but to set up a field...
  4. pewilson

    Another IIS 5.1 and XP Pro upgrade problem

    I recently upgraded my laptop from Windows 2000 Pro to XP Pro. When I go into my IIS panel everything looks fine but when I try running my asp pages my machine will not recongized the extension. I have read some of the documents on the internet about inserting my xp cd and re-installing IIS...
  5. pewilson

    Transfering info from Access to an Excel Sheet

    Here is a link to a thread I started months ago that will help you indirectly. It something to consider thread705-362853 Paul paul_wilson74@hotmail.com
  6. pewilson

    Transfering info from Access to an Excel Sheet

    I think you may have trouble trying to export data from three different forms into one Excel sheet. Because data from one form will override the data from the previous form. (ex. Case 1 will override NewJob). But my question to you is all the data from the forms saving on one sheet or on...
  7. pewilson

    SQL Statement Problem

    Thanks Everyone! By changing the * to % work just fine. Thanks again Paul paul_wilson74@hotmail.com
  8. pewilson

    SQL Statement Problem

    I have a SQL string that is giving me a problem and I'm not quite sure what is wrong. It's not returning any values, so I'm not sure if my syntax is incorrect. This is the SQL statement in question. Any and all help is greatly appreciated. Thank you With rst.Open "Select...
  9. pewilson

    Exporting multiple recordsets into multiple Excel sheets

    Stew, thanks for the info! I have fixed my code and it works fine until it gets to Set wksFashionAccessories = wbk.Sheets(&quot;Sheet4&quot;)<--- Error occurs here. I get a Subscript out of range message. Is this happening because when I create a new workbook only 3 sheets are created? So Im...
  10. pewilson

    Exporting multiple recordsets into multiple Excel sheets

    Sub CopyToExcel() Dim conn As ADODB.Connection Dim rstAtHome As ADODB.Recordset Dim rstExTracts As ADODB.Recordset Dim wbk As Excel.Workbook Dim wksAtHome As Excel.Workbook Dim wksExTracts As Excel.Worksheet Dim StartRange1 As Excel.Range Dim StartRange2 As Excel.Range On Error GoTo...
  11. pewilson

    Exporting multiple recordsets into multiple Excel sheets

    I need to figure a way to export 12 files from my database into one excel file onto 12 different sheets. I know how to use the DoCmd.Transfer method, but I would like to use VBA to export the data and to have it start at specific cells. I know how do it for one, but not for multiple recordsets...
  12. pewilson

    Help with Delete SQL Code

    I actually found what the problem. I was referencing the wrong primary value in the SQL statement. I took that SQL statement from another area and neglected to change the primary value [FirstOfCompany Number] to [StoreID]. But it works fine now. Thank you for your help! Paul...
  13. pewilson

    Help with Delete SQL Code

    I am setting my value for txtID from a listbox. txtID = lstView.Column(0) Paul paul_wilson74@hotmail.com
  14. pewilson

    Help with Delete SQL Code

    I am having trouble with the following code. When I hit the delete the record I get a runtime error stating that &quot;No value given for one or more required parameter.&quot; Can anyone see what I'm doing wrong? Thank you in advance. Private Sub cmdRemoveTop10_Click() Dim rst As...
  15. pewilson

    Sending a HTML letter through Access in code..Help!

    I currently have a module sent up in my Access database that sends a pre-fabricated letter. It works just fine. But I am unable to format(such as bold,underline) words in my letter.But is there a way to format the letter in code using <HTML> tags? If so, could anyone post a sample code how it...
See more

Part and Inventory Search

Back
Top