Search results for query: *

Try: Me.undo cancel = True

A user opens a form name AddStorage, they can change a field named: Count that will hapen trough a combobox where they can fill in howmany of that product has entered the building. then when they click on a button this button will decide if there is more then 0 product on storage trough a VBA...

Thanks it works:D

srry about that. i found it here it is: INSERT INTO tblTEST ( Borentcode, Filliaalnummer ) SELECT tblApparaten.Borentcode, tblApparaten.Filliaalnummer FROM tblApparaten;

thats the problem i dont know what to fill in by SQL im new to SQL so. What i want is: Table1: Productname Location A form that can change the location. when the location is changed, Before update, the record in table1 must be copied to another table. so you can see a history where the...

Hey there, I have an Add Query that adds all records from the query to a table. now each time i run the query it adds the records again. what the query must do is, only add new records to the table AND old records but only when the field [Code] has changed. Is this possible? im open for...

I know what it is, but i dont know how to use it.......

hey there, i want to print a report everyday on 3 o'clock automaticly. is this possible? Why? the boss wants a report on his printer on 3 o'clock PM and if we forget it............ You know what happens then:P LOL Greetz Superguppie

Im still hoping someone can help me with this problem??? i would be very gratefull to you........ Thanks in advance:D Superguppie

Thanks you both for reactions, i tried SoCalAccessPro's code and that works:D i also tried your code Skip.. and als o that works so thanks for the tips:D Superguppie

hey there, in a form when they click Add, then a new form comes up, that form gets its data from a empty query. the query must be fulled with the data users are going to enter. so i tried using the "[field=]" = [field] and the code is correct but when it opens the second form, field is still...

ah Stupid, i just told it, put it in onload event....... Lol gonna try that again:D

thanks for the quick reaction, when i insert this in criteria in the query it tells me the syntax is wrong, i think this code must be put somewhere else???? also your code SoCallAccessPro is wrong syntax aswell.

Heya all, I read about creating a dtedefault user, no extension etc. and then connecting the DTE with a hypertermy thingy, the thingy then would show all the nice things the IPO does. did anyone of you use this in a nullmodem variant with the open com X in visual basic? so IPO barfes out...

hey there, im trying to calculate a date let me explane: when a product is buyed, an inventory will be made, we will in a table when the device is bought and howlong the garanty is for this product. also there is a checkbox that says: Garanty? Yes/No so the table looks like this...

well i did explane this very wrong:( Very Very bad Guppie :S so i will explane again in full detail: when a user tries to order something that is not in storage, it comes on a waitinglist. a query will search those record by the ordered checkbox. when they are false the order is placed but it...

hey there, When i close a form, all checkboxes from a query must be checked. but there are 2 fields that are Yes/No. 1: Ordered. 2: Send. Well all ordered checkboxes must be checked and not the send checkboxes, how is this done. Maybe VBA code? Thanks in advance Superguppie

This works Fine thanks:D

Also its in the table because the checkbox is needed in a report:D superguppie

its a field in my table thats gets checked by a VBA code in the form, i was hoping that there was a code for VBA to do this.....