Search results for query: *

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

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

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

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

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

I am trying display the elapsed time when an action query is being ran. The problem I'm encountering is that when the query runs, the form is not updated. I placed Me.Repaint and Doevents but the text box will still not update. ---- FORM1 ----- 'I have a text box called ElapsedTime and a button...

Hi. I have a requirement that the software that I wrote in access 97 needs to be disabled say in 30 days. Would you happen to know of a property that maybe useless which I can toggle and place perhaps a date? For example: dim dbs as object, sProp as string, sDate as string sProp =...

Hi. I have a requirement where the keyboard and mouse needs to be locked. I don't know if access (any version) is capable of doing this. Thanks in advance! Jason

Hi. Any ideas where EXCEL will not open up with the shell function? Here's my code: dim s_file as string, retval as variant s_file="c:\test\excel file.xls" retval = Shell("EXCEL " & Chr(34) & s_file & Chr(34), 3) When I run this on A2K full version or AccessXP, it...

Hi! I'm trying to use the FileDialog object. In my References I have "Microsoft Access 10.0 Object Library" checked. Part of my code is: Dim fd as FileDialog When I compile, I get a Compile error: User-defined type not defined for the code above. Thanks in advance! jason

Hi. I have a requirement where on my report I need to fit say 13 columns per page, total of 5 pages. The problem is due to the data in the fields (without spaces), the 13 columns won't fit on 1 page. I am wondering if there is a way to manipulate the page setup. For example, in Excel, I can...

Thx, Jason

Hi! I have a sql statement: SELECT * FROM tbl_ActiveFreight WHERE left([FILE_NO],2)="14"; On my PC, when I run the query it gives me an error: Function is not available in expressions in query expression 'left([FILE_NO],2)="14"'; On another PC, the query works fine!?! On...

For packaging an access distributable, I'm using the runtime in MOD2000 SR-1 which works fine if the user has Admin priveleges. Has anyone tried using another application to create their distributable? If yes, how are the files registered and which files (ie dll's, etc.) are required?

I need to connect to a network resource "\\servername\sharename" but the thing is that I need to provide a username for the resource since the current user logged on to the machine does not have the proper access domain rights. I came across an API (please see below) however I can...