Search results for query: *

I have a 98 machine where I have a shortcut to a dialup connection that I created. When I invoke it I go right past the opportunity to enter a password, it attempts the connection and I get Error 691 incorrect password. I need to get to the Connect To window where I'm prompted for a...

I have a query that, when the results or the query are displayed in Access, I choose 'Save As/Export' to an external file, than specify .xls as the file type to export to. I get an error message "The Microsoft Jet database engine could not find the object 'MyQueryName'. Make sure the...

I have a button that runs a query that dumps the data in my tables to an Excel file. When the data in the tables is modified and the query is run again, the Excel file does not reflect the changes made in the table. I thought this would occur in real time, i.e., change the data in Access and...

I have a user who has a doc created using the newsletter template. When doc is printed the entire body of text appears underlined when it is not actually underlined in the document. Print preview shows the text as not underlined. My user would like this doc to print without the text...

I have an end user who has a dial-up network connection that goes directly to the 'dialing' window bypassing the 'connect to' window where username and password and phone number are asked for. I created a new connection for him from scratch thinking that the 'save password' box might have...

When I attempt to open a table with return all rows in Enterprise Manager, I get the following error: An unexpected error happened during this operation. [MS Design Tools] - Query Designer encountered a MS Design Tools error: ODBC error: [Microsoft][ODBC SQL Server Driver][SQL...

Sorry to bother with such a simple question, but when I open a table return all rows in Enterprise Manager, the sort ascending and sort descending buttons are grayed out. Would simply like to sort my table in ascending order. Have looked through BOL and don't see an obvious reason why these...

I have a table set up with a text field as my primary key. It is an Access front with a SQL back. My impression was that my user would get an error message if they tried to enter a duplicate entry in a primary key field. I have looked closely at the entry to see if there might be a space, a...

I have a report based on a query. If I run the query I can choose through Office Tools to export the data to an Excel file. What I would like to do have a command button on a form that would either run the report based on the query or just run the query, and have the resulting data export into...

This is a pretty basic question but I've had little success finding an answer in FAQs here or the books I have. I have a report header and I've set Force New Page before section in the hopes that I would have the header at the top of each new page. Unfortunately instead the header is printing...

They received the mail, saved the file to their hard drive, created a shortcut to it, and dragged the shortcut to their desktop. When they try to open it, it invokes Access then comes up with an error message "c:\ets\Inventory_be.mdb is not a valid path. Make sure that the path name is...

I used Switchboard manager to create a command key on my switchboard to exit the database. If I go into properties on the command button, on click, it brings up the expression builder, with =HandleButtonClick(5) as the expression. I'd like this command button to exit the Access app altogether...

I have an Access front and SQL Server back. I have a table Switchboard_Items that I keep trying to export to the SQL server. My idea is to get a login to the SQL server as the first thing the user sees before the switchboard form comes up when the .mde is invoked. Every other one of my tables...

I've got an Access front with a SQL back end. I notice that when you go from the switchboard to a form that accesses any of the SQL tables, SQL server gives you a login prompt. I'd like this login prompt to occur when the shortcut to the .mde is first invoked before the user even sees the...

Got my tables imported to my SQL server with DTS thanks to some help yesterday. Now, I have ODBC Data Source set on my client machine with User DSN, System DSN and File DSN set to my database with a SQL server driver. In SQL server enterprise manager within this database I have my user...

I have a SQL 7.0 server. I have used DTS to import tables from Access to the SQL Server. Now, don't I have to link my tables in Access back to the SQL tables I've created? Hopefully this is not a stupid question, but how would I do this? What location do I look for from within Access? The...

I have the following code on a command button that opens a form: Private Sub Delete_Location_Click() On Error GoTo Err_Delete_Location_Click DoCmd.OpenForm "frm_LocDel", acNormal, , , acFormDel Exit_Delete_Location_Click: Exit Sub Err_Delete_Location_Click: MsgBox...

I have an add record form, and after clicking on the command button to save the record, the cursor seems to disappear. I would like it to return to the first field in the form ready for another record entry. Anyone have any idea what I could do to make this happen?

I have a form that has a command button which opens another form. I want the second form to open on a new record to add. I have the following code on the command button on the first form: DoCmd.OpenForm "frm_LocAdd", acNormal, , ,acFormAdd Then on the second form, I have Data Entry...

When I go to view my relationships, I should have a total of 10 tables. However I am seeing two new tables being created in the relationships window for one of the tables, adding _1 and _2 to the name, and one new table _1 for each of 7 other tables. The remaining 2 tables don't do this at...