Search results for query: *

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

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!

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

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!

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

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

Hi, I have a Stop button on a form that I use to let the user cancel processing during a long operation. Clicking it simply sets a global variable flag that process checks during looping. That all works fine. The problem is that I set the mouse pointer to hourglass during processing. I want...

Hi all, From Access can you use ADO to send commands to SQL Server to create a stored procedure, and then run it? Instead of just running a pre-created sp. Thanks!

Hi all, I'm trying to see how to speed up a rather large and lengthy Select Into statement. The SQL creates a large table out of dozens, possibly hundreds of smaller tables. They are all related on a single key field. Each smaller tables has one to perhaps a dozen fields. The final table can...

Hi all, On the way from VB6 to VB.net, what happened to... -- The About form, Splash form, and Tip of the day? -- right click (or before right click??) event Thanks!

hi all, I have a VB6 app that I wish to re-write in VB.Net. The VB6 app centers around the Hierarchal flexgrid - using totally unbound. Instead code reads and writes from/to it. By design the VB6 app is not a database app, it uses some text and XML files, and that's it. In .Net there does...

Hi all, Is there a difference between creating an index and applying it? I have been trying out various indexes on a table, on different fields, ascending, descending, and so on. But every time I open the table it is in the same order. How do I get an index to affect the order of records...

Hi, Three executables are created: one in the Bin directory, one in Obj\Debug, and one in Obj\Release. Why? I can see the Debug one is not the same as the others (at least in my project here). The debug is not working correctly. That in itself is another question - why is the debug one...

Hi all, I can't figure this out. I have code that references an XML file. Worked OK. Then I changed the XML file name and inserted a new XML named to the one referenced in the code. So, I would expect since now I am working with new XML data, BUT as named per the referenced file, I would...

Hi, Anyone know how to play MP3's from Access, or what ActiveX control to use, or how to shell to the media player? Thanks! KB

Hi, Is there any quick way to get a count of fields (columns) in a table?

Hi, Does anyone know if it is possible to set the selected item in a list box from VBA? I need to display the listbox with a value already selected, instead of having the user make the selection (although it doesn't matter if they change it afterwards) Thanks!

Hi, I have a Select Into (creates a new table) SQL statement that uses the fields from 27 other tables. The new table ends up with 500+ fields, with >20,000 records. In Query Analyzer it takes about 45 seconds. With an ADO connection from an Access front end it times out, even with the...