Search results for query: *

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

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

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

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

I've seen loads of posts about this, none of which work for me. I have a main form with 2 sub-forms double-clicking a field in one subform runs an insert into statement which updates the 2nd sub-form. However its only when you move forward a record and back again that the 2ns sub-form is...

I've got some access code which has been working fine - not now though!!! on my main form, a pop-up form appears which when a field upon the pop-up is clicked, it adds data to a subform on the main form - below is part of the code - it now doesn't like the docmd.gotocontrol...

Hi I have a unbound control on a form which is trying to reference a subform i.e. =[subform name].[Form]![ID field] if there are no records it shows #error I want it to show 0 any ideas please?

I've got the following code (I've removed the declare bits etc) and although it works, if the file is found it does an application.followhyperlink to the saved document, BUT it also creates a document called Dcoument1 which I don't need - how can i make sure this document1 doesn't load up...

I've got the code below, which uses application.followhyperlink to open a word document if found. I'd like though, to open the document as read-only How can I do this please? Regards Gwilym Dim db As Database Dim str As String Dim strselect As String Dim...

Hi I have a continious form for which I'd like to write a formula in code i.e. write the select statement and then say Dim result as string result = theforumla I have 12 fields (Month1 to Month12) I want to, for the sum of ALL 12 fields (not just Month1)...

Hi I have a section plan form (with alot of fields on - 50 at least) There is an option to create a new record, wherby a different form is opened, a new record cerated and the relevant details are copied across (using references) to the new record. The problem is, I could end up with 50 lines...

I'm running the following code which works great, except for that if more than 1 record is found, it doesn't loop through on the inser into line, always inserts the 1st one How can I get it to loop through the insert into as well? thanks ian str2 = &quot;SELECT * from qry_temp_weekly where...

I have a table called functions where there is a grouping number field. Each record can have the same grouping number i.e. duplicates allowed I have another table which holds the group - Arts for example may be number 10 the user chooses a group say &quot;Arts&quot; (from a combo box) and the...

I have a asp form with a checkbox defined as below <font face=&quot;Arial&quot;>Copy from Applicant details<INPUT TYPE=&quot;checkbox&quot; NAME=&quot;applicant_details&quot; value=&quot;YES&quot; onclick=&quot;return passvalues();&quot; SIZE=&quot;30&quot;><font face=&quot;Arial&quot...