Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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