Search results

hi, I knw how to import a delimited text file in VBA if I know in advance what the delimiter will be. The reason you have to know in advance is that you have to save the specification so that you can then use it in the Docmd.TransferText acImportDelim, SavedSpecName command. So, for instance...

hi, In the database window, it is possible to right-click a table, select Properties from the context menu and then make the object hidden by ticking the 'hidden' checkbox. How is it possible to interrogate the value of 'hidden' in VBA code? The reason I want to know this is that I have a...

hi, There is a control that Access uses that I would like to be able to use as well. I have attached a JPEG that shows the control I mean. It is the datasheet/grid layout control that is used by Access in the Query Design View, where you add fields and criteria. When designing a form, it is...

hi, can anyone tell me how to find the directory of the current mdb in VBA. I do not mean the default database directory but the directory in which the actual mdb file for the current database resides in. Thank you, Chris

Hi, I have a form that is "Always on top" of the other forms once it has been called. How do I change this ? Is it a property of the form? I have looked under properties but none of them seem to fit the bill, Thanks, Chris

Hi all, To start, I am an experienced 4GL programmer, so I understand programming concepts, but cannot seem to do some very basic things in Access. Let me explain in graphic detail. I want to make a query that selects depending on the contents of 2 fields from a single table. The problem seems...