General

Access - code
How to write in Access a "find" sentence, that finds a specific record in a table (according to one of the fields) and displaya data from other fields? (Eg the user enters the IDnumber of a book, and gets a message box with the name of the book) -- Gal ... 16 Mar 2010 17:26

OJG;mlorAM
huhe;$B#f#k#j#f#d#c(B:$B#s#j#d#f#k$b#j#h#v$K$q$&#h#t#g$l$&#h#t6q$"#h$D#8#9#w#4#5$f#8$&$l$$#t$.#j$j#d#j#t#f$7#p#f#k$##m$K$V$?#r!w#t#b!w$"#t!V#6#4#6!V$S$$#r#y#0#q#4#0#9#y#5#8#q#9#7$&#8$&#1$&$&#y$/$#$-$4#d#j#g#v#k#f#d#j#g$X$&$O$&$U$C$O#h$C$O$O#h#h#t$0$"!((B $B#cDD#l#k#m%s$U#v#c$A#k#j#n#y#t#y$l#y#h#y#b#g#b$A$'#rE+#y%... 16 Mar 2010 05:46

SendObject format
I am using an event to send a report as a pdf attachment. However, I cannot figure out the [OutputFormat] to use. I have tried every possible configuration of "PDF Format (*.pdf)" that I can think of. Without having the proper [Output Format], the user must select the pdf option when prompted. My command I ... 17 Mar 2010 19:59

Retrieving @@Identity value in ado.net
Hi I am using below vb.net code to insert a record into an access table and then retrieve the auto number id using @@Identity; If LocalConn.State = ConnectionState.Closed Then LocalConn.Open() End If Dim DBCommand As System.Data.OleDb.OleDbCommand Dim I As Integer... 2 Apr 2010 02:49

Switchboard in Access 2010
I am trying to create a Switchboard in Access 2010, but when I create the first entry the number block is blank and it will not let me edit to enter a number. I have tried changing the background color to see if that was why I couldn't see the number, but that didn't help. ... 16 Mar 2010 10:15

Recordset merge
I am merging from an Access 2007 Form/subforms to a bookmarked Word document. I am able to use <.MoveNext> to merge the recordsets, but get an error if there are less records. The DAO Library is referenced, I've tried this code, but now only the first record is merged and the fields of the recordsets of the form... 26 Mar 2010 14:22

ciao riccardo
... 15 Mar 2010 13:30

csv linked file doesn't add to the same numbers?????
Hi, I have a linked cvs file that when I do a sum in access I get a different answer than when I open the csv file and so a sum on the column. Can anyone explain why this is happening. ... 15 Mar 2010 13:30

Years of Service Calculation to 2 decimal places
Hi there In my database, I have used the following calculation to determine a person's years of service. YearsOfService: DateDiff("yyyy",[HireDate],Date()) -IIf(Format([HireDate],"mmdd")>Format(Date(),"mmdd"),1,0) A t the moment, the result is rounded to the nearest whole number. I would like to see at l... 2 Apr 2010 11:31

Converting a Number
Does anyone know of a rotuine to convert a number into its equivalent in English, e.g. 400,000 = Four Hundred Thousand. Thanks. -- Anthony ... 15 Mar 2010 00:17