Search results

Straight from windows help: Setting user credentials When you create a task, you are asked to provide a user name and a password. This provides a more secure way for you to manage the tasks that run on your computer. Different users of a single computer can each have their own scheduled tasks...

as always Adam, thankyou

Hi, I have my db launch my main login form on startup, which I have set through the Tools menu. I also have an autoexec macro which does two things. 1) refreshes the links to the backend 2) check if the FE is the current version My issue is that the autoexec takes a few seconds to load, so...

wait, nevermind, when copying the Do Until rst.EOF i forgot to change rst to rst2 Thanks again Paul

yeah, thats what i've done and it works a treat. Thanks for your help paul. I do have one issue though, when looping through the fields of the second recordset, the code block For Each fld2 In .Fields If (fld2.Value) = -1 Then If fld2.name = primLoc Then x =...

um, sorry to be a pain but i made a mistake in that first post. The field that gets extracted (say 4 for example) is the Primary Key from another table, thats the table where the -1's are that get found. My bad Edit** So just to make it clear. What I have so far: Recordset filled from...

Hey, I have a recordset which extracts atm just one field from a query and runs through that field looking for a particular value (-1), when it finds one it executes a bit of code and then continues its search. The bit of code extracts information via DLookup from the same query. The problem...

which means its popularity will go through the roof... or does that hold for just art

my question was is there another way. My table is setup like this since it is the easiest way to handle the information its storing.

I have a table that has a autonumber ID field, and then multiple fields which are all yes/no checkboxes. Can somebody show me a way of performing an SQL UPDATE that will uncheck all the fields, hopefully without having to manually typing in each field name.

ahhhhh i see what you mean now... cheers adam

Ok, explaining that block in words: 1) Recordset is set to record from tbl_Secondary_Location for the given LocationID 2) Since this record is made up of yes/no fields, I am cycling through the record looking for fields that have value of -1 (yes), when if finds one, it takes the fields name...

no problem, I appreciate you taking the time to help :)

so just to clarify. You select a Student, hit Add, that user is displayed in some sort of list. Your problem is that the same student can be added multiple times. If this is the case, I would remove that user from the dropdown box when their name is added. This could be done a number of...

How are students added to the subform?

Have you had a look at it yet adam?

Cheers Adam

Ok, i'm attatching the db so you can have a look at it. I'm going to step you through this. Select a username bob is the password First place to observe this in action is 'New Change Request' Click the field 'Secondary Locations' and you will see the locations form open. The second area you...

also, do recordsets close when a sub ends. Even if it is declared globally?

Bingo. I should have made this more clear, the forms recordsource is being set by a SQL statement that depends on which form opened it (there are 2 places that can open this particular form) The recordset i'm talking about is made in the original form. So... How do I do this magical recordset...