Search results

You need a reverse DNS lookup for Hotail / AoL etc to accept your SMTP mailserver. This is normally done when you have a static IP address. you will need to check with each hotel if they have a reverse DNS lookup that you can use. Cheers

I would put the following in the ON Current Event for your form where a txt_DepositField has Depositfield as it's source. Enter txt_DepositField = [costofQuote] / 2 the square brackets are optional. I hope this helps. Good Lick

I would have checked for zero length string before calling the function. Each to his own though. Cheers

You have not explained your problem very well. Please give some example fileds for each table. Cheers

I would look at a remote access program like 'Radmin' for update the remote server. I work from home and use it all the time. It works brilliantly and allow file transfer as well as complete use of the remote computer from home. Cheers

you can just enter the decimal number that is shown as foreground/background colour after you select the eillipsis (...) to select the colour in the properties table of a textbox etc. If you want the individual RGB numbers select 'Define Custom Colurs' from the popup box. cheers

All characters are stored as ASCII characters where 0 - 9 are stored as 48 - 57 A - Z is 65 - 90 a - z is 97 - 122 so Function RemoveAlphas (ByVal AlphaNum as Variant) ' why is this a variant and not a string? Dim Clean As String Dim Pos As Integer Dim temp As String Pos = 1 ' what is this...

Generate a new query and select 'find unmatched query wizard'. the wizard will guid you through it. If you are not sure just do it and see what the result is. you will soon realise if you have done it the wrong way round.

you do not say what the conversion error is. Is it text, numbers dates??

this is because you have one to many relationship with payments and each cottage. You can get over this by putting the payments on a form and adding this as a subform on your cottage form.

I load a form on startup that is hidden e.g. DoCmd.OpenForm "frm_VariableStore", , , , , acHidden Have a text box for storing variables and refer to them by forms!frm_VaraiableStore!txt_Var1 = ### etc then in the query place > forms!frm_VaraiableStore!var1 and < forms!frm_VariableStore!var2...

You can use ''File', 'Get External Data', 'Import' to import your excel file into access into a new table. You can then perform an unmatched query on the two tables and decide what to do form there.

in the textbox that you enter the field 1 date use the text1_AfterUpdate event to say text2 = dateadd("yyyy",1,text1) or text2 = dateadd("dddd",364,text1) Good luck John

Have a look at 'fixing access annoyances' by 'Mitchell & Callahan' (No relation) o'Reilly publishers. there are some excellent tips here.

Is the database split? i.e. is the data on a back end? I have encountered this problem when the back end database is changed on the original machine and the back end on the other computers is not the same? john

I echo Boblarson's comments Great Tool!! Thanks John

I am not thinking straight. Probably an easier way to do this is: DoCmd.OutputTo acOutputQuery, "QueryName", acFormatXLS, "filenameIncluding Path", False (has fieldnames or not)

You can very easily export a table using the Docmd.TransferText or Docmd.TransferSpreadsheet, see VBA help for the syntax. If it is not a table then you will have to create the table from a query that you want to export. cheers john

If the bound column is the third column then strWhere = "[invoiceID] = " & Me.ListboxName.column(2) as the column numbers are zero based John

If compact and repair does not work you will have to export the report from your backup.