Search results for query: *

I ended up making a form with a subform that has the fields displayed from a query in the Data Source. Sad, because it was a lot quicker to create a view and then just open it. But if anybody knows how to make the view work, please let us know.

Disregard. I'm going to create a form that displays the table.

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

Looks like if I simply add an "Application.DoEvents()" inside the loop, that should do the trick. Thanks.

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

That last line, the tableadapter.update, stops and says "Update requires a valid UpdateCommand when passed DataRow collection with modified rows." Perhaps it has something to do with the Update command expecting a different "value" than me.dataset.table. So I'm trying to figure how to write...

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.

Great! That will do the job! Thanks PHV!

I tried that and several other ways, and the error is "91 object variable or with block variable not set". As I debug and step through, I notice that db, tdf, fld all have a value of "Nothing". It's like the way I'm trying to connect to these SQL connected tables isn't working the same as if...

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

It had the focus. I got it. Thanks all for your help.

Thanks, that & "" fixed the error messages. But the selection still doesn't occur. I can see all the text get selected for an instant, then it's unselected and the cursor is at the beginning of the field. I don't think I'm building the form wrong. Think it could be the setfocus?

Hi PHV, I've tried that and upon the very first time of moving to that text field when first running the form, I get "Run-time error '13': Type mismatch. If I leave the Me! off the front of the field name, I get "Invalid use of Null". Could setting focus be messing this up? After I do other...

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

Thanks for the informative link for Harnessing the Power. I didn't think that could be done. To describe a little better. If a form is showing data from multiple tables, and you want to edit some of the fields on the form, how can that be done? This is how I'm getting the data: Dim db As...

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

Remou, This is exactly what I needed. Thanks!

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