Search results

I'm sorry if this is a repeat but I just couldn't find the answer looking at old posts. I have report with one grouping (accountnumber, header only) and a subreport of transactions in the detail. When I run the report most pages are fine but anyone that has more than a handfull of transactions...

Thanks, I was expecting some kind of select statement that made more sense but all I could find was something along these lines: <asp:GridView ID="gvBrokers" runat="server" AllowPaging="True" AllowSorting="True" DataSourceID="qtBrokers" AutoGenerateColumns="False" DataKeyNames="Broker_Id" So I...

I'm guessing this a simple matter though I did some searching and don't know how else to go about it.... I have an access database on my site that is referenced by an aspx page created by my predocessor in C#. I know enough html and other programming to edit it but I need to make some...

Can you open Access databases using file maker pro while on a MAC without converting them and blocking windows users?

Wow, that did it. Thanks so much for the help. I was starting to get afraid that it couldn't be done outside of a report. Thanks again.

Okay, I'm feeling really stupid since I think this should be pretty easy to do. I have a table of transactions that looks like this: CODE POLICY 44 FG48573 44 FG36439 44 FG29483 36 FG69274 36 FG23853 28 FG38567 I want to make a query that makes a...

Do something like this in the OnClick code: Dim stDocName As String Dim stWherest As String stDocName = "Name of my report" stWherest = "[MyTable]![MyField]= Forms![MyForm]![MyField]" DoCmd.OpenReport stDocName, acPreview, , stWherest ....just replace the My* with...

Not sure if you are still trying to solve this but here's a hint or two. In the sub form create a field that sums up all of the charges. In the main form create a text box that references that field. It'll be something like Forms![subform]![ChargesSum] ....If I were you I'd run the expression...

I kind of found a way around my problem by having it open a popup form instead and setting some fields on that form to match the data I want so I guess this isn't a problem any more but I'd love to know why this doesn't work. Thanks for the help, I'm sure thats what I would need were this a...

I have a form that shows a calendar...to make a long story short I want to open a report (Report1) and have it only show those records that have the same date as the day I'm on in the form. This value is stored in the aGridDate(intControl) that you see below. I know there are records for that...

I have a table with a field called Priority. Each record in the table has a priority except for the completed ones. What I want is to be able to check mark my Completed box on my form and have it set that record to a priority of 0 and to reorder all of the other records' priorities to fill in...

Thanks for the help everyone. I was thinking that was a little large for a FE. They've always been that large and there aren't any graphics short of the few really small ones they are using for special buttons and two backgrounds with our logo on them. Sadly I can't get them to give me the mdb...

I have a database that a company has designed for me. It is split into front ends (mde databases of forms and reports, one for each user) on the server and a single "data" database. The problem is that every time one of my users tries to open a certain form in the database from their local...

I have a table with 30000 records with two fields each. The first field is a record ID and the second is a memo field with text and html tags...as if you copied html code from a web page. I NEED to get that html data (tags with text inbetween) in the memo field into just plain text in a field...

Jeremie, Thanks very much for looking at that for me but it looks like you ran into the same issue I had. Luckily I figured this out using a second query (cross tab of orders and invoice) that provides me with a total due for the entire invoice. Thanks again

I have a database that keeps track of orders from the company store. There is an Invoice table that contains an invoice ID and Total Paid field among others There is an Order table that contains the information about the items ordered in the invoice (ie. Invoice ID, Item Name, Item Cost) I...

That did it!! WooHooo!! Thanks a bunch...I was about to give up. =(Nz(sum([field1])+Nz(sum([field2]))) works the way you want even if one of the two is Null

Thanks but I can't seem to find the default value box for the textboxes......I went to the properties of the textbox and looked but nothing about default value. Seems odd that I could miss that. Which tab is it suppossed to be on?

Thanks...I tried that and I figured out what is causing the problem. The sum only works when both fields have some value..... I should have mentioned this before but the report is based on a crosstab querey (I have set different products to be the column headings in the querey). Now if I do the...

Normally if I want one field totaled I put in a text box with =SUM([product1]) This works great but...... What do you do when you want to total more than one? I tried a text box with =SUM([product1]+[product2]) or =[product1]+[product2] but nothing seems to work. **a second less imortant...