Posted
by Shaun
on Stack Overflow
See other posts from Stack Overflow
or by Shaun
Published on 2010-04-01T10:17:16Z
Indexed on
2010/04/01
10:23 UTC
Read the original article
Hit count: 284
On a report I have the following code
=Sum([PartQty]*[ModuleQty])
Example results are 2.1 or 2.6, what I need is for the valule to round up to read 3
© Stack Overflow or respective owner
as seen on Stack Overflow
- Search for 'Stack Overflow'
lets say I have an embedded Excel Spreadsheet on a Microsoft Access form. I call the object frame
ExcelFrame
and I add a text box on the form called
txtA1
and I add a button on the form called
cmdInsert
I want to type "Hello World" into the text box, click the button and have it appear in…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Here is a silly question. Lets say I have a query that produces for a list box, and it produces values for three stores
Store A 18
Store B 32
Store C 54
Now if I ORDER BY in the sql statement the only thing it will do is descending or ascending alphabetically but I want a certain order…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
So a couple silly questions:
If I include this in some event:
MsgBox " ", vbOkOnly, "This little message box"
could I then with some more code turn around and 'click the ok button. So that basically the message boox automatically pops up, and then automatically goes away?
I know its silly because…
>>> More
as seen on Super User
- Search for 'Super User'
On a report I have a control which is bound to a column which can have up to 3 decimal places.
I want the number to format with commas separating thousands and millions, but I also want the number of decimal places to be automatic, so that if there is no decimal portion then no decimal at all is…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi. I use functions like the following to make temporary tables out of crosstabs queries.
Function SQL_Tester()
Dim sql As String
If DCount("*", "MSysObjects", "[Name]='tblTemp'") Then
DoCmd.DeleteObject acTable, "tblTemp"
End If
sql = "SELECT * INTO tblTemp from TblMain;"
Debug.Print (sql)
…
>>> More
