Recent content by mikebaldam

Are you just looking to set the display order for a dropdown? You can do something like this for your dropdowns rowsource: SELECT Table1.Col1, Table1.Col2 FROM Table1 ORDER BY Table1.Col2; Or via vba me.DROPDOWNNAME.rowsource = "SELECT Table1.Col1, Table1.Col2 FROM Table1 ORDER BY...

then do the same... or provide more info

Check the MAX function out ...

This should point you in right driection.... http://access.mvps.org/access/forms/frm0031.htm

Here is a nice and simple break down of how to reefer to Controls, Forms, Property's and subforms. http://access.mvps.org/access/forms/frm0031.htm

you can use the me.cboNAMEHERE.Column(2) to reefer to a 2nd column (although i think the count starts at 0 so 2 would be 3rd... but you can check that easily enough)

Check out using a recordset. http://www.everythingaccess.com/tutorials.asp?ID=VBA-Traps:-Working-with-Recordsets

Can you link the data..? If you can link the table so you can have a local query is probably easiest Or try an export /import Export a Query Import a Query You could auto export/import the queries then run a routine to do whatever you need on them..?

Try having a look at the export report features, it can be exported as a HTML file and hold data from your query

though if you can use a domain address (not ip) it will always point to the right IP address (they do change from time to time as servers are moved)

Please Note this is not a secure fix but if your just trying to keep it very simple: Dim strInput As String, strMsg As String strMsg = "Enter the password." strInput = InputBox(Prompt:=strMsg, Title:="Password", XPos:=2000, YPos:=2000) If strInput = "APASSWORDHERE" Then 'Do Whatever...

Here is the code i use to import an Excel file directly to a table Dim msgret As String Dim strDir As String msgret = MsgBox("Are you sure you want to import a new list?", vbYesNo) If msgret = "6" Then strDir = CurrentProject.Path & "\Data\" 'or amend to your excel filelocation ie strDir=...

Or check the word document, put it into mailmerge view (click tools - mailmerge) and a new toolbar shows up and check to see if you can select your new field in there (insert merge fields). If you cant check the db query you call into the word doc and add the extra field then check the...

You can export as an XML file. (including Schema if needed) If it still needs tidying try opening the xml via vb and using a replace function on the xml file.

Heres a module to do the work for you.. it backsup everything in the database (tables, queries, forms, modules ... everything) if u have any hassle let me know n ill give u an example mdb Call it with... Call ExportDatabaseObjects Public Sub ExportDatabaseObjects() On Error GoTo...