Search results for query: *

Hi Zameer, I tried to create the cross-tab query as suggested but I can't get it to work at all. It seems to want to process the data as a pivot table, which in this case is not want I want. I just want to display the data in columns in the form. I've created a 3 column report showing the data...

Hello All, I have a table that holds data for overnight uploads, it has 3 fields. I would like to display this information in a form, but I want the data to be displayed like a multi-column report. E.g. **** Column 1 ***** | ***** Column 2 **** 123155 12/06/2003 Y | 134540 13/02/2004 Y...

Hello Again, I had this function working fine, but for some reason it keeps on giving me the error 'Too few Parameters". Does anybody know why this is? is it a bug within access? Public Function NoDataCheck(inQry As String, inSql As String) As Boolean 'Check if the query actually produces...

hello nabiS2K Thanks for that it worked.

Hi All, I have successfully created a query using CreateQueryDef which is used by my report. The problem is that sometimes there are no records to display. I would like a way to check if there is anything to display within my VBA code, so that I can display a message to the screen. a...

Well, I've managed to sort it out with all of your help. My solution in the end was to create another textfield to store the result of the summation and hide it, then using the IIF(IsError.....) example from above displayed 0 in my report instead of #Error. Thanks all for your help.

Never heard of the NoData Event, but I tried it as suggested, but it didn't fire. Any other suggestions?

The report is based on a automatically generated SQL query, how can I check for EOF within the report, I'm thinking of adding some code in the OPEN_REPORT event but don't know what to add for this check

I tried iif(IsError(expression),0,expression) and it gave me the same answer. This is what I have =IIf(IsError(Sum(Exam Fee Cost]),0,Sum([Exam Fee Cost])) which gives me #Error Also, the data for the form is based on a query, which in this case is returning an empty recordset. Probably need...

Hi All, I have a report that has a sum field called sumExamFeeCost = sum(detExamFeeCost) and a detail field called detExamFeeCost. The report runs off of a query, which can result in no records being returned. When no records are returned there are no records to sum or display. The details...

Hi Bob, Sorry for the delay in getting back. I had a thought about the errors I was getting. They were all releted to fields in the User Table that where combo boxes. So before assigning the recordsetclone I set these values up. as follows - Dim rstUser As DAO.Recordset Set rstUser...

Hi Bob, Tried that, didn't work either. Now I'm getting the 3426 error - The action was cancelled by an associated object. Maybe I should force them to use the combox to check it a user is in the system, instead of this route. But if you have any more suggestions I'll be willing to try them out.

Hi, Well I added Docmd.CancelEvent, but nothing happened. I think what's needed is an explicit change of form mode, from Add to Edit. Garfield

Thanks for that Bob, I've added that code, but I'me getting these errors Run-time error 3201 - You cannot add or change a record bcause a related record is required. I have some combobox's which are linked to table could this be the cause of this problem. But since all the data already...

Hi Bob, I'm pushing the envelop as usual. The form is a bound form, I already have a combox with all the users by lastname, firstname. Which if they select and entry from will display the correct record. It's the user's request that if they enter in the first and last names into the form...

Hi Bob, I tried your suggestion, thanks, it works in identifying that the last name exists, but I need to go a step further and populate the form with the details of the record found and change the form into edit mode. I would be gratful for any help. Garfield

Hello, I have 1 main form, which can be used to edit/create new users. When adding a new record, I want to check if a record existing, if so, then populate the form/subforms and go into edit mode. To check if the record exists I use an index based on the Lastname and Firstname. This check...

Here's some of the code I've written Private Sub LastName_AfterUpdate() Set rstUser = CurrentDb.OpenRecordset("Users") rstUser.Index = "UserName" rstUser.Seek "=", Me.LastName, Me.FirstName If Not rstUser.NoMatch Then Me.Address = rstUser!Address Me.Town =...

It is linked, but the data is in different tables. The main form used the User table and this subform used the Client table where the userid = clientid. The scenario is the user can enter the first & second name and then I search for that user is found I display the details on the main form...

Hi there, I have a main form that has tab controls containing subforms to display/add information. And I need to populate the subform from a recordset. e.g. I get a recordset for the main form, then use an ID field from it to get another recordset for the subform, which I want to populate...