Search results for query: *

I am attempting to automated a document search in my database using wildcard options. I have a field on a form that asks what to search for... A user can for example type 'CO##_' and they will get all documents that have the letters "CO" followed by a 2 digit number and an "_". If they type...

I have a report where a section header is at the bottom of a page with no detail records. I do have Repeat Section header on so it repeats on the next page with the details... Question? How can I hide a header if there is not enough room for any details? McLean Jones buddycenters.org...

Anyone know a way to import a PST file into Access. I have a client that allowed their PST file to exceed 1.8Gb. Now Outlook cannot even open the items in it. At that size, I wonder if Access could handle it anyway. Any suggestions on how to get access to the e-mail items and attachments in...

Fantastic help! That works great. Didn't even think about looking for the ldb file. Great idea and very simple. :) McLean Jones buddycenters.org "Believing is Seeing

I have a timer code that does the following... 1. Sets a time value to now 2. Performs an action 3. Sets an end time value to now 4. Displays message box with elapsed time Very simple... However, I have some actions that take place in an external database. I have code that opens an external...

Fantastic... that works great... McLean Jones buddycenters.org "Believing is Seeing

Follow up from thread705-884378 I have existing tables generated from an import code pulling SQL tables into my Access database. This import process looses the index definintions. I need a second part of the code where I can set the index for the table. I've only found out how to do this...

Any other on-line places to look. My help files are screwed up on my machine. And I did find this file in a search but still can't open it... I get this error... McLean Jones buddycenters.org "Believing is Seeing

the primary key is the issue here. I'm now looking to find out how I can either maintain the indexes on the import or recreate them after the import. See thread705-884378 McLean Jones buddycenters.org "Believing is Seeing

I don't know SQL outside of the basic I perform in Access VBA. Where would I find this instruction. I'm a quick learner if I have something to read. McLean Jones buddycenters.org "Believing is Seeing

Tried your code to see if this would get around my PK issue. No luck... I get this error... McLean Jones buddycenters.org "Believing is Seeing

I use a TransferDatabase code to automate importing SQL tables into external backend Access databases... DoCmd.TransferDatabase acImport, "ODBC Database", _ "ODBC;DSN=eProj;UID=EProjUser;PWD=EPr0jUs3r;LANGUAGE=us_english;" _ & "DATABASE=eProjRpt", acTable, "dbo.TaskAssignment"...

Discovered the problem - Primary Key... Both our codes work fine when the related table (and the field that is joind) is a primary key. For some reason my import script has killed the PK identifier. Now I have a different challenge to fix. :) Thanks for your help...

No error... just trying real hard to perform. After 15 minutes or more, it still wasn't even 20% of the way done according to the status bar. I had to end task. So I know the code works cause no error... but it must not be good for this large of a data set. The Project table is a linked...

Doesn't seem to like that code. I think the data must be too large for the query within a query option. I've done it with the join method before no problem. Any other ideas how this can work.

I know I'm missing something basic cause I've done this tons of times and must be missing something. I have deleted archived projects from a table and now want all tasks that no longer have a related record in the projects table to be deleted as well... tried this but am missing something...

I have some reports that when they are run, if there is no data, return an ugly error. I want to make my own error dialog box in this case so I attempted the following... On Error GoTo Rpt_NoData code for running the report exit_Rpt: End Sub Rpt_NoData: MsgBox "There are no...

I did check that library 2.6 and added it. But still no help... See this image for what libraries I have... http://buddycenters.org/images/reflib.jpg

cmmrfrds - That does sound like a better option. I tried the code you gave and got a Compile error on the section starting with connString. For some reason, that variable is not getting declared. Any guesses as to why?

Lewds, I actually tried that first but it was still going after 30 minutes so I gave up on this as a solution. I did find a solution on Microsoft's newsgroups but still it's only part of the problem... Private Sub Command1_Click() Shell """C:\Program Files\Office2K2\Office10\MSAccess.exe"" "...