Search results for query: *

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

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

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

This a two part problem - I have a ODBC link table that I am making another table from with a make-table query. The new table has some slightly different requirements. This table is to be based on the requirements that an application needs to run it, the data from that table will be export to...

My database was created from an Excel spreadsheet which was created from a text file. The date came across as such: "YYYYMMDD". The date field is "Request Date". In order for it to appear correctly I believe I need to create an update query, but I am unsure of what the...

Sorry about the subject. I wasn't sure how to shorten it. What I have is a customer with a shelving system that will be used to store CD-Roms and DVD-Roms. There are 8 doors(numbered 01-08), within each door there is 14 shelves (1-14), on the shelf there are 17 slots, each slot holds 5 jewel...

I have a query with the person and that person has a subform with their multiple status, active and/or inactive. The query is for the person ID number, active, and based on their most recent/current status date. I only want to show the most recent/current status, not older. The date of course...

I want to create a subform based on a query that reflects the following: Employee 1 - Code 1, Name - How many times Code 2, Name - How many times The tables are: tblCodes, tblEmployee, tblMasterFile (where the employee is associated with MasterFile and Codes)...