Recent content by Avizan05

Hi All, I am new to access. I have developed an application using access 2013 and deployed it in my working place(with some help from our forum members). I have split the database and shared to FE to multiple PC and keep the FE in main PC(my work place doesnt have server and so i have...

Thanks CJ_London & Sumox. I currntly revisiting my application to see if it is designed as per ur suggestions. @ Sumox : In my work place all system are connect through Wired LAN using CISCO 892 router (NET GEAR - Pro Safe 24 Port 10/100 Switch) , All Systems are new and has 4GB RAM(Including...

I have tried link table method as u said and It WORKED. Thank u SO MUCH!! I just need couple more details. 1.I dont use a server(We dont have a server our workplace). I have placed my back end in a PC and mapped the location to Front End. When i try to open a form its taking bit long time to...

Hi, I have no knowledge or experience in developing Application. I am from a Testing Background. Recently, For a requirement i tried to Develop an Application using Access and after two months are hardship, i have learnt VBA and Completed the Application using Access. Now i have to Install...

Hi, I have no knowledge or experience in developing Application. I am from a Testing Background. Recently, For a requirement i tried to Develop an Application using Access and after two months are hardship, i have learnt VBA and Completed the Application using Access. Now i have to Install...

Thanks spikepl... the join query i am using is ("SELECT A.Job_no, A.Cmp_ID, A.cmp_op_id, A.Group_Code, A.Complaint_type, A.Tech_ID, A.Warranty_Req,A.lab_cost, A.Mask, A.Tech_tab, " _ & " B.lab_hr FROM Cmp_list A left join " & [TempVars]![modelcode] & " B on A.cmp_op_id = B.op_id " _ & "WHERE...

hi, I m having a subform in datasheet view. whn i use a join query as the record source for the sub form, i am not able to add or update any record in the datasheet. Is there anyway to use a linked query as record source of the datasheet with editable property.

Thanks eugin for your response. As i have mentioned, i am using tempvars not in code(VBA) but in query design mode of access and i have given try with all the suggested method from your link.none seems to be working.. I am getting an error message : "syntax error in from clause" since the...

Hi, In my application, table for a query is choosen based on the user input.I have declared the user input as Tempvars.I want to know how to use the variable in query design(not using VBA).