Search results

Sorry, if my words were confusing. What I mean is : The user will update his set of data every few days either by adding completely new records to his table or by changing the values in some fields of the existing records. And I need to append this set to my table each time, before I run the...

Hi. I have a peculiar problem with my work envi. There is a user who updates a 'bills' table every few days. And he copies that table to a shared folder location on our network. And I have to append this table's current records into another table. (From which I generate reports) This another...

Thanks a lot Ranman256 ! I'll remember the instructions and hope it really works well !!

Hi All. I have a simple application in Ms-Access 2007 with 10 forms - each having its own underlying table, about 20 queries and some reports based on them. It's being used by a single user. However, I have recently been asked to 'share' this application to 4 users so that data is input faster...

This does not give any error, as the event does not fire at all. Simply moves on to the next field. Why ?

Let me try that also and see ! The appl is on my PC at work.

ok, thank you. I'll check that and see.

Hello. I'm having a lot of trouble with Dcount() on a form. I Googled a lot and tried so many options but feel helpless with the stupid ' " (quotes). In fact, it's irritating ! Can some one guide me with the exact syntax please ? What I'm trying to do is as follows. On a form, i have 3...

Thanks a lot for the many options, arnelgp. BTW, after setting the column count property for the combo, it worked well. Great help indeed !

Thanks again. Yes, I did try that and I'm able to see the values in the combo box. But, for any value I pick in the combo, I'm able to populate first two unbound fields only. 3 & 4 unbound text boxes still empty.

Hi. I did try as said. private sub combo1_afterupdate() me.Text1.value = me.combo1.column(0) me.Text2.value = me.combo1.column(1) me.Text3.value = me.combo1.column(2) me.Text4.value = me.combo1.column(3) end sub But, there is a strange problem. The unbound boxes are able to display only...

Great Idea, arnelgp ! I'll surely try that and see. :-)

Hi. I have a form bound to a table that is used for entering records. On this form, there is a combo box that has some field values from the underlying table. And i have 5 unbound fields too, that need to display some values. As soon as I pick a value in the combo box, I need to just display...

Hello. I need to create a form that can go on accepting data entry of records until user clicks a stop button. To say it clearly, first I check if the "Depcode" (field name) already exists in the table through a Dlookup on form. If not, I accept data entry. In the form, I need to fill in 6...

Hi all. I have a simple table with about 15 fields and a few hundred records. In my data entry form based on the same table, I need to check if a record already exists. Using the first two unbound fields on my form that accept a text string and a date, I need to check in the underlying table -...

Thank you all very much for the inputs. I did try one of the options earlier, as suggested. private sub form_load() me.ponum = forms![po_form]!po_number end sub For this, I get an error at runtime saying, "You cannot assign a value to this ....." Anyway, I'll try them all again and see. :)

Thank you Paul. I've set the control's source as = forms![po_form]!po_number (i.e the first form's field value) And it's working fine, in the sense - it shows in the second form but does not save to it's underlying table.

Hi. I have a bound form in Access 2007 that opens up another bound :oform during data entry, after filling in a few fields. This new form is not related or linked (but borrows one field's value from the main form - as i have set it's control source property) and has some more fields that are...

Thanks again for the suggestion on normalisation, Dave. However, I'm only populating about 5 fields from the other table; as it is a must during data entry. And my form has a total of 15 more fields that need to be filled/typed in manually too.

Thank you Bob and Dave. Hope Dlookup() helps. And to clarify, I would like to first display the fields from the query on my form and later move these values into the underlying table; when I save the form.