Search results

What version of Access are you using? If you change the data back do the listboxes work again [to prove it is data dependant] It sounds like your joins need adjusting to re-assert uniqueness for the changed data.

Postscript print problems - ideas Some suggestions: See whether new printer drivers exist Use different drivers (sometimes the MS ones work best, sometimes the vendor supplied ones) Use a different language driver: Some printers will accept PCL and Postscript so consider the PCL ones Post more...

AlanS code works - thank you AlanS, Your code example pointed me in the right direction and enabled me to solve some otherwise awkward problems both then and now. Thank you :)

How to automate? Thanks for the suggestion regarding date. I can determine the required dates but still do not know how to automate the process so that it runs every day without human intervention. Could I schedule database runs that read /cmd, does the update and then closes the query...

Access '97. We have daily data being added to a series of tables. Is there any way to build a daily running summary of this data automatically? tblEvents containing date time event duration cost summarised into tblEventSummary date event eventcount totalduration totalcost A summary table...

where is the confusion? Is 'where' a reserved word in SQL? Try something like cwhere = "" If [GVL Shift A] = -1 Then cwhere = "[Shift ID] = " & "'A'" End If If [GVL Shift B] = -1 Then cwhere = cwhere & " OR [Shift ID] = " & "'B'" End If If [GVL Shift C] = -1 Then cwhere = cwhere & "...

Thanks FoFa, I will try it. Thank you.

We want a table of standards that are valid between 2 dates so we can have 2 standards for the same part. Is there any way to build validation into the table to prevent standards for the same part having an overlapping date range? e.g. part 1 standard 1 Commences 1st January 2003, ends 1st June...

dao. works for me. Thank you. I have also found f2 (object browser) useful. Now to review all the dim statements to find the dao objects then track them through each module....

access 97 to 2000 conversion gives grey screen only Can anyone point me a definitive list of all the DAO definitions or any way to recognise them for easy qualification? We are seeing similar issues converting a 97 front-end to Access 2000. The database opens without error after converting but...

1 table, 1.5million records, login information date (mostly blank) Reading down the table we see a login date combination followed by several login information records. We wish to add the date to each information line, resetting date to blank on each change of login and changing date if the...

One suggestion: Ensure your table has a unique key, copy the records you want to edit into a temporary table. Present the temporary table in the form and on closing the form and confirming the save use a query or 2 to update the original table. You have to validate each incoming line against...

When I searched further I found an answer in the tables forum. http://www.access-programmers.co.uk/ubb/Forum2/HTML/000896.html [This message has been edited by MrTibbs (edited 01-30-2002).]

Access '97. Is there a way of querying a given database and reporting basic details (fieldname, size, type, index mode) regarding the structure of the tables? The Documenter can do it but gives too much information, isn't available except in the Developer edition AFAIK, and doesn't lend itself...

(((qryForm.AnnOrgCode="12345"))). replace the 30 with 5 to only report the 5 figures after the 12th.

You need to use a conversion function and sort on the output of that function. Check out weekday()

Nope .. I found it 15 seconds after posting the question ... maybe I should post sooner!? I had 3 modules, one un-used, which had Option Explicit listed twice. Removed that and the error went away!

Opening a form which had an 'On Open' Event Procedure reveals error: "The expression On Open you entered as the event property setting produced the following error: Duplicate Option Statement" If I remove the open event the error appears on the load event, if I remove both open and load the...

Access '97. I have a series of nested select queries which ask for a date range. One of the queries doesn't re-ask for the date range but just reports what it once ran. This means, if I change the desired date range, the results are not as expected. Any idea how to stop the query persisting...

I wanted to put variables into a query which was imported. I'll re-work the queries to use the different parameter names based on the form values rather than try and put the form values into the parameters the query expects.