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

  • Users: pdupreez
  • Content: Threads
  • Order by date
  1. pdupreez

    How can I relate a table with a itself but with an offset

    I do not know if my question is clear enough, so please bear with me: I have a table with the following fields of information: Year[tab]Month[tab]ClosingStock 2009[tab]1[tab][tab][tab]1000 2009[tab]2[tab][tab][tab]1500 I want to calculate what was produced, and that is done by subtracting the...
  2. pdupreez

    Perl - Google Reader

    I use Google Reader (RSS aggregator?) a lot to capture interesting links and store them as "starred" for later processing. What I am looking for is a way to get all the links in the starred items, create a new html page (if necessary), spider through all the links within that new page and...
  3. pdupreez

    Lotus Notes - Detach and Save Mail Attachments

    I have been trying to extract all mail attachments from my Lotus Notes mailbox. I found the code below on perlmonk, and it works fantastically, other than for one small problem. It only saves the first attachment from the mail, and seemingly ignores the rest. I have looked everywhere to try...
  4. pdupreez

    ABB Freelance

    Does anyone have any ideas on how we can integrate data from a Freelance PLC (1996 vintage) to inSQL?
  5. pdupreez

    User File Directory Settings

    I always partition my HD into c: and D: and place all my user documents in the D: drive. However Windows insists on c:\Documents and Settings\... for all users. This includes the My faxes, documents, pictures etc. How do I ensure that it never looks in the c: drive for any documents but only on...
  6. pdupreez

    How to create form (datasheet view) populated with set of data

    I have group of employees for which I want to add daily working hours, leave sick leave etc. I want to select the start of week using a combo box (done already). This should then populate a subform in datasheet view, filled with all active employee's name, number and the relevant fields such as...
  7. pdupreez

    Report output to Excel causes NULL error in OfficeXP in Sum(XYZ) field

    I have a simple report showing daily despatches per month, including totals per day. When I export the report via VBA using DoCmd.OutputTo acOutputReport, "rptdaily", acFormatXLS, "C:\temp\rptdaily.xls", False, I get an #NAME# error in Excel(XP), which causes Excel to restart...
  8. pdupreez

    Graphs (Charts?), Forms and Real Time Updates

    I would like to have a form with a combo box, indicating the field names in a table. After the user selects a field a graph (defined in an unbound object frame) must be displayed using two fields, of which the selected one from the combo box , is the y-axis data. I can however not seem to update...
  9. pdupreez

    Reset Great Plains User

    Does anybody know how to reset a user that has forgotten his password to a standard/default password? Regards Pieter
  10. pdupreez

    How to select Duplicate Records on 50 fields

    I have a table with 51 fields, and I could have duplicate records where the values of all 50 fields might be the same. I need to exclude those records from my select query, but cannot use two copies of the same table joined on each field (Query too complex error) and distinctrow does not work...
  11. pdupreez

    Multi Column Forms

    I have form with a subform, and the subform will have multiple single field information on it. The problem is that the data in the subform is all in one column, making it look akward, as the main form is much wider than the subform. Is it possible to have multiple columns of the same field, with...
  12. pdupreez

    How to trap a key violation error in Code?

    I use an "insert " sql statement, and sometimes enter data into the table which already exists. No problem if I can trap the Access97 error box that comes up if an append/update error occurs. I cannot however seem to trap the error, even with an "on error" routine. Any Ideas??
  13. pdupreez

    Excel Hyperlink to Access

    Hi Can anybody help me transfer Hyperlinks from Excel to Access? It transfers the hyperlink descriptor, but not the actual hyperlink? Regards Pieter
  14. pdupreez

    Adding multiple records without having to enter repeating info

    I wish to create a data entry form, where the user will enter production data, per day. Fields are: Date PlantID SourceID TaskID ProductID PackingID HoursPerm HoursContr The Date and PlantID will be common for a number of records, and I do not wish to reenter each time, so I want the user to...
  15. pdupreez

    Page Break in Report, based on specific field value

    Is it possible to insert a page break when a header field changes to a specific content, and only then? Thanks

Part and Inventory Search

Back
Top