Search results for query: *

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...

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...

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...

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") =...

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...

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...

I am trying to loop through about 100 tables. Each named tblCopy1 ,tblCopy2 and so on. I have an append query that hits each of these tables one at a time and appends data to a different table. How can I use the 1 query and pass into it the name of the table. example INSERT INTO tbl2Column (...

Does anyone know how to programically fill in a category dropdown list? I can capture what's in there but not add to it.

Can someone tell me what events fire in a PivotChart? Also, if anyone knows how to capture what choices are selected in the dropdown boxes on the PivotChart, that would be helpful. Thanks

Can anyone help me with some syntac in Excel. I am trying to hard code an array with various ranges. As an example - Dim varArray As Variant Set varArray = Array(Range("A1:e5"), Range("G11:G22")) (This throws a type mismatch error)

I need to come up with a way to automatically save a shared workbook every few minutes or so. Autorecover isn't what I need. It seems the only way for a shared workbook to show changes is to click the save button every so often. I have 5 concurrent users and they need to see each others work...

Does anyone knoe the numeric value of xlPasteValues? Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False It seems using late binding and using CreateObject("Excel.Application") the code doesn't like xlPasteValues.

Can anyone point me to the right forum. I have a need for a .bat file to open Access only after it does something like the following. for %%c in (e:\new folder\*.txt) do if not %%c == "e:\new folder\My New Text Document.txt" del %%c It's that line I need help with

Before anyone suggests I look in our archives...I have. I just want to make sure I didn't miss something. I have a database on a server. Each user has a batch file that copies the database to their C: drive. (Speed is a major issue, so running it from the server is a NO go) My dilema - The...

I have a form that builds a strcriteria to be used as a form filter. The user selects an item from one or more combo boxes and the records are filtered. I want them to be able to select a column header and have the records sorted using that column. But at that point the records are based on a...

I am trying to create a simplle chart in Excel via Access. I have the following code which works fine. My problem is that it runs great from my PC, but when I move the database to a server it errors out on the line - .ActiveChart.ChartType = xlColumnClustered Private Sub...

Is there a way to create a hyperlink in the body of a Lotus Notes e-mail through VBA?