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

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

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

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

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

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

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

I am a complete moron so bare with me here.... I went into the Tools\Startup section and turned off all the menus and such. Now I want to go back in and change those settings but I can't see any of the menu choices (ergo Startup is missing). I'm stuck in a catch 22. I need to change that...

I have about 7 databases in my company all in one shared drive. Each Database has a really nice switchboard form. I want to ease my users' use of these databases by making one main switchboard that has buttons that open the switchboards of each of the other databases. I figured I would make a...

Hi, I have a couple tables with sales data split by year...so for example I have one with all the sales data for 2001 called 2001paid Now I want to run a report or query on these tables so that I can get all the entries for a specific sales code across all the years. How do I make it so that I...

I want to get a really good Access book to help the programmers in my office. Something that at least lists the functions and their usage/examples. Any ideas??

Hi, Not sure if this falls under Reports or forms but either way here goes.... I have a form with a button that when clicked previews a very plain report of all the record sets in the table. What I want it to do though is jump to the page that has the current record set's info on it.... Does...

I have a report that I'm trying to build that sorts purchases by month... So I end up with something along the lines of this: 1/12/02 John Smith 1 unit $4.00 Jane Doe 2 units $8.00 2/20/02 Joe Johnson 1 unit $4.00 ...now...

I'm sure this will be pretty easy for most of you but I'm stuck. I have a crosstab query and I want to filter out entries that do not contain a string of text. I'm used to using "like" in the criteria to find matching fields to the string but that doesn't work when I want anything that at least...