Recent content by gwilym40

Hi I have an Access 97 Database with linked tables to SQL. if multiple users access the same record at the same time - the first user who committs is ok, the second user gets a write conflict - this isn't the bit fields problem (using a default value of 0 in SQL - I've had that !) - can anyone...

Thanks Tarwn I'd be interested in the javascript to hold the arrays. If you had an example that would be great - I'd need to build the arrays dynamically i.e. from the 2 recordsets containing service and area - I'm abit of a novice at all this so an example would be great tony

I've created a table in SQL which links to an ASP - the user submits data through the asp which updates SQL. The owner needs a front-end access 97 database whereby he'll get a form showing the data from the SQL table (I've done this bit as a pass-through query which a form reads off) what i'd...

Hi I have a query in access with 3 columns ID, service and area The first combo box in the asp takes the ID and distinct service from the query I'd like the 2nd combo box to filter the area values based on the service chosen from the first. thanks tony

Hi I have craeted a pass-through query in Access 97 based on a table in SQL, and a form has been created based on the saved query - when I click details for a particular record in the form I'd like another form to open whereby the user can add/edit the record which will in turn update another...

Is it possible to launch FrontPage from Access 97? as in you would with excel or word? e.g. Dim ExcelSheet As Object Set ExcelSheet = CreateObject("Excel.application") ExcelSheet.application.visible = True Regards

yeah when a user selects a name in the browser

Hi I have a combo box as follows, where name is what shows and ID and email are hidden. <p><font face=&quot;Arial&quot; size=&quot;2&quot;>Select your Name <select name = &quot;reqname&quot;> <option value=&quot;&quot; select>Name</option> <%Do While Not rsname.EOF Response.Write...

Is there any way, with a secured Database, that you can give certain users access to build queries (select queries only and read-only) or any shareware programs that would do something similar - like a SQL builder or something (it would have to be 1 or more tables they may want to build queries...

Brilliant! thanks

great thanks I just changed idate = DateAdd(&quot;m&quot;, idateadd, Format(Me.initial_month, &quot;long date&quot;)) to idate = DateAdd(&quot;m&quot;, idateadd, Format(idate, &quot;long date&quot;)) and it works fine thanks very much

brilliant thanks

Hi After using an application.followhyperlink to take someone to a word document, can you print out that word document automatically from access? regards

I have a form wherby the user chooses a frequency of Monthly, Quarterly, Half-Yearly or annually. They then choose an initiation date. and a life-span there is another form wherby the user can see their 'risks' that are due for review. for example if the initiation date for risk number 001 is...

I have a word document set-up with bookmarks created e.g. appendix_1 Hoe can i, from access 97, click on an appendix_1 button and launch the word document, automatically taking me to the bookmark appendix_1 in the word document? any help appreciated jacq