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

I wanted to add to this: Some of the new fields are "filler"s, with a "0" in each. Another one should a number in it that is matched to a specific code.

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

Thanks! I will try the combination of both, tomorrow. And, let you know if this worked. One more point to make, this is for a database app. that is going on a PocketPC. When the handheld is not synced up, I am guessing this could be a problem if two users tried to "assign" a...

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