Search results

Hi everyone. Sorry for delayed answer. Yeah all of you have right, I think to complicated. I have created two records DateOrder and DateOrderShiped. That works fine with the query. Can you help me to automate process a bit having automation on the field DateOrder to save Now date to my Table. I...

Hi Everyone, I am a beginner in access but trying hard and learning every day. Could you please help with my problem to view record from another table in unbound txt box on a form. I have two tables Reg and Gender. My table Gender has two columns where one is Gender (e.g. Male) and second column...

Hello. How to write sql Insert statement to insert current record displayed on the form with cmd button. Records in the Customer table are ID_Number, Name and Surname. I need to insert ID_Number, Name and Surname in the Customer_List table. Thank you.

Thank you for your answer. You are correct. Will try another solution. Thanks

Hi there, I have Combo box on a main form Registration where user select gender from drop down menu. Combo box pulls data from a table Gender (Male, Female, Child Male and Child Female), In that table I have a second column with Gender abbreviation (M, F, C/M and C/F). in the second form FL_form...

Hi thank YOU for the answers I have internet shop and warehouse with 15000 products. According to my contract with shipping company I have to pay extra fees after 48 hours if I don’t sheep the products. My employees are careless some time and need to follow up these items. Order receive date is...

I have some items which will expire in 48 hours and want to query whole list to know which one is expired. It is easy to have checkbox results in the query.

Hi everybody, Can you help me with some solution to uncheck checkbox after 48 hour pass. Will have date/time data field next to the checkbox where I will put desired date and time. Please help with this issue because I am not that experienced in VB source code. Thank you.

Thank you Bandylank, You hit the point, but I have already the form as you suggested. I wanted to create command button for the current record which will open query to ask which DNA LAB Code to assign current CY-Code. I forgot to mention that the CY-Code for the current record is in the GENETIC...

Hello, I have two tables, one is GENETIC and the other one is BoneSampleDNAprofile. Both tables have the field CY-Code. I want to create small form with 2 text box fields and one command button on the form to be able to insert CY-Code from the table GENETIC to designated DNA_LAB_Code in the...

Hello, I am new in acces world and will appreciate help from the experts. I have created a form where is ID (e.g. CY_1000) set as the primary key in the 1st table. I would like to copy that ID, who is also set as the primary key, to another table for the current ID (e.g. CY_1000) opened in the...

Thanks David I have created new field in the second table which is empty now. That field has the same name as the field in table GENETIC. I'll try tomorrow at work and let you know. Thanks again.

They are not linked right now. In the form I have sub form with DNA sample code. To be able to link certain code to the specific DNA profile need to populate DNA samples table with CY-Code who represent missing person. Checkbox is called "Identified". Then this two tables will be linked to each...

Hello everyone, I've created checkbox in one form and would like to copy/populate data from one field to specific field in another table, to be able to link these two tables. The field name is CY-Code (e.g. CY-1000) from table "GENETIC" want to copy to "DNA samples" table, field name is the same...