Search results

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...

Can you post an example to look at? You can get around the problem by doing a seperate lookup for the email address ie do a query for email and set on subform current action (but its not the best way and will re-query data so slow down the db). If its working on the form but not as a subform...

Hmmm.... Ok here is what microsoft say about it http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.access.formscoding&tid=381f6860-cd15-4d29-94d2-e3d6676d340f&cat=&lang=&cr=&sloc=&p=1. Can you post your MDB (stripped down) ?

Whats the error no/message you get ?

Take a look at the DateAdd function... open your database and press F1 for help and it gives a list of examples including how to add (or subtract a time period) i.e. DateAdd("h", 1, [Start Time]) will display a date/time 1 hour after the start time.

Hi, Im not sure I know what you mean, if the code is running on startup this should hide the main DB window and only allow the Switchboard to load. Mike