Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. famousb

    Need check box auto fill another field or visa versa

    you could use the OnCurrent event of the form to set the value of the checkbox to -1 if the value of the field is 'P' this could be done with a formula or VB, depending on your preference. IIF([fieldname] ='p', [checkboxname] = -1) or VB If [fieldname] = 'p' then me.[checkboxname] = -1 end...
  2. famousb

    Access and Visual Basic 6.0

    simple idea. instead of installing the entire database on the network and having everyone access the whole thing that way. create a database for the tables, put that on the network, and then have seperate databases for the forms, which is installed locally on each user's machine. this way you...
  3. famousb

    forcing report footer to bottom of page

    stormtrooper, by definition, a report footer is not the same thing as a page footer. In design view, from the View Menu, which option do you have checked: Page Header/Footer, or Report Header/Footer if you want it at the end of the report, that would be the report footer option. now if...
  4. famousb

    HUGE Problem - AutoNumber Table Reset itself, Compacting Problem?

    ok, this is really bad.<br>i had (emphasize had) a table that contained between 10,000 and 15,000 records, and an autonumber field that was set to start at 10,012.&nbsp;&nbsp;well the table is still there this morning, but none of the data that was in the table last night remains.&nbsp;&nbsp;and...
  5. famousb

    multiple copies

    you could very easily have the button controlling the opening/printing of the report simply repeat the print statement twice.<br>ie.<br>docmd.printreport &quot;report&quot;<br>docmd.printreport &quot;report&quot;<br><br>or you could put the same type of thing in the On Open event of the report...
  6. famousb

    I want to add a menu to my website with values that add as selected

    for basics, what you need is a table with the product names a check boxes, and the prices - it would probably be easiest to have each product have 3 seperate fields across the table.<br>then you need a form showing all these fields on your form.<br>then in the After Update property of each of...
  7. famousb

    Saving changes

    ok, i haven't thought this all the way through.&nbsp;&nbsp;but what you could do is create a &quot;dummy&quot; form that is not bound to anything that the user sees - this would be just like the one that you have now.<br>then you could so what Jim suggests by prompting after every record to add...
  8. famousb

    Report controls

    i think that the DCount function should work well for you:<br><b><br>= DCount(&quot;<font color=red>[Yes/NoField]</font>&quot;, &quot;<font color=red>TableOrQueryReportSource</font>&quot;, &quot;<font color=red>[Yes/NoField]</font> = -1&quot;)<br></b><br><br>change the red to fit your situation...
  9. famousb

    Open Form Maximized

    and to expand on this idea, if you want the Access window itself to be maximized, create a shortcut on your desktop (or wherever you want it) to the specific database.&nbsp;&nbsp;then in the properties (right click on the shortcut icon and choose properties) of the shortcut find the Run window...
  10. famousb

    database compaction

    the only time you can compact a database is when you are the only person in the database.<br>as far as i know, there are no disadvantages to compacting.&nbsp;&nbsp;it's not something that necessarily has to be done every day, or even every week (unless you get a lot of db...
  11. famousb

    Update table through combobox

    this is an example of the code that you could use, i derived it from one of the FAQs in the General discussion forum:<br><b><br>Private Sub <font color=red>ComboBoxName</font>_NotInList(NewData As String, Response As Integer)<br>&nbsp;&nbsp;&nbsp;&nbsp;Dim iAnswer As...
  12. famousb

    Code to Print Excel Sheet from Access Module

    another option instead of the TransferSpreadsheet method is the OutputTo method, this works exactly the same as if you went through the toolbar and chose Analyze with Microsoft Excel - it produces a slightly cleaner, more readable format.&nbsp;&nbsp;It automatically can put the data in a...
  13. famousb

    Populating an Access Table

    personally, i don't know if there is a way to import it directly into a table and combine those two fields from Excel (i'm sure there has to be a way though).&nbsp;&nbsp;You could just import the table as is, and then run a Make Table query that concatenates the two fields using any of the code...
  14. famousb

    RE: Filter by Form

    i'm not positive, but i think this is the numbering for the filter by form function.<br>but it behind a button on the form and try it out.<br><br>DoCmd.DoMenuItem acFormBar, acRecordsMenu, 1, 0 <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>
  15. famousb

    Field updated instantly

    if your table name is &quot;tblArea&quot;<br>your field names are &quot;area_ID&quot; and &quot;Surface&quot;<br>then your code should be<br><br><b><br>Private Sub area_ID_AfterUpdate()<br>&nbsp;&nbsp;&nbsp;&nbsp;Me.[Surface] = DLookup(&quot;Surface&quot;, &quot;tblArea&quot...
  16. famousb

    Populating an Access Table

    i'd say yes, i've used that before as well.&nbsp;&nbsp;i think i'm just on my SQL kick right now. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>
  17. famousb

    Two tables in one form

    you want to have the Control Source be the field in the table that you want the data to go in to (the submittal table).&nbsp;&nbsp;then under Row Source hit the Build Button, this will bring up the Query Builder window, simply select the table you want the data to come from (and enter any...
  18. famousb

    How can I automate a module to run daily?

    you can make an AutoExec (just name it AutoExec) macro that has a RunCode command in it, that calls the name of your module.&nbsp;&nbsp;this will run the code whenever the database is opened. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>
  19. famousb

    converting numeric values to equal text values

    follows is FAQ 3C, courtesy of Jim Conrad.&nbsp;&nbsp;doesn't include the dollar sign, but i'm sure you should be able to incorporate it without too much trouble.<br><br>Function NumberToWords(InputNumber As Double, Optional NeedCents As Boolean = False) As...
  20. famousb

    Starting up Access so that the Form is the only Option

    you're right, it works for everything else but the Close button.<br>here is another option that i know i've used.&nbsp;&nbsp;Set both Pop Up and Modal to Yes.<br>Then create a shortcut for the database on the users desktop.&nbsp;&nbsp;then in theh shortcut's properties, in the Run window, select...

Part and Inventory Search

Back
Top