Search results

One more question !!! One more before the weekend!!! in code how do I tell it to open a switchboard EX: If txtPassword = "55" then "Open switchboard" else msgBox "no good"

Thank you I just need it for simple useage on a database, thanks a lot!! DaniBoy

Hello, I have a table that links to the Employees table called "SecurityPassword". In this table I can pick an employee from the Employee table and set a username and password for that employee. I have a button on my switchboard that opens up a form that I created. This form has 2 unbound fields...

Thank you ! Thank you for the input!! Dave, I will let you know about the book as soon as I get it. What cought my attention about this book is that I saw that they actualy go into each event procedure and tell you what each event is used for. Also it has examples of codes and what they do...

Thanks Let me see if I can acomplish that!!! :) DaniBoy

This is how I tell it to see if the Report has no Data!!!! Report Event On No Data: Private Sub Report_NoData(Cancel As Integer) MsgBox "There are no Reports at this Time", , "AM Yard Waste Tracker", , , Cancel Cancel = True End Sub I dont know how to do the Following: " In an...

I guess noone has taken the course !!! I just bought a book called: Alison Balter's Mastering Microsoft Access 2000 Development Looks realy good, anyone got it? any comments? DaniBoy

Hey guys and gals, I am thinking about taking the Introduction to Programming VBA Access course on this forum. Has anyone taken this course? I think I know enough VB to do simple If Statements, Do loops, options, check boxes ect. What I dont know is stuff about records, "programming...

Thank you so much!! Will Try it. DaniBoy

Is this understandable? Has anyone tried it on a form? Thanks DaniBoy

Hello, Ok, I got the email thing to work, its now sending the report once every 24 hrs!!! yyeeeaaahhhh!!! BUT, jeje!!! I got another task to do: I have the report to cancel if there in no data and the sendobject never sends an email, I want it to actualy send an email saying that there is no...

Pat is right!! awlways right!!:) Dan, Start by starting all over again, I know this sounds realy bad, believe me!! I have done it!! Ask your self this questions: What do I want the Database to do? Ex: I want to keep records of patients treatments, ect. What are my enteties on my...

Little Confused!! What data is in your Main Table? and What data is in your Person Table? Are the Main Table and Person Table related in any way? When you say "transfer" the codes, do you mean type in the codes on text fields or are you importing the codes? "On my form I want to select a...

Thanks Thank you Pat, Its now working. DaniBoy

Hello!!, First of all!!!! Congrats to Kelly Clarkson, great girl!!! I am having problems trying to send an email. This is what is happening. I made it so the timer sends the email automaticly. Well, when I put this code: DoCmd.SendObject acSendReport, "AM Email Tracker Report" It...

I'm trying to have the application send an email every day at 12:55 am and 4:50 pm. I wanted to do this by just having the application open instead of the form. This way the user can continue working on the other data entry forms and the email would be sent automaticaly. If this cant be, I...

It Works Great!!! Now, I need to... I there any other way other than a form to make the "On Timer" event work? What I want to do is to make the "On Timer" code run without having the form open. Maybe put it on a autoexec that starts running the code when I open the database. Any ideas on how I...

Thank you so much!! I will try that and test it, thank you for responding so fast!! DaniBoy

It Works Great!!! Now, I need to... Thanks for the help!!, I replaced the msgbox with the code to send a report via email and it works good. Now I need to know if the following is posible. Can I make it so the email program DOES NOT appear or open up when the email needs to be sent? Can it...

Hello, well am still trying to get this "on timer: code to work, I have tried two ways :!! #1) I used this code: Private Sub Form_Timer() If Format(Time(), "hh nn ss") = "03,05,00" Then MsgBox "It Works!!!" End If End Sub I dont know if the format is bad!! But it does nothing #2) Private...