I am workin in Access 2007 and have the following code: DoCmd.RunSQL "INSERT into ( lot_no, oiltype, material_desc ) Values (, , 'hello')", 0 I try to set...

I am running into a problem when I try to do an insert of a text value using DoCmd.RunSQL when a text parameter has an ' in the data. I have a line in my...

I'm having trouble with the where clause in the following statement. It works when I created it using the Query builder but not when I use it...

Hi I am trying to get the following to work but with little success tempsql = Me.Combo26.Value & Me.Area & Me.Text35 & "NP" DoCmd.RunSQL ("UPDATE WSLevs SET...

Hello, I?m trying to automate sending multiple emails using the DoCmd.SendObject. I have a report that groups managers; each manager has a number of users...

Hello! Can anybody give me some code for the Docmd.TransferSpreadsheet command, which i can adapt for my database (or know where to get it)? I need to be...

I have a table I imported a HTML into, unfortunately the name column gives me (E.G) Doe, John#http:/www.r02934-92340.com/0340394 Is there a way I can setup...

I have just created another querry in my database, which has currency values of parts which have been shipped. Previously I didn't have this querry, but now...

Hello there, I have a parent child relationship between tblProfile and tblAgreement. I have a form frmProfile that enables the user to make a profile...

I created a select query to get different fields from different tables. Two of the fields are Memo fields. Both of the fields are truncated at 255...

I'm using Access 2000. I'm studying some complex joins in a book that says SQL2 will do some things that SQL1 will not. Does Access 2000 support SQL2...

Does Access 2003 have a "proper" case? I have a text field with names that are all caps.

I have a database that I made a small edit to last night on my Vista machine running access 2007. The database is on a network shared drive (not ntfs). The...

I have a data field ODBC linked to Access that has data in multiple lines of text. It all belongs as one entry to that field. Eg as below. RED CELL...

I know how to use a FREQUENCY function in Excel to count the number of occurences that fall within ranges of values. Is it possible to set this type of...

Good afternoon. I've written several INSERT ... SET format queries for my Access FE/MySQL BE, but Access will not let them through. It reports "syntax...

I want to select names from tableA not from tableB. But I couldn't use MINUS in query in Access. What can I do? Thanks,

All, Heres an interesting question. In Access 2003 Proffessional. When you run an update query using values in a 2nd table linked in the query view. Is...

Will an UPDATE query create the record if it is not in the table yet? My update says it runs with NO ERROR but yet there is no record in the table... Do I...

I have a proprietary database of customers that I need to specify which time zone they are all in. BACKGROUND: I have a Company table, with their address in...