Search results

I see now that you got it figured out :cool: whilst I was busy with my fine artistry :D LOL !!!

see image...

You could save it, close it, then set the read-only attribute, then re-open it (as read only). Would that suffice? Of course the user could always still make changes, and save it as another name.. won't stop deliberate mis-use but might prevent accidental mis-hap.

In Form Design, select the form object (as opposed to selecting a section or control). View the properties (of the form) - from the View menu, select Properties... On the Format tab of the Properties dialogue, Delete the contents of the Picture property. HTH Regards John.

In Table Design, change the Field Size property to 11.

Thanks, I wait in antici............pation.!

Thanks mailman, On your suggestion I've googled Oracle Instant Client, and from what I understand I would still need to install the instant client on each PC, which in our out-sourced desktop and network environment is a *lot* harder than it really should be. So I'm still wondering if PBaldy's...

P.S Sorry christshis - I hope I haven't hijacked your thread !

Hey Paul, Can you please expand on this at all... I'd specifically like to know if you are saying that creating a File DSN on the network alleviates the need for the ODBC client to be installed on the local PC ??? Bit of background - I have an AC97 DB that uses ODBC to a SQL Server. I have...

If [PMType] truely is a text field (as implied by your original post), then what Ken said... =IIf(([PMtype]="3") Or ([PMtype]="4") Or ([PMtype]="5"),2,1) If it is actually a numeric field type, you would need to omit the quotes... =IIf(([PMtype]=3) Or ([PMtype]=4) Or ([PMtype]=5),2,1)

Could you save a query that references the desired control (or controls) to get the variable parameters, and then run further (dynamically coded) sql against that query (like a nested query) for what you need ?

Larry may have solved your current perception of your immediate problem; but Rich's apparently simple (but quite serious, I assure you) question stems from a depth of experience. If you truely do want to "get good with" Access, the path Rich is attempting to lead you down is likely to be far...

Brad, The specname comes into play after you have created an import specification, which as namliam points out, can only be done through the wizard - so you first go through the import steps manually to allow you to create (and save) a specification, and then you can later use that...

I realised we posted at the same time - that's why the "cheeky grin" is there. It is only 21:20 now, and 20:34 when I posted initial reply, so not really that late. Of course we're closing off Wednesday, and you're just opening it.... Edit : - Oh, OK , it is now called a "big grin", I thought...

Yeah, what Ken said :D

297 * 210 = 62370 An integer can only store numbers in the range -32,768 to 32,767. Whilst you are trying to assign the end result to a Long Integer, I think the type of the operands (variables Num1 & Num2, in your case) comes into play first. Dimension (declare) the Num1 and Num2 both as...

Branden, Len is on the money! Some of the other posts, while well intended, may have mis-represented some facts, or written them in a way that could be mis-interpreted. The posters may not have noticed your footenote that you are using AC97. Access & Access security can do what you are...

This construct looks wrong, but it may not be the cause of your immediate problem. and later I suspect you intended... strName = GetUserName() strXLFile = "C:\Documents and Settings\" & strName & "\Desktop\Invoice.xls" 'note: also removed space before (.xls) and later FollowHyperlink...

All care / no responsibility - I haven't used this, I just knocked it together for you... be sure to create a back-up copy of your database and test it carefully before you use it... Public Sub DeleteAllTablesBySuffix(szSuffix As String) On Error GoTo DeleteAllTablesBySuffix_err Dim...

That is because you need to update the data field, however you are trying to update the text box. Me.EntryNo = DMax("[EntryNo]", "T_Drug_Receiv_Head") + 1