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!

Search results for query: *

  • Users: pewilson
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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 "No value given for one or more required parameter." Can anyone see what I'm doing wrong? Thank you in advance. Private Sub cmdRemoveTop10_Click() Dim rst As...
  7. 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...
  8. pewilson

    Importing Text File Problem

    I am having difficultly importing a text file into Access through an automated process. I have a form created with a button that will run the process. I'm not understanding what information is needed to provide the DoCmd.TransferText acImportFixed, SpecificationName, TableName, FileName...
  9. pewilson

    Massive Insert Statement not working....Help!!!

    I inserting data into a table, but I think my sql string is way too long! The syntax message I get is &quot;Syntax error in INSERT INTO statement.&quot; Im not sure if I need to break it up, what method would I go about breaking it up. I am including the sql string in hopes that someone can help...
  10. pewilson

    Insert SQL string problem

    Hello, I am inserting two values from my form into one value in the database. I am allowing users to select the time from a Option list name=&quot;cboDepartureTime&quot; and select AM/PM from another Option list name=&quot;cboTime so I end up with a value of 3:00 PM. My browser will error out on...
  11. pewilson

    Private variable is not accepting date value

    I'm not sure if anyone has come across this problem, but in my Property Let in my class module is not accepting the date value that Im passing from the form. Im actually doing this project in VB, but I thought someone from this forum could lend a helping hand 'Class Module Private...
  12. pewilson

    Private variable is not accepting date value

    I'm not sure if anyone has come across this problem, but in my Property Let in my class module is not accepting the date value that Im passing from the form. 'Class Module Private mvarControlDate as Date 'Declaring private variable -----------------------------------------------------------...
  13. pewilson

    Bolding words in an Email Body

    I have a created an email letter using Outlook reference in my database and it works fine. But I would like to know if there is way to BOLDwords or letters in the middle string when I preview the email. Is this possible? Sample: strBody = &quot;My Text goes here&quot; & vbCrLf strBody = strBody...
  14. pewilson

    Converting Access Report to Rich Text File

    I am using the doCmd.SendObject,,, command in Access 2000 to send an Invoice I've created in the database. I have elected to the report as a Rich Text Format when the customer receives it. However, when I open the attachment the company logo (.jpg image) is missing. Is there a way to preserve...
  15. pewilson

    Unable to Populate DataGrid with ADO.....Assistance Please

    I have a form with ADO code and when on load, the customer data should populate the DataGrid. However, when I go to run it, the DataGrid is empty. Any suggestions? All the help will be greatly appreciated. Paul Here is the Code: Private Sub Form_Load() Dim rsLoadCustomer As ADODB.Recordset...
  16. pewilson

    Synchonizing (2) ADO Data Sources on (2) Different Tabs

    I would like to display my data using the datagrid by synchonize two ado data source on two different tabs by the Customer ID. I tried setting the where clause portion on the adoCustomerHistory to adoCustomerHistory.customerID=adoCustomer.customerIDBut Im running into errors. Im still learning...
  17. pewilson

    Using SQL 7.0 Personal Edition without the use of a server

    I was told that I could install SQL's 7.0 Personal Edition on my Win98 without the use of a server. Is this at all true? If so, any suggestion in how to install it without confusion. Thanks in advance. Paul
  18. pewilson

    Displaying fullpath filename and query name on reports

    I would like to display the fullpath of the file name where the report is located and on some reports I would like to show the query name on my report footers. Can someone show me how to achieve this? Thanks in advance. Paul
  19. pewilson

    Clarification of incrementing a numberic portion of a string

    I really want to create a primary key similar to D-1001where part is &quot;text&quot; and the other part is &quot;numberic&quot;, but I found an sample code that will give the results that I am after. But I do not fully understand what's going on here. Private SomeField_AfterUpdate() Dim StrMax...
  20. pewilson

    Primary Key Function

    I am trying to utilize a function to create a primary key value of D1000 or D-1000 each time an entry is made into my customer table through a form. Can someone provide a example in how a function like this is to be created? And under which event this would take place? Thanks in advance. Paul

Part and Inventory Search

Back
Top