Search results for query: *

Hi Guys, Many thanks for taking the time to help me and I know.......I really should get to grips with SQL, but I have managed to achieve my goal !!! I've added an autonumber to my INVENTORY table which I append to on a monthly basis. I then created a little query in Access with just a unique...

Hi, This seems to have been covered before, but none of the answers work for me........... Bascially I have a query which looks at an inventory table. I have 7 fields in the table:- ID which is an autonumber Product code Opening balance closing balance Year Period Date timestamp I can have...

Will do, Thanks for your help guys [lipstick]

Hi again, I'm confused, nothing strange there though...... In my table field property I have against format \A000000 In my table data I have one saved record which has the autonumber as I want it i.e. A000043, in this instance. I thought because it has been saved into the table as A000043...

Ah... that would explain it then! Thanks for this, I might have to look at an alternative numbering sequencing then!! [lipstick]

Hi, I'm using autonumber for my header record form, A000000, and I want to display the same number in my detail record form. It does show the number but not the prefix, any ideas what I need to do to get it to show would be a great help! Thanks [lipstick]

Hi TheAceman1, Thanks for taking the time, I will copy and paste as you suggest into my DB and see how it goes. I'll let you know the result. [bigsmile]

Hi, Can anybody help please. I'm sure this is quite straight forward, but I have searched through the site and can't find anything that quite matches my query and I'm no good with VB So here goes, I have two forms, one being a subform into which Sales Order data will be entered. What I want...

Hi guys, Last time I checked I wasn't a guy, honest.....lol. I do admit to having the odd blonde moment though and garebo, I think we could start a trend in Wellingtons!!!!! Yes it's been fun dismantling my PC, (not very often I get the chance to take things to bits) I think I need to make a...

Hi again, Not sure if this is what you're after, but I paused the boot up and got Award modular Bios V4.51PG 08/12/1999 AMD-K6(tm)-2/450 Now I have the tower in bits on the floor (lol)the mobo is in full view, so hopefully you can make something out of this lot! 5SSVO-D150A TS895B-2 v2.0...

Hi again guys, Looks like i'll have to get my screw driver out then. Women and screw drivers don't go together so I'm told, but for you, I will dismantle the tower and have a look at the mobo. Hope you'll all be online when I have bits left over that won't got back!!!lol and no garebo, don't...

Thanks guys for your quick replies, much appreciated. I was thinking of keeping you in suspense Doc, but that's not nice, so as long as you promise not to laugh, here are my PC's vital stats as per Belard Report........ Motherboard, SiS530, Bus CLock 100mhz Memory 60mb, slot 0 32mb. slot 1...

Hi, Bit of help / advise required please. I have a rather old PC which plods along quite happily, running Win98SE, but I want to go to Broadband and thought it best to upgrade to Windows XP. However when I tested to see if the PC would upgrade to XP, I got the message, hardware to old to...

Thanks Pudda, will try uninstalling AOL. I'll let you guys know my progress!!!! Watch for the latest installment............ [ponytails]

Hi, Thorpe89 Thanks for replying, but I've left the PC 20 mins (just in case) and nothing. I don't even have the red light flashing on the tower to show that something is happening in the background........ I will try and find out about the windows key though...that might at least give me the...

Hi to anyone out there! I am running Windows98 and I recently downloaded AOL 9 (may be no connection to my problem, but worth mentioning) and whether I left or right click on the start button nothing happens. The button dims as if the command has been accepted but the PC hangs. I can get into...

Many thanks! I'll give it a go Jan [ponytails]

Hi Everyone, Sorry bit vague there on my help cry! I have a subform which contains two fields Qty and Label. The Qty field has a 'default' value which is pulled through from the main form and the Label field has a default value of 1. The user can either leave the fields unchanged or amend one...

Hi, Can anyone help please. This maybe a daft question, but I'm struggling to get an answer. I have a form which contains a sub form. On the sub form, I would like to add a record to a table without the user having to actually enter data. So ideally if the values in the two fields remain...

Glad you're ok now. I haven't tried hiding the drop down on the combo box and I'm not sure how to, but if you do find out I'd like to know too!! Good Luck Jan