Search results

Marshall, Do you have a reference set for Microsoft Scripting Runtime?? It is required to use FSO. That routine was looking at text files and also data macros that had been saved as text. You probably don't need all that logic. Data macros are associated with tables. When you save to text...

See this video by Steve Bishop for ideas. For more info on the concepts google/bing "RBAC".

Welcome to AWF, Barry!

Welcome to AWF!

See this M$oft link on FileSystemObject some sample usages here

In #6 are these all wire or is flexible conduit also involved? What exactly does layer 1/2/3 represent? Do you "package" the item(s) to be delivered ( multi-wire/multi-product ) on a large spool? If so, is this the typical "item" sent to the customer. Please realize that most readers (me at...

I agree with plog. I'd like to a see a description along the lines of " a day at the office" or " processing a typical request".

Please tell us more about the Null value issue. We need some specifics to understand the issue. Can you post a description with example? Even a copy of the database?

Hi Steve. Welcome aboard AWF!

See this by PBaldy to ensure your logic is consistent.

Hi Marshall, Glad to hear things are progressing and that Notepad++ is helping. For your DDL, try this sort of pattern for names containing space. Works for me! I run this right in the immediate window. Currentproject.connection.execute "ALTER TABLE Employee ADD COLUMN [Extra Notes] TEXT(25);"

Doc. Perhaps, proof that history does repeat! I am old enough to remember Myron -eh- Floren, as LW introduced him.

Good stuff John. You should be in line for a raise or promotion! Glad Edgar was able to solve the issue. I'm sure it would be a great addition to Sample Databases or similar. I'd like to see it and I'm just a dabbler. Congrats Edgar(y) and John(y)

Hi Daniel. Welcome aboard AWF.

An interesting video on electric vehicles in recent Chicago cold snap.

Tom, Can you explain this apparent difference? Somehow you chose the TableDef and Field route -- why- just curious. MajP, This "but not the Fields collection of Index or TableDef objects " seems to indicate DataUpdatable can not/should not be used with TableDef???

I also adjusted Tom's code to use my table: tblTestAuto ' ---------------------------------------------------------------- ' Procedure Name: testUpdateable ' Purpose: Testing Updateable attribute MajP and Tom ' Procedure Kind: Sub ' Procedure Access: Public ' Author: Jack ' Date: 22-Jan-24 ' '...

MajP, I tried the following based on your code. Note the error returned. Public Sub TestAuto() 10 On Error GoTo TestAuto_Error Dim Rs As DAO.Recordset Dim fld As DAO.Field 20 Set Rs = CurrentDb.OpenRecordset("Select AutoID from tblTestAuto") 30 Set...

Hello Sakala! Welcome to AWF.

Welcome Carmine.