Search results for query: *

I got it to work!!!!! If comes across this thread, I hope it this will work for you as well... 1. Go to http://www.microsoft.com/downloads/thankyou.aspx?familyId=7287252c-402e-4f72-97a5-e0fd290d4b76&displayLang=en 2. Download Office 2003 Add-in: Office Web Components 3. Select the Reinstall...

Hi CMP, Thanks for your suggestion. I think you're right, there must be some .dll that is corrupt that the Office Install/Removal/Repair will not touch. Action 6: I created a XML map and applied to my workbook in excel and was able to create .XML data. Action 7: I also tried but got the same...

Hello. I'm trying to export my table to XML but get the message "Microsoft Office Access was unable to export the data" - Version 2003 / SP2 This is only happening on my laptop PC but I don't have this problem on my desktop. Any suggestions are welcomed? Thanks. Here's what i've tried: Action...

Geez, I was using the incorrect function. Supposed to be month and not dayofmonth. Regards.

Hello. I'm trying to retrieve the hours worked for each employee however i'm getting the total for the employee in a month. Example: Name Jan Feb Mar ---- --- --- --- Joe 0 480 0 Tony 0 0 480 Sue 480 0 0 Output that I'm trying to get is (each employee worked...

Hi Remou. Thanks for providing the link. I'll check it out. The main thing obstacles that I have: (1) retrieving the info (I have a solution as listed above but I don't think it's efficient) (2) updating the database Hi cmmrfrds. Thanks for your post. I understand your suggestion and will give...

Hi Remou. Thanks for your reply. The reason why those two are separate is that WorkDate is a redundant field. The tables can be combined (denormalized) but that defeats my objective. I feel that a complex SQL statement should do the trick, however, I just can't put it together to acheive the...

Hello. I'm trying to create an updatable recordset (DAO or ADO). Here are my tables: tblWork tblActivity ------- ---------- WorkID(PK) ClientID Date ActivityID(PK) Description 11 100 4/10/06 1...

Hi. I have a similar requirement. Any luck?

I have a similar requirement. I'm just adding on to this thread for those who may come across this: 1. Table - ensure that the Display Control property (found in the Lookup tab) of the Yes/No data type is CheckBox 2. Query - create a query based on the table and select desired fields. 3. Form -...

Hi. I have several apps written in A2K that extracts information via ODBC which are triggered at specific time intervals (via Scheduled Tasks). Problem is that if the extract fails due to an ODBC error, I tried to trigger the timer event of the form for it to wait and run again say in 5 minutes...

Geoff, Thanks for your suggestion. I'll re-post in that forum. Jason

Hi. I have several apps written in A2K that extracts information via ODBC which are triggered at specific time intervals (via Scheduled Tasks). Problem is that if the extract fails due to an ODBC error, I tried to trigger the timer event of the form for it to wait and run again say in 5 minutes...

Tom, Thanks! Jason

Hi Tom, Thanks for your reply. MS website is currently screwed up a bit since I could see OFF2000: Error Message When You Try to Display Help on a Microsoft Windows XP-, Windows 2000- or Windows Me-Based Computer but their link is not available. I think that VS manipulates IE somehow which...

Hi. My Visual Basic Help is not working properly. I can look up something fine, however, below say a certain topic, I do not see the links (like See Also Examples Applies To ). It was working fine before until I installed Visual Studio. I uninstalled Visual Sudio, removed MSO 2K and...

Hi paron, Thanks for the reply! I remember this... Listed below is what I ended up doing... Hopefully this could help others as well... Regards, Jason '----------------------------------- ' Code in my form '----------------------------------- Private Sub cmdCreate_Click() Dim oDialog As...

Hi nicsin, Thanks!!! It worked. Whoa, now I know that each field should be thoroughly validated. Crafty idea on the zeroes. Thanks for your help. Regards, Jason

Hi nicsin, Thanks for the reply. I tried it but still got the same error. Problem is that for some of the records, the RETURN_DT is actually null but for some reason, access won't process it. Jason

Hi. I'm trying to write a select a query but get an error message - "Invalid Use of Null" Table: tblBooks FIELD NAME TYPE BOOK_ID TEXT CHK_OUT_DT DATE RETURN_DT TEXT Sample data -------------------------------------------------- |BOOK_ID | CHK_OUT_DT...