Search results

Nope, I have tried everything under the sun, I assume there is also problem in opening reports. Waiting for someone to come up with a solution.

Hi, I am working on MS Access 2003, the problem I face is that whenever I want to view the code and open the VB Editor, Access give me Debug Error. The message box pops up with a Microsoft Visual C++ Debug Library (it also gives the path of the MSACCESS.EXE file located in my system). When I...

Hi, I am working on MS Access 2003, the problem I face is that whenever I want to view the code and open the VB Editor, Access give me Debug Error. The message box pops up with a Microsoft Visual C++ Debug Library (it also gives the path of the MSACCESS.EXE file located in my system). When I...

Hi, I have a table "Scores" in which I have the fields "Date" and "Location". I have a form "frmscores" which is used to enter today's scores. The fields on this form are as follows: 1. combo box "cmb_location" for selecting the location, 2. text feild "txt_score" for entering the score and 3...

Thanks all for your help and guidance, the attachments were helpful, and I was able to customize the time picker according to me requiremnents. Thanks

Andy, I could download the attachment from the link you had suggested, it looks perfect but is there anyway I can add this control to my form which has some other controls/fields. Thanks

Thanks,, but how do I construct it?

Hi, Do we have an exclusive Time Picker only, I am using the Calendar control for selecting date, Is there any similar control which will help the user to select a particular time instead of manually entering it?

Thanks for the help. The problem as you have explained was with the delimeter. Thanks once again.

Hi, I am trying to retreive values from a Query "abdulQuery" where the Location is the one which the user selects from the combo box "cmb_location" and date is the user selection from Calendar control "calrecon". The datatype for the field Location is text and for the field Entry_date is Date...

Thank you very much. It worked.

Thanks for your suggestion, I have changed the field name "date" to "entry_date". Please advise how do I make the combination of Date and Location fields as compound primary key. And I believe Access will show its own error message if this combination is already existing, Is there any way I can...

Hi, I have a table "Sales", where I have the fields "date", "location" and "points". The field "date" internally tracks the date of entry using the function date(). The other two fields have to be entered by the user. I need help whereby on a particular date; for a particular location the points...

Nice take, but this is only a sample database; the fields might not be desinged taking everything into consideration, but a solution to this problem is necessary to go further. Can you please help me out of this scenario?

How can I hide empty fields in a report? The table "Batch" which I'm using has the fields "City", "State" and "Province". Now when I pull a report I want the fields which have a value entered in them only to be displayed. That is; if for a particular record; the field "City" and "State" have...

Thanks for your replies guys! It worked using Calendar control and query between [Enterstartdate] and [Enterenddate] Once again thanks for your help

Dear Nakin, The problem is I have always been using static reports based on a query, like say "Select entry_date from Batch", but this time I want to generate a report based on a user entry, so I am not able to figure out how do I go about it. I am unable to understand how do I track a user...

Generating Reports in MS ACCESS Dear WayneRyan, Thanks for your help. The first option of a dialog box for user entry of start and end dates would be fine. But how do I write a dynamic query for generating the report within the dates specified by the user. I mean the report I use would be...

Hi, I am creating a database in MS ACCESS for data-entry of records, where the system should track the date of record entry. I am using the function date() to track the user entry date, which automatically saves the system date in short date format (12/24/2003) as soon as the user saves the...