Search results

@CJ_London that worked perfectly. The problem was solved by converting the section field into a string using the CStr function. Will stay away from the reserved words from now on. Thanks loads!

Hi, So I've narrowed down the problem to the following: The append query works only if the table it appends data to is a local table. It doesn't work if the table is linked to the back-end. I've attached a sample of my DB for your reference I made the location of my back-end trusted but the...

The plan date in both the table and query is set to 'medium date', StyleID is set as a 'long integer' and Section as 'short text' in the table but doesn't have anything in the query. I might be wrong but there's no place in the query to specify the data type for the latter two.

Hi all, I'm trying to append a query into one of my tables, the query runs fine as a select query but produces an error when used as an append query. I've pasted the SQL of the Query below: INSERT INTO TblSPlan ( StyleID, [Section], PlanDate ) SELECT QryGenerateDates.StyleID...

Hi, I've used the fOSUsername() macro to record usernames easily in forms previously. However, I now need the following: a) Generate a query via a filtering form. b) The query should have a checkbox field which has to be ticked if a record is valid. c) The username of the person ticking...