Recent content by hoschi

thanks a lot! it works great... hoschi

here's an example of my problem In my example there are two tables, tblSource (with the informations) and tblDestination (where I want to put the Infos with some more Infos). In the form frmTest I used these SQL Statements to select from the Information Table tblSource. There is a button...

sorry Nouba, that is not what i'm looking for!!! my problem is that I don't know how to store the selected criteria into a different table!!! hoschi

my problem is that I don't know how to store the selected criteria into another table!!! hoschi

yes, I'm trying to save the criteria that was selected! By pressing the button a code should run, which saves the selected criteria in another table! I tried the following: [Forms]![frmTest1]![land] = [tblTest2].[land] but it does not work!!! any ideas??? hoschi

I got three combo boxes with this code... one table: tblTest with these attributes: land = country, stadt = city and einwohner = habitant the boxes are filtered, so i can only choose the cities which are in the country i decided in the box above... box 1 SELECT DISTINCT tblTest.land FROM...

thanx to all, I did it like rich said and it worked fine for me! thanx a lot hoschi

I forgot to say: I work with access 97!

I got it... I made it with an SQL Statement and then I used following code for the output to Excel: DoCmd.OutputTo acOutputQuery, "myQuery", "MicrosoftExcel(*.xls)", "C:\temp\output.xls", True, "" hoschi

hi there I got 2 text boxes: datum and day in the datum-textbox I enter a date and I want that the second textbox (day) automatically updates itself with the Day of the Week! I know it must be done with following code but it does not work: =Format([datum],"dddd") Where have I to put this...

I want to get a Output to a Excel Sheet from a filtered Form! I want the user to enter the filter criterias, to see the filtered records and then by pressing a button to get a output to excel! please help thanx hoschi

thank you very much ...that works great!!! thank you very very much But I still got the other problem. I tried something and came to this: when I change the record from the main form, the subform updates itself automatically. I did this with Link Child Field and Link Master Field of the...

Hi there I got a Form with a subform. In the Form there are all Information of the record. The subform is like a listing of the todays added records with only four fields of information. 1. How can I filter the subform OnOpen to show only todays records? 2. I want to add to the subform a...

I searched the forum but I didn't find what I need because I don't know how to name my problem. I want to create a form where the user can open a record for a computer problem. This form must have a subform where the user can add the actions he made. The subform must contain the date/time, the...

thanx Doc_Man but can you explain me, how can I create such number with this criterias (A-C)? For the second, thanx, I'll search the forum... thanx again hoschi