Search results

Is this going to be an ongoing function where you import the records into the database from an Excel spreadsheet, or is it a one shot thing, after which you'll be typing the values in yourself? Where is the Excel Spreadsheet getting its data from? Is there any way to create the spreadsheet in...

You'd need to change the way your database is laid out to do it. Basically, you'd need two tables--an "Agents" table and a "Monthly Amounts" table. Tie the two tables together via an ID number, then build your form based on that. From there, it's quite easy. The graph doesn't update...

Yes it is...except, it doesn't work; at least, not from a query. "=Forms![formname]![comboboxname].Column(1)" returns "Unidentified function 'Forms![formname]![comboname].Column' in expression".

I would imagine this is a function of the mail-merge. Have you considered building a report in Access to do the invoicing instead? This type of report is pretty standard, and Access will easily build it for you.

OK, coming up with a title for this one was a little difficult. Almost as difficult as the problem I'm facing ;) Here's the basic premise. The database is used to register people for a weekend convention. Part of the registration allows the person to request a specific roommate. In an ideal...

I don't believe you can do that. Here's a workaround: Create a form to input the start and end dates, rather than using the query directly. Then, reference the start and end fields in your query, and on your report. So, you have a form called "CreateReport", which has fields "StartDate" and...

Hello again, it's been a while. I'm back in Access Programming Mode, and here's my latest quandry. I have a list of registrants that I'd like to e-mail receipts to. The obvious solution would be to send the mail to each registrant as their information is entered in, but alas, this is not a...

Get to the 'form' properties. There should be an option on the 'Format' tab that says 'Auto Resize'. Select No. Then, size your window appropriately, save it, and close it. It should now re-open at the size you want. Alternatively, resize your grid to the size you want and save it. It...

With your form in design mode, RIGHT-click on a blank area(DARK grey, outside of the grid area) and select 'properties'. This will take you to the FORM properties. Go to the 'Event' Tab, and you'll see the On Open function. Click the little '...', it will ask you to choose a builder, select...

Use the 'on open' event to maximize the form via code. The code is: docmd.maximize That easy.

Have the query you base the subform on reference the listbox on the main form. Then, have the on change event of the list box requery the subform. Should work.

Ever consider going to MySQL as the backend, and Access as the front end?

Thought it was illegal to sell an access database without paying royalties to Microsoft?

AFAIK, you can't have this automated by just running the query. You can either do this via code behind a button on a form, or by using a macro. I'll show you the macro way, since I can't remember the code off the top of my head. ;) EDIT: Or, you could do what the other two said. Mine is more...

Create a query to count the data, then create the report based on said query. Here's how: Create the query to collect all of the information you need. Select only the tick boxes, and the date field. Once you have selected all the relevant fields, click on "View-->Totals". A "Totals" row...

For B, do the following: accept = "AC" & acceptNo Put that code wherever you need it; I imagine on the 'lost focus' event of acceptNo. For question A, you're going to be getting into setting recordsets. Try the following: Dim db, recordlist set db = CurrentDB set recordlist =...

Actually, at one point, it did do a compact/repair as a result of an outright crash. It crashed shortly after that again, so I automatically discounted it as having solved the problem. Perhaps it did, though. Meh, well, whatever. So long as it works!

Thanks for the post! Did a little more digging, and found out that it has nothing to do with my administrative status. Changing my secLevel to 3 or 4 prevents me from being able to open it as well. Which means the error is in the filtering code. I added msgbox commands to show the values of...

In answer to question B, it's pretty easy: Accept = "AC9" Now for question A. You have Form1 refering to data in Table1. Then, you have Form2 refering to data in Table2. Assuming the following: Form2 opens as a result of a function on Form1 (ie, press button). Form2 ALWAYS contains specific...

Allright, so I've got a Purchase Order database that I created a number of years ago. It's been working fine, up until last week. When a user other than myself attempts to open the 'receive po' form from their workstation, I can see in the status bar that it calculates, then filters the form...