Search results

Is it possible to administer work group security via a form. eg Add/Delete Users Reset Passwords Lock User access Also is their away to pull the current users login and group membership details?

Anybody got an example ?

I'm trying to abbreviate the code below. MovementType(1) = Me.Type1 MovementType(2) = Me.Type2 MovementType(3) = Me.Type3 MovementType(4) = Me.Type4 into somthing like this, but i can't get it to work?? For I = 1 To 4 MovementType(I) = Me.TypeI Next I How should i reference the...

I am calling from VBA, how would i do this though.

I have a UDF which i calculates two values. how can i get it to return the 2 results when called. the function takes alot of processing to run so i don't want to call it twice.

I have a set of four parameters completed by the user on a form. I want to pass these to a function as parameters, would it be possible to use an array type declaration to do this. at the moment i have something like the below. Function EnterJourney(Crew As Integer, Stage1 As Boolean...

I'm using an SQL to insert a record into a table in VBA, how can i then get the autonumber for the the record just created. No other fields are unique so i can't use a lookup. Any help?

Thanks, Works a treat!

Since splitting my db i'm having problems looping through recordsets, i think it's something to do with the movenext or possibly the calculation of the recordCount as i'm only looping to the first record. Any help much appreciated, code below. Set dbs = CurrentDb Set rst =...

This Works, but i forgot i need to allow a space aswell! how do i refer to this!

Anyone now a quick way to return whether a string contains only standard characters (A-Z,a-z,0-9) as a true/false.

I have a form with 2 subform on a tab control. I like my form very much as it is and im just adding a "Save and Exit" button and a "Exit without Saving". Problem is that the Me.Undo won't work to reverse any changes if the user has moved focus to one of the subforms as any prior changes are...

I have a continues Form with some tick boxes and DropDown Boxes X and Y. How Can i get the Dropdown control X to default to the value of Y on the record above. How can i reference the status of the tick boxes in VBA and distinguish which row on the form they are on. EG is row eight on the...

The Purpose of the form is to allow the user to run a query on the information entered. The details entered are processed to return the distance and time to travel between each location, giving a breakdown of each leg of the journey and an overall total. The overall journey can only contain the...

I have a form running from a table with the below fields. Journey__ Required ___StartLocation___EndLocation 1________Yes ________London_______Manchester 2________Yes ________Manchester____LiverPool 3 ________No________ Please Select___Please Select 4________ No________ Please Select___Please...

I'm trying to write some code to return the distance, drive time and so on between two locations ( which will be entered through a form in access. Just testing the basic objects in Mappoint at the moment and i have a problem finding addresses. I'd like to just us the post code as this works...

I need to write some code to return the distance between two postcodes for a batch of records on a daily basis. I can think of two ways to do this and I'm stuck on both. 1) Obtain a matrix of postcode distances and reference this in the database. Does anybody know of such a matrix. 2)...

Thanks guys, I'll try both methods and see which works best for me, Rich's method made my head hurt more so that will probably end up being the one i have to use.

PS Whats the best way to look the record when using pages so the user can't move to another one.

Access appears to only show my forms in the window sized to that in which it has in the design view. I've always got round this in the past by using maximise when the form is opened or spend hours trying to align the design window to the form size, but its just not good enough. I want to have...