Search results

Hi, thanks for the suggestions! Struggling with this though and am not sure where im going wrong (beginner at this stuff)! Iv sorted my first query. when opened this simply displays a list of locations, nothing else. Could you guide me a little further on what to do (and how) with the second...

Thanks for this, Is there no way i could do this with somthing in the criteria of just one query??

Hi, I would like to run a query on one of my tables. In my table column labelled 'location' each record will have a 'location' allocate to it. This could be a number between 1 & 100, with a prefix 'a' or 'b', therefore a location could be somthing such as 'a25'. Within my table, there will be...

Hi, Im planning my new DB and am contemplating the best design. It will be used for warehouse stock rotation and control of pallets. I want to track each pallet (product/time in/time out etc) to each pallet space within the warehouse. There are a total of 400 pallet spaces or 'locations' as...

Hi, Im not sure about the conditional formatting cos my text box contains a product code (4numbers) and also the best before date ie. Sep13. As far as i understand, conditional formatting would be for the data in the actual text box. Where as, actually, my text box is only there for 'user'...

Hi, 1. Yes, data type is Date/Time 2. No, dont need the time part. 3. Yes, aware of conditional formatting but dont think it would work in this instance. Awaiting your suggestions with interest! Thanks

Hi, Iv got a form with various text boxes and cmd buttons on it. Im using it for a stock/inventory tracking purposes. I would like some sort of visual prompt for when a stored item is nearing its best before date or when an item gets x% through its shelf life. Therefore, i have a text box...

Hi, Thanks for link to help, but i cant seem to resolve this? Anything else i could try?? Thanks,

Hi, Iv got a database that works great on one PC. Iv now put it onto another PC (running the same version of access 2002) and when i run my DB, i get an error message saying 'Undefined Function' '[Format$]' in expression. I assume this could be somthing to do with a query i want to run, but...

Excellent - sussed it!! Thanks for the help!

Hi, Thanks for guidance, but still struggling with this. Iv tried all sorts of variable that i can think of from the link you have provided but nothing seems to work. Could you spell this out for me?!? Greatly appreciated,

Hi, How can i set the format of text using some code in the control source of a text box? Ill try and explain: I have a textbox (a) that creates a string of data by 'adding' together data in a variety of other text boxes (b&c). As such, my control source for text box (a) reads somthing...

Hi, Iv added a 'subform/subreport' to one of my forms. I wanted to use this to display a report. Therefore i assumed that i would simply set the source object to my desired report and hey presto! But no, when i look in the source object drop down list, my report doesnt appear. Any...

GREAT! Thanks for that! Oh so simple, but not somthing i could put my finger on! Many thanks,

Hi, Thanks for the help, but im struggling with this one! Iv searched access help for 'Explicit format string' and also 'User formatted numbers' but im not really sure what im looking for or where to start? Perhaps you could enlighten me further - (self tought beginner at this stuff)! Many...

Hi, Used a tab form and it does exactly what i need. Thanks for all the suggestions!

Hi, If i have a string of numbers in a text box on a form, how could i dictate the amount of digits? I would like the number of digits to be set. For example, if i type a number of 50, i would automatically like this to be displayed as 0050 (ie. a 4 digit number). Therefore if i type 150, it...

Hi, Thanks for reply, Im thinking of a slightly different approach though. I am hoping to use the 'subform' on my form to display different forms dependent on which cmd button in selected by the user. I am thinking of come code that would set the source object of my subform(???) something...

Hi, Iv got a form with a 'subform' on it. I have a cmd button, that when clicked i would like my 'suppliers' form to appear in the subform. Any suggestions on the code i need to put in the onclick event of my cmd button? Many thanks,

Hi, Iv got a form with various data on it. The data comes from a table. I wish to print the detils on my form onto a label (10cmx12cm) as it appears on my form. I understand the best way to do this is via a report. So, i have created my report from the same table that my form gets its data...