Search results

I have this combo box which has two colum: tool and tool size. This combo controls a subform linked to "tool". I was wandering can I sort the data in my subform using both the column in the combo box? Thank you

how to? Thank you, The database is read only but for me who upload and manage the data entry so I guess this could be done, the only problem is that I do not know how? Sorry, can you at least put me on the right way? Thank you also for the 2 GB limit, I did not know that. Ciao

Is this feaseble? My table are on a server linked to the user FORM, Queries ETC. The server, is somehow slow. I was thinking: is there a way to have all user to have all the DB in their hard drive and only refresh the new data I will put on the server each time they open their database? Thank you

can he read minds? thank you for your answer, I would like access to give me an error message and abort the import. If it is not asking too much Access could ask me to modify the data and the go on. Alternatively he could skip the record and past it in the paste error table. I guess the...

I can now import data in my table using the transfer spreadsheet macro. I would like to set a simple validation rule in my Field that contains number to make sure the value entered is really a number and not something else. Thank you once again for your help!

why not I guess I will do something similar to what you suggested. I Import the data given a large range of the spreadsheet, then I append them to the table using a appen query where criteria for the field containing the index key is: Is Not Null. Still it would be more elegant, I guess, to...

I am populating my database with data from an excel spread sheet. I am now importing the data by cutting and pasting them in a table. I would like to be able to import the data directly from the excel spread sheet, without opening it. I have found out that there is a macro to do that but the...

Thanks also to the people of this forum I was able to come up with something nice and useful. I then discovered access XP pivot chart feature. I installed Access XP over access 97 on my computer at work but it doesn't work. I cannot drag and drop field as it should be. I can only see the...

I will bite that TY Very useful something to explore. Thank you

I have this query that works, for once properly. it is a date query. it finds records between two dates. I used criteria of: Between [Type the beginning date:] And [Type the ending date:] in the criteria field. Now I have to put in the date manually. Is there a way to have drop down menu or...

don't ask me how Funny enough, if you are still wandering, I imported my database in access XP and magically all it works as I whised in the first place.Now I will study the code and see where the mistake was. Thank you Enrico

still nothing.... it looks like I cannot make it work. I am afraid there must be something substantially wrong. I will surely try again when I have less work. Thank you anyway for you help. ciao Enrico

I will try tonight Thanks for your patience. I will try this as soon as I can. I must make it work! Ciao Enrico

lets see.. thanks for still answering me. As a matter of fact you are right. What I want to do is requery the WellName field in the subform when I update the combo box called [B]cbowellname[B]that contains the list of [B]WellName[B] in the form header. I would like to do this cause with...

When I do as you suggested and try it gives me an error messages saying that the Macro Me. does not exist. Anyway I paste here my code, maybe you can help if you feel like. In any case thank you a lot. Option Compare Database Option Explicit Private Sub cbotable_AfterUpdate() 'Déclaration...

thank you but.... Thanks but I have no idea where I should put that code line. I would like to have this requery in the combo that changes the subform shown, is that possible? Moreover do I have a macro called Me to make it work? thank you

I have spent a long time trying to do this but no chance I would really appreciate some help. I have a form in which there is a subform. Two combo boxes control the subform. One queries the subform by WellName the other select the desired subform Es subform with geological data, subform with...