Search results

Hi I have a listbox with 5 options and 5 controls which are enabled/disabled based on the selection from this listbox. What I need to do is clear any data entered into the 5 controls for a record each time the selection from the listbox is changed. Sounds simple, but I am having difficulty...

See my post (#2) in this thread which explains how you can hide/unhide controls and change the size of the form depending on which controls are visible - http://www.access-programmers.co.uk/forums/showthread.php?t=180821 This of course assumes that your fields already exist in the...

Show us your code when you have it available.

Thats fine, most people on here probably wouldn't have looked around. Simple is definitely good sometimes!

Absolutely not a problem, just make sure you remember to never store a calculated field in a table!

You most certainly do not want one table with 200 fields! As a starting point I would suggest you read up on normalisation.

Ok, now that you know what you are doing and hopefully why you are doing it, I will tell you how - Firstly, paste this code into a module - Function Minimum(ParamArray FieldArray() As Variant) ' Declare the two local variables. Dim I As Integer Dim currentVal As Variant ' Set the...

No you don't want to insert a fifth field into your table, you want to create a query with a calculated field that will calculate the max value.

I was unable to copy a shortcut to a users Desktop through Access because of permissions so I ended up creating a .bat file to do it and ran that file from Access using a Shell command. Not pretty but it does the job...

I came across this when trying to decide which type of Primary Key is best to use - http://www.broomscloset.com/closet/dbms/autonumber01.html I ended up going with Autonumber...

Even if they do not log in to the Database you may still be able to use their network login using the Environ("username") function, assuming they have to log onto the network! If not then you can simply password protect your delete button. Place this code in a new module (this will mask the...

aprpillai - 1000 was a typo, was meant to be 10, which is why the K:\ drive FE version was still active and not the local copy, have amended the code (now to only 1 second) and works a treat, cheers! RuralGuy - I had been following wiklendt's thread with interest but decided some time ago that...

Right. I have finally got around to writing a module to automatically update a user's Front End each time the Database is opened - this was the best approach for me as new queries are requested on a regular basis. When the Database is opened, an AutoExec macro is run, which runs an...

You can do it by performing a check on the option selected from the list in the list controls BeforeUpdate (maybe OnChange?) event. Then if it matches the criteria you have set, set the macro to run. You might also want to think about whether or not you want the macro to be run multiple times...

You know what the error is and that it is non fatal, so why not? Granted he could write some better code but I would take the easy way...

Use an error handler Private Sub Whatever() On Error GoTo ErrorHandler 'the rest of your code here ErrorHandlerExit: Exit Sub ErrorHandler: If Err = 2001 Then MsgBox "You have cancelled this operation" End If End Sub

I have always used that function so have never needed to create a login screen. Have a search on this forum, there are loads of threads with people asking the same thing.

If you don't require a password then you don't need a login form, have a look into the Environ("username") function...

Exactly wiklendt. What is the point using Excel for data entry but access for storage? Obviously you won't want her to enter the data directly into the table, so just design her a nice form which should make data entry much simpler for her and make the switch from Excel to Access more...

In the forms On Current event - Me.Disposel_address.Visible = False *list any more fields that should be hidden when the form opens here* In the After Update event of Dispose - If Me.Dispose = -1 Then Me.Diposel_address.Visible = True *list any more fields to be unhidden here* End If