Search results for query: *

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

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

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

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

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

I have two forms. Form1 and Form2. -On Form1 TextBox1 (an unbound text box) contains a value. On Form1 also is a button, which when pressed opens Form2 -Form2 on opening creates a new record in TableA. TableA has FieldA which I'd like to populate with the value contained in TextBox1 on...

I'm trying to get a Subform (that is based on a query) to update (requery) automatically when a new value in a textbox on the main form is updated. On the update of the textbox, the subform should read the value contained in the textbox using it as a query parameter for the record it is to...

Scenario. You have a table holding a list of companies. On a subform, you want to display a list (filtered or not) showing just the company name of the companies in that table. (kind of a quick list that a use can scroll down). The user should then be able to select/highlight a company from...