Search results

I have a form with a button which imports an excel spreadsheet to a table and then runs some macros. How can i stop the user from clicking the buttong twice and importing the records twice? can i check if the table is empty? thank you

I have a query and the results i want to split them into a new table. lets say the query has 8 fields. A B C D E F G H i want to append these in a table like this 1st row of the table = A B C D 2nd row of the table = E F G H and it has to go trhouh the whole query for all the rows to do...

how can i change the code you gave me to append to a table with different structure.. can i indicate which field to which to be appended? if you see in the excel spreadsheet i am attaching this is the new table am appending to. thanks

Error When i try to run the code you suggested i get this error and i dont know why.. the Date field is not on the destination table.

Thanks! Thank you so much i will give it a try to see how it works.. thanks so much again:D

I am attaching a spreadsheet with two sheets. on the first are the results from query that have matching fields Query2.SOBP and Query1.SOBP and the other one Query2.SOBO and Query1.SOBP Have different values. On the first case i want to append the entries in a table i have already created...

the problem is that the unmatched items are not identical so i have to do more queries on those.. the fields that i will use in the if statement are static. i have 12 different values and i want to use them in an if statement.. can u help me write the if statement?

Let me explain further what am doing.. i am calling a query in my sub Public Sub Find_Couyntries() DoCmd.OpenQuery "query3" after this i need to check two fields. lets say field1 and field 2 if field 1 = field 2 then move row in this table X if field 1 different than field 2 move row to...

Beginners help! How can i write in VB an IF statement that will do the following action IF value of field1 = value of field 3 then move this row to this table ? is this possible? can i move lines based on these criteria?

Many Spreadsheets every month! There are lots of spreadsheet every month that need to be manipulated. its not only one. Besides i managed to import all of them at once into one table. how do i continue with the process. it needs to run on its own.... thanks in advance

:( :eek: I have created a small database that will be used by one person to run a procedure and manipulate the records. Basically i have an initial Excel spreadsheet (File1.xls) and i want to come up with spreadsheet (File2. xls). I managed to automatically import the spreadshee tin accees...

Not working i have tried what you instructed me but it doesnt work. it says that there are 0 rows to be updated. i am sending the table and the query now to have a look if you can. Also when i open the query in design i see olny the fields that have the Is NULL criteria. thank you so much..

i think i didnt explain correct.. this the table i have. on the debit and credit columns u see there are blanks... i want somehow to search for these blanks and fill them with the value "\fp". Date Org FACCT CSUB P/S SOBP Cntry Debits Credits 25-Dec-06 632120600 52156000 RN00788788 2400...

I have a table with three columns Column A, Column B, Column C in these 3 columns i have different values and in two fo these columns there are blanks. I want to search for this blanks and fill them in with a static value. But only the two columns. How can i do this? Update Queries? Thanks you

Can you elaborate on that because i have the same problem? how to import different spreadsheets on different tables based on the file name of the spreadsheet..

I have a default directory that will contain Excle spreadsheets. This spreadsheets have the name of the table i want them to create when they are imported in Access. I want first to count and present to the user the number of the spreasheets. then import one name the table with the name of the...