Search results for query: *

Hi all, Summary: The problem is the sort order in a view created from within Access 2003 to a SQL 2000 backend database does not sort properly on a SQL 2005 backend database. Detail: I have an Access 2003 app that uses a connection to a SQL 2000 backend. Some views were made with the query...

Hi all, Summary: The problem is the sort order in a view created from within Access 2003 to a SQL 2000 backend database does not sort properly on a SQL 2005 backend database. Detail: I have an Access 2003 app that uses a connection to a SQL 2000 backend. Some views were made with the query...

In Access 2003, and now in Access 2007, I've used the status bar SysCmd functions acSysCmdInitMeter, acSysCmdUpdateMeter, and acSysCmdClearStatus. I've noticed in both versions that while looping through commands and displaying the status bar, at some point Access seems to lose focus and the...

Hi all, I have a form with a datagridview (dgv) that's bound to its bindingsource, dataset, and table adapter. I'm trying to figure how to programmatically update rows/cells in the dgv with values from either a text box, or a row from another dgv. First case, for example, in a textbox on the...

I'm just not finding the spin button control in Access 2003 nor in searching the forums here. Not in the default buttons nor under "more controls". Is there a spin button control for incrementing a number value up and down? If so, how is it made available to place on a form? Thanks, Tom.

Hi all, I have an Access 2002-2003 project (.adp) that uses the SQL datalink connection to an SQL database (not "linked tables"). The tables work OK and are listed in Access as "tablename(dbo)". I need a way to get a list of fields in one of these tables. I've tried DAO methods, but get an...

Hi all, I haven't found in the threads yet how to do this exactly. Using Access 2003, if you enter text in a text field, then loose focus by doing some other code to say, display some records in a list box, then come back to the original text field, how do you get it to select all the text...

I've joined 2 local tables on a primary key and opened a recordset as part of a Form_Load sub. The form displays the text fields and I've added simple Previous,Next, buttons while learning how to display data and move through a table or query. I added an Update button to learn about editing...

Is there a function that will return the filename of the .MDB file that you currently have open?

Hi All, If I use CREATE Trigger NAME On TABLE For Insert, Update As UPDATE TABLE SET field = value FROM TABLE WHERE CONDITION... how can this type of trigger be changed to affect only the CURRENT RECORD that's being inserted or updated? I don't know how to tell the WHERE CONDITION (or any other...

Hi all, Using Access 2003 or 2000, I cannot keep focus on a form while it's looping through records and displaying the results/progress. It will start out fine, but after a while, it loses focus and continues to run, but I no longer see the results/progress. When I first run the form, my...

Hi all, If I want to prompt for several pieces of information like for example, a date, a last name, and an amount... and then return that input to the original form, what do I use to do that? Do I use a subform? Or an inputbox? For example, I imagine that what would happen when the button...

I have an Access 2003 .ADP file that I want to pass a couple parameters to when I start it up. For example "c:\code\accessprog.adp 'fred' '1234 bedrock'". When I run that, I of course first get the security warning because the file is not digitally signed. And I made the startup in Access...

I quickly wrote an applet that works. But I'm questioning if it's as efficient as it could be. Using Access 2000 as a front-end and SQL 2000 as a back-end, I use the "DoCmd.RunSQL sqltxt" command to SELECT, INSERT, and UPDATE data. The Access 2000 front-end is an Access project file .adp. I...