Recent content by techcrium

I heard it's bad design to have forms directly binded to a query because you have no data control. Is it better to make forms unbounded and then have users fill it out, and use VBA to programatically validate the data and insert into the database?

ok i got it. Thanks!

I have an Employee Table with columns EmplID, FirstName, LastName, Birthdate, Gender, etc I have a Position Table with columns PositionID, Title, Level, Description, StartDate, EndDate, etc I have an Education Table with columns EmplID, School, StartDate, EndDate How do I build a single...

ok thanks. I managed to find the error, but I was basically doing brute force: I took my excel data, deleted half, tried to import it. If that didn't throw at error, I would take the half of the other half, and so on. Apparently the error was that a number did not match table key constraints...

I use a piece of code to transfer Excel files into my MS Access database. I use the DoCmd.TransferText method to do it. Sometimes, I get errors which I automatically get notified. However, it is a big excel file with alot of rows and columns. How do I pin point exactly which column or which row...

Hi, anyone know when you should use which to solve your problem? For example, lets say you have to find the average of a list of columns in the table. You can either A) Use SQL: SELECT AVG(column_name) FROM table_name B) Use VBA: Pass the table object or call the table object, iterate...