Recent content by Malkim92

Thank you :).

Hey, Sorry i couldnt reply but Ive been a bit busy lately. Well, I am a bit new to Access so where do i put that? I have a table called "MainTable" and the 2 fields are "Day" and "Time". Now do i go to SQL view of the query and enter: SELECT Time, Day FROM MainTable WHERE (Day + Time BETWEEN...

Hey, Basically I have a query that when I open, I need it to show me all the cases entered in that day. Now the shift is between about 6:00PM to 4:00AM. So i want the query to filter all the cases entered on that shift.

Hey, I have a query that has a Date field and a Time field. I need it to filter from 6:00 PM to 4:00AM. of course those are on two different days. any help would be appreciated. Thanks.

The thing is i have searched on google and couldnt find anything similar to my case, but ill search more. Thanks anyway, and if there is any code that you know that is helpful that would be nice.

If what im asking for is not possible then is there a code to select End on the runtime error window so then it would go back to the same box on its own?

Run-time error '-2147352567 (80020009)': The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing Microsoft Office Access from saving the data in the field.

Its not a big deal pr2-eugin, no harm happened :). Im still a noob at this myself, but thanks anyways.

Hello Everyone, I am using a code to check if the name exists in a table and if it does then gives an error message and returns back to same field and empties it out. The form has a field called Customer_Name which is need to check in table tblCustomerInformation. Im using this: Private...

Hey, I have a form called AddNewCustomer which has a field called Customer_Name, now I have a button that opens another button called Command1. The thing is, when i click on that button, i need it to check if Customer_Name is empty and if it is to give an Error, and if it is not null then check...

Thanksfor the help, I followed spikepl's advice and I got it done.

Thank you, I will follow on to your advice.

I do have the Purchase ID, but i need the customer name with the Customer ID. I need that because I'm going to make a search form to find a customer purchase history by ID or by Name incase the person forgot the ID.

Ok basically, i have a two tables; Customer Information and Customer Purchases, and 2 forms based on that. The Customer Information form has 2 fields, Customer Name and Customer ID. The second form has the same fields; Customer Name and Customer ID. What i want to do it that when i open the...

Hello everyone, I'm new to this forum and I'm also new to MS access. Im facing a problem with opening a new form from a form and setting two fields to equal two other fields from the original form. I have Form A which includes FieldA and FieldB, and FormB which includes FieldC and FieldD...