Search results for query: *

You mean there is no record source? Are the controls bound at all? How is a record saved? Can you give an example of code to read the data? Thank you.

I'm using Access 2007 and SQL Server Express 2008. I have created an Access Data Project and a SQL Server database. I seem to be able to make a query for my forms' record source just like regular Access and it reads and updates my SQL Server tables. But I want to use a stored procedure...

Hello. Nevermind. I think I figured it out (not sure).

I am a newbie to Access 2007 FE/Sql 2008 Express BE and I would like to know how to create a form in an Access ADP that is bound to a stored procedure. I migrated some tables and data to Sql Server successfully. I created an Access Data Project. I went back to Sql Server and created a stored...

Is it possible to pivot a multi-column table? All the TRANSFORM examples I find just use 1 column. So, for example, you have tblPersons personid/height in inches/weight in lbs/age in yrs 1/72/185/32 2/64/129/43 3/69/167/37 I need a query that will do ...........person ...........1/2/3...

I tried it and I got this message Connection failed: SQL State: '28000' SQL Server Error: 18456 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'

I am a newbie using the Upsizing Wizard in Access 2007. On the second screen, the one where it asks you what server you want to use, I get a message which says among other things 'Login failed for user 'User''. I enter 'User' in the user field and leave the password field blank. I did it that...

Thanks for your help. None of the tutorials I looked at showed (local}\SQLEXPRESS.

I get a message which says among other things 'Login failed for user 'User'. So is it the password? When I turn on the computer I don't enter a password. How can I find out what my password is? (if that's the problem.)

I put in: What SQL Server would you like to use for this database? (local)\SQLEXPRESS Please specify login and password ... <blank> Use Trusted Connection Login ID: User Password: <blank> What do you want to name ... associates_beSQL

This is my first time using the Access 2007 Upsizing Wizard to convert an Access to SQL Server Express and it is going nowhere. I always get a Connection Failed error after the second screen. I have tried typing in "(local)" and "SQLSERVEREXPRESS" for What SQL Server would you like to use for...

I have a 2007 database which has forms and tables. But only the tables appear in the Navigation Pane. Where are the forms? I read the help about the navigation pane and it doesn't say how to make the tables appear in the list. How?

This is just one example: Me.fld1.DefaultValue = "ccc" fld1 is both a field name and a textbox name. No matter what I try, it doesn't work but it works it I put it in in the data tab.

I have a form with a text box which is bound to a table field which is a text field. If I set a default value for this field on the properties it shows up correctly for a new record but if I set a default value with code I get #Name for a new record. What am I missing as far as setting default...

You mean acDialog in the openfrom statement? I tried that but the form would not position (with MoveSize).

I have a menu form which opens another form beside it. The other form extends beyond the width of the screen. If this form is set as a popup form, no scroll bars appear at the bottom of the screen. If it is set as popup = no then scroll bars will appear (I know this because I opened the form...

It's seems that the forms on a database that I am working on are maximizing on being opened even though I do not issue Docmd.Maximize in the on open event. I have even copied a form that has no maximizing command in the on open event from another database into my database and it maximizes on...

Popups are working now. Thanks.

It's working now. Thanks.

Thanks. (Thank=you popups not working)