Look into the way the Switchboard works. This is a built-in item in Access. As it is it has an 8 item limit but once you understand how it works it wouldn't be too hard to program a similar form with many more possible items. PcDave -xXx-
2004-03-28
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-03-22
I would create a view if the number of AttributeId was 16 or less in total. But, from you post I would guess higher. If the total number of AttributeId per product (ProductId, AttributeId pairs) is small enough 16 or less I might still try a view, but not sure how to code it. See […]
2004-03-19
I'm relatively new to SQL Server and have been using it for a web based intranet application. Even though I have not encountered any problems, yet, from failing to qualify objects with the owner, this stills seems like good advice to me.Thanks for the article.
2004-03-10
One way would be if object_id('test_q') is not null drop table test_q go create table test_q( m char(3), b int, l int ) insert into test_q (m,b,l) values('10',10,1) insert into test_q (m,b,l) values('10',10,2) insert into test_q (m,b,l) values('10A',10,2) insert into test_q (m,b,l) values('10',10,3) select * from test_q order by m desc,b,l m b l ---- […]
2004-02-27
That's what I actually did. Looking at BOL for Maximum Capacity Specifications for processors and RAM and guessed right
2004-02-27
Access superior in some way to anything! Really? I didn't even know that Access had anything that could be called security.Unless that password stuff is being referred to as security. I've occasionally been asked what can be done with access databases that were password protected and someone forgot the password. It usually takes about 1 […]
2004-02-12
Thought others might benefit from Mary Chipman's comments (from newsgroup):An mdb is a better choice since you also have the flexibility of storing static data locally in Jet tables, allowing you to decrease round trips across the network to fetch data that rarely changes. You can't update the results of a pass-through query, and that […]
2004-02-04
1 reads
Thanks everyone. Based on your input I was able to change the query so it was SQL compliant. A couple minor changes on the queries Frank and Gary wrote and I was in business. This saved me a lot of time and frustration.Thanks again.
2004-02-03
Ain't date handling marvellous? All sorts of ways of "skinning the cat". My approach to getting the first day of the month and first of the next is as follows ... (I always use alpha for the month ... saves confusion).declare @today datetime select @today=getdate()select '01 '+substring(convert(char(11),@today,106),4,11), '01 '+substring(convert(char(11),dateadd(month,1,@today),106),4,11)01 Feb 2004 01 Mar 2004
2004-02-02
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers