Search results

Thanks for replying. :) Worked first time.

Based on advice given to me in another thread, I have implemeted a table with a single record and a single field which will contain the value of a variable. On certain events, code will run which will: a. Extract the value of this variable from the table. b. Do some stuff Now I've got...

Thanks a lot. Worked first time. :D

I've got a ComboBox with 2 columns. Getting to the value of the bound column is straightforward enough, but can I get to the value of the other column?? If not, does anyone have any workarounds?

Thanks for replying. I'm not at all concerned about an elegant (or not) solution. I just want it to work! If I used windows task scheduler to open the database, but the database was already open, would that trigger the autoexec?

Thanks for the reply. :D But if I did that would I have to have a different query for each value of Rates? Rates=1, Rates=2, etc. Is there a way I can do it so that it takes care of all values of Rates. The reason is that the values of the rates field might change from time to time.

I can't seem to be able to get the SQL right for this query. I have two tables, TableCustomers and TableRates. Both tables have CHARGES and RATES fields. I also have a form which updates the CHARGES in the TableRates table. After these changes, an update query is run that should update the...

I currently have a function which is manually executed on the press of a button. What I would like is to have code execute once a month automatically. Is this possible or plausible in VB? ? And how would it cope with the fact that the program would not be running 24/7?

Right on the button. Thanks... :rolleyes:

Thanks for the reply. I put the print in a macro because the code in the button does some other stuff as well. I tried putting DoCmd.PrintOut in the button's code but that printed the form. How can I print out the report from the button in the form using VB?

I'm trying to print off a report after the user clicks on a button in a form. I created a macro to do this and it is set off in VB by DoCmd.RunMacro ("PrintMacro") It prints OK, but the trouble is that it also prints the form as well. What do I need to do to have it print ONLY the report? :p

Thanks for replying. What would be a better way of calculating balances, or where can I go to find some more info?

I have a table which has the fields RATE and AMOUNT_OWED. How do I get a query/function to traverse every record in the table and add the amount in RATE to the amount in AMOUNT_OWED for each record?

I don't get a third option. All the wizard gives me is a choice of how to get values to populate the combobox, that is, a. look up the values in a table or query, or b. type in the values that I want :confused:

I have a textbox on a form and what I want to do is have a user enter a value, click a button, and a query will run. The fields of the query will be used to fill out a number of other textboxes on the form. I know this must be simple but I can't seem to get it. If I specify the query in a...