Hi my friends

Im designing an accounting form with these fields in a continous subform. Next to the Field names below Ill give you an idea of what Id like to try and do.

If I click the date text box on my continous form Id like an imput box to pop up so I can enter the date in it and after I close it the date would populate the text box

This is a combo box which has 3 selections 1. Payments 2. Income 3.Bank Transfers. If I select option 3 which is Bank Transfer Id like a popup tp appear enabling me to
transfer the whole accounting entry line into the account Im transferring it to. How would I go about doing this?

Date If I click the date text box Id like to have an input box where the date can be entered and after closing the input box it would automatically save into the date field for that entry

Type This just describes what the transaction is. Its a combo box which I would like to be able to add new entries to it so it would remember all entries and I can select from the combo list

Category This is a combo box which selects the accounting Category.

Payment This is a text box which payments are entered

Receipts This is a text box where receipts are entered

Balance I would like a running sum total which calculates the total from payments and receipts but would also like to have a way of entering the open balance

Ive been working on several ideas but as usual the best ideas come from you guys and any thoughts on this will be received with much anticipation and enthusiasm

Cheers
Mars

What you want is doable but how depends on which version of Access as different versions offer different options, such as automatic date entry... Please provide whichversion of Access...

Hi Gina

Sorry I just saw your post today.

The version of Access Im using is 2007

Im trying to get an input box to pop up to enter data and then when I click ok the data would fill the the relevant text box.

Thank you for replying

Cheers Mars

Mars,

Since you are using Access 2007 there should be a claendar like option next to the text box provided you are using. ACCDB format. If you are using MDB format then have a look at this calendar option...

http://allenbrowne.com/ser-51.html

Thank you Regina

What Im trying to do is have a continous form which I enter everything in from pop up input boxes which then gets transferred to the appropriate text box

So if I click the Date field I want to know how to get an input box with a text field to pop up and then enter the date in that input box and once I hit enter the date would be transferred into the date text box. I know what you are saying with the automatic date selectors but I would like to be able to have a box pop up for text fields as well in which I could enter data in that input box which would transfer to the relevant text box. I know....sounds a bit crazy but I just want to learn about this particular technique. It may be slower for data entry that way but I really like the feel of this method and would like to be able to use it in my own application design.

So what I have is an accounting program which lists lines in a continous form such as DATE, PAYMENT TYPE, PARTICULARS, PAYMENT DEPOSIT etc.
Some fields will be selected by value list combo boxes such as the payment type which hasnt got many options but the particulars field would have hundreds of options so I would want to click the PARTICULARS text box which would bring up an input box with a text field. Then I would enter a description of the particulars item in the input box and when I hit enter that description that Id type in would go to the particulars field.

Im trying my best to explain this and hopefully Im not confusing anyone.

Again I appreciate your time in replying

Cheers
Mars

I think I'm getting confused...

Step 1. Click Text Box
Step 2. Have Input Box pop-up with Date Selector
Step 3. Select Date form Input Box which then puts the date on the Form

...Is the above what you are trying to accomplish? If yes, it seems you are making more steps when just selecting the Date Selector located next to the Date field on the Form would work. OR did I misunderstand?

Hi Regina

Yes this is confusing...

I want to know how to call an input box with code to pop up if I click a field in a continous form so I can enter data in a text box which is in the input box. Once what I type is in the text box of the input box I would hit enter. Then the input box will vanish and the data I entered in would go to the text box in a continous form. Its similar to the date selector that you are thinking of. The input box that pops up is grey and has a text box in the middle for typing in data. So you enter the information in the text box that pops up and then the data is transferred to the field like a date selector.

Ive got a couple of programs which use this technique. Sorry its really hard to explain.

But thanks for trying

Cheers
Mars

Mars,

It sounds like your going to have make your own Input Boxes using forms. This way you can requery your continuous form to show the data you just entered via the Input Box. I don't see any other way to do this... I will say, from the End-Users point f view, this is not the way I would like to enter data as it requires extra steps.

Ok Thanks for your interest and advice Regina

Its not really slower because if I had to enter data on a continous form in a text box I still need one click to get to the cursor starting point in the text box.

I could set up the input box to pop up in one mouse click on the text box. Then type in the data. Then If I hit enter the data gets stored. So thats one click and one Enter button press for the input box technique. If I didnt use the input box its still one click and one Enter press.

So both methods enter data at the same speed. An example which might explain better what Im trying to do is located at this link http://functionx.com/access/objects/inputbox.htm

As Always I Appreciate the help and time people put in to try and answer my questions
Mars

The only problem with using the InputBox provided by Access is that you can't add code to it and it sounds like you are going to need some to requery your combo boxes once adding the data.