Search results
-
Y
How to get prevous record data?
Hi, I have a continuous form with a textbox, which displays one month records' integer data, I need to get the current and previous record and see which one is bigger ? I can get current one easily, but is there a easy way to get the previous one? Thanks for help! -
Y
Write conflict
Hi, I have a subform with two textboxes(data bound),let's say txtA and txtB, and one combobox with 2 different values( let's say 5,6). For both the combo and txtA,I have AfterUpdate events, Combo_AfterUpdate event does calculation, like txtA*combo ( is user slect 5,then txtA*5,otherwise txtA... -
Y
Switchboard Items table
Hi, Thanks in advance! My current switchboard manager has 8 items now, but want to add more items, some post tells to edit switchboard Itmes table, could anyone tell me where is the switchboard Itmes table? Also, I coped one item on the switchboard, changed names,why it does not show up... -
Y
allowAdditions problem
Hi, This might be a dummy question: I have a continuous form with a DatetimePicker, textboxes,which displays one month's data, but always got one more empty row at the end of each month, after set AllowAdditions to No for the form, got an error: Run-time error 2763, DTPicker returned the... -
Y
Date time problem
Hi, I have a dtFirst is 2/28/2010 8:00:00 AM, dtSec 3/1/2010, and need to do : 3/1/2010 12:00:00 AM -2/28/2010 8:00:00 AM. Tried 1. CDate(dtSec & " " & " 12:00:00 AM"), but still get 3/1/2010 2.DateDiff("h",2/28/2010 8:00:00 AM, 3/1/2010 12:00:00 AM), got an error: Comple error: Expected... -
Y
Run-time error 94, invalid use of null
HI, I need read data from a table, my code : strSQL = "SELECT time,Amount," _ & " Where sampleDateTime = " & "#" & lastDayOfPreviousMonth & "# ;" Set rs = CurrentDb().OpenRecordset(strSQL) If rs.EOF Then 'MsgBox .Show(no data) Else mTime = rs.Fields("time")... -
Y
insert query error: missing semicolon(;)
Hi, I have a query in VBA access 2003 strSQL = "INSERT INTO tblTest(totalNum, totalWeight)" _ & " VALUES" & totalGal & ", " & "" & totalW& ")" _ & " WHERE ID = " & Me.ID & " ;" CurrentDb().Execute strSQL The qry is in immediate window: INSERT INTO tblTest(... -
Y
subform with combo selection
Hi, I have a subform which displays mutiple records based on main forms date time parameters, now I need to add a combo with values 2,3. if user select 2, then a textbox value(databound) in the subform need to *2 and display results in a label, otherwise *3. The problem is my combo event...