Search results

Ok m8, put your full code in and its works :D as expected Is there any difference in the two codes, no? Your way - intStore = DCount("[WorkorderID]", "[Workorders]", "[StartDate] <= DateAdd('d', 4, Date()) AND [WorkProgress] = 'Awaiting Start'") Mine intStore = DCount("[WorkorderID]"...

Hi again Bob Just to say I managed to get it working, Ended up using it like this intStore = DCount("[WorkorderID]", "[Workorders]", "[StartDate] <=DATE()+4 AND [WorkProgress] = 'Awaiting Start'") Did a test and seems to be working perfect now, only picks up records within 4 days and with...

Hiya Bob I copied your new code like this intStore = DCount("[WorkorderID]", "[Workorders]", "[StartDate] <= DateAdd("d", 4, Date()) AND [WorkProgress] = 'Awaiting Start'") and its all highlighted in red in vba, If I try and run it, I get Syntax Error, When I added it in at first it gave...

Will the vba not need changed to - "[StartDate] <=Date()+4 AND [WorkProgress]") ________ Chrysler Royal Specifications

Hiya guys, cheers for the reply The reminder should pick up a date 4 days from the date in StartDate So - "[StartDate] <=Now()+4 the other bit I didn't see was there, that part should pickup a part of the Workorder form - WorkProgress which is a Combo box with the following Awaiting Start...

Hiya I have a popup reminder on my form splash screen that should only display if there are any work orders with "Awaiting Start" in the related tables, here is the code Private Sub Form_Load() Dim intStore As Integer intStore = DCount("[WorkorderID]", "[Workorders]", "[StartDate]...

ok cheers guys I did give it a go and got it working but I have about 15 forms and was going to create a help file for using them, decided in the end a simple PDF file on cd will do :D Much easier lol Thanks anyway tho ________ SHIP SALE

Hiya guys I've got a popup reminder that starts on my home screen when I start access. It should popup a msg telling how many new jobs are starting, however, I can only seem to get it popping up on the day the job starts, I need at least 2 days notice Here is the code Option Compare Database...

Its ok, I found a bit of code in there that should'nt have been there.. Everythings working gr8 Is that the way you would have done it for the JobCompleted? That way any date that is added in Completed will change the Combo ________ VAPIR AIR ONE 5.0 REVIEWS

Hiya Cheers for the reply I managed to get it working I had to do it this way, Private Sub Form_Current() If Me.[StartDate] = Date Then Me.[WorkProgress] = "Work In Progress" End If If Me.[EndDate] = [EndDate] Then Me.[WorkProgress] = "Job Complete" End If End Sub Seems to work...

Hiya m8 Works a treat, I don't use Now() for that field, I just use the Date() I change the date for todays dat and it worked perfectly, but will this still function after the date? Obvisouly when the job is complete I would enter the Date Completed and I would intend on using the code you...

Hiya I have a combo box on my form called "WorkProgress" it has the following within :- Awaiting Start, Job Complete, Work in Progress" Default value is set to Awaiting Start I also have these filelds JobCreationDate - (Date the Record was made) JobStartDate - (Date the work should Start)...

Hiya guys My Dbase is almost ready now for Distribution, but just a question... Is there a simple way to update this Dbase? The current version is 1, lets say there was a simple spelling mistake or something and the customer asked me to change it... Apart from giving him a whole new version...

Hiya Guys Anyone have any ideas for building Help Page System to go with a DBase? I think it would have to be called in by a button on the Menu Bar tho, can't seem to get anything going using F1 Sure there was a sample on here for a help system but can't find it anywhere ________ 3 Series (E30)

Hiya guys Is there any way to change the F keys in access? I've built my own help pages to go with my DB I was wondering if I can assign this using Macro? What I have the now is - Macro Save Name - Autokey Macro Name (Colum) {F1} OpenForm Help But that doesn't seem to work for me I've...

ok m8, fair comment, just an idea thats all. I'll give it up lol :D I had a look at the code you did for Serial Verification.. Looks good, would've been a good way for me to go. Maybe in a few months.. I did have a Hosting site but I closed it down about 3 months ago, otherwise I would've done...

The way its supposed to work is, When you log into the Dbase, enter you Username, Password.. This is timestamped and is saved.. The report will be email on Exit to me, then I can see who is using my Dbase, how long for.. Everything works fine in theory I have the Dbase sending me the report...

So if they don't use OutLook express or Outlook, what would I expect to see if that button was clicked? ________ Side effects from prilosec

Hiya Cheers for the reply m8 I managed to find this little code DoCmd.SendObject _ , _ , _ , _ "ToJohn@doe.com", _ , _ , _ "Subject", _ "Message", _ False If I leave the last part as False, it doesn't open Outlook ,but adds the email straight to the...

Hiya guys Is there a way you can track who is using your Dbase? My Dbase will be sent out to various Roofing Companys in Scotland, and I would like to know who is using it, when its getting used and how long for? Is there any ideas on this? Its standard Accde file, doesn't connect to a...