Search results

Dear Pat, Thanks.. Sorry...I think I wasn't very clear. When the user puts in a date on the form, I have an 'AfterUpdate' event coded. This calls the public function as you have indicated. Option Compare Database Option Explicit Public gLastRunDate As Date Public Function SetgLastRunDate()...

Hi Pat and Hammerva, I have a similar problem and I am stuck ...not sure how to access the global variable with the date field from the query. The way I have done this is after the date field gets altered, I am calling a function to set up the global variable from the form field. The query is...

Thanks Pat, When I did this, the query introduced the field from the form in the query and set the criteria as 'Is Null' for the field. It works fine now... Priya

Yes...If no date is specified, I want all records with Nulls in the date field to be displayed in the report. The date gets populated when an event happens in another field. Hence, not all records have dates populated

I have a query set up which needs to have different criteria at run time depending on values selected by the user. If no option is specified, I need to pick up all records with 'Nulls' in them else, if date is specified by user, I need to pick up all records with date > than specified date. The...

Dear RIck, From what I understand, you need a screen to browse the available record with filters on top. If the record that you are trying to add is not available, then you want to add it? A filter on last name can be built with an unbound combo-box where the source of data needs to be a...

G'Day Tim, Thanks...It works perfectly well.

Is it possible to alter the values displayed in a combo-box dropdown at run time. I tried using the following bit of code in a listbox's 'After Update' event , but it does not alter the combo-box's value list. dim strSponProjStatus as string dim StrNonSponProjStatus as string strSponProjStatus...

Dear Pat and Paul, Thanks..I will try this option

Yes Paul...The front end resides on the network and they all use the same front end..

Hi, The front end of the system that I have implemented recently gets corrupted frequently when the back end remains fine. I am new to Access and I am not able to understand why this should happen. The front end has reports, forms, queries, linked tables from the back end and related VBA code...

Uncle Gizmo, Thank you for your response. I have downloaded the B/E and F/E databases. I will have a closer look at the code! Thanks, Priya

Hi, I am having problems opening a form in a standalone second access DB using the the following code - I am able to open the second access DB but get an error indicating that ' The command or Action OpenForm isn't available now' - Run time error 2046. Private Sub Command21_Click() Dim...

Hi, :confused: I am having problems opening a form in a standalone access DB using the the following code - I am able to open the second access DB but get an error indicating that ' The command or Action OpenForm isn't available now' - Run time error 2046. Private Sub Command21_Click()...

Hi, I found this thread useful - just a question on Mile-O's comment - 'Set Object as Nothing' - when do we do this - Is it after closing the other Access application and control returns to the main application? I am new to access 'Programming' and hence please pardon me if the question is...

Hi, Thanks ..will try using the workshop. Priya

Dear Doc-Man, Thanks for the reply. I do not have Microsoft Help workshop - will explore other options. Thanks, Priya ;)

Hi, Is there a good way of providing help to users ? Books recommend the use of 'Windows Help Workshop' - any suggestions? Thanks, Priya :confused:

Were you able to disable the items on the toolbar? I have a similar situation and I want to disble the 'Delete' button on the standard toolbar. I am sure this is possible but I am not sure of how to do it using code when the form loads. Any help will be appreciated. :p

I think what you want is grouping - you could use the report wizard which will let you group data for each id / person.