Search results for query: *

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

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

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?

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

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

Is there any way to concatenate a value onto a field as opposed to just overwriting it when using an UPDATE statement? Instead of UPDATE tblTable SET fld = "abc" WHERE fld2="b" I want UPDATE tblTable SET fld = fld & "abc" WHERE fld2="b"

My understanding is that replication has been eliminated in Access 2007. If so, what replaces it?

I know this is a strange question. But I would like to learn SQL Server where I work when it is slow. Management doesn't mind if you use the computer for personal stuff when it's slow but they have software installed on the computer that wipes out anything anyone has put on it whenever the...

How do I convert an Access 2002 backend database to SQL Server? Is there a tool for this? Or is that just in 2007? I have Access 2002 and SQL Server Express 2005.

I have an unbound combobox which has a value in it when the form is opened. It shows the same value every time. I'd like to get rid of this and just have a blank combobox like I have on several other forms when they are opened. Otherwise the combobox seems to be working fine. What causes a...

In a previous thread, I was advised by Lost500 to use the database tools tab to convert a backend Access 2007 database to SQL Server. Does this exist on Access 2002 or 2003?

Is there any way of converting multiple blanks in a string between words to just one blank?

I have a form with a datasheet subform on it. After pressing a button on the main form, some records appear on the datasheet. The top left cell of the datasheet is highlighted. I'd like to get rid of this. I have tried putting a dummy textbox at the left of the existing fields which does get...

I don't have Access 2007 on my computer and I was wondering if someone could explain to me what the ribbon does.

The following: =Format(datefield,"ddd") produces Sun, Mon, Tue, etc. Is there any way to make it come out all in capitals?

I have a Date/time field that contains a value like 5:00 PM. For space problems on a report, it want to print it as "5:00" omitting the PM. I also need to concatenate it to another field so Format(field,"h:mm ampm") and making the textbox short enough so the pm doesn't show really...