Search results

  1. C

    Problem setting default value - referencing issue

    Sure. Here it is.
  2. C

    Problem setting default value - referencing issue

    Hi I have a database which contains a Public Function forecasting dates based on working days, ie excluding weekends and Public Holidays. I wish to update fields based on this formula, but I want the controls to default to this calculation so that the record source can be updated. If I...
  3. C

    Only save record when all fields required are complete

    Thank you very much Trevor This is working a treat!
  4. C

    Only save record when all fields required are complete

    Hi gurus I have a data entry form which has certain fields for which I require the information. I have set Validation Rules and Messages up for those fields in the underlying tables but not set them to required. These work as I tab through the form. However when I create a button on the form...
  5. C

    Conditional formatting not displayed on report

    Never mind gurus I have figured out what the issue was. I needed to change the Back Style of the text box from Transparent to Normal. Duh!
  6. C

    How do I show 0 instead of #Num! errors on my report

    You need to use error trapping. This may help http://www.cpearson.com/excel/errorhandling.htm
  7. C

    Conditional formatting not displayed on report

    Hi I have included some conditional formatting on a report of mine. The only time this formatting appears is if I hover my mouse over the formatetd field. It does not appear when simply viewing the report or especially if I print the report. Does anybody know how to have this formatting...
  8. C

    Conditional Formatting Not Showing

    Hi Not sure if anyone is still viewing this post but I am having the same trouble. Yes I am using Access 2007. When I view the report in Print Preview or if I print the report I am not getting the conditional formatting displayed. Does anyone know why this is Thanks c
  9. C

    Make a text box required if a different text box is not null

    Thanks Galaxiom I was using the former above. I am still unsure of what code should follow the latter though. I have tried If Len(txt1 & "") = 0 Then Len(txt2 & "") <> 0 But then it is telling me Expected Identifier?
  10. C

    Make a text box required if a different text box is not null

    Hi gurus, I am trying to figure out how to make a text box value required only if another text is completed. Lets call them [txt1] and [txt2]. So if [txt1] is filled in then [txt2] becomes necessary for the user of the form to fill in too. I am sure this must be easy enough but my limited...
  11. C

    Database slows tremendously as soon as there is more than one user

    Thanks jdraw Most helpful :rolleyes:
  12. C

    Database slows tremendously as soon as there is more than one user

    Hi gurus I have built an access database, split it putting the back end on our work server, and distributing front end versions of the database to my colleagues. During current testing the performance of this database is reduced significantly as soon as more than one user logs in. Does...
  13. C

    Access search form needs to be able to write retrieved data

    Hi gurus, I sourced a great access db which filters data based on a companies name or tax reference number being LIKE user entered data in two text boxes. The results are displayed in datasheet format in a subform. I would like to be able to write this data to a table. ie trigger a make table...
  14. C

    Open only reports containing the specified record

    Hi Actually this is still not working correctly. I tried it first on an example where there are CIT and VAT profiles. Hence it ran through the first three reports and I thought it was working. However it seems to stop as soon as it reaches a section of code where there is no case id for a...
  15. C

    Open only reports containing the specified record

    Hi The correct indentation has solved the problem. Thanks for your assistance - I had no idea the indention made that difference. I thought it was to make it easier to read. Thanks again
  16. C

    Open only reports containing the specified record

    Hi Sorry about the multiple postings - I wasn't sure under which topic to post it. I won't do it again. The problem is as follows: when profiling a companys tax we may look at either the CIT, VAT, PAYE, customs or some combination of the tax types. Depending on this selection only the...
  17. C

    Button supposed to open only reports where case is populated

    Hi I am having a little trouble with my code here. I have a button on a form which opens reports on a particular Case ID. the button pulls up an input box asking the user to specify the Case ID to open the reports for. After that It should always print "Rpt_Profiling_Cases", then it should...
  18. C

    Opening only populated reports

    Hi I am having a little trouble with my code here. I have a button on a form which opens reports on a particular Case ID. the button pulls up an input box asking the user to specify the Case ID to open the reports for. After that It should always print "Rpt_Profiling_Cases", then it should...
  19. C

    Open only reports containing the specified record

    Hi I am having a little trouble with my code here. I have a button on a form which opens reports on a particular Case ID. the button pulls up an input box asking the user to specify the Case ID to open the reports for. After that It should always print "Rpt_Profiling_Cases", then it should...
  20. C

    Please Help - Urgent Issue

    Hi again I have rediscovered how to get back to where I was - shoo! however could anyone tell me why a form based on a query would choose to only show on record of the underlying query results? Thanks
Back
Top Bottom