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, could you give a little bit more information and we might be able to help. I'll give it a go anyway. If I understand you correctly, then you will need to alter the SQL string for the query. If you your Query is called Query1, you can find out what the current SQL is like this: debug.print...

hi, the GetDBPath code is almost right for you. the problem is that it leaves trailing '\' whereas currentproject.path does not, thus giving a bad path. For instance. If you database is C:\Databases\TestDB.mdb, CurrentProject.path gives you C:\Databases, wherease GetDBPath returns...

hi history, I do not have Access 2007 so I am not sure if the following will definitely work. I think it will more likely depend on your version of Windows as it involves and API call. This works on WinXP XP2 / Access 2003. Put this in a standalone code module: Option Compare Database Option...

hi, try: Select Case Wkd Case 1 'Check for Sunday MyDate = DateAdd("d", 1, MyDate) Holidays (MyDate) Case 2 MyDate = DateAdd("d", 1, MyDate) Holidays (MyDate) Case 3 MyDate = DateAdd("d", 1, MyDate) Holidays (MyDate) Case 4...

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...

Thanks. CurrentProject.path was waht I needed. I knew it was somewhere.

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

Workd it out Hi, I have worked it out. It was a property called "Pop-up". See ya, 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

Thanks Hi, thanks to both of you who replied. The SQL supplied by both worked fine. I used the criteria cell method in the end and it worked perfectly. I feel a BIT STUPID but also the scales have lifted from my eyes. My problem was that I had all the "ORs" for Steward in the same criteria...

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...