Search results

Re: Missing operator when running SQL from command button (resolved) Hey Bob, I don't think SQL Express 2008 was the issue but going to SQL Express 2005 helped me start from scratch. In doing so, I found that I did not have a primary key set in tblIMT_IOT_Country_Name. After setting a PK in...

No Bob.. It does not. tblContact I'm thinking the issue may be tied to SQL Express 2008. I have uninstalled it and just finishes installing SQL 2005. I will try it and report back

When I use the query designer in SQL Express 2008 I get UPDATE tblContact SET mailingcountry = tblIMT_IOT_Country_Name.CountryCode FROM tblIMT_IOT_tblCountry_Name INNER JOIN tblContact ON tblIMT_IOT_Country_Name.CountryName =...

they are in fact underscores The tables were upsized from Access to SQL . In the Access navigation pane, they appear as tblContact and tblIMT_IOT_Country_Name. When I hover of the table name in the naviagtion pane, the table = dbo.tblContact and dbo.tblIMT_IOT_Country_Name. The same is true of...

Private Sub cmd1_Click() Dim strCountryCd As String strCountryCd = "UPDATE tblContact set tblContact.mailingcountry = tblIMT_IOT_Country_name.CountryCode " & _ "FROM tblIMT_IOT_Country_name where tbContact.mailingcountry = tblIMT_IOT_Country_name.CountryName;"...

It is SQL backend (2008) so I tried the latter. dbSeeChanges = 512

Tried CurrentDb.Execute strCountryCd, dbFailOnError I get dbFailOnError = 128 .. Does that mean anything to you?

Thanks for your reply Bob. Good catch .. it should be tblContact. After changing it, I still get the same error

MS Access front end SQL 2008 backend This runs fine in SQL Server query but throws a Run-Time 3075 syntax missing operator error when executed from a form command button Dim strCountryCd As String strCountryCd = "UPDATE contact set tblContact.mailingcountry =...

Thanks for your reply "jib". I am having trouble with the "open recordset" can you give me an example of what this should look like? Detrie

I have a table - tblText. It has three columns (tblTextID, strFileName and memText) I need to import the contents of multiple text files from (c:\TextFiles\) into tblText>memeText and place the file name into strFileName (one text file = one table record). Can anyone offer any help? TIA Detrie

TAH DAH!!!!!! Thank you Paul.. That did.

Hi Paul.. Thanks for your reply I should have been more clear... I need place all of the selected rows (columns 1 thru 5) into the test box with a VbCrLf after each row When the listbox has 4 rows selected, the textbox shuld look like this: Column1 Column2 Column3 Column4 Column5 Column1...

My form has a multiselect listbox with 5 columns The form also has an unbound textbox I need place all of the selected rows (column 1 thru 5) into the test box with a VbCrLf after each row I can use a jumping off point Thanks Detrie

Hi All, I have a form with a Microsoft Web Browser Object The form is bound to tbl_Extract tbl_Extract has a MEMO field memData I would like to pull the text form the Web Browser Oblect into the memData field Any ideas? Detrie

You said that the data was from a "screendump". How is the screendump done? Detrie

Hi All I'm am trying to push data from a control on my form to run a search on Google.com. If i get it to work with Google.com I hope to also use Hoovers.com. My form has a control txtSearch and a cmdGo but that's it. I could use a jumping off point Thanks Detrie

Access 2003 Hi All, On my form I have a control txtCompany I would like to select characters in the control and pass it to a select query For example, if the txtCompany value is My Company Inc I would like to highlight “Comp” and pass it to a query where I expect to use Like “*” &...

Hi All, Is there a way to disable the Access Min Max Close buttons like you can on forms? I need to have people use a "Close Application" button (there is code behind it) To be clear.. I need to disable the Min Max Close on the Access application and not forms. Thanks Detrie

Access 2000 Hi All, I am using an email form that will send emails to others within a company. The form has a txtSendTo field where the recipient’s name is entered. The form allows multiple recipients by inserting a comma. I need to strip the @abcd.com from EACH recipient’s email address...