Recent content by Inky2201

Thanks both of you, I think Skips idea is more appropriate as the date and time will not be todays but a booked date and time for the future. But both are worthwhile - thanks I

Hello, I have a problem with entering the date and time on a report tidily. At present I have 2 text boxes, one for date and one for time with an "at" in another text box in the middle e.g. [26th July 2005] [at] [9.30PM]. When I use this method the first text box has to be large enough to accept...

Trevil, Thanks. It worked a treat. I cannot understand how I have not seen that before. Zion7, Thanks for your suggestion I have made a note of it for future reference. It is very much appreciated. Regards Inky

Thanks both of you. They both lokk worth trying. I will give them a try. Thanks again I

Hello Trevil, Thanks for answering so promptly. Yes I have seperate controls for each field. Name, Address1, Address2, Town etc. Regards I

Hello, I have a report formatted as a letter which imports the name and address of the receiver from the database. When there is not a line imported it leaves the line blank in the report which obviously leaves a gap in the address it is going to. I need a command which will move up the address...

Hi AceMan1, Yes the PK is Autonumber and all of the entries have unique IDs I

Yes Chaz, You are right. The tables without the relationships are the ones that delete ok. Its the ones that have the relationships that do not. Will I have to give up on this? I

Yes it is possible but they all show in the form when running through the records so why are they not being referenced in the report? surely some would still appear (the ones without the spaces)? Or am I misunderstanding what you are saying? I

Hi Blorf, I do not get any error message. It just does not carry out the function. I

Hello, I have recently pasted 1000 records into a table from Excel as import was causing problems. This works fine but I have discovered that trying to reference the data in a form to a report will not work. I have a query that is "looking" for the entries in the form but it will not pull it...

Hello. I am trying to delete all of the tables, on a command button, from a self contained database. I have managed it with one table but for an unknown reason it does not want to delete all of the tables. I am using the code: DoCmd.DeleteObject acTable, "TableName1" This works but if I try...

Hello vbslammer, Saw your very detailed entry on the forum for deleting objects from a database and wondered if you can help me. I am trying to delete all of the tables, on a command button, from a self contained database. I have managed it with one table but for an unknown reason it does not...

I have a form that has been populated with a list of 16 parts (in 16 text boxes) by VBA code and is not saved or based on a table. On this form I want to "pull through" the value of a field in a table and carry out a calculation on this field to change the value in the table underneath. In other...

Thanks both of you for your comments. I will give it a try. Regards I