Search results

the data that i'm trying to hide from the user will be a choice of about three products. I have just never filtered a query before.

Okay... I have a query to display relevant data for a user..i am displaying a field called 'product'. The problem is that i do want all of these products displayed...apart from one! Is there a way i can filter the query so that it will hide a field if the value is a variable i have...

Brilliant, worked like a dream...thanks autoeng!!! Sarah

Hi am slightly confused as to why this keeps happening, and wondered if anyone else has experienced a similar problem??? Whenever I make e.g a record in my orders form, if I was to open a query which displayed fields I have just added to or edited (via a button on that form) I find the query...

You are right....i've decided to use a query!!! thanks all!!..

Hi rollerz....have been trying to send you a database all morning..but i've got limits on file attactchments all over the show...so i'll try and help first!! (am novice myself...but have been where you are a few months ago!) * n.b Firstly your form should be linked to your orders table!!! as you...

okay..i'm not very good at coding....i'm trying to copy some fields in a form to a table. Can i use the code for forms e.g. Private Sub Purchase_Orders_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "PurchaseOrder" ' DoCmd.OpenForm stDocName...

Basically i need it ...as it will be the table that is opened when a user rings our office needing to work out which license belongs to which location ...the users visual recognition between hundreds of records is needed!! This is not my choice..i know its not logical. It is a one-to-one...

I've got a similar kinda thing..... Do you have any additional details to an order...apart from just the products being sold?? E.g i have a order form holding customer information, within this there is a subform 'order_Details'...this has a drop down list of products. I total them at the...

Unfortunatley it isn't actually possible to have coloured buttons in access however.... if you do a search, i remember a good posting by rich to show examples of how to make your buttons 'appear' coloured.

Okay..got a really strange problem…(or I’ve just been completely dumb!) I have a form with order details such as customer name, address etc. Within this form I have a subform…this includes details such as products , price etc. The problem is that each detail (line in the subform for each...

Hi thank you for replying. I'm not really sure of how to implement all of that!! apend query? where would the query be activated...? on click? the problem would then be..if there was a problem with a invoice, and it had to be re-printed...then it would have two numbers!? someone suggested...

Hi sparker I ahev got exactly the same problem, and have been trying to resolve it for overa month...someone else has found my problem on another forum and asked this same question If you have any solutions please let me know!!! I had quite a lot of help from col (colinessex) but i now...

thank you so so so so much!!!! You and Ally have both been great ..thank you so much Chocalates all the way!!! You really have helped me (and my job) so much..your both brilliant!! :D :D :D

So close Col...so close!!!! I used this ...at first all appeared to work as hoped!!!! i typed in a number and when i 'printed invoice' the number incremented!!!! (was so chuffed!!!) then.....i did the same for the next record...and all i got was 1...and the next.... It must be that unless i...

Hi Col, the report is called an 'invoice' it is produced in connection to three other reports ...they all display similar data, and take details from the same form. Yet they have slightly different calculations etc. The invoice needs a separate number for analysis reasons! You are completely...

thank you soooo much...problem solved Your a star Sarah :D

Hi col, that is exactly what i need...each number increasing by one When i say opens on preview...this has to be the case....the user has decided they'd rather preview the report then print it...rather than print it immediatly!!! But i am presuming that all reports previewed will be printed...

Okay, have the following very novice question!!!... have a label attached to a text box on my report….I’m trying to work out the code..so that if the textbox is null, then the label will be invisible!!! I’ve used the following code: Me.RenewalDate.Visible=Not IsNull(Me.RenewalDate) The...

So Stuck..PLEASE help!!!!!!! hi i've posted this problem before...but haven't had a response i can use yet!! The problem is sequence numbering of a report, every time a report is previewed i need a number to be generated. i know this number needs ot be generated on the 'on click' command, but...