Search results

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

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

Greetings all, done a quick search and came up empty handed what is the best way to use 'or' in a Case statement. I am using Case "14" or "15" however it only seems to recognise the first number not the second. Sometimes it does not recognise either number. ~rbinswe

Greetings all, I have the code below which is giving me grief as I have copied it from a previous usage and it worked fine. I have tried it in a beforeupdate and now as a seperate button on the form and it gives me the same error message; I have tried to put a save command in to save the...

Greetings all, This is the strange scenario that is playing out. Through a switchboard I click a button, opening a form (Grape Intake)with two sub forms. Then happily enter data and everthing is fine. I have then set up to open a form (Job Orders Intro) from the swithboard. On this form I...

Greetings all, I have done a bit of reading and research on the 'tag' property in forms and tried to set some code. Now I am all muddled as to how to do it and what comes first? What I am trying to do is if the condition in one field 'time required' is yes then I would like a whole lot of...

Greetings all, I am having trouble translating a query to SQL. The error message I am getting is; Run time error 3075 Syntax error (missing operator) in query expression 'tbl_Data_AllocationDetails.TradingName = CompanyB' The code I am using is; varRet =...

Greetings, I am a bit drained today and can't think clearly. How do I stop a new window opening everytime I open a new form. When I get going on the latest project, inputting data I can have up to 6 different windows open. ~rbinder

Greetings all, Continuing to work on my problem and I am now getting and error of '3075' - syntax error (missing operator) in query expression the error line is strSQL = strSQL & "HAVING (tbl_data_DispatchDetails.TradingName) = " & varVal2 & " AND (tbl_Data_DispatchLineitems.WineNumber) =...