Search results for query: *

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...

...for every record in the table. QueryA's criteria for this field looks something like: Like [Forms]![FormA]![Text1] Text1 is defaulted to '*' This I expected to return all records in Table1 as this (I though) effective means Like '*' ie, return everything... However this only returns...

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...

Thankyou! Both buttons now work like a charm. :-)

Cheers!... I'll give it a whirl...

Hello Everyone On my main form (FormA), I have two buttons (ButtonA and Button B), a Subform (SubFormA). I also have a second form (FormB)... oh and a table (Table1). SubFormA's record source is a query (on Table1) and a single criteria and will only display a single record. The form is for...

I have Access 2000. Is there a way to assign more then three different types of Conditional Formatting to a field on a Form? Ideally I need five.

I have a form containing numerous subforms. A user may make selections of records on both the main and subforms. How can I save the status of the Main and Subforms when the user exits from the main form, so that when the form is next opened, the selections remain intact and the user doesn;t have...