Recent content by Zygor

I remmebr now. It is a collection. Thanks

I need a memory jog. A long, long time ago...in a galaxy... no. Really. I remember being able to create a recordset that eliminated duplicate values. Since I am not using a query I cannot use "select distinct..." I thought there was another method, like creating a group that would not allow...

Excellent! Thank you both! :)

I am trying to figure out the right way to write a case statement. It should go something like the below. Field(0) is a date time field. I am trying to get a date that is today or yesterday after 5 pm. Any help would be appreciated. Private Sub Command0_Click() Dim db As DAO.Database Dim rst...

Is there a way to hide (and unhide) an object (or text) in Powerpoint when a selected piece of text is clicked on? I know there is an on click event of the text...I just can't figure out the syntax to hide and unhide a separate object on the same slide

I am trying to copy a range of records from an Acess database on a server to an SQL server table. I have a wealth of experience as I've made 1 stored procedure already. :) I feel I may be close but could use a nudge. Here's what I have so far. It is a create procedure but I'll execute it after...

doh! I meant to start a new thread. sorry

I am trying to copy a range of records from an Acess database on a server to an SQL server table. I have a wealth of experience as I've made 1 stored procedure already. :) I feel I may be close but could use a nudge. Here's what I have so far. It is a create procedure but I'll execute it after...

PHV, I know you sometimes answer a question with a question as a clue to help steer them to the answer. Is this such a situation? When I link to the table, it doesn't present the option to select the pk. Nor can I change it once it's in the Access database. Is there something I'm overlooking?

Excellent question. No. It has assigned it's own (incorrect) PK.

My bad. The linked table is an Oracle table. I have duplicated this issue in a brand spankin new database with only the linked table.

I see duplicate records in a table where there aren't any. If I open the linked table I see duplicate records. If I sort the table, the duplicate records don't sort together. If I run a find duplicates query it doesn't find any. It gets better. If I copy and paste the entire table to Excel...

That's how I got the above code. I checked other posts before I asked to see if anyone came across this problem. Thanks for the quick reply.

I have a make table query that creates a new table everyday. I have tried- Dim tdf As DAO.TableDef Dim fld As DAO.Field Dim db As DAO.Database Set db = CurrentDb Set tdf = db.TableDefs("MyTableName") Set fld = tdf.Fields("MtFieldName") fld.Properties("Format") =...

Thank you Remou. That's just what I needed.