Search results

Dear All, Does anybody know how to rename field names with a help of a macro or with VBA? How I do that at the moment is that I created another table with the correct field names and I append the data with a query It is quite a good solution but there is huge data movement (approx 30 000...

It is happening via a form, they are free to surf the records So I would like that if they change the content of Field1 then they also would be forced to change Field2 before moving to the next record Thank you

Could you please precise how I can do that? (for me it is not the point to force them entering data right at that moment, but before closing the given record) Thank you

The problem is that I dont know what the "whatever you decide" will be As it is a text field, users can write there anything So the point is that whenever TxtFldA is changed to whatever, user needs to fill in TxtFldB as well (so focus remains on that field until updated) and vice versa Thank...

Hi DCrake, Could you be more specific please? Many thanks

Dear All, I have a form where I have two fields that I need to behave in a way that if one of them is changed then the other needs to be changed as well and vice versa. eg. I have a date and a text field, if the date gets updated, the text should also be updated otherwise user cannot...

Dear All, FYI the beforeupdate method on form level works perfectly!! Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me.Progress) = True And Me.Status <> "open" Then MsgBox "Please fill in all the required fields!", vbCritical, "Attention!" Cancel = True Me.Progress.SetFocus End...

Maybe I do something incorrectly but if I use this code: Private Sub Progress_LostFocus() Dim stmessage As String If IsNull(Progress) = True Then stmessage = "Please fill in all the required fields!" MsgBox stmessage, vbCritical, "Attention!" Me.Progress.SetFocus End If End Sub Focus is on...

Thank you for the hint, I modified the code to get focus on Progress Private Sub Status_AfterUpdate() Dim stMessage As String If Me.Status <> "Open" And IsNull(Me.Progress) = True Then stMessage = "Please fill in all the required fields!" MsgBox stMessage, vbCritical, "Attention!"...

Dear All, I have a form where user can select Status, after Status is selected, and if the Progress field is empty I put a msgbox on screen, stating that all the required fields need to be filled in and looped it until field is filled in (Progress field is not set as required because during...

Dear All, There are nice built-in pivot table designs in Excel 2007 I duplicated one of them, modified the duplicate and saved it My problem is that the one I saved is only available in the file where I did it, it does not appear in the design list when I open other files. How can I make...

Thank you very much it works fine!! :)

Dear All, I have a query that should count unique values only but it does not work: SELECT Count(*) AS Expr1 FROM [SELECT DISTINCT T1.[field1] FROM [table1] AS T1]. AS T1; if I replace field1 and table1 with my table and field I get an invalid bracketing error message Could you please...

Dear All, I have chosen another solution The db gets compacted when the first user opens it I found a code that I customized a bit, I post it below FYI Option Compare Database Public Function cptdb() On Local Error GoTo MCError1 Dim stDatabaseName As String Dim stLastCompacted...

I found the code for compacting! But unfortunately I could not find the code on how to schedule something... or to check if nobody is in the database

I am sure that at that time nobody will be in the database Could you please help me with the code as well? Thank you very much

Dear All, Is it possible (if yes, how) to run Compact and repair at a given time every day automatically? (so to somehow schedule it?) Or the other option would be to compact it when the last user closes the db I have already tried Tools=> Options => General => Compact on close but it did not...

Now it works!!! I did not know which option enables multiple selection, but now I found it that you mentioned its name Many thanks for your help

The problem is that I dont know how to do it What control shall I use and how? Thank you!

Dear All, I would like to create a list or an option group on a form, where users can select not only one option but multiple values at a time After selecting a query would run using the selected values as criteria How can I create a multiple selection option in Access 2000? Many thanks in...