Recent content by Hisoka

Thanks @June7 you're a lifesaver, its work like a charm :D .. Thanks @Edgar_ I will try it

Hello, I have this code to open a conversation with customers on WhatsApp through the WhatsApp application, CreateObject("Shell.Application").Open "https://wa.me/" & Me.tbMobNum & "/?text=" & Me.tbWaMessage As you can see, I have the customer's number in the TextBox, But the number format in...

I get it @Pat Hartman, Thanks for the clarification. Regarding the separating of tables, it is not a matter of my preference, I just wanted to create an database according to standard rules and Now I and understand and convinced that my method was wrong.. You are right if we have more than one...

Your words are very logical, Thank you, But in my case I prefer to separate the order from the Details(Status) of the order (for example, was it shipped or not, was it delivered or not, the date it was delivered to the customer, etc.)

Hello, I have a database that includes the following tables: Table 1: Customers (CustomerID, FirstName, LastName, Number) The primary key is CustomerID Table 2: Orders (OrderID, CustomerID, TheProduct, Quantity, OrderDate) The primary key is OrderID Table 3: OrdersDetails (OrderID...

When I created a query, the program by default created a relationship between my two tables In Query DesignView, But when I opened the relationships from Database Tools > Relationships, I did not actually find this relationship and it does not exist in the tables either. When I delete this...

Thank you, @Ranman256, Unfortunately, I did not know how to modify the code to suit my request. I will try it again. Thank you, @MajP, Very nice idea. Combobox solve the problem. Thanks for the help..

Hello, I have these two tables and this form, I want that if I write the name of an already existing customer, That is, the program will bring his record to the main form (his ID & Number...etc) to be able to modify his order in subform without having to search for the customer through the...

I get it, Thanks @Pat Hartman to point it out..

Sorry guys, it was my mistake. I was trying to write the code from the Zoom interface 😓, But when i research on this topic, I noticed that the code had to be written using Code Builder... Thank you so much, @pbaldy you are a lifesaver, and thank you @jdraw for participating..

I modified it and put it before update, but the same message appeared :cry:,, Frankly, I don't know how to use the code. Should I create a macro first for this code and then put it in before update or what? Sorry for disturbing you

Thanks,, But it didn't work for some reason. When I wrote this code in before update If Len(Me.MobileNumber & Requests) = 0 Then MsgBox "You need to fill out SomeControl" Cancel = True Me.MobileNumber.SetFocus End If Then After opening the form and trying to save it without filling the...

Hello, I have two text boxes, one called "MobileNumber" and the other called "Requests". What command should I type in "Before Update" Event to prevent the Access from saving the record until they are filled together? Thank you in advance..

Thanks @Eugene-LS You are life saver :D... I liked the idea very much, But I did not know how to create a new records, As when I try to create a new record, Nothing appears on the subform (Customer & Order). In my case, it must appear so that I can fill the Customer number and Order to save...

Thanks for the advices and clarification, I will try to using sub forms to solve this problem as "Eugene-LS" suggested