Search results

I think that you know the answer! Looking like version conflict.

Could be the 2003 / 2007 compatibility. Have you tried to Back up database (rather than compact)? I have a database that imports lots of data and then creates 100's of PDF files and even though it is only 200Mb it takes 10 mins per pdf, yet if I backup the database it takes 10 secs per pdf.

Second attempt! Add this line to your Excel code: 'Run Code oApp.Application.Run "Test_Message", strN, dteN I previously assigned name and date to strN and dteN Create a module in Access with the following code: Function Test_Message(strName as string, dteStart as date) MsgBox...

Use a form with a textbox where you type in the date. In the criteria of the query use in the date field: Between Forms![Form Name]!ControlName AND (dateadd("m",1,Forms![Form Name]!ControlName)-1) This will give you a months worth of data.

yup...day is getting worse!

In the query criteria instead of =StrFilter in the relevant field use: Forms![Form name here]![FieldName]

Where is StrFilter coming from?

Am trying to delete info from tblA that exists in qryB. SQL: DELETE tblA.* FROM tblA INNER JOIN qryB ON (tblA.fld1 = qryB.fld1) AND (tblA.fld2 = qryB.fld2); I view the results in design view. Shows the 42 records that I want to remove. Run the query: "Could not delete from specified...

Add a _1 to the name of ALL your modules, subs and functions and try to compile. Slowly remove them and see which one is causing the problem.

The reason for this is that in 97 you code with DAO and over 2k you use ADO. Convert the database ignore the warnings and when you have got the new 2002 version of the database: 1/ click on the Module tab 2/ Open a module so that the VBA editor screen is showing 3/ From the toolbar select...

Would have done it the other way and had the script on the network db, with that db forcing the data to the server. This script can be launched through windows scheduler calling a macro within the database by using the /X switch eg "c:\program files\microsoft office\office\msaccess.exe"...

The following code will look through all subfolders, returning mdb files to a table. Amend, play etc! Set rstMDB = CurrentDb.OpenRecordset("Found", dbOpenDynaset) With Application.FileSearch .NewSearch .LookIn = "k:\" .SearchSubFolders = True .FileName = ""...

Think change bound column to 2

or Me.lboNameList.ListCount - 1

Create a new table with 2 columns and 24 rows. Hours in 1 column and group name in the other ie: Hr GN 00 0-3 01 0-3 02 0-3 03 0-3 04 4-7 05 4-7 etc. Now in query design link Hr with HourInterval from your current summary and use GN in your new query and group on that. HTH

try the other option len([FieldName])>0. This will remove those cells that are null as well as those that are empty.

sounds like problem with the data. Try cleaning it up before adding to the string so something like: strList = strList & "," & Trim(Me.lboNameList.Column(1, varItem))

Think, though only use it in VBScript, use: MyString = "blah, blah" & vbcrlf & "more blah blah"

general rule is width less than 16 = portrait, less than 24 = landscape (you can increase both by a few cms by playing with margins)

Sorry, but looking back through the post, the sample was based off Lyndseys database. Deleted that over a year ago and cannot remember the final result.