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 Rhinorhino 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: irethedo
  • Content: Threads
  • Order by date
  1. irethedo

    Checking for a blank line in excel from Access

    I have a spreadsheet that I am doing a TransferSpreadsheet function from within Access DoCmd.TransferSpreadsheet acImport, 8, "NewData_tbl", In_File, True but sometimes the top line of the spreadsheet is a blank line which causes a Run-time error '2391' Field 'NoName' doesn't exist in...
  2. irethedo

    Looking for the most efficient way to update a table...

    I have a table called TotalOrder_tbl which contains order information. In my database the user can select a button to display order information on a form called Order_frm. On the Open form event for this form, an input box is used to allow the user to enter an order number and then a query...
  3. irethedo

    Run-time error '3078' question...

    I am getting a Run-time error '3078' which states the Microsoft Access database engine cannot find input table or query when I attempt to execute the following code: strSq1 = "SELECT * INTO ViewOrderData_tbl FROM Total_NW_tbl WHERE (((Total_NW_tbl.SO_NO)=1492198995))" CurrentDb.Execute strSql...
  4. irethedo

    StrComp function- Limited Case sensitive string comparisons?

    I have a question about Case sensitive string comparisons... I have a form with a text box called OldPWD that I entered "Test" into and with the code below I am comparing this to "test" and the result is 0 which indicates that they are equal. If I enter "TEST" (all caps) into the OldPWD text...
  5. irethedo

    Is there a way to click a button on one from from another form?

    I have a form in my database named 'OrderMenu_frm' that allows a user to match items from a sales order. The data from the sales order is populated onto the OrderMenu_frm if the user clicks a "Get New Order" button on this form. The user then matches sales order items on this form that are...
  6. irethedo

    Database design questions

    I have a spreadsheet that contains sales order information that I would like to convert over to an access database and I am looking for suggestions or any tutorials on how to best do this. The fields on the spreadsheet include customer name, order number, date entered, system type, computer...
  7. irethedo

    Excel export is over writing spreadsheet

    I am trying to reuse some previous code but it seems like I am missing something... The following code dumps the contents of table CleanPC_tbl into a spreadsheet and I would like this to be an append but the spreadsheet keeps getting over written. What am I missing? Thanks Set objXL =...
  8. irethedo

    Continuous Subform question

    Is there a way to not display the last line of a continuous sub form ? I have the following continuous sub form and I don't want the blank last line to be displayed... (shown highlighted in the picture below): Thanks
  9. irethedo

    Query works when run manually but not when using CurrentDb.Execute

    I have a query (IpelaOrd_qry) that I am using to load data into a table (IpelaOrd_tbl) but I am doing something wrong as it is not working as I would hope... At first I set this up as a select query as shown in the code below: SELECT Ipela_tbl.ID, Ipela_tbl.PartNum, Ipela_tbl.Desc...
  10. irethedo

    sorting a table with a query

    I have a continuous form that has a table as its record source but I would like to set up a combo box on my main form to sort the table by part number, by quantity or by line number... Here is what the query that sorts the table by Part number looks like: (I have omitted the other two queries)...
  11. irethedo

    removing records from a continuous subform

    I have a form that I have been working on which consists of three continuous sub forms in which the user can select items from each and click on a Match Selected button which combines these items into a table. When each record of the three tables (which control the data source for the...
  12. irethedo

    Need help with a query

    This is a simple one but for some reason I don't remember how to do this... I have an query that makes a table but I want it to make one record for each quantity of PC_frm_tbl.QtyLeft so that if the value of PC_frm_tbl.QtyLeft = 12 then I want the qry to create 12 new revords in the table...
  13. irethedo

    suggestions requesting for a form layout

    I would like to make a form that contains four different lists of types of items that are on a sales order and allow the user to match one of each of the items up per type into one configuration. So if an order contains a variety of PCs, software licenses, special software, and other options...
  14. irethedo

    MoveLast doesn't appear to be working...

    I have the following code and I am stepping through it and monitoring a watch variable for rsx.EOF but immediately after it executes the rsx.MoveLast line in the code, the watch variable stays at rsx.EOF False I would expect it to be True after executing this. Any suggestions why it isn't...
  15. irethedo

    Adding the total quantity of a type of record in a table to each record

    I have a table that contains four fields: Unit, Device, Qty, and LineNo and I would like to add a fifth field that contains the total quantity of Devices or Units of each specific type within that table to each record such as total field in the example below. In other words, There are a...
  16. irethedo

    Exporting a table to excel and including the titles

    I have a table that I export to Excel but it doesn't export the names of the fields in my table at the top of the spreadsheet. This is most likely one option that I left out of my code but have been searching for how to do this and have not been able to find the answer... I have included my...
  17. irethedo

    Run-time error '3021' No current record

    I am getting a Run-time error '3021' No current record when attempting to edit a table record. The table is initially is an empty table (MatchUP_tbl) and I have tried adding a record with AddNew and Update and have also tried MoveFirst, Movelast (and no move at all with the assumption that...
  18. irethedo

    Looking for an easy way to test to see if excel spreadsheet exists

    Is there an easy way to test to see if an excel spreadsheet exists to avoid the error message that happens when trying to open a spreadsheet for export when it doesn't exists? The idea is to create a new spreadsheet if one doesn't already exist Thanks
  19. irethedo

    TransferSpreadsheet is messing up some of my data

    I am converting an excel 2007 spreadsheet into a table but I am seeing some of my part numbers getting messed up. My code contains the following line: DoCmd.TransferSpreadsheet acImport, 9, "NewData_tbl", In_File, True and the spreadsheet contains the following: Part# Desc Line 015968...
  20. irethedo

    malformed GUID in query expression

    Not sure what I am doing wrong here... The following code gives a malformed GUID in query expression message: Set rs = CurrentDb.OpenRecordset(strSql, dbOpenDynaset) strSql = "Select * from PC_SP_Line_tbl order by SP,[Line Number]" But have no problems when I place this in a...

Part and Inventory Search

Back
Top