Search results

Hello, After hunting high and low online i'm not even sure if what i'm trying to do is possible. I would like to select many fields where one field = yes, or select different fields where that field = no. This is used for if a person wants the parcel to go to their home address there is a...

Hey, thank you anyway. I know that they are not structured like that but for a report I need any letters underlined. HMRC for you. Here is an example of over seas ones and I need the letters within the numbers to be underlined. Just like they have. Thought there must be a way I can get access...

I wish to have only the letters within a string of text underlined. Is there an input mask which would be able to do this. e.g. 123ABC456 would be 123ABC456 Many thanks

So I was thinking that the code would be written something like this If Order contains large part, Print Else If Order.OrderLines>5, Print Else add to list until 5 orders selected Then Print Cheers

Hello, I have a list of orders, if the order contains fewer than 5 lines, and doesn't contain a large item (marked in the stock record in a yes/no box), I would like it to group these into 6 orders so I can have 6 orders of 5 lines in a report. If the next order does contain a large item I...

You star, I was looking at properties of the field and not the form. THANKS

Thanks James Thank you for that, it all goes well apart from the LinkMasterFields. I go to the Property Sheet and data section and there isn't anything about link master fields. I'm using Acc2007. Where will I be able to find the master fields properties please. Iain

I have a form in datasheet style as a subform (subOrderForm). As I type in a part number it then completes the next columns with the name, price etc. I have another subform (subPartDetails) that is also within the same main form (customerForm) that contains information (pictures, specification...

=DLookUp("[Sum of Quantity]","[Running Stock 2 Query]"," [Part Number]='"+[Part Number]+"'")

Thank you for your help, I have now got to the stage where it is pulling up the information but there is a problem with the criteria option. It isn't select the data based on the part number. At present it is just returning the first line in the query for all results. My part numbers are made up...

To disable the message I click on Access Options>advanced> and under the confirm it has action queries. Untick this and they stop.

Under the part section there is + where the sub query "Running Stock 2 Query" is run, when the + is clicked then the calc is performed. Before this it doesn't know the full info. Will look up Dlookup.. Cheers

Hello, I have the above message box appear. No problems to get rid of it. The main problem is that when I do it then messes with my code and asks for input data which it collects from various fields. If I turn the message boxes back on then it is able to find the data and continue. Please can...

Firstly, sorry for my tardy reply. Rather busy with the run up to Easter. Please find attached a copy of Hal.zip If you open the "Document" form then this is a form which will be placed within the customer form. At present I have the calculations working when the "Running Stock 2 Query"...

vbaInet, Thank you for your help, I have managed to implement what you have said. Great. But at present it only works once the subform has been expanded on each part. How can I get it to auto lookup. I have thought about trying to get the sub forms to auto expand but to no avail. Thanks

vbaInet thank you for that, I have downloaded the phone.db and I am going to go through it. The main problem I find with searching for these is what to look for and where. Rather than just returning a result from the table / query can I use this to perform the calculation. At present I have 2...

vbaInet, By the looks of it (haven't read through it fully yet) that is exactly what I am trying to do. YOU STAR. Thanks Access Guy for your reply, I have got as far as you gave but got stumped. Cheers

Hello, I have been able to set up a running stock level but I am trying to get it to show it in a datasheet view. So that as I type in a part number for a client it will give me the running total depending on the part number in that row. At present it will give me a big error because it...

Many thanks for the information, very useful. I have been able to set up a running stock level but I am trying to get it to show it in a datasheet view. So that as I type in a part number for a client it will give me the running total depending on the part number in that row. At present it...

Many thanks to the above. I did have it so that it calc the total from currentLevel-stockSold but wanted to avoid it becoming slow. P.S. Like the "How to talk to a programmer" Think I will have it calc as it goes then perhaps at end of week / month to update the main stock file. Thanks