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!

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

    Going to NT from Office 2000 Question

    If you are using Access 2000 -- There is a bug related to the new "Track Name AutoCorrect" feature. Try turning this feature off and see if the printer settings remain as last set. From the Access menu bar... Tools/Options/"General" tab Jim Conrad JimConrad@Consultant.com
  2. JimConrad

    network performance

    If the data for the list box doesn't change frequently, consider putting that table into the front-end database. Jim Conrad JimConrad@Consultant.com
  3. JimConrad

    Date and Stamp Check Box

    I assume you have a form with two controls. I'll call the checkbox control "chkBox" and the text box that will hold the date/time, "txtDate". You can set the "visible" property of txtDate to "true" while you work on the form and reset it later to...
  4. JimConrad

    Email from access

    Sounds like you have multiple issues to deal with :-( Are you having problems with creating an email? Storing the "reorder point"? Deciding where to put the code? Jim Conrad JimConrad@Consultant.com
  5. JimConrad

    NotOnList Event Procedure Works Partially

    Did you add this code to the NotInList event procedure?<br><br>Response = acDataErrAdded<br><br>This tells Access that new data has been added and it should requery the db. <p>Jim Conrad<br><a href=mailto:JimConrad@Consultant.com>JimConrad@Consultant.com</a><br><a href= > </a><br>
  6. JimConrad

    Populating an Access Table

    Assuming you have already imported the Excel data and that F1-F7 are the fieldnames in the imported table... then a &quot;append&quot; query is all you need.<br><br>You probably will want to make a copy of your &quot;Form Element&quot; table before you start, in case something doesn't work while...
  7. JimConrad

    exporting a report

    Your might want to view <A HREF="http://www.microsoft.com/ACCESSDEV/ProdInfo/snapshot.htm" TARGET="_new">http://www.microsoft.com/ACCESSDEV/ProdInfo/snapshot.htm</A> for information about the Access Report Snapshot Viewer.<br><br>You can create a snapshot of a report into a file that your user...
  8. JimConrad

    Maximum Access Database for Regular performers

    Maximum database size is 2 gigabytes.<br><br>Maximum rows depends on number of columns (max of 255 per table) and type of data. <p>Jim Conrad<br><a href=mailto:JimConrad@Consultant.com>JimConrad@Consultant.com</a><br><a href= > </a><br>
  9. JimConrad

    VBA Documentation

    VBA is Visual Basic for Applications.<br><br>Check <A HREF="http://www.microsoft.com" TARGET="_new">www.microsoft.com</A> for more details. <p>Jim Conrad<br><a href=mailto:JimConrad@Consultant.com>JimConrad@Consultant.com</a><br><a href= > </a><br>
  10. JimConrad

    Record locked by another user.

    Watch out for Edited Record option.&nbsp;&nbsp;Unfortunately Access does not lock individual rows of the database.&nbsp;&nbsp;It locks &quot;pages&quot; which are sets of 2000 bytes.&nbsp;&nbsp;So if you have a small table (just a few columns of data), you might have 10 rows of data sharing a...
  11. JimConrad

    open sub form

    You can just single click the subform and make changes to it while viewing it in the context of the mainform.<br><br>But I liked it better in Access 97, too. <p>Jim Conrad<br><a href=mailto:JimConrad@Consultant.com>JimConrad@Consultant.com</a><br><a href= > </a><br>
  12. JimConrad

    Data Access Pages??!?!?! ARRGGHHH!!!!

    Try the Microsoft site <A HREF="http://www.microsoft.com" TARGET="_new">www.microsoft.com</A> and search for ASP. <p>Jim Conrad<br><a href=mailto:JimConrad@Consultant.com>JimConrad@Consultant.com</a><br><a href= > </a><br>
  13. JimConrad

    using incremented number to fill a field

    Set it up exactly as you planned.&nbsp;&nbsp;Assuming your table is called ReportSeq and the numeric column is also called ReportSeq then...<br>&nbsp;&nbsp;Add the ReportSeq table to your query (do not link it to your other tables), add ReportSeq column to your query grid... <br>&nbsp;&nbsp;Add...
  14. JimConrad

    Binding

    <FONT FACE=monospace><br>Dim LateObject&nbsp;&nbsp;As Object&nbsp;&nbsp;&nbsp;&nbsp;' Late binding<br>Dim EarlyObject As Recordset ' Early binding <br></font><br>Access can help you write your code when you use Early binding since it knows that EarlyObject is going to refer to a recordset type...
  15. JimConrad

    Connecting Form to Microsoft example module

    Try this code attached to MyButton on the form with NumberOfRecords as the name of the unbound textbox<br><br><FONT FACE=monospace><br>Sub MyButton_Click()<br><br>&nbsp;&nbsp;&nbsp;&nbsp;Call BuildRandomTable(NumberOfRecords)<br><br>End Sub<br></font> <p>Jim Conrad<br><a...
  16. JimConrad

    Last record in subset query.

    Try using MAX instead of LAST <p>Jim Conrad<br><a href=mailto:JimConrad@Consultant.com>JimConrad@Consultant.com</a><br><a href= > </a><br>
  17. JimConrad

    Value List info passed to a parameter query

    Or try...<br><br>Note: Listbox columns are zero based index, so Column(0) refers to the 1st column...<br><br>[Forms]![RunProductionQueryForm]![List21].Column(1)<br> <p>Jim Conrad<br><a href=mailto:JimConrad@Consultant.com>JimConrad@Consultant.com</a><br><a href= > </a><br>
  18. JimConrad

    Control Collections: Anyway to control the index of each control?

    The &quot;Controls&quot; collection is indexed in the order the controls were originally added to the form.<br><br>If you are trying to set some of the control properties (but only for certain types of control), you can use the &quot;TypeName&quot; function or &quot;TypeOf&quot; if...
  19. JimConrad

    Am I organizing my database correctly

    You might want to hire a consultant for a few hours to get you started.<br><br>You may want to take a class in beginning programming.<br><br>You are going to find that, although Access is good at doing some simple things, your needs will almost always exceed what can be done...
  20. JimConrad

    i would like to have a form that adds new records and .........

    Sorry, but it isn't clear to me what you are trying to do. <p>Jim Conrad<br><a href=mailto:JimConrad@Consultant.com>JimConrad@Consultant.com</a><br><a href= > </a><br>

Part and Inventory Search

Back
Top