Search results

yup. thats what I'm afraid of. I don't really fancy doing that. There's A LOT of code there. I was kind of hoping some nice chap out there had some nifty bit of code laying around that would query the procedure stack. Oh well :(

Hi all, Does anyone know if there is a way to programmatically (is that a real word:confused:) access the name of the current sub? Something like this: Sub ProcA msgbox "Sub: " & me.SubName & "Module: " & me.ModuleName end sub Sub ProcB msgbox "Sub: " & me.SubName & "Module: " &...

Hi ya. what do you want the dropdown list to do?

brilliant! Thanks PC.

Ok, I've got a weird one here i can't work out. I have a main form (MainForm) that contains 2 subforms (subform1 & subform2). MainForm contains a public sub called FilterSubForm2 The subform1 onCurrent event needs to call FilterSubForm2 I've tried call me.form.parent.FilterSubForm2 call...

Hi all, Had to write a quick and nasty function that outputted a number in base 36 (don't ask!) and thought I'd share the code. You can modify this function to work out any base by removing the unwanted digits from the DigitArray. E.G. for Hex DigitArray = Array("0", "1", "2", "3", "4", "5"...

Found an interesting looking one This looks worth a go: http://nbit.net.au/vpages.aspx?ID=HTML%20Editor%20OCX The demo even has a Access 2k3 mailmerge example! Has anyone had any exprence with it or can recomend others? TTFN

Hi All, Can anyone recommend an WYSIWYG control for editing HTML in an Access 2003 form? Open Source would be nice if possible. Tar. M.

Help, I a bit stuck. I'm trying to create a trigger that will launch on changes to the data in a table called tblContacts. It should record the changes in a table called tblAudit I've tried to make the code so it checks all fields (columns) in the tblContacts table. The problem I'm having is...

Cheers for that. Saved me fiddling around. Here's the same code as a function: Public Function FileExists(stFileName As String) As Boolean Dim FileExistsbol As Boolean stFileName = Trim(stFileName) FileExistsbol = Dir(stFileName) <> vbNullString FileExists = FileExistsbol End Function

OK, here's what I'm thinking - please critque : I set up a table which is publicly accessable storing the following data: Form Name : Varchar Object Name (null allowed) : Varchar Role: Varchar Access : bit (0: Deny, 1:Grant) By default I want roles will have access to all forms. Using the...

ooooh. OK I think I've found the problem. It looks like if you're the dbo it doesn't check your membership properly. Does anyone know if this is a known fault / intentional design? If the former, is there a fix or a workaround?

OK, there's something I'm obviously missing here (newbie to this). In Enterprise Manager I've Created a new role on my database called FinanceStaff. I've added my login as a member of this role (SQL is using NT Authentication) From Access I run this view SELECT IS_MEMBER('FinanceStaff')...

Am I being rather stupid or is something not quite right? I'm executing the following stored procedure: ALTER PROCEDURE dbo.StoredProcedure1 as exec sp_helprole and getting back 10 rows but no columns (see screenshot) Q1. where am I going wrong Q2. as a side issue if I wanted to use the...

Hi all, before i start recreating the wheel, could anyone give me any pointers in getting Access to block users from launching particular Forms based on which roles they are members of in SQL. I am using Access 2003, with SQL 2000 in NT Authentication mode. The forms are located in an Access...

Cool. you could also use the same sort of thing to do a check and report before saving the record. All you'd need to do is something like setting the Tag for each control that has to be filled in to TRUE. You could then get the code to loop through all the items in Me.Form.Controls checking the...

There's a nice quick SQL reference on MS's site. It's quite useful when you're getting started and not quite sure about syntax. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_operator_1qd5.asp All the best Marc

Sorry for cross posting but on second thought my question's more of a coding problem rather than a straight query. you can find the post here: http://www.access-programmers.co.uk/forums/showthread.php?t=97763 Thanks to anyone who can help All the best M.

Hi all, I'm starting to write some import routines and though it would be a good idea to be able to match existing data with data for import. I was thinking sometihng along the lines of: 3 tables & 1 query table1: A list of fields, the type of check to do (EG LIKE, = , > , etc), and a number...

Sorry, just descovered that you can actually use regegex in Access. See: http://www.access-programmers.co.uk/forums/showthread.php?t=97666 With it you should be able to evaluate an email with a regex something like this...