Search results

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...

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...

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...

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...

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, 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, 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...

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...

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, 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...

Hi, I have a form and a few tables. On my form i have a few text boxes and a cmd button. When clicked the cmd button looks up data in a table (using info in one text box) and then populates other text boxes on my form from corresponding data to the record being looked up. My code uses the...

Evening All, Iv got a query that gets its data from a table. When going through the query wizard it enabled me to group my data by 'Date'. So, for example, in my table there are numerous records for different products on different days. The date field for each record in my table is a...

Hi, New to this site, and hope i may be able to source some help. Im a bit rusty on my code knowlege: I have a form with a cmd button with the following code behind it: Private Sub Find_Click() Me.RecordsetClone.FindFirst "[RecordNo] = " & Me![FindNo] If .NoMatch Then...