Recent content by Hammondo

Herb, your the best... that works perfectly. I used the following: Expr1: IIf(([Validation Date]) Is Null,#01/01/1900#,[Validation Date]) Then query the expression column with: (Like [Forms]![IssueQueryForm]![ValidatedOnStart] Or >=[Forms]![IssueQueryForm]![ValidatedOnStart]) And (Like...

FormA displays contains SubformA and a text box 'Text1' A date is entered into Text1. SubformA is based upon QueryA. QueryA displays records from TableA, displaying them in SubformA. QueryA's query criteria are selected from numerous text boxes and combo boxes on FormA. TableA contains a...

Cool, It works! cheers for that =)

FormA contains SubformA. SubformA based upon a query display a list of records in tableA. On my main form I have a button which when pressed opens data entry FormB and adds a new record to TableA. I would like SubformA to refresh when I close FormB, so that it shows the new addition to...

In TableA I have a load of records. Off of TableA are linked other tables (TabA, TabB) that may or may not hold one or more comments pertaining to the an individual record. Relationships for this have been defined. I can generate a report that lists all of the records existing in TableA...

thanks, 2. the dates will be user defined. 3. The Db is set up with relationships. tbl1, tbl2, tbl3 all hold copies of the root records key field (but have their own unique primary key fields). One to Many relationships from TableA to tbl1, tbl2 and tbl3 are defined.

I'd like to place a field on a form that displays a count of the number of new records created in a table in a given day. What would be the most sensible way of doing this? Also, I'd like to produce a report for a date range 'all records between dateA and dateB. what would be the syntax for the...

Hmmm... A little more info... The users already have access installed on their machines, using it to access two other Access databases (not of my creation). I've noticed that there are also some Users and associated permissions set up on these machines. These differ from those on my own. I think...

Oh and I've also relinked the front end tables on a users local machine accross the n/w to the backend to make sure that this is ok. This reports successfull. I then open the front end and same problem... I'm very perplexed..

Cheers for your help... Yeah, I've placed the backend on a n/w share granting full access to everyone. I've relinked the tables to the Backend on the n/w share. I then reopen my front end. On my machine I can see the database. As soon as I copy the frontend to another machine on the n/w and...

I've split my Db into front and back end. However I can only access the Db from my machine. Whenever I install the front end mdb on another machine, the GUI displays ok, but no records.... why is this? Help!!!!

I've split my database and would like to make my front end into an MDE file, only access keeps giving me the rather unhelpfull message 'Micrsoft Access was unable to create the MDE database'... any ideas why this might be?

Main form and subform... Mainform contains a textbox bound to a field on the subform. When I use the sort/order option on the Subform, the textbox on the main form reports #error. Is there a way to get around this?.. or maybe disable the right-click sort ascending/descending option on the...

I've given this a go and it doesn't work.... I change the condition to '> 0' to make sure the function was working and it returned the "null" string as expected.. might the currentrecord statement be returning something else for zero record counts?

I have two SubFormS (SubA and SubB) SubB has a query as a record source. I call the SubB from SubA and tell in to requery as follows: Me.Parent![SubB].Requery this is fine. I need to detect if no matching records are found when SubB requeries, so that I can send a "Null" value to a...