Search results

One more thing, do you know of a way to get a previous records' value into an unbound text box. Would I need to do a DLookup? As I think the SendKeys method only relates to fields of the same name. I think this might be tough.

Thanks for your help. I used a command button where I used SetFocus for each control then I used the SendKeys to add the previous record. Works like a charm. Thanks again.

Does anyone know of a way to have the system run through each control in a table and look for something, and if it finds it to do something to that control. I assume I would need some sort of For Loop. But I cannot get the syntax down right. Thanks.

I tried to autofill to work properly, but could not. As it is based on if the user needs it autofilled or not, he would click a command button. Most samples I see have something in the OnCurrent Event of the form, which I tried to put into a command button with no luck.

I am trying to add the value from the last record into a couple text boxes. I have ran out of ideas, so I figured I could perhaps simulate the pressing of ctrl and apostrophe in 5 different controls and have it bring up the previous records' value.

Is there a way to simulated through VB that someone pressed control and apostrophe and the same time. How would I get this to be added into a certain field: ie: Quantity.Value = (Press the ctrl and apostrophe keys) The client wants this automated. To fill in 3 fields if needed. So I would do...

Does this make any sense?

I have tried a few suggestions from the board, plus a few other things, and I cannot get the following to work properly. A user enters in a record, which includes Transaction Date, Quantity, Price, Buyer, Currency etc. When a command button is pressed, I need it to copy over the present...

I have two tables, one table has all the main transactions in it. Now, the system needs to know what currency to use, which I have figured out. Here is my problem, I created the other table to add exchange rates on a daily basis. I want to use a DLookup to find the exchange rate for that given...

Regardless of what I do to the format, when the text box is clicked on, it adds the seconds to the time. Is there any way of getting rid of this without having to disbled the text box?

I have a text box called Time with the function Now() as the default value. Problem is, if clicked on the text box reveals the exact time down to the seconds. How do I change it to not show the seconds? I tried changing the format, which did not appear to work. Thanks.

This works well if you want a default value for every record. All I need is something that takes 5 fields from the current record and transfers to the new record when a command button is pressed.

I know you can duplicate all of a records data to a new record, but I only want to paste certain fields from the current record into a new one. How do I go about this. For instance I have a field called TransactionDate. Is there a way just to append this to the new record? Thanks.

I have a query where I need to see how many times the same delivery location appears between 2 dates. Then I need to average that. Any ideas? The dates are plugged in from a user through a form.

Thank you, worked great.

I want to find the maximum price between two dates. When I do this, I get the maximum price for each date within the two dates. I just want the highest price in the table within the two dates. How do I go about this? Thanks in advance.

I have tried this before, but I am getting a too complicated error when I use this to get the day before totals under criteria in Transaction Date. [Forms]![frmDates]![txtStartDate]-1

I have a query where the user enters the transaction date through a form. It then totals everything given that date. How would I go about having it give totals for the day before the selected date. Pretty simple I'm sure, cant get it to work though. Would it be (transaction date - 1)or something?

Not very good with queries. I have a query that has 5 fields. Transaction Date, Quantity, Price, etc. I want to create a query where it sums the total quantity of all deals by transaction date. Right now, I am getting the same date popping up several times.

I have added a command button to the form that enables editing on saved deals. With new deals I can enter everything, but when I get to the Save and Print button, I get a "Save Record isn't available". I have to click the Edit Record button before I can save the deal, anyway around this?