Search results

What do you mean?

I tried, but after I change I to numeric it deletes those records with the very large values.

Hi All, This question has probably been asked before, but couldn't find a related topic. My question: How can I import long numeric values (integers) greater than 2,147 billion (standard long integer). I tried a lot, but couldn't find the answer. Thanks.

Thanks for your reply. It all looks understandable, but: 1) Can you explain the sSSN = tbSSN 2) I do not use a button, can I use this code on a form_activate event?

Hi All, I have a continious form where each record can be edited. After editing a record the form does a me.save and a me.requery (is important). After this it jumps back to the first record (seems logical), but how can I write a code that he goes back to the 'previous edited record'. Thanks.

Hi All, I have a subform in which users kan edit a field. Some contain more than 100 records. After 'an edit' the code save the adjustments in the table. Then the subform automatically jumps to the first record, but I want it to go to the previous record which they just edited. Is that...

I have a form which shows multiple records. Users can tag checkboxes on and off, sometimes they edited so much boxes that they forgot which ones they changed.

Hi All, Is there a way that I can make a button which will undo all the changes being made on a form (on multiple records). I have a continious form with a checkbox after each record and want to restore the 'old values' if necessary. Thanks. I know it's possible by record, but the tricky part...

Hi All, Does someone know how to validate data entered in textbox to a table? In other words: how to check the value entered in the textbox exists in the table. Thanks.

Oh I fixed it already! In the 'after update' I told it to save en requery the record. Now I copied it to the click event (last row). That explains why it went to the first record.

Private Sub Afgehandeld_Click() If Afgehandeld.Value = 0 Then AfgDatum.Value = Null DoCmd.Save Me.Requery Else: DoCmd.OpenForm "formulier5" End If End Sub Somewhere in this code I have to tell that he has to go to the record that I just updated (I think)

Hi, I can't upload anything but I will try to explain better... When I click on the selectionbox (true or false), it will open a form (docmd.openform). The next form will be based on a query from the record I just clicked on. Like this: ValueA Name Selection 123 Hello1...

Thanks, But it still takes the first value (record). It has to do (I think) that I select a selectbox and that is the same as modifying the table, so it goes to the first record. On click it has to highlight the currentrecord...

Hi All, I Built a form with a selectbox. On each form there a several records shown. After each record you see a selectbox wich you can turn on and off. Now, everytime I click on a selectbox it automatically goes to the first record on the screen, why is that? With this action I want the...

Hi, If a datefield is empty (null) the result is 12:00:00 AM, we all know that, but I do not want to show that value. How can I make that possible? I tried several things like: if datefield.value = #12:00:00 AM# then datefield.value = "" but nothing seems to work, can someone help me? Kind...

Hi All, How can I count records with a by-statement? For example: I want to count all the citizens by city. All fields are part of the table and form. I used dcount, but doesn't seem to work, or I am just to stupid :) . Thanks in advance.

Not quite... How would you write this in code (suppose you have 3 fields x,y,z)

Hi All, I have multiple fields on a form, does anyone know how I can make them unvisible without writing 30 times .visible = false.. Someone told me I could use the tag property. Thanks in advance.

Thanks but I still get 30 dec 1899, does anyone have another solution?

Hi All, I have a problem. When I update a datefield with datefield.value = Null it doesn't empty the field but I receive 30 Dec 1899. Now I know that is the standard voor datefields, but how can I just display an empty field? Thanks in advance.