Search results

Question, do you ever alter your tables? RV

Double post: http://www.access-programmers.co.uk/forums/showthread.php?p=513932 Don't double post and don't use bangs. It's considered to be rarther rude and not done. As for your question, in ORACLE you'd use a SQL script. In Acces, you need to use VBA. RV

Tim, if you google on ADP versus MDB, quite a lot of inetersting sites come up. For instance this one: http://www.pcreview.co.uk/forums/thread-2183599.php HTH, RV

Yes it does ;) You need to build an update query that will update all rows in your underlying table. RV

Haven't got a clue on why you're to achieve. Anyway, in your code you're referring to a function called GetOpenFile_CLT Do you have such a function defined? RV

Are you sure that badge_no is text string, as you refer to it as being a text string in your code: '" & rsEmployeeDetails!badge_no & "' If it's a numeric string, change this bit of your code into " & rsEmployeeDetails!badge_no & " RV

Sorry, made a typo. Code should read =DCount("[Ref number]","test","[team] = 'rangers' AND name = 'jimmy'") Rename your column called name. Name is a reserved word in Access abd should not be used for object names. Also, avoid using spaces in object names. RV

Try =DCount("[Ref number]","main","[open or clsoed] = 'open' AND username = jimmy'") RV

You could use the Like operator. If you're after some sort of intelligent data comparison, that's not going to be straight forward, assuming it's possible at all ;) Run a search here on soundex. RV

You only need one query, the one with the left join. RV

Fugan, the reason it doesn't work is because you're not using check boxes but option groups... Put this code in the Before Update event of your first Option Group: If Me.Frame23 = 2 Then Me.Case_Detials.Enabled = True Else Me.Case_Detials.Enabled = False End If Put the same code in the On...

Why would you want to ? RV

Normally that means that indeed your rows are not unique. I'd run your query, and have a closer look. For instance, if you've got any autonumber column included in your query, then you won't have any duplicate rows as each autonumber is unique. RV

Matt, you a NOT EXISTS construction: SELECT * FROM Software WHERE Software.Type = 'SA' AND NOT EXISTS ( SELECT * FROM ImageSoft WHERE ImageSoft.SoftwareCode = Software.SoftwareCode ) assuming you join both tables on SoftwareCode. Don't use Type as a name for objects as it's a reserved word...

It means that you're sort of behaving yourself in the forum. If you've been very very naughty, then it would read "raskew can only hope to improve" No idea who determines whether you've been naughty or not. Perhaps your spouse :D RV

For table 2, columns should be: NameID (data type Autonumber, this is your primary key) Name1 (change this into something more obvious) Telephone Number Date Added Date of Promotion Private Sub Command81_Click() Dim strSQL As String strSQL = "INSERT INTO Table2 (Name2, [Telephone Number]...

Would be helpfull to post your expression ;) RV

What you should check upon first is whether each and every combination of Name, Telephone Number and Date Added in Table A is unique. To guarantee unique rows, you always need to include a unique identifier (primary key) in your tables. For Table B, add an autonumber column NameID. And don't...

I was hoping someone could tell me how I can put together a masterlist using the data I already have and maybe if possible setup the 12 tables in such a way that by inputting an entry on one of them will automatically crossover the name of the business to the masterlist without me having to...

Gary, code should be put in two events. One being the After update event of your first combo box. The other one being the On Current event of the form. RV