Search results for query: *

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

...to add all the prices together for all the fields that are checked.&nbsp;&nbsp;the easiest way to do this would probably be to multiply the price*Yes/No (which is saved as -1/0, respectively) and then add all of those totals together, and then multiply by -1.<br><br>ok, this makes it sound...

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

...Here is an example of the code:<br><b><br>DoCmd.OutputTo acOutputQuery, &quot;<font color=red>YourQueryName</font>&quot;, &quot;Microsoft Excel (*.xls)&quot;, &quot;c:\&quot; & &quot;<font color=red>WhateverNameYouWant</font>&quot; & &quot;.xls&quot;</b><br><br>just change the red to fit your...

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

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>

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

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>

...= Int(InputNumber / OneBillion)<br>&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;Millions = InputNumber - (Billions * OneBillion)<br>&nbsp;&nbsp;&nbsp;&nbsp;Millions = Int(Millions / 1000000)<br>&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;Thousands = InputNumber - (Billions *...

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