Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Inky2201

    Problem with date and time formatting on reports

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

    Problem with date and time formatting on reports

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

    To lose empty lines on an address section on a report?

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

    To lose empty lines on an address section on a report?

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

    To lose empty lines on an address section on a report?

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

    To lose empty lines on an address section on a report?

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

    Pasted in data causes problems.

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

    Trying to delete multiple tables on a command button.

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

    Pasted in data causes problems.

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

    Trying to delete multiple tables on a command button.

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

    Pasted in data causes problems.

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

    Trying to delete multiple tables on a command button.

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

    Function to delete all objects except tables out of a Database

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

    How can I change the value of a field in a table from an unbound form?

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

    How can I overwrite tables using import?

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

    How can I overwrite tables using import?

    Hello, I want to be able to import tables from an external Access database into another copy of the same database and contains the same tables. When I do this it creates another copy of the relevant tables e.g. Table, Table1, Table2 etc. How can I import the tables and overwrite the originals...
  17. Inky2201

    Export to Word

    Hi. Why not create an Access report instead of exporting to Word which is based on the form that contains the data? Regards I
  18. Inky2201

    Can I open more than one website at a time in Explorer?

    Hi PHV, Yes I think an explorer window could be set up ok but it is really the aspect of holding open six sites at the same time that is the issue. Do you have any suggestions for this. Thanks Tony Jollens and PHV. Regards I
  19. Inky2201

    Can I open more than one website at a time in Explorer?

    Hello, I hope you can help. I want to be able to open and have active, 6 websites at one time and display them all on a split screen on the pc. Is there any code out there that will enable me to do this from one Internet Explorer application? Regards I
  20. Inky2201

    Can I open more than one website at a time in Explorer?

    Hello, I hope you can help. I want to be able to open and have active, 6 websites at one time and display them all on a split screen on the pc. Is there any code out there that will enable me to do this from one Internet Explorer application? Regards I

Part and Inventory Search

Back
Top