Search results for query: *

Hi, Never mind, I figured it out. I needed to include .SelectedItem.Value to get the value of the drop down list, like this.... strSQL= "SELECT * FROM tblClients Where ClientState='" & states.selecteditem.value & "' Order By ClientLastName

Hi All, This is likely a breeze of a question, but I am still stuck in ASP Classic, and trying hard to get on the ASP.Net bandwagon. Anyway, I have a web page with a dropdown list ... <asp:DropDownList id="states" runat="server" AutoPostBack="True" DataTextField="ClientState"...

Hi All, I have 8.5 Developer edition loaded on one computer. What do I have to do to view a report on another computer? I put the .rpt file on the second computer but that didn't work. Do I have to compile it on the first computer first somehow? The funny thing is I have .Net loaded on the...

Mishbaker, Thanks. I guess 1.1 is just an update to version 1. Access 7.0 is the same as Access 95 I think. And Access 2002 is the same as XP, perhaps I should not call it Access XP.

Hi All, For a project I need to list all the versions of Access that have been released. My list follows. I am curious to hear if there is an agreement that this is the correct list, or is there anything I am leaving out?... Access 1.0 Access 2.0 Access 95 Access 97 Access 2000 Access XP...

Does anyone know how (or if) you can set up a custom keystroke to perform an action. For example to open a specific form is there a way to create a keyvoard shortcut to do this? Thanks!

Creating the user - I am the developer, not the network person. This is for a small company - a couple of users. I am not sure how SQL was installed, but it seems that they can get on OK with whatever password they have. Makes sense?

I am setting the timeout to 0, which means indefinite: conn.CommandTimeout = 0 When I try to run Profiler I get a "General Network Error". The installation I am on right now is a SQL developer edition running on my PC.

Could these type of permissions become hit and miss like this for no reason? Simple Create Table SQL statements are being passed from Access to SQL Server to make the tables. Why / how could permissions be set different on some of the tables. Nothing in the code is dealing with permissions...

But can this be? Each application makes tables, let's say 10 tables. The user at the office in question - when the processing is complete will only see 7 of the tables in Enterprise Manager. There is nothing particularly different among the 10 tables. THey all are data queried out of a master...

Hi All, I have an Access front end to SQL Server back end. Part of the processing is to create tables on the back end. In one setup, at one of the offices, the application works fine. At another office, soem tables don't appear. This is the key point. It is not that all tables do not appear...

Hhhm, I don't know about 97 but I have XP and I can see the groups. In the plain old database window - where the tables, queries, forms, etc. are -- just below that is there a section called Groups?. Also, it might be hidden. Just below the regular database objects, if you move the mouse over...

what version are you using? It's not in all versions

Hi all, Does anyone know if it is possible to program adding/removing groups that are listed in the database window? The Favorites group appears by default. You can manually add or remove other groups. I am trying to see if it can be programmed. Thanks!

Donutman - Perfect! Thanks, it's just what I needed.

Hi all, Just wondering the best way to tell if a table exists before writing data to it. This would be from an Access front end. Is there a particular stored proc? Or is it a query into one of the system tables? Thanks! KB

SQL Sister, yeah, A talk with the client is a good idea. Thanks for thinking it though.

Hi SQL Sister, The process of altering the data structure is the client's requirement. They end up using the data in SPSS - a statistical package. They need the data in the the process creates it, although I don't get into that side of things. I have wondered about the crosstab, cut can it...

Our current solution uses an Access front end. Selections are made in the Access form that becomes the criteria for SQL statements (action statements, not selects). The question is, is the performance with this approach any different, or much different, than coding it up as stored procedures...

VBrit and Hypetia, Thanks for the suggestions! Problem solved.