Search results

Hello, i need some piece of advise here. I have created a form with some boxes on it which include in their body textboxes and labels and combos. I would like to know if it is possible (or if a control exist) to group this items which are inside the box and with a simple box.visible = false to...

Thanks for your answer, very helpful. But my tables are fixed, i do not create and destroy anything. When you say create and destroy you mean load data and delete them? For example read some records from a file and later on docmd.runSQL "DELETE * FROM ... "; Good thought with the other database.

Hello, I would like a piece of information from you experts. In my access applications i have used the database split built in functionallity to split my frontend and backend tables. But i have a problem with databases that grow very bit, to 1.5 GB over the day. I have created a mail mechanism...

Hello, one question, can i have static methods / functions inside a class body in VBA?

Can anyone help me please?

Hello, I have a problem and i need your advice. I am creating an access software that browses for a folder with *.doc(x) files and for each one of these adds custom text with formatting at the end (as a new line) of each selected section, meaning header or footer. I have managed to create the...

Hello all, I have a problem which i dont know how to face. I have a database on a server share which is split into frontend and backend, users get a copy of the front end via a vbs script i have made, from a shortcut in their desktop. All are very good so far. Recently i found out that another...

Good evening, I have a form which is bounded to a table. I had a textbox bounded to a field in the table where the user freely entered text. Now i turned this textbox into a combo and from another table i get a code and a description in the rowsource, i bound to the code (second column) and...

Well thanks a lot, i manually edited Allen code and insert a function before the event that creates a new record for the table. Function resets the autonumber to the highest value, and later a new record is created safely with the highest + 1 autonum. Job Done, thank you all.

There is no append query, just in a code on the click event of a button, a docmd.goto new record. Well i dont know what it is but the seed stops at a value and another value bigger than the seed exists in the database so it throws the message about duplicate key.

Hello, I have an Access DB in which there is a table with an autonumber field in it. For some unexpected reason the seed does not work as expected and i am obliged to use a fix i found from Allen Bourne site, there is a function that resets the feed to the last correctly used value. The...

Hello, I am in a phase that i have frontend that i distribute to some network users through a copy procedure and some backend databases with linked tables. Well my question is, how can access database frontend understand if there are no ldbs, no users have opened the backend tables so to...

Thanks for your reply, I installed Microsoft Access Runtime 2010 on the Server. When i try to open the *.mdb databases that i have on it, there seem to be many problems that start with missing ocx files and in the end of the process a run time error execution appears and after clicking ok the...

Hello, I have a question to make. I have a production server that is a file server, holds shares and some databases in access 2003 format. (mdb or mde) files. We added a new WS2008 server and want to move the shares and databases in it. We are going to install Office 2010 professional in it...

Thanks a lot you made it clear to me. That is the best way. Thanks again!!!

Hello, I need some piece of advice here. I have a database that will be put into a network share so to be accessed by some users maybe at the same time. In order to achieve some security i have seperated users into some groups. Well i have a main form that according to the user logging the...

Well the news are that i replaced all of my queries that read from the text file with code, surpisingly all seemed to work ok, but in the morning it says that the text file is opened exlusively from another user. Do you suggest in my code to tell, if the file_is_opened, close it, then reopen to...

Thanks a lot for the help i will keep you informed if i resolve the matter. Wish you all the best.

Through vbs i always give a copy of the current version of the frontend each time the user double clicks in his desktop icon. I dont ony run the db through vbs but i have written some code to copy the front end to the user and do the other stuff like opening the database with the linked tables...

What i think of is that the first time the macro runs, stays stuck, then the consecutive runs every half an hour stuck and report the error i give becasuse the database is left open and stuck in the macro by administrator. The question is why in the first time the macro does not finishes and...