Search results for query: *

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...

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

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...

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...

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

hey there, when i open a form trough a macro, the where condition should get HaalDezeWerknemer from the ribboncallback. and then put it in the form under cmdWerknemer i tried using this code ="gstrDezeWerknemer=" & [cmdWerknemer] This code doesnt work and access tells me to use this code...

hey there, on my mainform, i have 2 things: =Date() =Time() Now if =Time() = 12:00 and de computer will now say 12:01, the =Time() is still 12:00, it must also go 12:01, that also must be done with =Date() so that if it has been midnight, the date goes 1 day ahead:D How is this done? Thanks...

a record is opened, and that form also opens a subform, there is showed all record for the same person. but it must not show the record that is also showed in the normal form. so if textbox"ticketnummer" = 15 then all record must show in the subform except for record with ticketnummer 15 how...

hey there, when the field (in a table) is 1 or more, then the checkbox must be checked, if it is 0 then it must be unchecked. how is this done in the validation rule, i had this: If[Aantal]>=1 then [Voorraad]=Waar but it seems not right. can anyone explane why, and give the right...

hey there, in the ribbon i want to have a text that says: Name of Username, you have ** task open. the ribbon must look to the current username (stored in a variable) and then look to the query and look if the name is there, and then show to the user howmany records with his name are in the...

Hey There, i have 2 thingss...... in a table 1 have a begindate and enddate and i have a checkbox named SLA when the diff. is more than 24 Hours between begindate and Enddate SLA must be unchecked when it is less than 24 Hours, it must be checked (it can be: when more than 24 Hours it must be...

Hey There, i have 2 thingss...... in a table 1 have a begindate and enddate and i have a checkbox named SLA when the diff. is more than 24 Hours between begindate and Enddate SLA must be unchecked when it is less than 24 Hours, it must be checked (it can be: when more than 24 Hours it must be...

Hey there, When i close a form, it will automaticly op another form with a Where-condition Ticketnummer = ticketnummer de form opens and i see the correct ticketnummer and then it has also a checkbox wich is not visible but is active, als afmelddatum is not visible but active. now the...

hi all, when a user closes a form, then another form opens with information that this has happend by User actions, when that form closes, a Checkbox in the form must be unchecked, in VBA i had this: Me.afgemeld = False But then the following error occurse: Cannot give amount to this object...

hi all, when a user opens a form and fills in information in a Subform... and then click on de normal form on Close without save, the record must be cleaned so it wont go into database (table) this must be done trough VBA code, because there is more code that has to be done in same button:S...

Hi all, i have the following problem. when i add this code to VBA: docmd.OpenForm(frmOplossing,,,="[Ticketnummer]=" & [Ticketnummer],,acDialog) VBA will give the following Error (hope i did translate it well???) Expecting expression What is wrong about this code?? Greetz Superguppie

hi all, i have 2 tables, tblStoring and tblOplossing. also i have 1 form, frmStoringaanmelden. in that form the ticketnummer automaticly fills in with autonumber, but that number must also be in tblOplossing, i thought this is done with a simple VBA code but im not sure, so the field...

Hi all, In my database i have a login form, when the user clicks on "login" the VBA code must automaticly look if this user is manager or admin. in the query, i have 2 column, 1 is "manager" the other is "admin" both as Yes/No. the VBA code for the button login is: If...

Hey There, Somehow my analog phone wont send its cli with an outgoing call. The situation ; i have a 412 with 4.x running, and 2 analog trunks, a lot of ip phones and some ananlog phones via the trunks. Combined with a ISDN 30 (Main number 020-1234500) and 100 Numbers I've stated into the...