Recent content by adhishvellore

Thanks Paul. I did not use the "format" control though in my sql :-) But it is better to put it in there, so i have taken your's :D

It's done now...anyways thanks for helping :) i was having problems with the date format where i have to # instead of " :P Cheers Adhish

Hi Paul, thanks for the reply. Yes, i do have the other criteria (just taht the same also needs the date filters. I tried the below given code, but it is giving me some runtime errors. i am not so good in these codings and had Joern from this same forum help me construct these codes. I have...

Hi all, I have a form in access where i need to select a record between two different dates. For example i have a "valid_from" and "valid_to" field. I have an unbound text box with short date format and calendar control inserted for users to select a date. This is named "drpdate". I have a...

ok..got it.!! thanks a lot.!! hav en god dag.!

Hi Jørn, Ideally i would like to have only one record displayed because otherwise it will still cause the users to pick the wrong record. But i understand that if we are doing this then i guess i will have to start assigning a primary key to my data tables whereby each record is unique and...

Hi, sure. what i meant was that if the results can also be in the same format as filters that is one below the other. For example: Filters Country : Germany Location : Munich Customer : Cont Type/Size: 20'Dry Results: Depot Name: ABC Munich Depot Code: DEMUN01 Amount: 50 Currency: Euro...

hi, tusind tak for hjelpen :-) My danish is not so good yet, but that was very helpful indeed. exactly what i was looking for.!! One small question - is it possible to have the subforms in a vertical manner than horizontal so that users do not have to use the scroll bar...it is not that...

Hi, The search criteria can be limited to the below 4 fields. Country, Location, Customer Name & Container Type/size The values should be displayed from the PIO_Tariff table in case there is no match with the customer name mentioned or if there is no Customer name specified. Even if i could...

And now with the attachment

Hi there, thanks for the message. All the values should be retrieved from the table PIO_Contract (if the customer name specified in the combo box exists in that table). If the customer name specified in the combo box does not exist in the table, then the values should be retrieved from the...

hi there, i hv been able to re-construct my cascading filters now, but i do not know how to get the results of the search based on the different filters into the set text boxes :( Does anyone have any query or code that i could re-use? Please please...much appreciated. thanks.!!

Hi all, Not sure if anyone could help me here. I have been assigned a project and have no prior experience working with Ms Access, but i need some database where i could manage my customer contracts and tariffs. I did the simple part of creating the database, and the form template...but...

Hi all, myself adhish. here to look for tips and tricks on how to create a smart database with forms and queries. I am a beginner in MS Access and knows only the basic functionalities. Cheers Adhish