Search results

calendar Did you look for missing references on the machines giving you these issues?

Pictures Is your picture embedded or linked? If it is embedded try linking it. Also, make a copy first and if you link the picture(s) do a compact/repair to get the database size down.

emails A few years ago I did this where there were over 40 retail stores that received a sales/commission report every two weeks. I would run the report for each store and using the TransferSpreadsheet function I saved the report into a folder for each store. Ex: C:\RetailStore1\TheirReport...

Random If you didn't include the following line of code like I stated in my example you will get the same records every time... ORDER BY Rnd([avalue]); I have tested this several times and does indeed produce random results

Access Version The computer I am on right now has an older version of Access than what the DB was created in and am unable to open it. Can't help.

count And you have your criteria for your customernumber in your query set to equal the customernumber on the form?

previous Then there is something wrong with the design you are using. Can you post your db?

Order Since you are adding a new order the previous order will always keep it's data. If you don't want to keep a previous order's data then just overwrite the previous one although I don't why you would want to do this. Why wouldn't you want to be able to keep previous orders? Seems to defeat...

Don't quote em Create a query using your first table as it's recordsource. Create an expression in your query Expr: """" & [yournumber] & """". (2 sets of 4 quotes)Make the query an append query. Append the EXPR field to your text field in your second table

book You could use a returneddate field and use that instead of Date(). Set your default value of returneddate to Date(). That way the net fine never increases. If the book is never returned the net fine field will not exist in that IIF statement. Hope this helps. I did not see the double...

report If upon truncation you put say 2 periods at the end of the field like "and so.." you could in the ONPrint event of your report something like If Right(me.truncatedfield,2)=".." then me.thelabelcontinuedonnextpage.visible=true else me.thelabelcontinuedonnextpage.visible=false end if...

Inventory I would recommend you sit down and take a look at the Inventory database that comes with Access. Go to File>New>Databases>Inventory database. You also may want to look at the Order Entry database as well.

dups See if this attachment helps

SELECT TOP 3 table1.avalue, Rnd([avalue]) AS Expr1, table1.sometext INTO Newtable FROM table1 WHERE (((table1.sometext)="H")) ORDER BY Rnd([avalue]); This takes 3 records from the number field [avalue] and the textfield [sometext] where [sometext]="H" in table1 and dumps it into a table...

Sorting Check out this link..... http://www.candace-tripp.com/pages/access_downloads.aspx I posted this yesterday for someone that wanted to open a form and sort a listbox which contained several columns. This will allow you sort by any of the columns in your listbox. Don't know if this is...

printing last page http://www.thescripts.com/forum/thread191653.html See if this helps

Date I have seen this on a client's computer. Only one of the computers was giving the Date error in a report. Turned out it was a missing reference. Go into any of your vba code. Then go up to the menu and click on Tools>References. See if any are marked MISSING. If so, check that reference...

listbox reorder http://www.candace-tripp.com/pages/access_downloads.aspx Go to this link and scroll down to you come to listbox reorder. This gives an example of how to do this. Hope this helps

iif Create another expression in your query, anothertry: You don't need to mess with the logic you were given (aasuming it is correct of course), just the order you want the conditions to be read. anothertry:IIf(Not IsNull([admit_dec_code]) Or [admit_dec_code]<>"R" And...

Iif Remember that in an IIF statement in a query the very FIRST instance of a condition being true will get the assigned value and basically exit out of the query. Try putting your most complex IIF conditions first in your query. Good luck and go Browns!!