Search results for query: *

Glasgow, you may be able to use - docmd.setwarnings warningsoff before your loop then docmd.setwarnings warningon after the loop to solve your problem. Regards Max

If the Number of rows in your table is not to big or you are selecting a subset of the rows.... you could always concatenate the rows into one string and then right each row to a text file... that way you will the pipes from your fields without any further delimiter.

Oh Sorry you will also need to add a reference to the microsift outlook 11.0 object Library hope that all helps.

if you create a module using the below script you could then put an action behind the button you want to use to loop throughyour query result and for each row send out an email to each user by calling the function. script below - Public Function EMAIL(StrEmailRecipient As String...

If the values you are wanting to insert are from the result of a query or held within another table you could open the result and a record set and then loop through the recordset and perform the insert for each row of the record set.... so for example if one time you get 5 rows of data it will...

Scra..... You will always get that message if you use Me.FormFieldName.Value = rs!IssueAssignedNum + 1 you need to replace FormFieldname with your actual name of the field so for example if your field on your form is named ISSUENUMBERFIELD then Me.FormFieldName.Value = rs!IssueAssignedNum +...

scra, Place the code in the form load event.... that way when you open a new blank form it will populate with your new issue number. hope that helps Max

No worries feel free to drop me a line if you need more help! M

Sorry should have said remove that and any reference to set db = nothing as well Cheers Max

Shelby.... You need to keep the line set db = currentdb you set the dimension with the dim line... but you then still have to asign it to your database with the db line. however you can comment out the below as well strsql = "select name from MSysobjects where name like '*_importErrors'"...

Shelby, Where I used db.execute strsql I had set up s string strsql which cleared down a table i was about to load the data to. if you comment out the strsql and db.execute lines but leave the set db=currentdb then it should work for you.... to comment out place a ' at the beginning of the...

could always try using strInputFileName = ahtCommonFileOpenSave( _ Filter:=strFilter, OpenFile:=True, _ DialogTitle:="Please select an input file...", _ Flags:=ahtOFN_HIDEREADONLY) never used it myself but you may be able to get it to work...

Shelby, try checking out this - http://support.microsoft.com/kb/279508 M

The Only Ones I am using that your not is microsoft Excel 12.0 object Library Microsoft office XP web components microsoft visual basic for applications extensibility 5.3 and it all works fine in my version (obviously) otherwise i wouldn't have given you the script lol..... strange that if...

Shelby 1. On the View menu, click Code to open the form's module in the Visual Basic Editor. 2. On the Tools menu, click References. 3. Click to select the Microsoft Office 10.0 Object Library check box. 4. Click OK to close the References dialog box. Cheers M

Shelby I meant - Dim db As Database Dim rs As Recordset cheers M

Hey Shelby, Just noticed your only using Access 2002.... try removing the 'DAO.' as this is sometihng that is needed in 2003 onward... Dim db As DAO.Database Dim rs As DAO.Recordset apart from that pretty much everything is the same. Cheers M

when you split it there is more than one way of connecting to the backend. The most simple way would be to create links to the tables from the front end to the back end.... that way all your forms and reports etc will still work. If you have the backend on a network drive rather than the laptop...

If you split out to a front end and back end... you will be able to access it on your laptop at any time if that is where both are stored. If you then put a front end onto the other two office PC's they will only be able to get access to the DB when the laptop is connected to the network. You...

Hey Sako, I think you will need to use <td> to create extra columns in your HTML table.... Have your initial table creation loop in one set of comments <td>.....</td> and then do the same for your other tables.... i think by doing it this way you will have tables next toeach other appearing in...