Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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