Recent content by AnalystDBA

hi appi, thanks for the reply. I have a cancelled field and that can eliminate the cancelled deliveries. If the first delivery is cancelled eg. del_num = 1 and status = cancelled then I have to go to del_num = 2 for the second delivery. Is there a FIRST operator in Informix that will get the...

Hi, I am trying to get the first delivery date for each order in a recordset that will have many orders for each customer and many deliveries for each order. I need to get the Customer details, the order details and show the first delivery date for each order. The Tables I am working with are...

Hi All, Can I use a Create View Statement in a Stored Procedure in Informix v7.31. I am trying to created the stored procedure and I keep getting a Syntax error. I can't seem to find the error and was wondering if it was the Create View statement in my stored procedure. Any help would be...

Hi All, I have an application in Access and sometimes I get a Windows message telling me that Resources are dangerously low and I should close uneeded programs. I have an AMD Athlon XP1800 with 256MB DDR Ram. Its not the quickest machine around but its not exactly slow either. MS Access just...

Hi People, Does anyone know of a function or have a function that they have created that will convert a number to its text equivilant. ie Number = 1240 Text = One Thousand Two Hundred and Forty Cheers, AnalystDBA

Hi everyone. Simple question. Is it possible to nest a select case statement within another select case?? Cheers AnalystDBA

Hi All, Can anyone help with this?? It may sound stupid but I can't open the sorting and grouping window in report design view. I click on the sorting and grouping option on the toolbar and the report loses the focus but the Sorting and Grouping window appears to be hidden for some reason. I...

Try this automaticbaby DoCmd.OpenReport "Transaction Report", acPreview, , "[User ID] = '" & Me.User_ID & "'" You can also assign the filter to a variable and then open the report with the following code. Dim FilterCriteria as string FilterCriteria =...

Hi all, Can anyone help with this one? I am using Access 97 I have a basic report based on a static table in Access. I am trying to insert 2 sub reports into the main report to total data for each segment of the report (ie sales by territory,area and manager with a total for area and...

Steve, I checked both of these and nothing obvious stuck out. Thanks for your help anyway. I guess its back to the drawing board :o) Have fun programming Steve. Cheers AnalystDBA

Steve, Thanks for the reply. I have checked the regional settings however this should not effect the query as Access converts any date to a serial number regardless of the format. The filter in the open report command has the dates enclosed in # and the controls on the form that I have assigned...

Hey mouseman , This should give you a count of the names in your table create the following query SELECT Sum(findtext([Your Name Field Here],'/')+1) AS NameCount FROM [Table Name Here]; then create the following function in a standard module. Option Compare Database Option Explicit...

Hi Errolf Unfortunately there is no code that I know of that will format the page layout of a report in Access and I have looked into it in detail. You can however open both reports in the one action so they display on screen on top of one another. In VBA all you need to do is open both reports...

Hi Kelly, This sounds complex. Can you email me your .mdb file and I will see what I can do. I create reports like this all the time. Cheers, AnalystDBA alc_consulting@optusnet.com.au

I have an Access report based on criteria entered by the user. The problem I have may not necessarily be Access related. When I run the report on my machine the report opens fine with the correct information. When someone else tries to run the report on their machine the report does not return...