Recent content by tinkertoy

I am stuck! My query is done, and works great! I can export/run it to Excel, and get what I need for my OrgPlus program. I need to automate the process. I haven't dealt with query processes, or nVision at all. I can create reports in Crystal based on a query, set up the component, page...

I have done all that. I went into our development DB, and do the same procedures, and actions, and get the correct message. So I tracked it down, in that code, and in the related db. I have the message catalog info, and number, which didn't exist in the catalog, so it defaults to the message...

I created a new message in the message catalog, using 25000, 1 - 12. According to the training and instruction I had, 25000 was OK to use for custom messages. Well, apparently not the #1 message. When a user, including myself, makes a change or edits a Job Data (or other page), and then...

I have a multiple page Orgchart, I am going to post to the web, everything is OK, the Visio Viewer is embedded to it also. In the application, to search for specific text, a name, I just click find or ctrl/f, and can search on all the pages. Any ideas on how I can do with a command type button...

I don't want to involved in this post on my problem. Briefly - Record has 3 fields, new, one is a checkbox, Y or N, N is default. PeopleCode behind it on FieldChange, If box is N hide the other two fields, if Y unhide. On page, the fields show up, until I check then uncheck the checkbox. I...

On occasion a user will want to add more comments than the field will allow. What do I do to do this: 1. Button to open Word and blank document 2. Add additional information for this record. 3. Close/Save with the Record case name and link to this record? 4. Button to open linked...

Thank you - it looks great and reads like it will work - but, in step #4 - what is the 'sub other form'? and in the record source the object in the brackets [OPENSYSTEMCUST] what do I use, my qrySearchBarcode? I have the code figured, I think behind the search button, on the line MySQL =...

I have searched and this doesn't seem to come up anywhere. I want to search for a barcode from two different tables, the field name is only slightly different in both. The tables are related by the Primary key field from the Main table, MediaID. I know I need to create a query that joins the two...

Looks like I was still getting some great replies - thanks everyone! I am using all the replies for different types of things for my resources. Thank you! PS - I am a MS SQL person, not Oracle.

I am creating a new module in PeopleTools. It is actually a modified version of Company Property. I have a new field in it called ArmoryID. I would like the field to do an auto-number thing when a new record is created. This field will be about 10 characters long, and a number, of course. I...

I have a field that comes across blank there is no data, but in the query, if the field is blank I want to force a specific string into it. I tried IsNull and IIf expression, and a combination of, but, I get a data type error or no data at all. The field is a Date/Time Field, and if it is Null...

I am creating a module that will track transfer requests by employees - An employee makes a request to transfer to one or more depts. I need to track the date and the department by employee, and additional other information. I got the record part, page, component, menu, etc. But the code that...

I have a query created, that lists employees, home addresses, city, zip, phone, job location, job. This is for a disaster plan in a very large county that is split by a mountain range. My question is in the query, I want to be able to run and get all data, but also identify what area the zip...

I have a database that resides on a server, that will be shared with others. The others will be accessing the database from a PDA that will be synchronized either wirelessly or when back in the cradle. The database is converted to the PDA database program, and in order for it to synch up, the...

Query is built, all fields set up with formatting, etc. All fields are now text. Query is a make table query. The new table is then to be exported to a fixed length .dat file. This is for an existing Organizational Chart program, until we can complete the OrgChart from our new PeopleSoft...