Search results

Is not Working!!! Whats wrong?!!! Hello, I tried the on timer event and its not working!!!! this is the code Private Sub Form_Timer() If Timer > TimeSerial(12, 13, 0) Then MsgBox "Its Working" End If Me.Timer = 0 End Sub I set the timer interval to 5000 like the other thread says, and then...

Hello ladies and gents, I just need to know if it is possible to make a code or someting that sends a report by email in a certian time? I asked before and searched on the forum, but other similar question had no answer, so I just would like to know if some one knows if it can or can not be...

Would this Work? I actualy did this to the regular code: Private Sub Command67_Click() On Error GoTo Err_Command67_Click Command67.ForeColor = vbRed Dim stDocName As String Dim stDocName1 As String Dim Mytime Mytime = #11:55:00 AM# stDocName = "AM Email Tracker...

Hello everyone, I have looked and cant find anything where someone helped someone with the same thing I want. Is it possible or not? I want to send an email of a report "I can do that", but I want to automate this email so that it will always be sent at the same time automaticly. I think...

Hello, I dont know why this is happening, I have a subform that has 4 fields, I want to set the focus on field three, this is what I do: On field 1 I enter a value, on field 2 I enetr another value, on field three I want to skip, and field for I enter another value. On the event On...

Nevermind!!! I got IT but need help on.. Hey I got it, I put a third field that gives me the sum!! but is an unbound field how do I put that data into my bound field? Thanks DaniBoy

Hello guys, I am trying to make an iif statement that will give me a result of a sum depending on the criteria: I have a fieild on my products table that gives me the total units per package example: 24 units per box. and I have a total units bought. Now, what I did in my subform was to...

Hello, One more thing and am done with this program!!! Ok, I am making a little program that takes invoices and orders, I also add it a Expenses. This is just a simple application, people buy on credit, and pay every to weeks. Ok everything works great, but now I want to make a report that...

Hello Everyone, I have a query where three og the flieds are expressions. Expression #3 is made up from Expression #1 and #2, when I put a criteria on the Expression #3, I get a parameter to fill in Expression#1. I know that if I make another query from this query it will work, but how do I...

No appolagies No need to appolagize, I welcome every help I can get!! Maybe someday I'll me the one helping people just like you guys do!!! Its tough enough to have to deal with a frustrated individual like me!!jeje You guys are the best of the best!!! yyyeeehhhaaaaa!!!! it works Braddd...

Hello, I have a problem with Dlookup, I am triying to bring in a value to my Clients form from a table called "Abonos", the field that I need is "AboCantidad" and I need it to be the same "ClienteID" that I am viewing on the form. I have tried all kinds of ways to do it but it does not work...

Thank you very much!!!!!:) Thanks o lot, I have been doing it the other way for a long time and always I had to go back and change or add another field on the table, I am going to strat doing it like you do, I am glad to cleared that up with your explanation. So this way I actualy do one report...

Hello Its me again!!!:o I took an Access Database Class like 3 years ago, from what I remember we had to first Desing the database on paper. Now, the way we did it was finding out what the client need it and then writting down all fields that they would use, from there we decided what...

Hola Maria Maria Estoy haciendo un programita para un supermercadito en Nicaragua. Tengo todo listo menos una cosita que nose como hecerlo. Me gustaria mandarte en programa para que lo mires y si es posible llamarte por telefono o si podes meterte en MSN Messenger para explicarte bien que...

Need some help with a spanish database. Thanks DaniBoy

How Can I Do it Via Queries I had tried doing it via queries, but I cant seem to get it to work. this is what I did: 1) I first created a querie that gives me a detail of all the products the client bought. I have the "ClientID" and "DetailInvoiceID" and the "Quantity Field" and the...

Hello, I have a big problem!! I have a database that keeps track of invoices and payments recieved for the invoices. "Invoice" First of all I have a calculated field "Total" on my invoice form that is the sum of all items on the invoice detail subform. This field is an unbound and so the value...

Thanks I'll try it Thanks Travis, Now will this wrok the same for a report? I guess you now what am trying to do!! Its like a Balance Sheet to be able to get the Gross Income and the Net Income. I will Subtract The Total Expenses from the Total Profit. Thanks DaniBoy

Hello, I have a table database for a small store. these are some of the tables in it: Products Invoice InvoiceDetail Orders "from suppliers" OrderDetails Expenses "Its actualy in spanish" From this tables I can get queries that give me the AvgCost of the product and the sale price of the...

Thanks Pat I did the lookup but I still get the name error!! I put the code on the afterupdate event right? and the code should look like what? maybe am doing it wrong!! Thanks DaniBoy