Search results

AWESOME!!! HAPPY NEW YEARS TO YOU FRIENDS! That is good to know. I am one happy camper right now. OK, worked great this is a closed case. Now that I am starting to play with some VB I may use the modules a lot more. This could become VERY helpful. Thank you so much guys!

OK WOW that was EXCITING!!! OK, I have never once used a Module but here is what I did. Please let me know if it was right I copied my VB script from the Form. I then deleted the form completely. I then opened a module & Pasted the script. Made a few changes. I then created a macro...

OK maybe I doing too much then. query - list all orders placed today form - nice way to view the orders I click the button, a VB script I found online will then email each client their info. I then close the form and then close the database. I do this at the end of the day. I am...

I have a form that opens when the database is opened. There is a button called "btn_GO" Right now I open the database and the form will open. I then manually click the button. It does everything it needs to. I then close the DB. Can I tell the form to click the button for me after it opens...

This worked. Once I added 4 ys for the year the Date() function worked.

Data type mismatch in criteria expression

OK so if I want this for today, could I do this? Format([RecordDate],"m/d/yy")="Date()"

I do not understand. So if my field name is [RecordDate] which function would I use to show all records entered today with no time stamp?

I tried =Format(Date()) with no luck. This will only show records that have no time stamp at all. The recrods with time stamps will not show with this.

I have a field in my database called [RecordDate] which is a date & time stamp. In my query I have ">Date() Or Date()" to find all tests from today. Q1.) Is there a better way to write this? Q1.) I want to remove the time stamp from the result for this query. I need to total a column and...

thank you rainman. I will check it out & check back if I get stuck. THANK YOU again.

In my system it shows when my users lon in with a date/time stamp. examples: "12/9/2008 9:00:27 AM" "12/9/2008 8:50:58 AM" "12/9/2008 8:48:35 AM" ect... I want to write a query which will give me a count by day then hour. I want the query recordset to show me something like this: 12/9/2008...

Access 2000. Here is my VB thus far. Option Compare Database Private Sub cmdBUTTON_Click() Dim sSubject As String Dim stMail As String Dim sDocName As String sDocName = "rep_CLIENTS" 'message subject sSubject = "Here is your bill. Thank you. dated " & Date stMail = DLookup("[ClientEmail]"...

I have a form with a subform. When my user types in a bar code in the search form the subform will then show the result. My user then has to go down into the subform and check a box [Rcvd] and then add todays date into [Rcvd_Date]. Then they go back to the main form and search again. I want to...

Gotcha... it is working PERFECT!!! Thank you again Bob. Once again you save the day. A modern day superhero of sorts you are.

I am running an Access 2000 DB. It looks as if that Wizzard is not an option for me?

I am trying to set up a macro to export a txt file so I am using the TransferText command inside a macro. All is setup and working fine. My question is this: Is there a way to change the default symbol used to separate the columns per record? Right now the database will use a comma to...

DC Thank you. I looked at this last night and it is over my head because I am not good with VB, however I do know enough to get it to work with my db. THANK YOU for the demo, very cool stuff.

[CheckID] [ImageLink: "C:\Images\"+[CheckID]+".tif"] These are two fields form my query. [CheckID] is a unique number tracked in my table for each client. I have a form that I type a CheckID into and data will display AND a scanned tif image will load on the form based on the [ImageLink] for...

I have a big access database (300 MB, main table has 500,000 records) that needs to be switched over to SQL but I have no idea how to do this. 1.) Is there any great books or pdfs out there with step by step info? 2.) I want my backend to be SQL and my front-end to stay Access. Will any of...