Search results

How do you Delete a Table with a qeury ? You can delete records but the table still remains.

I just checked and can find no way to Delete a Table. I also can not think of a time when I would want the system to delete a table. Why do you want a table deleted by the system ? If the database is Split the Back End, tables, ussually have the least developer attention ie, Tables are not...

I am not sure of all the pitfalls to global vars but I understand you do have to be carful when using same. As far as having a reference to utilise from anywhere in the database you can do this with a Table. The benefit of a table is it can hold more information, if this was required and...

I just realised, you know how to email a .pdf. You are holding documents within a table in your database, doesn't this cause the database to be quite large ? This link may assist...

Here is a DoCmd example. DoCmd.SendObject acSendReport, "Rpt1PageApplication", acFormatPDF, varTo, "Loans", , stSubject, stText, -1 The attachment is Rpt1PageApplication

MyMail will do this. Sample code, below, uses variables to find the correct attachment but you can just hard code the path and name if it is not different every time. 'Create variable for Outlook Mail Dim MyOutlook As Outlook.Application 'An Outlook Application Dim...

Check your Modules group. Do you have any functions there ? Help is never far away and the vba section of the forum ussually has the most visitors. With vba code it is a little easier to join string as you can get one value, hold it in a variable and then get another value and join the two...

Sorry, I am not sure how you would join text for records in a continuous form. You could create a UDF (user defined function) to do this and put this as the record source in the footer/header control.

You could use Code (vba) to do everything. eg have one button that when clicked asked the operator if they want to Preview the report (yes) or Printit (no) or cancel the action (cancel). Get the response and act accordingly. Yes would Preview the report, No will Print it and cancel will do...

Create are normal Select Query with the important fields. When it displays all the data you believe there should be, click the Totals Button and use Group and Count accordingly. Count will of course give you the number of records for each Group - Teacher. Sort Order on the field you are...

I you are spending your money, I would go with 2010. You may not notice any issues with the difference. Both 2007 and 2010 use accdb, if that is the file type work has. My fear would be work will upgrade and you will be left behind. Unless there is a cost saving in buying 2007, go for 2010.

Test qrySubRates. It may well have an error in it.

This is a solution for Dates. Looks like a subquery http://stackoverflow.com/questions/9142634/how-to-do-self-join-on-min-max

I understand, Thanks. I jumped to the conclusion that a control named Project_Number held a number.

Thanks Paul, I assumed datatypemismatch was because either the data was different ie text/number or the code couldn't understand what it was ie hadn't been declared. Your solution is really just correcting the code string which I guess means the code was "correct" just couldn't be read by vba ??

Good news but what worked ? My guess or Pauls experienced advice :)

Declare your project number variable first and use that in your strSQL. Dim ProjectNumber As Long ProjectNumber = Me.PROJECT_NUMBER strSQL = "SELECT * FROM Table1 WHERE Table1.Project_Number=" & ProjectNumber

Try =[fieldOne]+[FieldTwo] for the footer Here you use the text box control name, not the Control Source name.

Before this line of code DoCmd.SearchForRecord , "", acFirst, "[ContactID] = " & Str(Nz(Screen.ActiveControl, 0)) Add code to evaluate the data entered and compare against any data in text boxes on the form. To do this you will need to use code something like this: If Me.thiscomboname =...

Here is an sql I have played with. Doesn't replicate your situation as I have entered the start and finsh values where as ou have them in your records. The sql returns all records for TBLLOAN and only thos records in tblBulkLateFees where there is matching data ie there are a number of empty...