Recent content by wakamoe

Hello all, I current have a form (form1). On this form, there is 3 subforms all taking information from different tables. child1 - table1 child2 - table2 child3 - table3 All of the tables have the same information. The reason why 3 different tables and subform are being used is because the...

Amazing! Thank you so much! Manage to get it working, there were some typos that confused me a bit but after changing it, it works wonders. One last thing, do you know how I can limit the value keyed into the text field (for the amount of records to be changed) based on the "Customer Order"...

Wow, thank you very much for the reply. Your code is a lot more streamline and easier to understand. However, there seems to be a problem with the code. "Set db = CurrentDb" has a type mismatch error. I tried to swap it to RST1 or deleting it, then the next line" Set rs1 =...

Thank you for the reply. I changed the the declaration for String and also edited the setting for RS1. How should I make it so that the value keyed into the text box will not be more than the records for the Item number/Customer order? Also, After editing, I am having an error "Objects...

Hello all, I am trying to create a form that will look for entries in a table and edit them. I will try my best to explain everything so it will be easier to understand. The goal of the form is to allow the user to add Week and Year into entries in a table that does not have values in those...

Hello everyone, I managed to do the base of the form (combo boxes works now) but I am still unable to insert new values into the table (edit). Currently there is two tables, [table1] with all the individual information of each item and [final_table] that uses the same information as the first...

Hello, Thank you for your reply but I am quite lost... When making the customer order combo box hold the customer ID, do I go row source, click on the table and only place customer id (from table) into the query? Also, where should I place the code "Select * from final_table where...

Hello everyone, I am currently trying to create a form that would help me add week number and year into entries. I am not so sure how to go about doing this and dont know how to start. The form consist of 2 tables, a query and a form. Table 1: shows all orders individually Table 2: orders...

Awesome! thank you very much for solving the NULL issue and even doing up the solution for the from-to. :):)

Thank you very much for the reply. I should have elaborated on the problem. I am still not able to leave a blank in the text box. When a textbox is left blank, an error appeared saying that there is an error in the update statement. As for the from-to update query. I will try to find a...

Hi! I went about adding in the "NULL" so that it will allow me to leave the textbox blank but it still does not work. Do you have any idea why? Option Compare Database Private Sub updatebutton_Click() CurrentDb.Execute ("UPDATE [table1] " _ & "SET [checkin_time]=" & Nz(Me.[control1], Null)...

Yea... haha, thank you once again for your help. This is a mock up. I am trying to get it to work before moving it to another database where all the names would be changed.

Thank you so much! It works fine for the most part expect for 1 problem. I am not allowed to leave a blank in one of the text boxes. Do you have any idea how we can overcome this issue? EDIT: This is the current code with all the subject changed Private Sub updatebutton_Click()...

Hello yall, I have an idea for a form. However being new to VBA coding, I have not idea how to proceed. I want to create a form to allow me to change multiple fields of multiple entries as once. However, only those entries that is checked on the form will be changed. After the entries are...

Hello everyone, I am currently not at work so I do not have the exact database but I happen to have a screenshot that I took a few days back when I was starting the project. The form is intended to be user friendly to people that has never used Access. The point of the form is to allow the...