Search results

Hi, Im trying to write a simple procedure that i ac kick off of an evening and the process will start at a designated time. Ive put in a simple loop that will run untill a certain time and then show a message. When i have it working I will incorporate it into the full procedure. unfortunatly...

Thank you. That worked a treat.

Thanks but I still cant get it to work. In the Control source of one of the fields on the report I have chaged its value from Demand to =Abs([Demand]). This produces an #error on the report. Any suggestions

i need to force absolute vales on the detail part of a report. That is how its displayed on the summary table. The report is based on a query which reverse the signs of one of the two lines in the summary table. This done so that the sum opn the report footer will actually be the net ie first...

thanks .

thanks guys. The first fields is a date field so can i not order on this field and save the changes. ie the first record will allways be the latest date.

I have had to put some code in the detail part of a form. It worked fine but I need it to do some more calculations. How do I go about getting two differnt pieces of code to run in the detail_format part od the form. thanks

i want to store a maximum of 90 record in a table. Each day a new record will be added so i want my code to count the number of records and if it over 90, delete the first record. Im fairly new to code so any help is appreciated. the code i have so far is Function record_count() Dim db As...

I want to open one database from another in code. The second database is accesed by a work group. Is there any way in VBA I can by pass the workgroup login by placing the password and username in the code. If any one has an example of this code it would be greatfully appreciated

I have a lable which runs a process. I want it to change colour on mouse move. i put this code in but it doesnt work. Can any one tell me where Im going Wrong . thanks Private Sub lblPage1Label1_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)...

thanks for your advice. It was very helpfull. The procedure was a " see if I can do it" senario. Once the core code worked i tweaked the code to use you naming convention

That worked. Thanks allot for you help Drew.

I Have 2 controls on a form . One is an option box and the other is a command button. on the command on click comand i have put a simple if statement that says if the option box is ticked, open the report print preview else print the report. When i run itIt gives me the error "object doesnt...

I want to export a table form my database to excel where the name will contain the date. in the export directory ive put "C:\WINNT\Profiles\mcgrco\Desktop\test" & (Reports![cob]![Reporting Date] & ".xls" This just gives me a failure creating file message anyone one got any suggestions...

Does anyone know some code to get the progress bar to run when a macro is running

Thanks Robert but the text box is based on the calender. i want to see how the proper code would be structered for refernce. Can anyone else help. thanks

I have a active xcalendar on a form. On click it updates a text box on the form and updates a tbale with the date. i want to put a button on the form that closes the form only when the date in the text box = the calender. IF the text box is blank, then I want a message to appear. the code im...

I am just starting to learn VBA in Access so have limited Knowledge of code. I have converted a macro to code and at certain stages along the macro i want to update a lable on a form. I have inserted the code prglable.caption = " CFD import" but the code keeps falling over. Do i need somthing...