Search results

Try this as column expression: your_timestamp_field: DateValue([your_table].[your_timestamp_field]) with the Date()-1 condition.

Good advice; I'll change my programming style accordingly. Always happy to learn something new & improved :D.

I think I was answering the wrong question :o. Are you trying to make links in an Excel-file activate on a single- rather than a double-click? Or is you problem getting the data into the Excel-file?

Never seen THAT one before :confused:. Putting brackets around the offending column name should work. The problem could be somewhere in the underlying queries and only pop up when a GROUP BY is used, I've seen stranger things :D. Also, check the [TimeDone] field for non-numeric values (date/time...

Had a look at your original post :D. First off, you may want to read up on database normalization. Those 7 genres should be in a separate table. The way you're going, you should use Excel (unless you're going to have more than around 65535 titles). Rambling seems to be contagious.. that is...

Also worth checking out: TimeSerial(), DateSerial(), DatePart() and Format(). The xSerial()-functions "overflow", so you can do this: Format(TimeSerial(0, 0, 93), "Nn:Ss") ' yields 01:33

This may be not at all what you're looking for, but unless you really want to "roll your own", there's a template database in Office Online :D. No idea what's in there, but it might be worth checking out..

If the two tables contain similar fields, you 1. probably have a normalization problem :), but 2. could maybe use a UNION query to combine the results from the two tables, then do the mail merge in 1 go. SELECT contact1.contact_name, contact1.contact_address FROM contact1 UNION ALL SELECT...

Something like this ? DoCmd.SetWarnings True DoCmd.RunSQL "DELETE * FROM tblA" DoCmd.TransferDatabase acImport, "dBase IV", "c:\my\a.dbf", acTable, "", "tblA", False DoCmd.RunSQL "DELETE * FROM tblB" DoCmd.TransferDatabase acImport, "dBase IV", "c:\my\b.dbf", acTable, "", "tblB", False...

No, not in tables. You can do that in queries. Your WORKERS table should probably not have a SALARIES field. Read up on Database Normalization. Having said that, a query like SELECT Workers.Name, Jobs.JobID, Workers.MileRate * SUM( [Job Details].NumberOfMiles ) AS [Job Salary] FROM...

Be aware that the 'Kill sFile' deletes a file bypassing the recycle bin. You don't even need to delete the file. Private Sub Form_Current() On Error GoTo Error_Handler If IsNull(DLookup("[txt_CoLogo]", "tbl_CompanyInfo", "lng_RecordID=1")) Or DLookup("[txt_CoLogo]", "tbl_CompanyInfo"...

Yeah, it's OK. You should see the number of relationships a Person table has in a CMS system :D.

Your questions are a bit hard to spot :). Empty lines are not forbidden. Looks OK to me. Looking at the relationship diagram, they are related. That will do quite nicely :D. In short, you seem to have your tables and relationships set up as they should be. So what was the problem you were...

In Access 2003: Tools | Database Utilities | Convert Database | To Access 97 File Format

Have a look at DoCmd.FollowHyperlink; that might do what you want.

Now I'm really out of ideas. Can you post your database (or a relevant sample thereof)?

Joy! Even I was hard put to get the point of that :D. Not really; I learned most of my SQL through osmosis from SQL veterans (guess I'm one myself now :cool:). Fortunately, Google knows zillions of'em.

Grr..running out of ideas :mad:. What is the format for the offending expression set to?

Have you tried column_name: Int( [table_name].[column_name] ) as a query expression?

Try this: sDate = Format(dtDate, "yyyymmdd") sFileName = "I:\Statistics\" & sDate & "\SALES_" & sDate & ".csv" DoCmd.TransferText acExportDelim, , "SALES_", sFileName, -1 Split into multiple statements for clarity. Supply your own dtDate.