Search results

Thanks guys for the quick and helpful response.:)

I have an employee table updated through an input form and want to track any changes made by users. I expect to store this info in a log table including what change has been made on what field, by who and the date/time when that happens. I could append this info to the log table when the...

I have to run the following codes in the After Update Event for a number of form fields and can not figure out what varible type to declare in the user defined sub routine. The procedure is the same except that the field name should be a variable. Private Sub ContractorType_AfterUpdate() Dim...

Thanks for your advice. The database is normalized. We have an employee table capturing employee info including contract data. We want to see all current data on the employee input form but allow the option of archiving contract info to an archive table and let user to enter new contract data on...

Hi Bob, I meant to use the OnDirty property of the fields not the form on the Form Before Update event. So, my logic is that only changes made on selected fields will trigger off an action with no impact on other fields of the form. I want users to archive a contractor's employment...

Hi Boblarson, I appreciate your comments but I did try to use the codes in BeforeUpdate but got the same error of type mismatch. I need users to click a button on the form to archive data of those fields first before new changes are made. I could disable those fields first as you suggested but...

I want to make sure that users of a form need to perform an action first before changing on some selected fields on the form. My thought is to fire up a message when either of those fields has changed. I can not use the OnDirty event on those fields since I only want the message to appear once...

I believe you meant Case Right(....) but it works. Thanks for your help. ;)

I have created a mde file from a mdb database. I want to open a custom tool bar on the start up form only for the mdb file. Since the files have different extensions, can I set up a condition something like this in the start up form - If current file extension = .mdb then Me.ToolBar = "Custom...

Hi there, I have run the Auto FE Updater provided by Tony Toews in the server folder pointing it to a MDE file to be used by other users. Just try to get it clear in my mind - do I have to save a copy of the MDE file for the first time in user's local PC first and then create an User Setup...

SOS, thanks for your guidance. I'll give it a try.

I do understand the benefits behind splitting the database into front & backend. I did not do that to save the trouble of having to install a copy of the frontend to each user's PC on different locations whenever there is design changes on the frontend. Most of the users are not computer...

We have been using an Access 2003 database in a shared network drive where 4 - 5 users can use the database simultaneously. However, we now have a new user with Access 2007 and everytime when she exits from the system, she was asked to save a copy of the file. We ended up having a number of...

The form does open and the procedure was run properly although I still got an error on invalid procedure call or argument at the Msgbox line. Any way, I don't really need that msg since user knows the process is completed when the Excel spreadsheet pop up. Anyway, thanks a lot for your help...

Where should I put the codes you suggested? I put them in the form load event and it does not work, got an invalid procedure call or argument.

Hi DCrake, Thank you for your suggestion. This is an alternative to my problem but actually I want the pop up form to stay open until the exporting routine is completed. The challenge is when the form is opened, Access shifts focus to the form without running the routine. I tried to call the...

I have a module with a public Sub routine to export data from a query to Excel. Owing to the codes requried to set up the resulting spreadsheet for printing, the exporting process takes about 15 seconds. I intend to run a pop up form while the process is running, alerting users to wait and the...

Boblarson, Thanks for enlightening me. I know it should not be something complicated.

Hi, I tried to use the Excel function ISNUMBER in marco coding but got a compile error: sub or function not defined. e.g. If IsNumber(ActiveCell.Value) Then do something else do othertning end if Does anyone know why this built-in function works in the spreadsheet but not in the...

Never mind, I found the answer. Put the hyperlink in a different Section and just protect the Section before and after the hyperlink area. :)