Search results for query: *

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

Is there a way (which is a stupid way to start because i'm pretty sure there is) to convert the last two digits of a number into two decimal spots?<br>ie.&nbsp;&nbsp;1000 becomes 10.00<br><br>i thought i could do it through the import wizard, but can't seem to figure that out.&nbsp;&nbsp;i'm...

ok, i have a combo box pulling from a table.&nbsp;&nbsp;i'm using the NotInList property to prompt the user when he/she types in a new record that the record will be added (this is to give them an out if it was just a typo).<br>the recorded is then added to source table, and everything goes...

I know i've seen this done, i have a 15 digit number in field &quot;Claim&quot;, i need the last 3 digits to be moved to a field name &quot;LineItem&quot;<br>what is the easiest way to go about this?&nbsp;&nbsp;cutting and pasting uses too much glue...<br><br>thanks again <p>Brian Famous<br><a...

ok, i know this was posted just like earlier this week, but i can't seem to find it (i looked through the last 16 pages)<br><br>how can i get a query to have a field with autonumber of the records? <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>

ok, I know i can change the record source of the main form with the following code:<br>Me.RecordSource = &quot;queryname&quot;<br><br>but i'm not sure how to change the record source of a subform.<br>My subform name is &quot;subDenClaims&quot;<br>and the new record source name is...

I have a query <b>&quot;qbfDenClaim&quot;</b> which feeds one form, and then i want the same query to feed another form that summarizes the information, but i only want the summary to contain records where <b>[Outcome]</b> does NOT equal <b>&quot;ok&quot;</b>.<br><br>for some reason evil beings...

ok, i've done this before but can't remember how.<br> I need to generate 100 unique random numbers ranging from 1-X, with X being a value enterred by the user.<br> I thought i did this before through a query, but i can't seem to get it to work now. the formula i'm using now is<br> <br>...

Here's a link to some free utilities from FMS Inc., which elizabeth pointed me to earlier (thanks elizabeth).<br> <br> the last one is really nice for visual effects on forms, it allows you to easily create shadowed, raised, etched, etc... text.<br> <br> <A...

Here's a really tough one...<br> we are beginning to collect line-item data that can reachup to 5 million records (a little bit more than what Access likes to handle). all we need to do is to take a random sample of 100 records from that line-item data. we are looking at buying software to run...

I can seem to manage to get Word to open fine through code, and to open to the Mail Merge helper fine, but i want to be able to automatically have Word open a new document as a mail merge with the data on my form (as limited by a query/filter) be the default data for the mail merge. <br> <br>...

Using VB I am creating a new Word document. In this document there are going to be several date fields. They currently come up in the format mm/dd/yyyy. What I want them to do is to appear in a format like Weekday, Month Day, Year. (i.e. Thursday, March 9, 2000).<br> Is there VB code that...

I need to export a table/query as a .dbf file. i've managed to do it as a .txt or .xls, but haven't seemed to be able to do the same thing with the .dbf format. <br> can anyone provide me with the actual VB or code otherwise?<br> <br> thanks in advance. <p>Brian Famous<br><a...