Search results
-
M
Import data (transfer) from excel and exclude some coloumns/rows
Difference number of columns...Can I deletecolumns before importing? Yes. I can do the way you are suggesting, but the problem is following: - How to hide messages the system gives when importing (key violations)? - How to store both excel files in the same table according to difference number...- metad
- Post #7
- Forum: Modules & VBA
-
M
Import data (transfer) from excel and exclude some coloumns/rows
I havealraedy seen this, but... this will not solve my problem because the information stored in some rows/colomns are not good (Text as number/Number as text i Excel) and I want to exclude this rows/columns. If I make a temporary table to import everything to this table, I will still get...- metad
- Post #5
- Forum: Modules & VBA
-
M
Import data (transfer) from excel and exclude some coloumns/rows
I did not found anything in the help file!! I have already done that, but nothing worth there. Have you any tips? Thanks metad- metad
- Post #3
- Forum: Modules & VBA
-
M
Import data (transfer) from excel and exclude some coloumns/rows
Hi. I know how to import data from an excel file to a table. But my problem is to exclude some rows. I have tried following, but it does not work: DoCmd.TransferSpreadsheet acImport, 8, "FlightInfo", "C:\Avgang.xls", False, "A, B, D, G, J, L" It works, if I write "A:L", but I do not want C, E...- metad
- Thread
- Replies: 7
- Forum: Modules & VBA
-
M
Expert helps needed!! Continuous forms and change color when data changes. pls help!
Thnay you. Solved Hi agian, and thank you for your tips. Yes, I was talking about using Conditional Formatting on the whole row based on the value of one field of that row. I marked the hole row and then used the following condition, and everything is working: DateDiff("n";Now();[ActionDate]... -
M
Expert helps needed!! Continuous forms and change color when data changes. pls help!
Hi. I use MS Access 2002 and I have a database with 2 forms, one in continuous view. I want to change background colors (or text colors) when a field “ActionTime” is closed to the actual time. I have studied a lot of threats here, but still I have problems to make it works. To test the... -
M
Go to current record after closing and opening the form
Thnak you again. I have find the solution with requering metode. -
M
Go to current record after closing and opening the form
Could you please explain more Dear Pat, Thank you for your response. Could you please explain a little more "requerying the form and searching for the key of the record"? Thanks in advance. -
M
Go to current record after closing and opening the form
Hi. I have a form which has a lookup function. The lookup field (a combination box) is collect information about 8 fields from a query. The problem is that I can not see the information before I close an reopen the form. When the form reopens, it goes to the last record. I know that I can get it...