Search results for query: *

Hi there, I am looking for some advice. I am just about to start setting up an Access database. Most of it will be local, but some of the information needs to be updateable via the internet. I supposed that I will then have to have one database held locally and another held on the web server...

I also managed to work out a vbscript routine below where the checkbox name is "chkCandidate" and is initiated by a button called cmdSelectAll: Sub cmdSelectAll_OnClick For i=1 to form1.elements.length - 1 if form1.elements(i).name = "chkCandidate" then...

Thanks very much mwolf00. I will try this out, thanks for your help.

Hi there, I have an asp page that generates a list of 100s of checkboxes dynamically. All the checkboxes can have the same name or ID but have different values. I then want to have a button that I can click that will automatically check all the check boxes. Is there an easy way to do this...

Thanks very much GaryC123. I also found a very good example of exactly what I wanted on the microsoft tech net site at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdaexamples_vbscript01_5.asp Thanks again

Hi there, I am trying to set up a simple form that is linked to a database. The form displays the current record's first name and last name from a list of names in a database. I want to include two buttons that move to next record and to previous record. Does anybody have any sample code...

Hi Zeroanarchy, I did manage to get the database to work the way I wanted, though I would be interested to know how to get the pictures to work using a continuous form.

Hi Kojak43, I tried out my solution, above of just storing the link to the photo in the table as a text field, and using a picture in the report that can represent each photo showing several to a page, and it works fine for me. If you like I can email you a copy of the example database I used...

I didn't get past the problem for continuous forms. Though if you are working in a report have you tried putting the photos in the detail section of the report, and then having running an event on the "on format" event for the detail section that changes the path to the picture. I...

Thanks Aubs010, That was very helpful. What I have now done is I have inserted a picture into the form and then change the path to the picture on the on current event where the picture now gets its path from the text field holding the path to the picture. This seems to work quite well, except...

Hi there I want to be able to link photos to records in access and I want to be able to (if possible) view the photographs from within Access as thumbnails. I did not want to use the OLE object embedder as this uses too much space and was hoping I could use a text field to store the path to...

Thanks very much - that is working. But I had thought that if I tried to open an ASP file directly I would at least get an error message or a save file message, and not nothing at all which is what is happening.

Help, None of my ASP files will open in IE. Although I can edit them in text editors when I double click on them directly nothing happens at all. I think the problem may lie somewhere with the asp.dll file but am not sure. I have re-installed IE (6) and IIS (5) but this hasn't made any...

Thank you for your reply. I eventually managed to solve it using the following code where "Ro" is the variable holding the string: Ro = Replace(Ro,"'","' & Chr(39) & '",1,-1,1) Which seems to do the trick Thanks again

I'm getting an error on an ASP page. I have a text box that users can enter information into and then submit. When they submit it writes that information to a database. However if the user includes any apostrophes in their text it throws up an error. Does anyone know of an answer to this one...

Thanks for the reply. I won't waste any more time on that then.

Can I set up a pass through query from an Access database to another Access database. I have been trying all morning with no luck! Every time I try I get one of two errors: either it says: You cannot use ODBC to import from, export to, or link an external Microsoft Jet or ISAM database table...

I am using an Access 97 database. I have a form with a subform. In the subform I have a piece of code that updates some of the values in the parent form. However for some of the values every time I exit the subform to the Parent I get the Write Conflict message, saying "This record has...

I'm using Access to update some reports in Excel. The workbook I update has 3 sheets. Two of the sheets contain charts and the third sheet contains the data for the charts. The access function rewrites the content of the data sheet. However, I don't know how to get the two charts to...

I can think of two ways of doing it. 1. In a new field use the access DAvg function to self refer to the query based on the last 30 days. So if your query was called qryData based on a table called tblData, the field you were averaging was called fldData, and the date field was called fldDate...