Search results

Hi Rich, Is the email field's data type text? Try <> "" in the criteria section. Regards, Martins

Hi there, You already have a one-to-many relationship established between tblContract and tblFinance, which looks good at first glance.You can't use FinanceID as a foreign key in tblContract because there are many transactions for each one contract. So, storing the FinanceID for each...

Hi hatstand, I am fairly new to VBA, but it seems to me that it might be easier to accomplish what you need by exporting from Access rather than importing from Excel (which is what it appears you are doing). Of course, depending on what you are doing, this may not work for you. If you are using...

Hi there- congratulations and good luck on your educational ventures! Some things to remember: Comparison Operators such as <> (not equal to), > (greater than), < (less than), >= (greater than or equal to), etc. are normally used for comparisons between numbers and/or dates (in some cases they...