Search results

I am able to fill the fields in the form but when i click save ..it doesnt save in my subform and in the table..system doesnt throws any error..but no data is added ..hope i made that clear.

Hi ..I am created a subform in my navigation page and created a list of fields in that ..which gets input and updates to a table..everything was working fine and I added around 50 entries to my form which is written to table ..but all of a sudden i couldnt add datas to my subform and table..I...

Hi ..I was updating my records by filling a form and entering the data's into a table but all of a sudden i couldn't add data to form and table..can anyone please help on this issue....thanks in advance

Hi .. I am trying to update information for 7 fields now from the form to the table ...but I am not able to get for one field "Me.txtbarcode"..any help is appreciated .. CurrentDb.Execute "INSERT INTO sample ([User],[Barcode],[toolCare Job],[Worked On Activity],[Start Time], [End Time]...

HI ..Sorry for posting that twice..Yeah it worked..I gave both as string..thank you

Hi ..I just googled and tried this one .. Barcodefromtable = DLookup("Barcode", "Barcode_Table", "toolCareJob= '" & Me.cbotoolCare_Job & "'") it worked..yeah Barcodefromtable as string is defined.. Thank you so much

Hi Thanks for the reply..I tried the brackets ..I got the Runtime error 6 overflow..can you give some inputs..i tried this code. Private Sub txtbarcode_BeforeUpdate(Cancel As Integer) Barcodefromtable = DLookup("Barcode", "Barcode_Table", "toolCareJob = '" & Forms![Navigation Form]!toolCareJob...

Hi I am trying to get my Barcode value from my table, by comparing other field called toolcarejob which is also present in the table and will be given in navigation form, but while executing my code I got syntax error. Any help on below syntax will be appreciated. Private Sub...

Hi..I tried that link but still I am getting the syntax error ..this is my code.. Private Sub txtbarcode_BeforeUpdate(Cancel As Integer) Barcodefromtable = DLookup("Barcode", "Barcode_Table", "toolCareJob = '" & forms! Navigation Form!toolCareJob & "'") Barcodefromscanner =...

Hi I am trying to get my Barcode value from my table, by comparing other field called toolcarejob which is also present in the table and will be given in navigation form, but while executing my code I got syntax error. Any help on below syntax will be appreciated. Barcodefromtable =...

@Plog , @CJ_Johnson .. thank you so much for your help

Hi ..I am able to record values in tables for all fields except toolcare job ..I think the field names are problem and I am changing it ..but my subform doesnt show table data ..it just shows like #Name? for all fields ..can you provide some info.. and I am just using access for 3 days so I...

Hi Thanks for the reply. I executed this below query but I am still getting runtime error. CurrentDb.Execute "INSERT INTO sample ([toolCare Job#],Worked On Activity,Start Time, End Time, Total Time)" & _ "VALUES ('" & Me.cbotoolCare_Job & "','" & Me.cboWorked_On_Activity & "','" &...

Hi I am creating a table in access database for my company which reads the data from a subform and store in a table. I have 5 values in which 2 of them are combo box and 3 values are time values (start time , end time and work time)..I executed the below insert into statement which throws...