Search results

Dear Simon, Thanks a lot for your feedback. Most of your terms are not really clear. Particularly slowing down happens when I set a record set from a FE form. For example these lines down here take minutes to perform: Set dbs = CurrentDb feltNaptar = "Select * From AlapNaptar Where...

Dear Galaxiom, - I use indexes only that are set by Access automatically. Actually I don't know what indexes are for and how I'm supposed to set them. Is this okay? - Please specify a bit what you mean by queries returning the minimum data required. What I have noticed is that particularly...

Hi, I have a quite complex database for running my company. Tables are on the server, five users are linked to this, using different modules like warehouse, bookkeeping, service etc. I developed this through years for covering the company's need, however the speed is getting critical. I'm trying...

Dear pr2-eugin Here I'm attaching the screen shuts of both tables' structure and the relation. Kivétek (many side) has 14 000 records at the moment. KivetekRaktari (one side) has 3 300 records. Can you see something? If you need any further info or translation, please let me know. Peter

Unfortunately I had to modify a database quite deeply due poor design. I had a table (Table A) that was used on its own before. I had to define a new table (Table B) and between them establishing a one (Table B) to many (Table A) relation. Some values were copied from Table A to Table B. A sub...

I'd like to print out a report so that each record should be printed into an individual pdf file. When printing manually, record by record, I use an app called cuteprinter for converting reports into pdf. But that one needs saving path for each individual pdf file. What could I do if I'd like...

I'm trying to prevent my database from copying it. I'd like to read out a pc specific parameter that would be identified in a code before starting. Could you help how to read out such a machine-specific parameter? (like machine serial number, mac address or something similar) Thanks in...

Could somebody help how to read out from a VB a unic machine-specific parameter? (like machine serial number, mac address or something similar) thanks Peter

Hi Pat, The thing is that I can't find an option of importing tables from another database (in Access 2010). I could only export the tables from the old database to the new one. But I can do it only table by table, one by one. I have nearly 100 tables in the database, must be possible to...

Hi Pat, Thanks a lot for your hints. Unfortunately the tables that are out of the page can't reached, I can't delete them. In the second option you say I could import the tables from a new database. However in Access 2010 I can't find import option but only export and only by table. Could you...

Hi, I have a database, originally made in earlier version of Access, recently converted into Access 2010. Due to the high number of tables relationship page is quite crowded. My problem is that I can't move the page to the most left-upper corner of the relationwhip page where I still have...

I have the very same problem: just changed from Access 2000 to 2007 and when trying to open a pdf from code I get the same message (having Acrobat 9.5). Interesting is that only on one out of the six pc that are sharing the same system. I can't find the reason. In my case it does not help if I...

Thanks a lot for your help. I agree but sometimes it would be easier to locate a public sub in a form when the sub needs values from that forms' own fields. So reference woulbe be much easier. I'm trying your suggestion: Call Forms!ProjectKondicioTar.Test But I get an error message...

I've been trying to solve this problem for I while with no succes. I found no matching questions in this forum, either. I'd like to call a public sub of a form from its subform. Is that possible? Thanks for any help Peter

That's doing exactly that I was looking for. Thanks a lot for your help!

Hello All, I have a question but its rather difficulties to put it on paper as I don't know the exact terms. I try my best, please help if you can. I have a PC in our office on which I have all the tables of the db. Users are connected to these tables by linked (or attached?) relation from...

Exactly... Thanks a lot!

Hello everyone, Could someone give an idea how I could code the followin task? path and filename is always known - if exists. However existence has to be checked: If path\filename exists then delete path\filename End If Thanks a lot for any help petko

Hello, I'm making a text file with the help of the following procedure: FileNum = FreeFile Open "path\filename.txt" For Append As #FileNum Print #FileNum, "Content" Close #FileNum Could someone advise a procedure that would create the file (like this example) if the given path\name does...

Thanks a lot for your help, it works fine. From the help I can't understand what the filenumber in the Open statment is for, it just don't specify it too much. Is that someting important to know? thanks peter