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!

  • Congratulations Wanet Telecoms Ltd 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: *

  • Users: Inky2201
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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
  8. 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
  9. Inky2201

    Populate a form record by selecting one textbox?

    I want to try to populate a whole record of text boxes on a form by selecting one (e.g. Item Number) from a combo box. I dont think I am making it very clear. I want to select an item in the combo box which will pull through the rest of the record. Can anybody help? Regards Inky
  10. Inky2201

    Problem with OpenRecordset with query

    Hello, I have a problem that I cannot overcome. I am trying to retrieve records from a query using the code: Set rcd = db.OpenRecordset ("qryCustomer", dbOpenDynaset) but it comes up with the error "Expected parameters 2" why is this and what do I do do get over this. Thanks I

Part and Inventory Search

Back
Top