Search results for query: *

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.

Please forgive me but I have searched FAQs and done searches till my eyes are bleeding but I can't seem to find anything to help. All I want is to be able to have a user click a button and navigate to a folder where they want to save a file to. I tried to use fileopensave but it requires you to...

Found my own answer. http://support.microsoft.com/kb/945674

I am noticing the endusers are leaving temp files behind. i will go into the directory and there will be a dozen tem files db1...db2...db12...etc. This started happening when I checked the compact on close box. I use Access 2003. Has anyone experienced this before?

I'm trying to get the following code to run. If the cbo box has an entry, filter it on that. Otherwise use no filter. But the no filter (nothing selected in the cbo box) isn't working. Anyone see what I'm doing wrong? Set rstSurg = db.OpenRecordset("SELECT tblMyTable.*, tblMyTable.Dept FROM...

Worked awesome! Thanks!