Search results

I've used like clauses before without a problem in other sql statements,,, wondering why these prompt me to enter a parameter for filterm.prod details DoCmd.RunSQL " delete from filterM where filterm.[product details] not like '*scrap*' " DoCmd.RunSQL " delete from filterM where...

I searched through a few posts here and on the internet to get together code that you can use to alter a backend ODBC with VBA. If you have anything to add, please post. #1. Adding Columns DAO For DAO, addition of columns works something like: Dim db as DAO.Database Dim tDef as DAO.TableDef...

Private Sub Command6_Click() 'Create a Catalog object Dim con As New ADODB.Connection con.Open CurrentProject.AccessConnection Dim Cat As New ADOX.Catalog Cat.ActiveConnection = con Dim oldn As String Dim newn As String Dim tbln As String tbln = "test" oldn = "dog101"...

Before I made my first vba app I thought ms access was a remedial. Now I believe its a must for many kinds of professionals including DBA's, for its automation, especially when it comes to normalizing data from flat text files. What else is there that you can use thats as flexible with excel...

How can you accomplish union queries to combine multiple tables of similar structure. this is the union query. I have 3 tables I want to get put into a 4th. SELECT * FROM T1 UNION ALL SELECT * FROM T2 INTO T4 ????????

I am going to remove duplicate company names but not all records have phone, fax and email. For example. company.... phone.... fax .....email abc ......... 123 abc ......... ......... 456 abc ......... ......... ......... abc@abc.com abc ......... 123 def ......... 456 def def def...

IMO this one is tough one. I have a table with phone & fax data in an address column that I want to put into their separate phone and fax column. To further complicate things the phone comes in a various forms: phone, T , ph, tel., tels., fono. The same issue occurs with fax, i.e. Fax &...

Here is some code I have to remove duplicate occurances of catid & recid in tblcat1_rec table, leaving only 1 entry: mysql = "DELETE FROM tblcat1_rec " mysql = mysql & " WHERE ID <> (SELECT Min(ID) AS MinOfID FROM tblcat1_rec AS Dupe " mysql = mysql & " WHERE (Dupe.catid = tblcat1_rec.catid) "...

I got external excel data into an access database. my problem is that it seems like the vbLF's are gone. I have to explicitly copy data from one cell of excel to access for the linefeed to show, 1 by 1. Do vblf's & memo fields not mix? Do vbcrlf's work out better??? HOW CAN I...

I just imported an excel into access. A column turned out to be a memo type field. I just noticed my line breaks didn't transfer over. Is there any way to control this or should I just go back to my original excel source and replace my vblf's with vbcrlf's? Or if I ultimately intend...

I'm nearly done with an action query that will make category associations. I have a table for the categories and another to relate from. My trouble is with the where clause of my insert into values expression. Lets say for example I have the following variants deep fry deep fryer...

while thinking of multiple people working on a single database over the internet I wonder which are either the most common ways to handle unstable internet connections. IMO it seems best to always keep track of the last update of a record so that if a user has disconnected while working on a...

I have an excel for recipes I recently imported into an access database heres how the nutrition data field looks : 84 Calories; 3g Fat (36.5% calories from fat); 1g Protein; 9g Carbohydrate; 1g Dietary Fiber; trace Cholesterol; 81mg Sodium. Exchanges: 0 Grain(Starch); 1/2 Vegetable; 1/2...

I just finished a access vba project that puts brings together allot of different recordset data and sends an email. The way it achieves this is looping through the recordset and aggregating strings. I only used a certain amount of spaces & vbtabs to more or less mimick tabular data based on...

yes I hate the fact that I had to start with access and vba but its a great start! hello again

Access doesn't support sql select but I also didn't run across an example where switch was used for anything other then setting string values. Can I do this: select order.[amount], order.[date], switch (order.[co type]=1, tblcustomers.[co name] as company name...

its been a pain for me to click through yes for every email sent through outlook. apparently this page has the vba you can use to disable it and just wanted to share. http://www.everythingaccess.com/tutorials.asp?ID=Outlook-Send-E-mail-Without-Security-Warning

I built an app that compares the next record with the current. The way I did it was storing current values into variables then .movenext and compare. then moving back before progressing through the rest of the code that takes into consideration whether certain data between the current and the...

hello forum. I get a runtime error 3464 data type mismatch in criteria expression when doing this sql: mysql = "SELECT tblLoads.Ref, tblloads.contents, tblloads.[destination port], tblLoads.Carriers, tblLoads.[Ship Date], tblLoads.[Est Arrival], tblLoads.Brokers, tblBrokers.[ISF email]...