Search results

How can I set up a form that asks for an inputed date then using that inputed date it opens up a new form for entering totals based on the inputed date. If the date already exists I would like it to pull up that dates information in the form instead of 0's. Any help would be great.. Thanks...

if anyone else wanted to take a look and make any suggestions IM all ears :p

Sure, you can take a look... It still needs a lot of work of course. Dont laugh at it.. lol its a work in progress. The fulltable table is the main table.. And then the newtab is the main form. Thanks for taking a look, Any help would be awesome Chris :cool:

This is a pretty good question.. the calender control 11.0 ms access 2003 provides is a very nice little addition to what im working on. Ive searched and searched to no avail untill now. The calender control does not provide an update on click. You have to manually enter the code for the on...

lol, we'll should i set up a table with an autonumber as the primary key then just use a date as the second record or something? I'm a newb here :rolleyes: *edit* I was doing some reading on another site and I found some pretty good info which sort of got me in the right direction. I will be...

Thanks, and ya... sorry for the double post, the other post was more dedicated to a simple yes no relating to if i could even set a user input for a query but there both related. Sorry :rolleyes: Chris

Would you say using the date as the primary key when creating your table is a bad design idea? And if it is what would be a better way of retrieving data based on a date? Thanks Chris :cool:

I have a table set up which uses date for primary key. That being said, each record is based on short date. Can i make a query that uses input from the user? I ask because i would like the user to input a date, then the query displays a sum of all dates previous to the inputed date. Any...

Ok, I have my table set up with the date as the primary key. I have a form set up for the table. So far I have the switchboard open the calender control... I have a button on the calender control form to open the correct form for inputing daily numbers. I would like to use the calenders...

Awesome, thank you much. I'll go check em out :D

I'm creating a site for a guild I'm in for world of warcraft and I was wanting to put forums on my site. I really like these forums and i know exceltip.com uses them too. Anyone know if i can download a template or where i could get something similar.. I know about phpbb.. but thats about it...

Awesome, I think that will help a lot... thank you. And ya, because im taking away the record navigation I need a way to submit the data to the table, a button is fine. You got the script to do that by chance?

Oh... I'm sorry! lol.. in the original post I did mean records... not tables. Ya, I need the new record made on click of the calender based on the date in 1 big table.

Thats the whole point in using the database. Dont see whats wrong with it?

I was looking through some of the stuff access has to offer when I came across the calender control. I really like its set up and what I would like to do is create a switchboard to link to the calender then have the user click on the correct date. I need the date clicked to create a table...

I'm looking for a way to have a form set up that has a submit button on it so that when it is pressed it takes the data and inserts it into a table. I need to make sure the button is only pressed one time. And.... I would like to take away the new record, previous record ect.. buttons at the...

Should I be using access?

Actually, this is to keep updated records of financial info. I get a print out of numbers every night with things like total room revenue, total restuarant revenue, taxes and basically all revenue for the day. I get a nice long list from 1000 to 9000 of diffrent stuff ranging from banquet...

I have 2 questions here, First I have a lot of info to enter a night. Should I make 3 seperate tables for my data and use 3 seperate forms or should I make 1 Large table using 3 forms to input data to it? How can I link the forms using a command button? All 3 forms are made from the same...

Awesome, that'll save me some time for sure. How do I go about doing that?