Recent content by jdcallejas

Hello, you have giving me this code to add EmpID on the Not in List event to add the EmpID if it was a new EmpID. This is working great. Private Sub EmpID_NotInList(NewData As String, Response As Integer) CurrentDb.Execute "insert into [tblEmployees] ([EmpBarcode]) select '" & NewData & "'"...

My database is really something simple. I just need to scan personal that come through a buffet line. That's it. This is for employees that come get lunch thought the buffet line, this is paid by the company. So I have everything working, is a three table database, tblEmployees...

How can I change that msg to a custom msg and after clicking ok on the msgbox field goes blank...

Hello Arnelgp, I have a question, I have the subinvoice table working great, the new records are being added automatically into the employee table. Now i have another task. I have made the empID on the subform No Duplicates, So now when I try to input the same employee I get the error msg...

Here is the way I have it to get each ingredient cost for that plate Here is the formula working. What I need to get its the total of numbers on the right hand side of the subform...

Thank you, Ok, this is what's going on. The ProdQuant and the AverageCost are not calculated fields on the subform. So for me to get the Ingredient cost I multiply AverageCost by ProdQuant. I do this in an unbound field on the subform detail and I get each ingredient cost for that plate. Where...

Hello, I have a form called menu, here I create menu plates like Roast beef example. Roast beef is served with rice, bean, etc. When I create the menu, I add each ingredient that the plates use on a subform. When I pull the product ingredient it brings with it the average cost of the product...

This is exactly what I needed!!!! Thank you!!!

Thank you!!!! Thats what I didnt remember... Hello again, Can you help me with the code. I want to use the not in list event but I just want it to add new item without any questions. Let me explain, The company company serves breakfast, lunch and dinner to about 800 employees. They come...

Its been a long time since I have worked on access, I am making a simple invoice database for my own use. Back in the day I remember that there was a code to add new item when selecting from combo box if item didn't exist. I have been looking for this but cant find that code. So if I have open...

Hello, I am creating a small database to keep track of invoices and payments for my small Internet Service Providing business. I now got into something that I need some help from you. I have created invoices, products, clients, and one I call payments. I want to be able to create a code that...

Thank you, I decided to just go find another forum, looks like this forum is focus more in criticizing how we ask for help then helping us out. Have a great day.

Hello, I have created a database and for some reason I can’t run it on my network. I have splitted the database, I have the BE on a server and each pc has its own FE, forms, query and reports. When I link the tables I LINK all the tables, I am able to see the records, go to next, previous...

Hello, I am having an issue when I make my mde file. Iam using MS 2010, for some reason when I convert to mde, I loose all VB code. Examples like docmd,close, or docmd.open... I notice that all my other bottons that where made by defaut macros work. Why is this happening? What do you think it...

Hello all, hi spikepl, I got my database working, I am not sure what I did, the only thing I can think of is that when I linked the tables this time, I did not select "Always Prompt for new location" and just let the system ask me where... I am having one issue, I have an update query, this...