Search results

you would want to use the the "requery" command after you have added the new item... maybe on the OnClose event of the form that adds the item?

Hello, I have created a form that returns a list of contacts with an outstanding balance greater than zero. the form is unbound, and the list results are being pulled from a query that returns the name & company name, and a charge/payment/balance summary... the bound column on the list box is...

use a visible true/false property... on the change page event, make header 1 not visible & header 2 visible? [This message has been edited by jatfill (edited 06-27-2001).]

It's having a problem with this line: Docmd.Close acForm "YourForm" It says something like "Error: Excpected Array" I just changed it to "DoCmd.close" and it worked perfectly... thank you very much for the tip!!

Hi all, I'm creating a registration form, and I've set it up the following way: User enters the contact's first and last name. Once the last name field is completed, I run a check to see if any matching names already exist in the contacts table. If there are matches, a message box appears...

you can use the box (i.e. set the report criteria for the Department field to [Enter Department Name], but really you can tie an event to a button on the query form that opens the report (either in preview mode or send it directly to the printer), then closes the form itself... makes it very...

create form that had a combo box based on the departments, so that users can just select which department they need from a list. In the report, set the department's unique ID or value equal to whatever value is on the form... =Forms![formname]![departmentID] with this method, it wouldn't...

sorry, I looked again at the example I was using and tested exactly what you're trying to do and it does not work... but here's another idea that works great: ="H. (" & Left([home_tel],3) & ") " & Mid([home_tel],4,3) & " - " & Right([home_tel],4) & " W. (" & Left([work_tel],3) & ") " &...

I've done this before & it works great for me... Create two fields on your report, set their visible property to no and make sure their input mask is displaying correctly (preview them first & see before you make them not visible, if they don't show the correct input mask, set it on the field's...

those are all good points... and I wish I could say that this is going to be a major feature within the database I'm working on, but it's not. It's really one of those insignificant things that no one will ever appreciate unless it doesn't work. As far as using other Office tools, I'm well...

use the "runApp" function inside the macro, enter in the full path to the .bat file in the arguement section

If you're using Access 2000, you can also go into Tools, Startup... and uncheck "Display Database window" and select your switchboard form in the "Display Form" section. Then on the On Open AND On Activate properties of the switchboard form, add the DoCmd.Maximize statement that christy...

Thanks, it sounds like I'm on the right track! While we're on the subject, will the results of the crosstab report be dynamic? As I eluded to in my original message, the number of columns in the crosstab are/will be dynamic, depending on the event itself. So there might be three columns in the...

I was thinking about that part of it earlier, and I came up with the idea of reversing the subform/parent form relationship...? It's definitely worth a try, thank you very much for the input!

this is the error message I get: "You can't use pass-through query or non-fixed-column crosstab query as a record source for a subform or report. - Before you bind the subform or subreport to a crosstab query, set the query's ColumnHeadings property." Any help someone cn offer would be much...

I'm using the BeforeUpdate property to validate a form, when it runs through the checks, I have a message box appear that states the proble, and cancels the save operation. If the error is encountered, my error message pops up, and then I get a second message that says "You canceled the previous...

I'm using the BeforeUpdate property to validate a form, when it runs through the checks, I have a message box appear that states the proble, and cancels the save operation. If the error is encountered, my error message pops up, and then I get a second message that says "You canceled the previous...

the requery command works for me in these types of situations...

Is there any way I can customize the name of the Report Access attaches to an email when you use the send object command: I was hoping to do something like "PO" & [po_ID] & a date string, so a result would be for example: PO67754_06132001.rtf thanks for any help you can offer!

a quick easy way to solve this problem is to close the form using the "On Open" event of the second form...