Search results

I want to update sth abouth 10000 records (change number of the module to its name - name comes from anotheta table) I have used this query UPDATE problemy SET problemy.modul = (SELECT s_modul.modul FROM s_modul WHERE problemy.modul = s_modul.ID) in RunSQL macro but I am getting "Operation...

I was thinking of writing a VB script to transefer data from one access database to another. the problem is that the structures are diffrent - some data matches the other and some not (ex. In source table I should concate two firlds to get the destiny field, some fields would be left..) How to...

I have tried this :( Now I have both - in access form and in asp application lines like this "oldline&vbCrLf& newline" ... But thanks for help! Maybe it has something to do with coding (Unicode ? )

When I am adding a new line to field in database record via WebInterface(ASP) I update my database with "oldvalues"+"\n"+"new values" entry. In web interfase it looks fine and gets data from table with proper formatting. But when I open my form in access textbox has strange look with funny signs...

When I open my form normally from forms list in database view Find i enabled and working. But when I try to open it from MenuStartForm like this: DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormEdit, acWindowNormal or DoCmd.OpenForm stDocName, , , stLinkCriteria, , acDialog Find is...

Ok I know how to send an email from access I have table with admin(s) emails so hardcoding is not a problem but how to get to know when the data is changed? It is only one field in database which, when changed, should rise emailing action. But how will I know it has changed. Make a copy of data...

Ughh.. this is not so simple - user chooses how to filter his data before form is opened. Filtering depends on 4 values in textboxes but i don't know which of them where choosen as a filtering criteria. I was thinking of using Me.recordset - it contains filtered data but how to bind it to listbox?

I was thinking how to make a simple data change notification. For example when user inputs new/change data in the table how to notify the database admin. Is there an event that I can handle and send and email for admin afterwards ? Joanna

I have a form with a list box (ListLink) to navigate between records. I load it in Form_Load() with data from SQL query. I works great BUT sometimes my form has some filtered data - how to display in listbox only filtered records to navigate? Now it displays all record an fails if cannot find...