Recent content by famousb

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

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

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

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

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

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

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

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

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

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

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

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

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

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>

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