Search results

Are you simply looking for this: 01/01/200830/01/200810010015/01/200828/01/200840

give them a tap, just hard enough to put a crack in them, then they should pull apart nicely. Bit of a Pistachio nut numpty too then? :)

Where did this work you want to include on your CV come from? If it's your own personal work, for example done as part of a college course for instance - then fine, make it clear that this is your OWN work. Never release work that you done whilst being employed - companies might not trust you...

I thought Violence against women was only taught in middle eastern countries

Anything you can do to spice up your current job? I think a lot of job postings out there push the boundaries in terms of what they really want / expect from you. Where I work now, new people start at the company, believing they are going to be 'really involved', and very soon find themselves...

This is for our fellow Americans - but if you own a gun - always carry one extra bullet!

How to identity a real life Heart Attack - thanks to Hollywood movies :)

Why is it the poorest in poor countries are skinny, yet the poorest in rich countries are so fat? I guess in poor countries people have to work for a living, and grow their own food. In rich countries, the poor are lazy fat slobs.

The hotter the water - generally the better the coffee. But it does makes me wonder how society ever allowed an attitude of allowing idiots to blame their own stupidity and carelessness on others.

Hi, I have always found the purpose of the 'print preview' tool is to show exactly whats going to be sent to the printer. If you want to stop something from printing out, have you looked at options such as changing the font colour so its invisible, or hiding the cells. But it will be...

This is one example of a list box that has the following SQL statement in the Row Source property of my list box: SELECT TestLocations.TestLocation FROM TestLocations INNER JOIN HardwareTestTypes ON TestLocations.TestLocation = HardwareTestTypes.TestLocation WHERE...

I am trying to find some form of VBA code that will automatically select an appropriate (default) item in a list box. I can't use the 'default value' property as whats displayed in the list box is different depending upon other selected fields on the form. Could somebody please help? I'm...

Around the code that attempts to delete the object, you might be able to implement the following code around it. On Error Resume Next (your line of code to delete the object) On Error Goto 0 I have used this code successfully in similar situations. The 'On Error Resume Next' tells Excel...

I can look tomorrow, but just a thought, do you have the option of changing your table properties for this field (name) to 'Required'? This is an alternative way of ensuring data gets entered.

I haven't actually ever used a Subform, but I think the first line of your code should be changed to this: If [Forms]![frmEquipmentSub]![Name] > "" Then Hope this helps.

If you have a 'close form' button on the form, you could add coding along the lines of: If [Forms]![formname]![textboxname] > "" Then DoCmd.Close acForm, "formname" Else MsgBox ("Enter something in textbox") End If

You can add a command button to run a query by using the control wizard. To count the total number of fields, you can use something like this in the Row Source text box: SELECT Count([fieldname]) FROM QueryName;

Phew..!! I have managed to work it out. In case anyone was wondering, I can get the dates in order by changing my expression from 'mm-yy' to 'yy-mm' :-)

You can use the 'DoCmd.OpenForm' command to open the Unpaid Orders form. To copy the records over it should be something like this: [Forms]![Orders Subform]![fieldname1] = [Forms]![Unpaid Orders]![fieldname2]

I was making the assumption here that you are using a query (from a table unspecified in your post) to assist in populating some fields on the form, that will save data into your "Inventory Movements" table. This is fine for having fields in the form coming from lookup tables/queries to...