Search results

Thanks, looks off putting but Hey gets the result wanted

User picks from the date picker. The format is set for each control, and set in the Tables, The weird thing I am getting now is that the date stored in the text box shows medium date but if edited to a different date via the picker, it reverts to short date momentarily, then changes to the...

Your advise is sarcastic and not helpful. I do not claim to be a "Programmer" but a learner who finds the forum helpful

Customer asks for the dates on the forms to be in Medium format instead of short format. I have changed to this in the tables used and on each of the forms controls The tables look as expected When I change the a date on the form it reverts back to the short format?????? What have i missed?

Yes Thanks

Thanks Pat

Thanks, I have done almost exactly this as advised by fellow advisers

WOW! At a loss as to how to answer everybody but here goes. Ken, Pat helpful as usual. bbfromgb thanks, I have visited that article and will study it. Appears that my statement was not sufficient for some, so I am attaching an image. I am at a loss as to how I have subforms on a form that is...

I have been asked to change present forms so that there is a"Background" form with no connection to any table and that only contains a few Command buttons. Then showing always, three smaller forms, each derived from it's own query and always placed on the background form in the same position...

Thanks all will work on it

This works to show current linked tables My problem is that it seem to be saving the records to a different tblVisits in another, previous saved, backend and i cant figure out where

I have a form writing to a table that appears to be in an older version of the database. how can I find this table. The for opens, accepts data and closes without any error mesasage. The data file (split database) has been backed up numerous times but I cannot find the table (tblVisits)...

I wish to find and track miss spelt products in the Products table. I guess ProductID, PartNumber, and Product (the description) are the items in discussion. I wish to find products that have been mis-entered EG spelling or spaces that should not be there. a sample would be 100B470JT500XT and...

The need to test is to deny duplicate entries. When an order is received it notes both the manufacturer's part number and description as well as the part number the customer gives the product. We need to record both. The manufacturer's part number is usually in the system. There is an entry form...

Thanks Doc man Like I said...Difficult and you just made it more so! The structure of the product table (tblProducts), is ProductID...PartNumber....Product etc etc (Product is a detailed description of the product) The structure of the table recording the Customers associated part number is...

I have have two tables...tblProducts and tblCustomerPartNumbers. I need to record the part number a customer gives to a product that the manufacturer has given a part number, ie the manufacturer builds a product and sets the Part Number as R5G100, but the customer lists it as 000-123-00. I...

Thanks, you guys are unbelievable! Answers in less than an hour. I have used Me.txtNextContactDate = DateAdd("d", 7, Date) and works fine

I have received great help for this post ( I have a form in which we enter a date, say for when we receive an order say 21/08/2024. I wish to have the entering of that date trigger a textbox entry for a date that is say, one week more. Thanks guys Now how would I do it using the Now Function...