Recent content by rbinder

Greetings, I am now travelling in my job and having trouble sending emails. I use the normal outgoing mail server (SMTP) when I log on in various hotels or airport but it does not let me send my emails. Is there any universal SMTP address I can use or is there a way of finiding out the STMP...

On Change Hi, In my haste forgot the point; The on change code seem to run everytime I go in and out of the field whether there is a change or not! ~rbinder

Greetings I am grappling with a problem with some code I have put into On Change of a field I set up the field with the following code; Private Sub Location_Enter() Dim sqltext sqltext = "SELECT tbl_Data_Vessel_Barrel_Position.Position " sqltext = sqltext & "FROM...

Greetings all, I have the code I use below but was now wondering if I can add another cirteria to base the dcount statement on. The code is in the beforeupdate() to allow me to avoid the duplicate. What I would now like to add is that the Dcount is only calculated on say a particluar date...

Greetings I am using the code below to try to update some tables and data. My problem is the code seem to only work on one line in the recordset the last line. I have put up to 10 records in the recordset and it still only does the last record. Any help would be great as it is the last bit...

Greetings, I have just opened Access and for some reason my menu bar is gone. I have fiddled for a few minutes try to find and restore it - but I am clueless. It is working fine in all other programs. How do I restore it? ~rbinder

Greetings all, Below is a query were I can get eveything into tow columns but I would like to have the results in one column? SELECT tbl_Admin_Company_Details.Companyname, tbl_Admin_Company_Details_1.Companyname FROM tbl_Data_JobOrder INNER JOIN tbl_Admin_Company_Details ON...

Greetings I was wondering how I go about this? I have a table that holds vessls and barrels in a winery. When I enter data via a form I have a lookup to showme the location of a vessel or barrel. The vessels are static and have a two letter location ie WT or RT etc. The barrels, once filled...

Greetings, I have a strange thing happening here down under with my report! It always want to print to the same printer - we have two printers the network printer and my own. I changed the default setting to my own printer but the report still want to print through the network printer. Any...

Greetings, I was wondering of I can simplify this line of code which to me looks very clumsy. It work but I assume it could be more efficient? The line is; If IsNothing(Me.transvalue) Or IsNothing(Me!FrmDestination.Form.sumtransvolume) Or Me.transvalue > Me!FrmDestination.Form.sumtransvolume...

Greetings, I have also tried this - it gives the same result rbinder

Greetings, I have a subform where I can edit data and I have the following code; Public Sub GotoNewRecord() If Me.sumtransvolume = me.TotalLitres Then Me.LabOpNumber.SetFocus Else DoCmd.GoToRecord , , acNext End If what occurs is that focus moves to a new...

Greetings, I am a little stumped in logic again What I am trying to do is the following If the value is on field is say "OA" then I need an input code of LL0000 or LL00000 in the next field If the value is say "OT" then I need an input code of LL etc What is the best way of going about this...

Greetings, I have a form with three subforms. I have a filter in place to filter the data. I do have to add records to the subforms. I can go to a new record by tabing to it, however I want to use some code so that if a new record is not needed then go to the next subform to further edit or...

Greetings, I am running some code to work on a table and I want to blank a date field. It is a stock control system where when a vessel is emptied I would like the updated field to become blank as it is empty and therefore has no history (this is stored in another table.) The code I have...