Search results

Hello everybody , I have one table with 3 fields. The table also has only one row. I want to display to an Edit Box in a form the second field and I get the error: Name?. Do you know what does it means? Example: Field A, Field B, Field C Row A 100 200 300 I want to...

Respect ! hvala ti. (I guess is right) :)

Hello Guys, I am using Access 97. Do you know If I can use the function RIGHT in the SQL syntax. And If, how ? Thank you in advance. :)

Hello everybody, I work for a big Car Manufacturing Company from Germany. Μy manager assigned me a kind of "Mission Impossible" project. It is critical for me to accompish this task my the end of the week. I would be greatful if you can give me some help or some guidelines. I have an Access...

I found how it works ! Thank you for your help

Hi guys, I have a Button and a radio button. The scenario is very simple. Everytime I click the Button (Apply), my code should check If the Radio button = True Then Execute a Query. So I wrote this : Dim strSQL As String Dim Arial_f As OptionButton If Arial_f.Enabled = True Then strSQL...

Hello everybody, Lately I started dealing with dynamic reports. I am searching over the internet a "How to" article according the creation of this kind of reports but I didn't found something yet. Guys do you have something to propose for reading ? Here is what I am looking for...

Thank you guys, both Actually what I did: Dim OrirgnalDateRelease, TodayDate, YearDiff, convertdate As Variant TodayDate = Year(Date) convertdate = CInt(TodayDate) OriginalDateRelease = OriginalReleaseDate.Value YearDiff = convertdate - OriginalDateRelease Age.Value = YearDiff Thanx. ;)

Hi guys, I have a variable TDate which is Date Dim Tdate as Date Then I use the function Date to get the current Date. TDate = Date(). Actually I want only to convert the year to integer and store this number to a new variable. I don't have a clue. Any ideas ? Thanks !!!

So through VBA, I guess I have to ... Dim sqlselect As String sqlstring = SELECT Sum(Tracks.[Hours]) AS SumOfHours FROM Tracks WHERE (((Tracks.CDID)=[Forms]![CD]![CDID])); DoCmd.RunSQL sqlstring And to pass the result on the edit box Me.EditBox = ??? The way I am thinking is correct ...

Hello guys, I have a listbox with 6 columns. Tha last 3 columns are Hours, Minutes & Seconds. I have three other edit boxes (Total Hours, Total Minutes & Total Seconds.) where I want to summarize the column data. Do you know how ? :D

Thank you !!!! I will try that immediately !! :o

Hi Guys, I am in a quite difficult situation. My boss asked me to export 3 tables from an Access 97 DB to text. Dilimited. This is not my actual problem. I know how. My problem is that I have to add a Header( With the NOW() Date) and a Footer with the result of a Row Count for each Table. As...

I guess I didn't described my problem properly. I wanted to create a List Box with 6 columns. That was it. Recently I found out how. Thanks anyway.

Hello People !!! Recently I started working (For the very first time) with Listboxes on Access 2007. I managed to link my listbox with my Table and I also wrote some VBA in order to create a button ADD Data. BUT now I have a new challenge to face. :rolleyes: Do you know guys HOW can I create...

Hello, Finally I did it. I erased all the VB and I replaced it with macros. On the Next & Previous Buttons I added two macros where they control the navigation and the refresh of the from. Thank you. :D

I tried it. It doesn't work. :( I don't understand. The SELECT query is correct. It brings me the correct data. It refresh the data only when I press the Edit Value button on the List Box. I also wrote the Me.Refresh on the OnLoad event of the form.

Hello everybody, It might look simple ans silly. BUT I really have this problem. I created a ListBox on my Form where it takes a parameter from an Edit Box and brings me back data from a table. IT WORKS BUT ... I can't refresh the list box when I press NEXT or PREVIOUS. On these buttons I...

Ok. It is clear. But what If I want to add values direclty from another Edit Box ? Without Opening another form. What Row Source Type I have to declare? Table / Query or Value List ? Thank you. :D

Hello Boys, I was wondering if you have any useful articles or samples to propose according List Boxes. I want to add values to a listbox from an edit box through a button ADD. (Actually this is a List of CD Tracks. I want to save this list in a database field. Is this possible ?) But I...