Search results

I'm not exactly sure why you would want to do that, but it is possible. You can either create unbound test boxes in the form or report that you would like to display the results in (setting them equal to the query fields)... Or You could create expression fields (not sure if that's the...

use the navagation buttons on the bottom of the Screen/form window, or you can add command buttons using code, a macro, or the command button wizard to move to next record!

Okay....I think what you're saying is that you're getting an error message in a form which feeds back to a MAINtable which houses the fields from the user form and the restricted form. Even thought the user form does not include the fields from the restricted form...once the user creates the...

Hmm..not axactly sure..but this is what I would do: I would have a command button launch a macro, or code to open your report, in report preview. Have the report based off of a query. In the Criteria section of the query: Supplier - Place [Enter a Supplier Record: ] In StartEndDate -...

Chris, You have the option to edit your posts...and reply to your own post. I would not suggest starting a new thread just because you need to ad something new. You're going to confuse the people who will try to help you...and clutter up the forum. I would help you, but i don't really...

Set the field in the table to Required.No In the form that you want to make it mandatory in: Set the form properties, Close Button to No and the Navigation buttons to No On the command buttons that you create for Close, or navigation include the following as part of your close statment: If...

Okay..let me know if this comes close to doing what you want to do. I know...I've made some serious changes, but I'm hoping that I got the idea down....at least if I'm close...you will have something to work with. Please let me know! :D

Okay....it's really simple. Create a form with a bound textbox, control source [YourComboField] Add a button to your current form, taking you to the form you just created. The form allows you to make additions to the combo box and the combobox on your MAINform will allow you to select the...

Just explain what you want Can you at least explain what you want the database to do. FOr someone who has only been working with access for two days, you seems to have done a lot. I'd like to help you, but if you can't express what you need to accomplish then it's going to be almost...

Schorsch, I'm only at work for 1 more hour, but I will be glad to assist you as well. I would admit that you've provided us with ver little to go on. What exactly are you trying to do. Be very specific: What form are you having trouble with? What combo box are you getting the error on...

John, Why don't you just use a query to prompt the user for criteria to populate your form or report? I guess you've mentioned that there are a lot of records to thumb through, so I'm wondering why would you want to have them scroll through a huge datasheet. if they are patient enough to...

Andrew, I would have to admit that it would be nice if there was a booklet that just contained the syntax, but they tend to be really spread out through out most books and many are jumbled by pieces of examples. Anyway, if you're looking for Query syntax (since it sounds like you will...

Didn't read through the whole wish list, but you can use page tabs for the multiple pages...and an unbound list box to allow users to select a record from a table like format! When they made a selection, complete the code to use the selected information to fill out the next page. I know that...

Solution!! Okay...here is a fully functioning solution. I'm now working in Access 2000 and 2002 (no more 97), so I hope that you are able to use this! P.S. I just realized after zipping that I should have included DoCmd.maximize After the OpenReport function:rolleyes:

Hmm...I have two suggestions: You would either use conditional formating to make over due accounts stand out from the rest of the records! Or you can schedule a task to e-mail you a report with the query is IsNot Null.

Rakier, I'm actually looking to see if the specific [Division] Is Null, so if the query isn't able to find any matching [Divisions] then it has nothing to report...thus the field being null is all I need as a flag for the Msgbox to appear. I even tried to make in unbound text box that...

Rakier, Code is great and that might be what I end up doing. unfortunately at the moment I have an option group that used a macro to determine which of the selected reports will provide data for which of the selected [Divisions] from a list. I didn't feel like coding it, so I just used an...

I would create a seperate field that will track the additional entries. Having the field increment is great, but in order to allow the users to view all of the records with a base number, you'll need to allow them to have that common field. So, have an invoice field and an increment field...

skate, If you follow the format that I suggested 'If selected will select all of the other check boxes If (Forms![My Form]![MySelectAll]=(-1)) Then Forms![My Form]![My Other Fields] = (-1) Forms![My Form]![My Other Fields]= (-1) etc. EndIf Meaning that if the user checks this one box...

Rich, No cigar. Although i could have written the code of these print operations, I chose to use a macro. I can't just run code in that portion of the marco. I used and options group and I know that their has to be a way to add a MsgBox in the THEN portion of my statement. I wish it was...