Search results

One way I have found to get a list box to update the other records on a from is to use the 'requery method' in VBA. The VBA is triggered by the 'After Update' event. You would insert the code in the 'after update' properties of your listbox.

Is there a good reason why you can't design and release your invoice part, and then take a copy of the file for development of the stock system? (this way you still have your separate file to mess around with, and you won't have to integrate 2 systems later).

First things first, set up a parameter query that gives you the data you want. There is an excellent Microsoft tutorial (if you need it) at the following address: http://office.microsoft.com/training/Training.aspx?AssetID=RP010969841033&CTT=6&Origin=RC010969991033 Once you have this...

Post away! I have had tons of help from this site so its good to help out occasionally :)

Had another look at the table properties, and you could add a validation rule something along the lines of: Like "??????" Or Like "???????" this would allow 6 or 7 digits. This can be expanded to cover between 6 and 10.

Make sure the forms properties for 'record source' is set to ORDERS, and the 'record source' of each combo box is set to 'product' and 'size'. I'm pretty certain thats all you need. You don't have to do anything with the save button.

If you go back to the properties page (described above), try the following settings: Under the Data Tab: Allow Edits: No Allow Deletions: No Allow Additions: Yes Data Entry: Yes Under the Format tab, you can also turn the record selectors and navigations buttons off as well...if you wish...

Some questions: Do you want the form to display current records too? Or do you only need the form to be used to enter single records? Are you currently using the default record navigation buttons to skip through and save records?

It sounds like it isn't entering data, but viewing your records only. If this is the case, I seem to recall that you will need to change the properties of the form in design view. This was certainly an issue I had. Go to 'Edit' - Select Form Then 'View' - Properties. On the window that...

You can certainly set the maximum field in the table design. If you require a minimum and maximum, I think you will have to add some code to check the string length falls within these limits when it is entered. This would be fairly straightforward to do if the password is entered in a form.

If you add a command button from the toolbox (with the wizard enabled), the wizard will sort this out for you automatically. Under the wizard categories, select "Record Operations", and under Actions select "Save Record". Hope this is what your looking for.

I tried this but as my TestDate is a Row Heading it doesn't seem to work, also, I would like to keep the automation of the database, as users run the query monthly. I can't easily change the query, as it is transfered into Excel where VBA goes through the data. Where I have my expression...

I have a crosstab query that has been working fine from 02-08 to 12-08 (mm-yy) where the dates have been in ascending numerical order. Now we are in 01-09, the query looks like this: 01-09 02-08 03-08...to... 12-08 What I need is this (in date order with 01-09 appearing at the end)...

I think it works both ways, people love to read crap, but also the newspapers / media also play a part in our direction. They tell us what it is we want to know about.

For instance: Front page of the Independent Online: 1) 'Darling is running out of options' - are we really surprised? Don't we all already know that changing interest rates is really the tail wagging the dog! And who really cares about any of this.... 2) 'Soho - Why sex trade...

A car is a pretty good Faraday Cage that causes the mobile to transmit at a much higher, or even maximum, power level. All this high power microwave radiation, being reflected all around the inside of your car, isn't too healthy for the brain cells. If you used a jammer, again you would...

Well, if you get tired, just imagine there's a hand bag shop at the end of your trek, that usually works doesn't it? Good luck!

Whatever is in it, just sprinkle it with chilli sauce, yummy :-)

opps sorry my mistake, I failed to see you said 2 different columns, try this: 1) Create a query and insert the same table in twice. 2) Join the 2 different dates from each table. 3) Select 'Totals' and save the query as DuplicateDates. 4) Then create a new 'Unmatched Query' to compare...

How about this: Create a duplicates query on the date. Then create an unmatched query and join the date in your table to the date in your duplicate query.