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 Rhinorhino 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: *

  1. CaptainBob007

    Paragraph Symbols

    Hello, I'm working on a system to parse XML files we receive from a client and transform them to HTML. One of the characters contained in this XML file is the "paragraph" symbol, which I will show: ¶ The file is standard XML 1.0 in UTF-8. I can't figure out for the life of me how to get C#...
  2. CaptainBob007

    intellisense not recognizing functions in .dll

    Hello - So I have a class "ErrUtil" (which is also the project name) that is compiled as a .dll, and am trying to incorporate it into a new solution I am developing. I have added a reference to ErrUtil in my new project, and also have "using ErrUtil;" in the file, yet when I try to access a...
  3. CaptainBob007

    Set combo box by hidden column

    Hi - I have a combo box with 2 columns, the first one is hidden and the second is not. So a user can select an address, and the (hidden) ID for the property is selected behind the scenes, and the form works beautifully. Now I am trying to open this form from another form by passing in the ID...
  4. CaptainBob007

    Conditional Formatting based on Date

    Hi all - I'm using Access 2000, and am working on a form for data entry and I'm trying to input some automated date comparison. I have it implemented, but it's not behaving as I think it should. I have a text box, with the short date format, and I'm inputting a date into it. I have...
  5. CaptainBob007

    Confirming a compile has completed?

    Hi - I'm working on making a database to track nightly builds with ant, and am trying to figure out a way to log whether or not all files compiled successfully. This wouldn't be that hard if the javac task had a 'errorproperty' or 'ailureproperty' attribute, but from my readings, it does...
  6. CaptainBob007

    Subquery with ORDER BY

    Hi all - I'm having a little trouble with a subquery and I'm not sure why. Here's what I'm running: SELECT DISTINCT tblPermit.PerID, tblProperty.AddNum & " " & tblProperty.AddStreet AS Address, tblPermit.Description, tblPermit.PerNum, tblProperty.AddStreet, tblProperty.AddNum FROM...
  7. CaptainBob007

    Date Formatting in SQL

    Hi all - Ok, this is a problem with a form, but I believe it stems from SQL. I have a SQL function which calculates a date and inserts it in a table using "Now()". The field on the table is set for "short date" formatting. When the record is called up later, it is displayed in a text box on...
  8. CaptainBob007

    Field-Dependent Query

    Hi - I'm not sure how exactly to classify this type of query or how to implement, but I'll try to explain what I need as best I can and hopefully somebody will understand. I have a table of complaints. Each complaint (simplified) has the following fields: CaseID Problem Complainant Notes...
  9. CaptainBob007

    Trying to populate an unbound form

    Hi everybody - I'm working on populating a form in an unbound database for keeping tack of municipal vehicle stickers. I have successfully written a way to search vehicle owners (via a form) and am able to selectg the correct record and have it populate an "edit owner" form with all the...
  10. CaptainBob007

    data dependent format in listbox

    I'm working on a search form, and am trying to figure out how to format the data to populate a listbox the way I want. Let's say I have a view that selects 4 fields: OwnID, OwnLast, OwnFirst, and Business. I want to populate the list box with 2 fields, OwnID (which will not be visible), and...
  11. CaptainBob007

    Incrementing dates

    Hi all - I'm working on a system which issues licenses, most of which have specific lifespans (3 months, 6 months, etc). Right Now I'm having it calculate expiration dates by adding days, however depending on the length of the months, the number of days will obviously vary. Is there a way I...
  12. CaptainBob007

    Adding character to existing field

    I have an existing database with a text field that is 5 characters long. In my forms I have it masked to appear as 00-000 where the 0's represent any number 0-9. Due to poor planning on my part, I'm going to need to add another digit so it appears as 00-0000. In other words I need to insert...
  13. CaptainBob007

    Premature Ascii "reading"

    Hi all - Ok, I'm working on an ascii offset encryption procedure, which changes its offset after each character (so its much more difficult to figure out), and its working fine for encrypting strings of any size. When it comes to decrypting, however, the problems start. Undoubtedly some ascii...
  14. CaptainBob007

    Assign passed value to combo box

    Hi - I'm working on a form to store pictures associated with given properties. The picture part of it works fine, I'm trying to figure out the association to a property now. In my first form, I have all the details about the property, with primary key PropID. The address of the property is...
  15. CaptainBob007

    Adding multiple values to a subform

    I'm working on a system that references addresses to property numbers (PINs). A given address can have more than one property number, so I have a table of properties (tblProps) with primary key 'PropID', and a table of Property numbers (tblPins) with primary Key 'PIN' and the 'PropID' field as...
  16. CaptainBob007

    Data Type Mismatch while editing in DAO

    Hi - I have a rather simple form that should run some rather simple code, but I keep on getting an error - more on that later. I have a form with a field PerNum, where a permit number is entered. Once it is entered and the appropriate button clicked, the record with the corresponding permit...
  17. CaptainBob007

    Listing missing external files

    Hi - I have a form used for lookiup up properties. It displays the owner name, phone number, address, and a photo of the house at that address. The photos are in external files, called by a text field called ImagePath, which is made up of the street and address numbers. If the photo is not...
  18. CaptainBob007

    Function with SQL

    Hi - This probably simple, but I can't figure it out for the life of me. I'm attempting to add some user-level security to a database I'm writing, and I have a table tblUsers to hold this information. One of the fields in that table is UserLevel, which is the access level of the user. The...

Part and Inventory Search

Back
Top