Re: Insert Into and automatic record entry

Tech-Archive recommends: Fix windows errors by optimizing your registry

Jeff,

I am glad to hear that all is working well for you. And congratulations for jumping into an aspect of programming that is not entirely simple, and coming through it relatively unscathed. There are some parts of what you have done that I can't quite reconcile, but hey, you can't argue with correct results! Best wishes.

--
Steve Schapel, Microsoft Access MVP


Jeff wrote: 
Thanks, guys.

Steve, I changed the Select to Values as you suggested.

I used the DateAdd as you suggested, but it continued adding one to the day instead of the month.

I don't know the difference beteen DateAdd and SerialDate, only that I changed the order of the days,months and years and it did the trick. The dateserial is working to accomplish what I wanted.

The strange thing about the DateAdd is that I put the same variable on a MsgBox and the date appeared to increase by month, but in the table it shows an increase by one. I can only guess that it's something to do with the sql because in the table after the insert, the date shows increase by day too.

As I said, I'm new to Access and trying my best to understand all this code, learning as I go along. The serialdate is working, and I'm going to copy the db to the computer at school tomorrow. We'll see then, if there is anything amiss!

Thanks for all your help, it is really appreciated,

Jeff


.

Relevant Pages

  • Re: Unbound Formula required urgently please
    ... Your first two DateAdd() functions don't have a closing parenthesis. ... Rick Brandt, Microsoft Access MVP ...
    (comp.databases.ms-access)
  • Re: EOMonth Add-in
    ... You can add or subtract months using DateAdd. ... Doug Steele, Microsoft Access MVP ... > Is there an EOmonth Add-in for Access similar to the one in excel? ...
    (microsoft.public.access.queries)
  • Re: Todays Date + 3months
    ... "Al Campagna" wrote: ... Try the DateAdd function... ... Microsoft Access MVP ...
    (microsoft.public.access.queries)
  • Re: Todays Date + 3months
    ... Try the DateAdd function... ... Microsoft Access MVP ... need to show everyone that is Mobilizing and Demobilizing from todays date ...
    (microsoft.public.access.queries)
  • Re: Calculated Field in Db Table
    ... just added the dateadd to make sure I, and Access 2007, were correct. ... In most cases it won't matter, but when using criteria to specify a date ... Armen Stein ... Microsoft Access MVP ...
    (microsoft.public.access.tablesdbdesign)