Search results

Hello all, I need a help in this: I have to generate text files from Access that define the details of bank transfer records. I'd like to do this automatically as all necessary data are present in my database (like partner data, invoice data etc). This text file needs to be done according to...

Hi DCrake, Thanks a lot for the simple solution. I did not know Dir. Only problem is that when the network is not available than Dir("\\Compaq3\Ugyvitel\Elokeszites.mdb") gives an error message. But I can handle it as a simple error occurrence. Thanks Peter

I would need some help in the following question: From a database I open another database with the following lines: Dim strDB As String Dim strCmd As String Dim objSecuredDB As Access.Application strDB = "\\Compaq3\Ugyvitel\Elokeszites.mdb" strCmd = SysCmd(acSysCmdAccessDir) &...

I have one more question still in this topic. I'm using now this code for opening the other database: Sub OpenDatabase Dim strDB As String Dim strCmd As String Dim objSecuredDB As Access.Application strDB = "C:\Ugyvitel\Project.mdb" strCmd = SysCmd(acSysCmdAccessDir) & "\MSAccess.exe "...

Thanks a lot!

I need a little help in the following topic: There is an Access (2002) database used at our company covering its different tasks; different mdb files are used for different tasks (storage, invoicing etc.). All of them are linked to a central file that holds the tables. Some of the users use...

What you wrote sounds logical but I need a practical double check... Where can I see this container? Do I give its name or it is generated somehow? I observed that when I click to a subform once in edit mode than I have different properties from the one I have after the second click. The...

I'm trying to do the following: I have a form, let's say Orders. I have a subform with the order articles, called OrdersSubform. I'd like to go to a new record on the subform from a Visual Basic code and give a value to the new record. While I can easily use the GoToRecord on single main...

Hello, I’m new in this forum. Any help is appreciated in the fallowing topic: I’m using an Access (2002) database for handling my company’s administration. There is a network with 5 PC in our office. One of the PCs has all the tables that the whole system uses. On each PC an Access runs with...