rmurgia
Last Activity: Jul 1 '12, 08:13 PM
Joined: May 17 '08
Location:
-
Ok Thanks. I guess I should post this in the Javascipt section. -
Jared,
Thanks for the reply. Actually, when I said cursor, I meant the mouse pointer on the screen. The user can only update one of the fields on this screen called Supported, to indicate if a particular make and model series is supported. The update works fine but when the screen is redisplayed, we have and issue. Here is the code used after the user updates the data to re-display the screen:
...Code:strSQL =
Leave a comment:
-
Move Cursor to specific record
I create a form which displays records in a list and allows the user to click on the last field of each record to update it. After the record is updated, the form is refreshed. The problem is as follows:
Let's say there are 5 records dislayed as listed below. By clicking REP on Model A, the field Supported is changed from Y to N. After the form is refreshed, it displays properly, but the cursor does not stay on the record worked... -
I appreciate your input. There may also be some cases where I would use that method....Leave a comment:
-
Correction: It did work with the view. I was not typing the view correctly. Thanks for the solution. The query is running much faster!...Leave a comment:
-
Yes, this would do it but there are too many different choices the user could make....Leave a comment:
-
Okay. That works but it can't read a View. Does the passthrough query only work with tables?...Leave a comment:
-
That is what I am currently doing, but the queries against such a large table take long to run. I felt if I could pass a parameter to a function in SQL Server, the data would be queried in SQL Server rather than in Access and would run faster. Lets say you had a table with 12,000,000 records, but the table in access only needed records belonging to a particular group which made up 1000 records in the table. You could create a view which selects...Leave a comment:
-
Link MS Access to SQL Server Table-Valued function to pass parameters
I am linking Access to SQL Server to extract data from a table containing over 12,000,000 records. I would like to pass a parameter to SQL Server to be used on the table-valued function assuming that extracting the data in SQL Server would run faster than in Access. I created a table valued function in SQL Server, however, when I go to Access to create the linked table, I only see tables and views. Does anyone know any other way to pass a parameter... -
SSIS Taking to Long in Pre-Execute phase after switching to Access 2007
We were running SSIS to transmit data to Access 2003 databases using OLE DB connection, Microsoft Jet 4.0 OLE DB Provider. We recently switched to Access 2007 and now use the OLE DB Connection with Microsoft Office 12.0 Access Database Engine OLE DB Provider. The Pre-Execute phase now seems to be crawling. We switched DelayValidation to True in all of the connection objects and changed all of the SQL select statements to stored procedures passing... -
Thanks for the response. I think the code you suggested must be a variation of what I was using. I tried it and got the same message. When I set up a successful link for Oracle, I had to set something up in an Oracle file called tnsnames.ora. Could there be some such equivalent requirment to link to MYSQL?Leave a comment:
-
Cannot create link from SQL Server to MYSQL
I created a System DSN called RunzLink. It tested successfully and I was able to create a linked table in MS Access with it. I created the following linked server in SQL Server:
I got the following error:Code:EXEC sp_addlinkedserver 'RunzLink', 'MySQLDatabase', 'MSDASQL', 'ikonnect.ikon.org' EXEC sp_addlinkedsrvlogin 'RunzLink', 'FALSE',NULL, 'UserName', 'PW'
Cannot initialize the data source... -
How do you programmatically import an XML file to an Access 2007 database?
Does anyone know how to programmaticall y import an XML file into an Access 2007 database? I was thinking along the lines of DoCmd.transferT ext, but could not find an XML option. Thanks in advance. -
Issues Creating an Access Report Programmatically
I am trying to create an Access report programmaticall y. So far I have been able to accomplish everything except the following:
1) I cannot determine the code to create a Page Footer
Gave the following Error:Code:Set TextBox = CreateReportControl(strDynamicFinalReport, acTextBox, acFooter, , strFieldNM, intFieldPos, intFieldLine, intFieldRptWidth, intFieldHeight)
Error Number: 2148 The number you used to refer to... -
Thanks for the response. I tried re-arranging a few lines of code and everything seems to be working.Leave a comment:
-
How to blank out a field before re-loading the page
Hello,
I have a situation using VBScript where I read a table of valid serial numbers and if the serial number cannot be found, blank out the serial number field, display an error message, and reload the page. Listed below is some of the code which would be issued after the valid serial number table is read. ( The error message display is left off since that code is working.)
Serial # field:...Code:<input type="text"
Last edited by jhardman; Mar 28 '10, 04:12 PM. Reason: added code tags. please use code tags in the future -
Meganjen,
I tried your solution and it works perfectly. Thank you! ChipR and Megalog, try this one.Leave a comment:
-
Megalog, ChipR,
I checked the Access Resources and got the following:
Microsoft Office Access 2007 (some #) SP2 (some similar #)Leave a comment:
-
Here is all of the information regarding my operating system:
Microsoft windows XP Professional Version 2002
Service Pack 3Leave a comment:
-
Access 2007 Buffer issue makes scrolling objects difficult.
Has anyone noticed that scrolling through objects i.e. forms, reports, tables, etc with Access 2007 is not as easy as Access 2003? I have a database with a large number of objects. When scrolling through with the down arrow or page down, it seems that items get caught in the buffer making scrolling through large amounts of objects cumbersome. After taking my finger off the key, the cursor continues to move. If I push down and let go quickly,...
No activity results to display
Leave a comment: