Search results

Just wondered if anyone has noticed that when sending a report directly to WINFAX it does not appear to show any check boxes? Or is there a setting that I have not taken into consideration? This could lead to considerable problems should a questionnaire be required to be faxed to someone. BTW...

Many thanks fizzio Again your knowledge has been excellent. Hope to chat weith you again soon.

Solution Your solution is great although to put the cherry on the cake it would be nice to have the form only pop up if there is any data within the query.... any ideas? Thus not bringing up a form that has blank entries. Great work. Regards Adrian

A little tricky The DB does not run 24/7 so I would like the message box to appear at start up of the DB as well as when entering the Project form (continuous forms containing projects) . The tricky thing is that the message box would have to decribe exactly which project is due for checking...

Here's a question that may require some VB. I'm currently reading ACCESS 2002 VBA (ISBN 1-86100-821-X) and its a steep learning curve at the moment. My situation is this, within the DB many manufacturing projects are currently created and a delivery date specified. Basically is there a way of...

Finally It worked like a charm. Thanks Fizzio. This should come in very handy for a LAN coms tool. Regards Adrian

Dcount The ID is an autonumber value in the job history table. As soon as somebody creates a new note then the number increases thus dcount detecting this and adding 1 to Me.Job_Notes. As far as I could see it the only way to maximize access from the taskbar upon a new note being written was...

50000 no the timer interval is set to 50000 for thirty seconds. Should this matter? The statement and fields are updated upon the timer execution.

New code still not working I tried the requery and it's still doesn't maximize. I have slightly modified the code below but I still cannot see why access isn't maximizing. Public Sub Form_Timer() AutoRefresh Me.txtHiddenCount = DCount("[Product ID]", "Products") Me.Suppliers =...

I'm trying to create this Dcount procedure to maximize access from the task bar should a new note become present in the job history table. It looks to me that if the ID value has increased then this should in theory bring up the page. The timer event is set to thirty seconds. With this code...

No offence intended I have notes your comment and putting them in place. It was a most ingenious solution. Although it is nice to hear other opinions on potential solutions. Thanks for your help Pat.

Getting there... Hello again readers and helpers, I just thought I would explain a little further as to my ensuing challenge against the dreaded skating user intent on traversing just about every record with his / her mouse wheel or page up / down. Lets face it; it's a pain in the neck. I...

I have re-assesed this situation Thanks for the help people. In terms of referential integrity all cascading has been implemented. I do not have a problem with this area as far as deleting the orders. My main problem now is letting a user modify or delete items within the actual order...

I have used the find unmatched query I have used the find Unmatched Records query wizard and it has successfully identified empty orders. What do you suggest next Rich? Do you have any ideas for the order entry scenario? (as stated above). btw can you recommend a good VBA book? I'm familiar...

Thanks for the help Rich I wondered if you could give me some help with the query? Thos how and where's Unfortunately I cannot give the user deletion rights as this must be set in stone as far as order history is concerned. This is starting to annoy me as I would love some how to allow a...

Purchase Order part 2 This is part 2 to the following posting. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=49702 It appears that having people given this some thought that in order to correct this flaw someone might know of code that could be applied to a button in...

Sub form integrity Sorry for the delay Order_Guts (apologies for the name) is the name of the sub form. It appears from different people that this one will have to be given a lot more thought by myself in order to enforce some kind of standard here. This is not a huge problem at the moment as...

Still having trouble sorry Is the following code correct? Private Sub Command134_Click() If Me![Order_Guts].Form![txtCount] = 0 Then MsgBox "No orders created. Please enter order(s)", vbOKOnly, "Error" Exit Sub Else DoCmd.Close End If Exit_Command86_Click: Exit Sub Err_Command86_Click...

Forgive my ignorance I'm not quite on the ball when it comes to VB Could you please peruse my code for the exit button below and tell me what I have done wrong. At the moment upon pressing the exit button it gives me the error "compile error invalid use of property"...

Hoping someone could help me with a simple or not so simple problem here. I have a purchase order form that using a form has the top half populated with the order details such as ORDER ID (using a table named ORDERS) , Date, time etc and in a sub form I have the order details derived from a...