Search results

Just reading up on the DatePart() function; trying to get my head around it! :-) Any code suggestions welcome; although i kinda like the buzz of sussing it out myself!

Thanks for your help, and yes, i get what you mean. :-) My prob though is that the users will only have a number key pad to enter somthing, so can only enter their date as a number i.e. 112021; Should perhaps i convert this number to a date, rather than the date to a number? (or am i trying to...

Hi; thanks for your patience! (no expert here)! :-) So, hopefully this may help explain what im doing: The user (using an onscreen key pad) types numbers into a text box then hits enter; the code then compares it to another textbox populated from a table of data, and if it matches the textbox...

If i remove the format setting of mmm yyyy from the text box (me.bestbefore), it just desplays as 28/11/2021 15:06:26. my format setting changes this to Nov2021 The textbox gets this info from another piece code which reads: Me.BestBefore = DateAdd("m", [ShelfLife], [Now]) This basically takes...

Hi, The format of the textbox which reads 'Nov2021' is set to mmm yyyy in the properties list. The text box which i want to simply read numbers as '112021' is not bound to a table. I want it to appear as numbers so that when a user types in numbers, then these can be compared and if they...

Hi; is there any way for me to change the format of a date to numbers? I currently have a textbox with a date in it which appears as "Nov2021' Can i code a cmd button, which on click, puts this date in plain number format into a second text box as for example 1120201? i.e. MMYYYY?? It is...

head scratching over; and solved it! Thanks for your help! :-)

That is brilliant! Thanks - i never realised it would be so simple. One further thing if you dont mind: Further down in my code, there is a bit that applies a filter to a subform; with the above solution you have provided, my main form works fine, and my search works, but then i get a data...

Hi, Please excuse my amateur approach here: I have a table with records in it called 'sheet1' I then have a form, with an unbound text box on it, with the below code behind the after update function. (this is just the start of the code). So, if in my table my 'Barcode No' field is...

Hi, I have a db with various reports. Each report is basically the layout and page size of a label onto which i want to print. I have a Zebra LP2844 label printer. My db will be used to print a number of different size labels. I dont really want users to access the printer dialog/settings...

great! Thanks, i think this has just solved my issue!

Hi, thanks for the help, Just tried suggestion by SOS - still no luck! Re. last post: I have a text box, (Me.Qty), and the user should input a number into that text box. So that line of code prints my report the number of times as specified in Me.Qty. If however the user doesnt input any...

Thanks, but still not working. I get the same error and when i debug, this line is highlighted: DoCmd.PrintOut , , , , Me.Qty.Value ?? Still scratching my head over this!

Hi, Im having some issues with some code and i would be grateful for a bit of advice if you can decipher what i am trying to do from the below code! In summary, this code works once, and then if i force an error again, i get a data mismatch error and am prompted to End or Debug. Clearly...

Hi, Iv got a tab control on my form. On each tab is a variety of text boxes. When i click/select a tab, i would like to set the focus to a particular text box within that tab. There appears to be the option to add an 'on-click' command, but this doesn't appear to work for me. For example, on...

Thanks for your help with this! Just found a rather embarrassing mistake, and that was that my form name was wrong!! Its been bugging me for hours!

?? Thats odd, Since i put my text boxes onto a tab control, its not working? Im getting Runtime error 438. Thanks for the help!

Hi, Iv got a various tab controls on my form (form1), each tab page has different text boxes on it. On tab 'Page1' i have a 'Textbox1' - when i close another form that i use for data input, i want to automatically enter data into 'TextBox1'. Before i put my text boxes into a tab control, i...

Worry not! Sorted it. Thanks for the help!

Ok, Got it.....Query 1 sorted, with locations AND latest date. Can you please explain next steps a little more? Many thanks,