Search results

Hi there, Please could someone offer me a little pointer. I am trying to create a query for a report or form. The idea behind the query is to compare the actual sales in a month to the forecast for that month. There are a number of things that I'm trying to take into account. I need to...

That's wonderful it all works perfectly now, thank you very much for your help. I knew it was to do with the American date format but not how to fix it. Thanks Jodie

Ok so now I've tried converting all the dates into format mm/dd/yy and it still isn't working. What else could I try? Thanks Jodie

Hi there, The problem I have is that somewhere in my database its is getting confused between UK and American date formats. I use a lot of autofill dialog data entry forms using - Date(). Basically I have one table that holds all the information on a dialog form that pops up by clicking on a...

Hi RuralGuy, I have just posted a new thread in the VBA code forum. It is a similar query to one I have asked before but with a new twist. You were such a great help on the last query I was wondering if you could please help me out again? Thanks Jodie

Hi there, I need some help setting up a few functions that can be called by any form to display each of the dialog forms in my database. I have included some examples of the current code below. Currently I use the full code for each instance it is needed via event procedures (the code is...

Just a quick update - I have no idea what caused the error but I have fixed the problem. When I dropped old forms (from a backed up database that were still working) in to replace the forms that had stopped working it fixed the problem.

None of the forms are filtered. I'm on Access 2003 SP3, although the database itself is in Access 2000. I've tried all the things it suggests on the link you gave me and downloaded and installed the hotfix and they still aren't working. Any other suggestions?

Hi all, I have a very strange problem, most of the forms in my table have a couple of search boxes to bring up a specific record on the form. All of them have suddenly stopped working. For example: The most common search box is for customer code (CustCode). I can type a correct customer...

Thank you very much, that works perfectly:-)

Hi there, I have a parent form (frm_TelesalesContact) with a datasheet subform (frm_subform_TelesalesContact). The dialog form (frm_dialog_IndividualContact) pops up on the specific record double clicked on within the subform. However when you double click on a new record in the subform the...