473,387 Members | 1,431 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Auto Todays Date & More

Hi all before I begin to tell you my problems just a big thanks to Mary McCarthy who helped me lots. Thank You Mary!!!

Right todays problems are
Getting the date in my form automatically. (read below)
I need to have a butt thatprint an invoice. (see below)
When running a Report the Company name is duplicated on every line of the order details.
I need to have my /cmpanyname/address/Tel/Order Number/ Item description by line/Qty/Line total.then Sum total at the botton of screen

I need to get an invoice to printout after the order has been taken.

With the date problem I have edited the DATE field in my form & in table field. When I put = Date()
I get nothing
some settings read

Input Mask 00/00/0000;;_
Default value is = Date()
Enabled & Not Locked
/
I have put =Date() in the criteria field.

My head is bent with this one.
Thanks
Mark
Mar 15 '07 #1
1 1443
MMcCarthy
14,534 Expert Mod 8TB
With the date problem I have edited the DATE field in my form & in table field. When I put = Date()
I get nothing
some settings read

Input Mask 00/00/0000;;_
Default value is = Date()
Enabled & Not Locked
/
I have put =Date() in the criteria field.
For some strange reason the Date() function won't work in 2003. Don't know what the bug is but someone else might. Change it to the Now() function and it should work fine.

When running a Report the Company name is duplicated on every line of the order details.
Create a Grouping level for the report. Group on Company Name.

Mary
Mar 17 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Gerry Viator | last post by:
Hi all, I have a textbox were a time is typed in like: upto 4 numbers 1900 300 1000 1425 I would like as they type the text to show todays date plus the time they
3
by: | last post by:
how can i make it so that when the value of one field is 15 another field in same record automatically enters todays date? thanks in advance!!
2
by: Chuck | last post by:
Using a macro to output a query to an Excel file. Is there a way to automatically add todays date in the file spec? As: C:\Access Data\ & todays date.xls Chuck ....
2
by: buck | last post by:
I'm working on a helpdesk database - does anyone know how to auto enter the date in a new record; would it be soemthing like iif field is null auto enter?
5
by: Vayse | last post by:
In VB6, I would have used Date() That no longer works. How do I find todays date in VB.net?
2
by: Drum2001 | last post by:
Hello, I am having isues with the following: I have two forms, a MAIN FORM with a SUB FORM: Within the MAIN FORM, I have an unbound textbox (Date Format) and a command button. Onload, the...
8
by: Trev | last post by:
Hi Can anyone point me in the right direction here, I would like to open a table in access 2003 by date. I have an asp web page which needs to read data from a table with each days today's date...
3
by: jonosborne | last post by:
Hi guys, im a bit of a novice being thrown in at the deep end ! Using MS Access 97 i have a table with data that is updated once a day from an Excel spreadsheet. I need a way of identifying when data...
6
by: frys | last post by:
I have a form set up like a journal the top of the page has 2 fields dateID {autonumber) Date (date/time) under these there is a subform with ny notes section
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.