Search results for query: *

You never asked me directly if my form was bound. This : "If this is a form bound to the table Entry4, then why not just update a control bound to h_rand? " I was not aware this is a question asking me if my form was bound. I realized that you weren't aware my form was bound when only from March...

You are right I need to save the record first before updating the table. I did notice that before I clicked yes for the save new changes that the table did store current tm_rand. Then when I committed the new change the tm_rand goes back to the old time (15:45). Here is the code in case someone...

what do you meant by locking it? How do I unlock it. When I close it I keep getting this message saying someone else changed the record do I want to save the change to a clipboard.

I am not running a query. I wanted to make sure the SQL works. I meant I tested the SQL through query and was able to update. The entire coding is VBA.

Btw the code just posted is the entire code.

Right now I have just this update statement. var1 = "UPDATE Entry4 SET h_rand = 13 where id = '001-012-004'" I changed the set warning to true and after the msgbox asking if you want to update the record. I clicked yes and got this error. MS Access can't update all records in the update...

The problem is the update does not appear in the Entry4 table. I am not sure why I cannot update the information in the table. User enters time into tm_rand text field.

I just change my code a bit and still get same problem. ID is from a text field in the form. The data type of id is text and I did put quote around it in the SQl. [code] Dim db As Database Dim var1 As String Dim h As Integer Dim m As Integer h = DatePart("h", Me.tm_rand)...

I was wondering how can I go into business or operations side of healthcare? So typically I would apply to Reporting Analyst, Data Analyst and Decision Suppport jobs. I studied Business Analysis where I took courses in Regression, Optimization, and statistics. I am currently a database...

I have this form where user enters a time (i.e - 15:45) into a textbox which is stored to this field in the database. For data checking purposes we also have two fields, one to store the hour (15) and the other field to store minute (45). My problem is my code for some reason cannot update the...