Search results for query: *

Here is my situation. I have to assign an avg to each player based of their last three games played. I have a table with scores for each game by person and the month played. I need to take their last 3 scores and avg them for each player. So my question is how do I get player 3 to only avg his...

I'm trying to create a new folder if it does not exsit but I keep getting a runtime Error 76, Path Not Found. It only happens if I specify multiple folders ex. Mkdir "D:\Folder1\Folder2". If I put Mkdir "D:\Folder1" it works. What am I doing wrong. Thanks Sna1maa

I have a Multi-select (simple) list box with customer account Names (unbound) and IDs (bound). I want to be able to select the customers I need and then print their reports. So what I need to do is get the list of customers, loop through their Id's, run a sql select based off the first name and...

I keep getting this error 2147217900 (80040e14) Invalid Sql statement; Expected Delete,Insert,Procedure,Select or Update when trying to transfer records to Excel workbook. Here’s my code run from a command button. Dim strMonth As String Dim rst As ADODB.Recordset Dim xlApp As Excel.Application...

What I want to do is find out when a customer hasn't paid his bill for the month and say what month/months are unpaid. So say I have a customer with billing info for 3 years. I have customer Id, Name, Bill amount, amount paid and the month/year it was paid on. Now say customer 1 paid every month...

I want to create a table that will use todays date in the format of "tblmmm_yy" as the table name here is what i have. Im sure this is an easy fix but i just can't seem to get it. Dim strTablename As String strTablename = Format(Date, "mmm_yy") DoCmd.SetWarnings False DoCmd.RunSQL "SELECT...

I have a query that selects all Contracts that are not complete. I need to email the Area manager with these contracts for his Area only. I’m able to send an email to each Area but it contains all the contracts not just his/her area. How do I send all records that are equal to one area only and...

I have found code that will capture a mouse click in the form I use but what if I want to be able to capture any mouse click outside of the form like in another app or on the desktop? This way I can set the focus back to the form. Basicly i want to force them to click OK before going on to...