Search results

Its nearly working, but using the Max on the date is giving me the last date the units were in Harlow whether they have been shipped or not. If I remove "Harlow" from the filter I get all the latest dates for all locations.

Hi, I would like to create a query in which I recall data from 2 tables in completely separate databases. Firstly, we have my database that manages the 'test status' of various units in manufacturing, all of which have unique serial numbers that go through different test stages. Every time the...

I guess Access 2003 SP2 is well out of date then, because thats what the wizard uses when you put a control box on a form, and select 'Duplicate Record'. But thanks for the tip I know I have a lot to learn.

You could put a text box on the form and name is "NoOfDuplicates". In your VBA code, you can get the value of the textbox by using something like: Dim NoOfRecs As Integer NoOfRecs = [Forms]![EnquieryForm]![NoOfDuplicates] You can then use the 'save and duplicate' code that looks...

I deleted my last post as I misread what you said, appologies! Yes you can use the 'save and duplicate' feature to save 5 records. I guess if you really wanted to have a textbox on the form that you enter a number of how many times you wanted the record saved, you can use VBA to read the text...

I don't know if what your asking is possible, but you can disable and re-enable the shift key as detailed in the following forum. Perhaps this might offer an alternative solution? http://www.access-programmers.co.uk/forums/showthread.php?p=196533#post196533

I was attempting to do this too when I was new to Access. As you become more familiar with Access you will find it is very different to Excel, and requries different thinking.

I just tried this myself, with one field as an integer, and another as a long interger, in 2 separate tables. I put the value of 8 in each table, and then created a query that has the formulae "Expr1: [Table1].[a]-[Table2].[b]", the result I got was '0' as expected. Have you tried this in a...

Are the data types for these 2 fields set up the same?

Thank you - I found and switched off the visible attribute in design view.

Hi, I have a Form that is filled in by various people. Once filled in, they hit a submit button that stores all the contents of the form to a table....fine. I have some fields on the form that I would like hidden from view, such as Windows Login ID, date etc that must be saved to the table...

Book I'm just finishing is called "The Family Way" by Tony Parsons, a fantastic book that really brings things home! Want to read another Nick Hornby book next, after reading "A Long Way Down", recommendations anyone?

Too right! Giving foreigners what they want helps keep crime down, sod everyone else.

Would sooner be blown around a bit than be sent into a war zone :D

The way I would do this would be to have a main form that allows the user to open the order form using a command button. If you then go to 'Build Event', code, you should see the code that opens the order form. You could add some extra code that would open the "Its too late form..." when the...

If I can throw my tuppence in, I simple believe young people are often brought up to believe in Santa, the tooth fairy, and perhaps even God. Older people sometimes then go on to believe that God still exists, simply because we can't prove otherwise. And if we dare to think otherwise, the...

I haven't seen that happen before but I am quite new to Access myself. I'm not sure why having the form open at startup would cause the query to open behind the form! I can only think it is something to do with the form attributes or the macro that displays the query, but I think you have...

I don't know why the query opens up underneth the form, it maybe that your form properties attribute for 'popup' is set to yes? in which case all other windows open up underneth. If this is the case changing the popup setting to 'No' may be all that is required.

Ensure the Auto Centre attribute is set to No. In design mode, you should then be able to place the pop up form where you want it. When you close the form, it should re-open in the location where you last saved it. I am assuming here that you are opening your pop-up form by a button on your...

Yes, follow the steps below: 1) open form in design view. 2) On the menu, select Edit, then Select Form. 3) Then select View, Properties. 4) A window should pop up, under the Format tab, the properties for width, Border Style, Auto Center/Resize, Moveable etc can be changed. Pressing F1 when...