Search results

make another table called policy_notes. In that table make three fields note_id of type autonumber: (unique record ident) policy_id of type number: this is the foreign key and will hold primary key value of the particular policy. note_note of type memo: this will hold the note information...

make a query for the sub form that pulls out the data you need and have the query sort on the field(s) you want.

I had forgotten about that. I built an Access app about 2 years ago for a few users and the db grew huge really quick and I ran into this problem. I never did get a chance to move it to at least the MSDE.

I agree, but you didn't give me any limitations :p

I have been using it for over a year now and I absolutely love it. Granted you have to be aware that quality is dependent on your ISP's infrastructure but most broad band ISP's can support 90Kb upstream without a problem. At 90Kb, the sound quality (at least for me) is so good that if there is a...

I can't use an Access db for 1000 users on the web. I can't use triggers and to the best of my knowlege, Stored Procedure support is limited. I'm talking about a straight up Access DB, not an access PROJECT that ties to a SQL database. If I need to build an app that needs to be used in many...

Not quite. There IS a VB language for .NET though. .NET is Microsofts newest push in the rapid development area. .NET is a framework that is used to develop software for both the desktop and web alike. I can write a class for the desktop and use that same class in a website (with nearly no...

I think it's another tool like anything else. If you have the time to bulid a windows app and the requirements are scalability and speed, then I would do that over using Access; However, access has it's place as light-weight / portable db and that's where it's usefulness really comes in to play...

DAP are a real pain the butt. If you manage to get them working on your host, then you'll be prompted with a box everytime to try to load the page that says something along the lines of "Do you want to load data across the domain".. I forget exactly what the message is, but you have to change a...

it doens't know anything about the business layer, it is only accessing a method of the object.

Make a windows service to do this :)

The apostrophe problem is only for inserts, not selects. lets see your code and some sample data.

I agree with pono1. States are changing any time soon so why not put them directly into the html or an xml file which you can bind to the control.

http://blogs.msdn.com/david.wang/archive/2005/11/07/HOWTO_Install_and_Run_ASP_Net_20_Side_by_Side.aspx

here's what I do for that. I go to advanced search and type in "question" for my search parameter with AT MOST 0 posts between certain dates. Seems to work well.

ack!! 2003 is truly a step in the wrong direction.. you should also tell your server person that techincally it's not an upgrade since 2.0 is resides side by side with 1.1 as per MS specifications.

is there a Dreamweaver user?

Glad you got it sorted. :) Which method did you choose?

that's a pretty broad question with lots of dependencies. Should the pc with that IP have open vulnerabilities, then yes, it could be possible. However, anything is possible but how paranoid do you want to be?

ok, I have a trigger set up to grab a value from the deleted table ALTER TRIGGER ECShipment_Update_Cartmember ON dbo.ECShipment FOR DELETE AS DECLARE @cartmemberid bigint set @cartmemberid=(SELECT top 1 shipment_cartmemberid from DELETED) exec spECMergeCartMembers @cartmemberid the...