Search results

DatePicker - default date (now) Didn't work though....(could not assign a value to...) i noticed that the datepicker contains some problems; because when i open the properties of the datepicker and i change some items (for example: the time as 00:00:00 in stead of the regular time); i get an...

I know, and i found some information i needed, but most of the threads and posts were and are about a text box with a datapicker (vb-code) behind hit, but rarely anything about the 'standaard' datepicker from microsoft which can be inserted. That's why i asked the question (again?)....

The datepicker chooses default the date on which the datepicker is put in the report. Actually i want the currentdate as the default date, but whenever i pick the current date in the calender, this one is saved in the datepicker and when i open the form the next day, the datepicker is still set...

Silly question: Situation now: form1: 10_form1 form2: 1010_form2 form3: 101010_form3 form4: 20_form4 form5: 2010_form5 form6: 201020_form6 query1: 10_form1 query2: 1010_form2 query3: 101010_form3 query4: 20_form4 query5: 2010_form5 query6: 201020_form6 Situation wanted: renaming 10 to 40 and...

Thanks people... I managed to control my form, by letting the date picker be filled anyway and used in the query the isnull value. Thanks for the answers, reactions

little question here: 1) table deleting i have a table in which temporary data is stored; With a command button i want to delete the table (or maybe just the data in it); 2) information from table in textbox In a form i have a textbox in which the data is mentioned from the table, after...

datepicker empty value I have succeeded to fill the criteria with that what you suggested, but (maybe a stupid question with an answer of the "oooooohhhh, that simple, huh?" kind)...how do i leave the datepicker empty? (there is always a date in the datepicker box as far as i know or can tell..)...

enddate can be empty the enddate in the database can be empty, so there can be A value or NO value......(see my problem here ? :)

Date Picker - current date Hellow again, I searched on datepicker or some searchkeywords like that, but didn't found anything of an answer which i could use, so please advise if you want: Information: 1) in the db are two fields (begindate and enddate) 2) in my form are four DTPicker fields...

i managed it though I managed to solve the case..... I have made to querys with criteria NotIn; and then i put those two queries in 1 union query...and "voila" the result i wanted was there... Thanks for the help of course!

to union or not to union... i have to make a report that uses a comparison both ways...a loj or roj doesn't help me (unfortunately).. Putting the sql query here is kind of difficult, because i used just an example and not my real situation (language-problem here in some cases :)) Hopefully...

or is it maybe possible to make an "NOT UNION" Query? (union = combining, not union = differences?)... It seems to be that access accepts the NOT UNION, but treats it like an UNION query.... hm...how do i do what i want to do?

Hello again... Is it possible to use a UNION query for comparison between to tables or queries? If so, please advise how to example: one query consists of a selection of books, grouped by category for a student the second query consists of all books, grouped by category for a student The...

underlay following sections problem I have tried to solve my problem meanwhile by placing all the fields in the last group and turning the property "Suppress if duplicated" to "yes", but then (of course) some fields are not sorted, or some fields are left blank other then fields next to it...

Is it possible to clean the windir cache after running a query? Some queryes, done in oracle, take up (in my case) till 2 gb (different left outer joins and several tables). Thanks in advance

Is it possible in a MS-Access report to place fields which are in group headers on one line? Example: Situation now: First group Name; line 1: TjS Second group Occupation; line 2: Programmer Third group Work; line 3: programming Third group Work; line 4: testing Third group Work; line 5...

Found my solution Excuse me for putting the problem ahead of the thinking. I had placed the concanated field in a group....This was (in my case) the problem.. Thanks.

If someone can, please help me out. I have a query in which a couple of passthrough queries are used to get relevant information from an oracle database into a access database (reporting and so on). In one of the passthrough queries there a concanated field which represents a name. When...

Thanks! it works fine...

Question: I have a make-table query which is runned when clicking on a button in a form. Of course after clicking the button the following notifications appear: 1) You are about to run a make-table query that will modify the data in your table (yes, no help) 2) (if the table exists) The...