Search results

It worked !!! Thank you Mr. B !! :D

Hello guys ! I am having a problem with the creation of a dynamic report. I have a combo box with lots of values , a OK button and a report. The combo box has to do with music genres (Pop, Rock etc). I have only one report: SELECT CDAll.Artist, CDAll.Title, CDAll.Genre, CDAll.RecordLabel...

Thank you guys so much. It was very helpful.

Hello everyone, I have a simple form on Access 2007. I added an print button. And when I press the button it prints all the records of the database. Do you know guys what I have to do If I want to print only the current record. ? I tried on the properties to change the "cycle" from "All...

Thank you Both , JohnLee & Raskew !!! I did it, and it works fine ! Thanks.

Thank you so much for your help. Now, I will try to follow your instructions. I will let you know :) Thanx.

I guess you are right Bob. :) I need to summarize elapsed times. After all I want to add times of Music CDs. And really I am not sure if I have to do it with data type "Time" or with data type "Number". I have 1500 CDs. For every CD I want to know the "elapsed" time. hh:mm:ss. At the end...

Thank you for the links. But I am not looking for elapsed time or to use the Datediff function. Take a look. value A: 01:54:25 value B: 00:12:01 value C: 02:45:56 The 3 values supposed it is time: hh:mm:ss. Now what I want is a query that calculates the following result: value A + value B +...

1. The name of the field is "cd_time". All is about the total time of a Music CD. 2. The field it does not contain date. I used mask. 00:00:00. I don't know if this is the correct way to do this. Thank you.

1. The name of the field is "cd_time". This has to do with total time on a music cd. 2. The field it does not contain a date. This is only time. I used mask to change the format of the field. And it looks like that: 00:00:00. I hoped I helped you... Thanx.

Hello everybody ! I have a problem that is quite unusual for me. I want to summarize time ! Sound good Huh ?! A have 1200 rows in Access 2007, which contain a field called "Time". With data type is Date/Time and Mask : hh:mm:ss. I am trying to design a query which will give me the sum of...

Thanks, I tried this and it works fine, but is not actually what I am looking for. I would like to have a browse button, which will open a dialog to search through the image file. And by pressing the OK button to save the path of the image file. Lately I read lots of articles according...

Hello everybody ! I am working on a project called Music Room (Access 2007). As you can realize is a CD Library. Has lots of features plus lots of statistics according a personal CD collection. I am looking forward to create an efficient solution to display images in my form for every CD in...

Thank You So Much ! You Helped Me To Understand Much Better The Whole Concept ! :d

2003 Version is ready

The save us menu has the feature "Save us Access 2002-2003 Database" but it gives me the following error: You cannot save this database in an earlier version.... because it uses features that require the current file format.... I guess I have to erase some features and then to save it on an...

The Form is Artists & the Field is Total Cds: THANK YOU SO MUCH :D

I did exactly what you proposed This is what I wrote : Me.CDNum = Nz(DLookup("Cnt", "CD_Count_Artists", " Artist = '" & Me.Artist & " ' "), 0) And the error message now is : Run-time error 3464: Data type mismatch in criteria expression. The query is correct & the VBA code looks correct...

The query worked fine but when I link it with vba I get the following error: Run-time error: '3075' Syntax error (missing operator) in query exxpression 'Artist = 3 Doors Down'. I feel it, I am so close..... :)

I guess it worked. It gives me back a number. Number 1. It is correct for the first Artists. I guess now I have to do something for refreshing every time I press Next Recordset. Requery is the correct way for running my query every time I press next ? Thanx.