Search results for query: *

SauerC has hit the nail on the head .. I don't currently have many forms, but it may pan out that way, and I DON'T want to have them all loaded in memory (not to mention some of the large recordsets some of them may display) Ben +61 403 395 052

OK my prob is this .. I have a table which contains among other things the names of Form objects in the project in question. I want to load a form (eg Load Form1, Form1.Show, etc) based on the string form name from the table - and NOT by a select statement like select case sObjectName case...

Look up Publish/Subscribe in SQLBOL .. Also have a 'central' DB which issues the ID field numbers (transactions, etc ..) Ben +61 403 395 052

Hrm .. that sounds like giving up and using the data object tho? which I don't want to do Ben +61 403 395 052

Haven't exactly tried that either, but have tinkered with it between SQL 7 DBs .. from memory it needed a Linked Server or Remote Server to be set up (in the Security section in SQL 7). Never did it using EM personally cos it continually crashed, but think in SQLBOL under sp_addlinkedserver or...

Does each field have to be so large? You could break it up into separate tables for the extra huge text fields .. just link them with original table's pri key Ben +61 403 395 052

Hi all, I've mainly worked on Access VBA before and now tinkering with VB. I'm using VB 5.0, and there's something I have yet to figure out how to do .. On a form I would like to use a grid (rather than heaps of text boxes and paging) to show data from a database. It seems that in general the...

simplest way off top of head would be to simply drop and then add the column again .. Ben +61 403 395 052

could something like select count(*) from clientTable where PhoneNo = '12 3456 7890' and check the value, or select * from clientTable where PhoneNo = '12 3456 7890' and check if BOF and EOF are both true (empty recordset) Ben +61 403 395 052

Well given it's VB, why not move them to be the last arguments, and add Optional before each one. Ben +61 403 395 052

well for the example above why not add something like WHERE dbo_Customer_Sector.Flight_Date > '5-Jul-2001' or dbo_Customer_Sector.Flight_Date < '23-Apr-2001' Ben +61 403 395 052

I could be way off the mark not having experimented myself, but possibly you should tell it what application you want to use? I think Windows 9x defaults to opening Explorer given the above line, but NT probably wouldn't. Maybe something like wshell.run &quot;c:\windows\explorer.exe...

Interesting .. I just used HTTP_COOKIE 'cos it appeared to be a unique browserID. Once I've validated the login, I store the username and that identifier in the database and refer to it when checking permissions for each page. (When viewed HTTP_COOKIE always appears to be something like...

Though I'd throw this general question out .. On a site I'm tinkering on I use the ServerVariables('HTTP_COOKIE') to uniquely identify someone currently logged on, paired with their username. Not sure exactly where that servervariable comes from or if it will work on most browsers? Just...

So if you have tables: table1, table2, table3, etc in the QuizDetails database you want your combobox to list table1, table2, etc, correct? OK in Access go into Tools >> Options and tick the Show System Objects flag. Now when you look through the tables in the database window should also list...

I just prefer that way to keep in practice .. and as I've mentioned elsewhere I have issues with the amount of times Enterprise Manager crashes. Ben +61 403 395 052

What sort of database? In SQL Server easy enough .. (QA example) use <database name> select name from sysobjects where type = 'u' order by name asc Never done it in Access, but trying just now .. select name from msysobjects where flags=0 and parentid=251658241 order by name asc that seems...

How bout this (if you're using SQL Server - hopefully you can get the gist anyway) use master create database test1 go use test1 set nocount on create table Images (ImageID int, ImageText varchar(50), constraint pk_images primary key (ImageID)) create table ImageCategory (ImageID int...

What the query look like? You may simply be able to group by/distinct the fields of the table producing the duplicates. Ben +61 403 395 052

Does it matter? Just always do it and no problems :P Ben +61 403 395 052