Search results for query: *

Sorry Andy but that will return all records matching the word or phrase input and only those. What I'm looking for is to provide a list records where the data matches the user input and/or anything thereafter, browsing the field contents starting at the point the user indicates

I'm looking into allowing my users to browse data input in a field by indicating the starting word or phrase and browse all data input containing the word or phrase and all data thereafter. Any ideas on how to do so? Thanks in advance for hints in this respect.

I thought so but my searches didn't return anything useful (JS scripts). Would you have any reference about a good enough script? Thanks!

Hi, How is it possible to add a value to a combo dynamically, sort of reproducing the MS Access Not In List event? I want to be able to put a button next to the input box, opening a new window where users input a value not in the dropdown list and reload the list in the form, preserving any...

Hi, How can I make sure that my combo box (not dynamic) default value is set to the value found in the database table (i.e. option selected? Thanks

Well, as I suspected it is directly related to the NT machine (the one running IIS 4) regional settings that set the date format as mm/dd/yyyy. The only way around is to format the date submitted as EDate = "#" & Day(date) & "/" & Month(date) & "/" & Year(date) &...

sweevo, the dates sent with the SQL are defined like e.g: EDate = "#" & date & "#" DateVal = "#01/01/03#" As detailed, the query runs fine in Access query window. It also runs fine in the IIS 5 machine. The problem is that it doesn't produce any results on the...

I looked in the FAQs and didn't find the help I need so I hope that any of you may help me with this (ASP/MS Access/SQL query). I have a page where users may display all future events. To do so I use the SQL: queF = "SELECT * FROM Events WHERE (Start_Date BETWEEN " & EDate & &quot...

I have a Access 97 application distributed throughout 17 countries European for cataloguing and indexing of publications. When users have completed a set of indexations for a given month, a VBA function allows for the export of that set; this export creates a fully tagged text file, by checking...

I think I got the picture. Thanks Michael

Hi, I need to create a database that will run code to delete some objects in another database and export some new fixed objects to that database, bypassing the startup. All my attempts did not work in order to open the other database and simulate the SHIFT key while opening, to be able to...

I have a form (ALL) with two subforms, SubjectMainSub and SubjectOtherSub, with the fields SubjectID (combo box) and SubjectSt (text box, not visible: default value 0 (for Main) or 1 (for Other)). The link between the form and subforms is the field AcNr. The record source for SubjectMainSub is...

I have a form (ALL) with two subforms, SubjectMainSub and SubjectOtherSub, with the fields SubjectID (combo box) and SubjectSt (text box, not visible: default value 0 (for Main) or 1 (for Other)). The link between the form and subforms is the field AcNr. The record source for SubjectMainSub is...

I really appreciate your help. Your example also gave me other ideas and I have been able to find another solution that implies less re-doing of the current code (I am fighting against time to deliver the application). All the best!

I'm gonna try your suggestion now. I have learned access and its programming while developing this particular application and I'm still some basics. I'll let you know of my success or else I'll be getting back to it here. A million thanks for your hint! :)

It seems my mouse is repeating clicks. I am sorry for that. Also, please note that in the example given the codes between ID and author names should always be "1001"

My code works fine in what concerns exporting all the data from both the main and related tables. Nevertheless, by writing to the file all data from the main recordset and only then the data from the related recordsets poses problems, by changing the order of the original input. There are two...

My code works fine in what concerns exporting all the data from both the main and related tables. Nevertheless, by writing to the file all data from the main recordset and only then the data from the related recordsets poses problems, by changing the order of the original input. There are two...

In the case that I continue using the current method, what would then be the sequence for the recordset.movenext command? Using the query method seems slightly problematic, as I have many different related tables (about 10 and I cannot reduce the number) and there is the limitation to the length...

The query is there. Both recordsets are created using SQL. rstMain, rstAuthors with rstMain while not .eof [data] wend end with with rstAuthors while not .eof [data] wend end with This results in: MAIN record 1 MAIN record 2 ... 1st Author MAIN record 1 2nd Author MAIN record...