Search results

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...

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...

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...

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 Everyone, Hope all is good with you. I have not been here in a little while and I need your help. I am building a database and so far it works great. The problem I am having is that it only works well when the database it’s a full database, meaning tables are within the program, not...

Hello, I created a DB on access and for some reason when I want to write an event procedure and start typing the code it automaticaly goes back and puts the code in red... Example if I type IF and click on space it goes back to IF and If turns red... It does this with anything I type.. Whats...

Hello, I have created a code that will automatically send an email from access using sendobject. The code runs fine but I noticed that if outlook is not open outlook will save the email in the outbox until outlook is open. Is there anyway that I fix this issue? thanks, Dani

Hello, I am trying to send an email using sendobject the code works fine. The problem I am having is that when I set the Edit Messege to flase outlook always brings up a warning saying : A program is trying to autmaticaly senb an email on your behalf. Do you want to allow this? I am using...

Hello, Ok I have a form timer where I set the timer event to send an email of a report every morning at 1145am. This works fine. Now I need to make this code do the following; I need to have this report sent on the 10th of each month. How can I do that? Here is the code that I have right...

I have a make a table query, I dont want it to ask me that its going to delete the older table and creat the new one, I just want it to do it!!! Offcoarse the MS Team as always make in things harder for users, gives this solution that does not work!!!! If your intention is to create or...

Hello, I have been here before almost a year ago and I am still having an issue on how to apply payments to my invoices.... Ok I have created an application for my apartment complex, I am very advance on it. We are able to create leases for our tenants and make maintenance workorders create...

Hello, I have a YES/NO control on my form. Its working great the only problem is that I have it as a dropdown box. I set the control row source to YES;NO and the Row Source Type to Value list. The problem is that it will only show this when you select the answer, once its picked it turns to -1...

Hello, I am trying to update a field and I am having a hard time doing it. I have two tables, tblInvoices and tblPmtDetails. I need to update the field InvPmt on the Invoices with the Sum amount of payments in tblPmtDetails "Field name AmountPmt" for that specific Invoice. I have this done...

Hello, I have created a dlookup field on a form and a calculated field that calculates the number on the lookup *2. Now when I first open the form on data entry there is no record selected so I get en error on the fields. This is because there is no data yet. So how can I get rid of the error...

Hello, I am going crazy trying to set some bookmarks on word_07 to get some data in there from access. Pat had giving me a sample database with the bookmark example. I was able to make it work with the lease we were using.. Now Management changed the whole lease again!!! I have tried to make...

Hello, I have an issue with my DB. I created a form from different tables. Lets say I have a Client Table, Invoice Table, InvDetail Table and a Product Table. Relationships are; One to Many from Client to Invoice, Many to Many from Invoice to invoice Detail, Many to Many from Invoice...

Hello, Any business programmers out here?!!! Need a code for an access application am doing, is anyone interested? Please contact me at jdcallejas(at)hotmial.com.... Its not a hard code I just dont know much code and want to finish this project.. this is all i got left.. Thank you all!!1...

Hello, I am designing a database on MS Office 07, I am doing the forms but when I go to View the form it opens the form but it opens the whole page!! and cant resize it to be the size of the form I made.. In 2003 this can be done I guess there is a way in 2007!!! Thanks, Daniboy

Hello Everyone, Ok, this is going to be long, I am going to try to explain what I want to do, here it goes; I have a table invoices and a table payments, what I want to do is somehow take the payment amount of client and if the payment amount is larger than the client invoice amount, update...