Search results

something like Sub TestControlsComplete() Dim ctl As Control Dim AreControlsComplete As Boolean AreControlsComplete = True For Each ctl In Forms("frm_Reports").Controls If ctl.ControlType = acTextBox Or ctl.ControlType = acComboBox Then If...

http://www.contextmagic.com/express-clickyes/free-version.htm ClickYes and Redemption are small programs to bypass the old "Access is trying to talk to Outlook" dialogue box

if in doubt, recreate the db and redo the security make a test version and keep an unsecured copy

http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Faccess%2Fcontent%2Fsecfaq.asp

can you link into the tables if you build a new database? is this 97/2000/2003 ?

the LDB tells you who has logged in during the time it was created...you can open it in notepad, but it's not that useful in a multi user environment hmm i'm not too sure that the currentproject connections aren't just read off the ldb anyway...

a log in, log out thing is all well, but the users will muck it up when they control-alt-delete you can write a function to check how many people are in the db:- Function CountUsers(cn As ADODB.Connection) Dim rs As ADODB.Recordset ' The user roster is exposed as a...

got it tdfLoop.Fields(i).Properties("Rowsource").Value but it doesn't allow tdfLoop.Fields(i).Rowsource harrumf, not obvious. i'm obvious addicted to my dropdown property thingy

afternoon all if i have a table with a (say) text field and in the table it is a combo box that takes a feed from another table... i was wondering if it were possible to reference the table that the combo field refers to? i've tried rummaging around the Tdef object, but source table and...

dlookups are very very slow

thought of that too (only recently found out about that) the query is was joining to was grouped and linked back to an ODBC source and i think that was confusing it... i just turned it into a table and it worked haven't got a clue why though! :)

try Between [EnterStartDate] And [EnterFinishDate]

it means you've tried assigning a long to an integer type

i have a table with 3740 records in it i do a query and outer join this table with a query and it produces LESS records = 3733 :confused: now i always assumed (never assume it makes an "ass" out "u" and "me" !) that the records would be the same as the table you were joining from, obviously...

search the forum :) or here's a link http://www.members.shaw.ca/AlbertKallal/Articles/split/

why not just check the properties and see who created it? right click>properties>Security>advanced>owner ?

is the db split between front & back? can you see the backup once it's made?

aaaaah i just asked the user (who it didn't even try to kick out) and she said she was away from her desk, so the screen-saver had kicked in looks like you're right, thanks how annoying, don't suppose anyone knows a way around it, if that is at all possible...? hmm, found this...

hi i have a flag in the back end of my database, which once ticked by me, should chuck them out of their front ends it runs off the timer of the opening form and looks like thisL Sub EveryoneGetOut() Const MINUTESLEFT As Integer = 10 If booQuitFlagTicked Then If Now()...

why not open it? get it to open automatically in the scheduled tasks...Tools>Control Panel>Scheduled tasks give it a form that pops up when it opens use the code to send an email make sure you have Redemption/ClickYes