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

...2 Fields: myfield1 (text) and myfield2 (text) 4. put in sample data 5. click on File -> Export; File name = Table1, Save As type = XML (*.xml) 6. Data (XML) is checked 7. click on Export and error appears Action 2: Created a module with the following code and ran it Sub...

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

...----------- workid workdate employeeid tblhours fields ----------- workid hoursworked SQL: select tblemployee.name, sum(tblhours.hoursworked) * (1-ABS(SIGN(dayofmonth(tblwork.workdate)-1))) AS Jan, sum(tblhours.hoursworked) * (1-ABS(SIGN(dayofmonth(tblwork.workdate)-2))) AS FEb...

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

...Common Dialog Control) on the form sDialogTitle = "Open..." s_excelfile = GetFileName(oDialog, sDialogTitle, "Excel Spreadsheet (*.xls)", ".xls", 1) If s_excelfile = "" Then MsgBox "I cannot continue unless you provide the location and file...

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