Search results

Thanks Bob. Unfortunately I'm still having the same issue. I really appreciate your help, I'll keep working on it.

Hello all. I generally am able to find what I need on here without asking for additional help, but this one has me a bit stumped. I am trying to prevent users from putting in a duplicate email address on a form—if they input a duplicate, they should get a message telling them so. I was able...

Redneckgeek--the data type of the field PROCESSED_DATE is Number. When I tried the ISDATE function, I did not get any output. Back to the drawing board! I really appreciate everyone's help! Thanks!

Thanks for responding so quickly. When I try to use your suggestion I get an "Overflow" error.

Hello all--I've got a query where the date in the tables is this format yyyymmdd and I'm trying to change it to mm/dd/yyyy. I have successfully been able to do this for several dates in the PPOLC table by using the CDate function, for example, Issue Date: CDate(Mid(dbo_G_PPOLC!ISSUE_DATE,5,2) &...

Hello everyone! I’m new at building databases; actually, I’m learning as I go as I’ve never had any formal training and this is my first significant attempt. So with that said, I’m hoping someone out there may be able to help me and I apologize in advance for how long this is. A little back...

First off, let me start by saying I'm very new to Access and this is the first real database I've tried to create, so any info you can provide is much appreciated. I created a form where you input a few fields that writes to a table. I also have a button that is supposed to run a query (uses...