Search results

That would be a 2007 file, but i don't run it on this machine. How about saving it as an earlier version instead? Chris B

Glad it's working. I used [MyDate] as the date reference rather than Date() just so you could specify a particular date in the [MyDate] textbox and prepare the accounts - say you wanted to get ahead and prepare some for the following period, but if automatic is good for you, then all is well...

You would generally base a form on a query. How do you want to display/summarize your data? You can use the query wiz to do this. I have created a query which summarizes your data by month as an example. Chris B

Stick is virtually always FAT not NTFS. Another one then, specifically for flash memory, Badcopy Pro - http://www.jufsoft.com/badcopy/download.asp Chris B

Try this - =IIf(Month([MyDate]) Between 1 And 3,"Apr May Jun",IIf(Month([MyDate]) Between 4 And 6,"Jul Aug Sep",IIf(Month([MyDate]) Between 7 And 9,"Oct Nov Dec","Jan Feb Mar"))) Should work forever. Chris B

=IIf([your datefield] Between #01/01/08# And #31/01/08#,"Apr May Jun",IIf([your datefield] Between #01/04/08# And #30/06/08#,"Jul Aug Sep",IIfyour datefield] Between #01/07/08# And #30/09/08#,"Oct Nov Dec","Jan Feb Mar"))) Not pretty but it will display the required text values Chris B

The combo would be on a form. You would create a new query which looks up the dates only and groups them (one of each only). Use this query as the row source for the combo. The reports query would reference this combo as its criteria. Add a button to the form which runs the report. In the...

Or to be more specific, set your fields visible property to no, create a new unbound textbox in the same section of the report and set its control source to the above. You can move it over the hidden control so it appears on the report in the same place. Run the report and you should see the...

Hide your date field and reference it with this =MonthName(Month([your fieldname]),3) Chris B

If the FAT (file allocation table) is gone, it will appear empty. GetDataBack should be able to recover your pics. Download the demo, then buy if the data is visible. http://www.runtime.org/gdb.htm Chris B

No idea. Hazard a guess - ensure that your file name is no more than 8 letters and no spaces. Chris B

You are correct. Each user should copy the front to their PC. If more than one opens the same copy of the front, it will behave the same as a single mdb. Chris B

Indeed it is not. Sorry. Applies when linked to external tables - informix etc. Chris B

Your table must have a primary key. Chris B

Provided the report is based on a query which has user parameters included, the parameter box will appear when you click the button to open the report. Chris B

This is generally caused by the systen trying to connect to a mapped/network drive which is not available. If you have such a mapped drive, delete it. Chris B

Even if you don't compact automatically you still should have a backup strategy in place. Access can corrupt at any time, you don't have to compact to have it occur. An excellent freeware prog for this is Cobian Backup (There are many others). This can be scheduled as required and dates each...

Try this DoCmd.RunSQL "DELETE * FROM Register;", -1 Chris B

Sooner or later it will blow up instead of compacting. How about a bit of insurance. Run a batch file Sunday night with Windows scheduler to copy it somewhere else. Open notepad, type - copy "c:\directory 1\mydb.mdb" "C:\directory 2\mydb.mdb" - and save it as "backup.bat". Use the inverted...

Look here - http://www.course.com/default.cfm This is the only thing I can see which might be relevant. Chris B