Search results

Hi there, seemed to be an easy job, but I still couldn't manage: I added a new Field (yes/no) in a table which was set on TRUE by default. All the new entries will get a YES automatically. Now I wanted to change all the old records which were automatically set on NO after the insertion of the...

Hi there, I have the following problem: I have a database and from the “Main Table” I have to delete some records from time to time. The records of the Main Table are linked to other tables. I would like to have another Database like “Archive” where all deleted records are stored in a table...

Hi there, I have the following problem: I have a form which includes a command button. Clicking this button another form will be opened. This 2nd form needs information from the first form (ID etc.) If I open the 2nd form the record is NOT saved yet. Apart from just pressing "Save record" in...

Hi there, Just a (maybe) simple question. I have a form A with a subform B. Subform B contains a list of donations (datasheet with ID, Date, Amount) which were given by the Person shown in Form A. I’d like to include a field showing the sum of the donations. When I enter a field into Form A...

Hi there, I have an ADDRESS field in on of the columns of the report. It is split up into 4 parts (lines). mostly the addresses just need 2 lines, the other two are empty. When placing the items the address field takes, of course, the room for 4 lines. Is there any trick to check whether a...

Hi there, I include an application into a form which opens a folder which is connected to the actual ID. The function below check whether a folder with the name already exists or not. In case not, then a new folder will be created. Strangely, the creation of the new folder works perfectly, but...

Hi there, I added a command button to a form which is supposed to open an "Explorer"-window. The path is related to the actual ID. So far I used the StringFromGUID-command, but it didn't seem to work. Private Sub Command280_Click() On Error GoTo Err_Command280_Click Dim stAppName As...

Hello there, I have a table with about 5000 records. the last record has the ID 7852 (this field was given the primary key and is of autonumber format.) If I want to add a new record, the next ID is given 7853 - as expected. In order to change the structure of the table I copied it (simple...

Hello there, the problem I face is the following. I had to change the structure of a table which contained the contact data of people. Every record resp. person was given an Contact-ID by Autonumber. I had to create some queries to change the table, then copied the query into Excel and...