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 Chriss Miller 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. denosaur

    Import multiple worksheets into single Access Table using VBA

    I figured out how to do what I needed to do. Below is my code. It worked just fine. NOTE: In the first For... loop, I used Step 2 because it turns out I only needed the records from every other sheet beginning with sheet1. I also only needed the data from columns A and D from the first 51...
  2. denosaur

    Import multiple worksheets into single Access Table using VBA

    I do not know how to get to all the sheets in the workbook...only Sheet1. There are 212 sheets (Sheet1, Sheet2, etc.) and I need all of them. A point in the right direction would help a lot.
  3. denosaur

    Import multiple worksheets into single Access Table using VBA

    I have an Excel spreadsheet that has 212 worksheets and I need to import (or copy) the data from each of the worksheets into a single table in Access. I figured if I could specify the worksheet to import, I could loop through the worksheets importing the data for each one, but the...
  4. denosaur

    Access Applicaton Options.

    Check out http://www.mvps.org/access/api/api0019.htm to address the maximize issue. Check out http://www.mvps.org/access/api/api0022.htm to address the disable the X to close the application issue. I hope that helps. Deno
  5. denosaur

    Access Applicaton Options.

    Do you want a form to maximize or the Access window to maximize?
  6. denosaur

    VBA DATE issue; DD-MM-YY ?

    Try using the DateValue function with the DTPicker fields. I had a similar issue with DTPicker fields and it worked for me. Ex: DateValue([Forms]![frmMeerMinderWerk].[cmbRedenAfwezig]) AS FK_afwezig_reden I hope it works for you. Deno
  7. denosaur

    Help with search PLEASE! Due tomorrow

    Okay... Try this SQL statement: SELECT Main.Manufacturer, Main.[Model#], Main.[Serial#], Main.Condition, Main.Description, Main.Ram, Main.Date, Main.[Jack#], Main.Location, Main.Processor, Main.Status, Main.Size, Main.Reason, Main.[CIFA_P/N], Main.[G/L_Acct#], Main.Total_Orig_Cost...
  8. denosaur

    Help with search PLEASE! Due tomorrow

    Hi! If any one of the search criteria that the user enters on the form can be true to be returned in your query, then you should try replacing the current WHERE clause in your SQL statement to the following: ... WHERE (((Main.Manufacturer) Like "*" & [Forms]![csearch]![Manufacturer] & "*") OR...
  9. denosaur

    Need function to import Several Separate Workbook Sheets

    Something like this might also work. Note: you may need to change the .FileName line to match the naming conventions of the workbooks. Sub ImportFireFighterForms() Dim fName As String Set fs = Application.FileSearch With fs .LookIn = "C:\FireFighterForm" .FileName = "Tbl_Data*.xls"...
  10. denosaur

    Type mismatch in open recordset

    Check your References...you may need to move the reference to Microsoft DAO 3.x Object Library to a higher priority that the reference to Microsoft ActiveX Data Objects 2.x Library. If this is not the issue, then you may also try changing the... & "Like " * "...
  11. denosaur

    myitem.body works in Access/Outlook 2003 but not 2002

    Try using .TextBody instead of .Body. I am running Access 2002/Outlook 2002. I reference Microsoft CDO for Exchange 2000 Library, so this is a different implementation, but it may be worth a shot.
  12. denosaur

    Outlook Security

    Hi! You might check out thread605-870309. You may find that it helps. The code helped solve this problem for me.
  13. denosaur

    Table Export with TransferDatabase

    You could create a Make-Table Query based on the table that you want to transfer to the backup database. In the Make Table dialog box, use the Table Name you want and point it to the backup database using the Another Database option. Then you can use DoCmd.OpenQuery... I hope that works for you.
  14. denosaur

    Coverting vertical data to horizontal

    I think I understand your problem. Based on my understanding, I created a table, VLoans with columns ToLoanID, FromLoanID. VLoans had the same data in it that you noted in your example above. Then, I created an empty table, HLoans with the following columns...
  15. denosaur

    run macro once for each row in a table

    blute, I would suggest modifying your module... Add a sub that iterates through your customer table and as it iterates through each record, have it call your other sub that makes the table and exports it to Excel. I'll assume that your sub that makes the table and exports it has an argument...
  16. denosaur

    refer to variables in loops

    autex, How are the values of the variables stored? If I knew more, I might be able to help.
  17. denosaur

    Convert EBCDIC to ASCII?

    HiTechUser, I had previously tried the link to convert ASCII to EBCDIC (and visa versa) from the microsoft support page to no avail. However, the code that you found and posted worked like a charm. I tested and validated the results (the file, which I am getting third hand, has trailer records...
  18. denosaur

    Convert EBCDIC to ASCII?

    I have a fixed width file with multiple 200 byte records that I understand was created on an IBM. The file contains a Zoned Numeric value, which looks like ASCII except for the last byte of the field. The values of the last byte of each field are one of the following characters: {, A, B, C, D...
  19. denosaur

    datagrid in access

    Rizunb, you should be able to select the query that you want to base the form on, click Insert on the menu bar, then select Form. From there, you can try Form Wizard or Autoform: Tabular or Autofrom: Data Sheet. You should be able to play around with those to find something to your liking. I...
  20. denosaur

    How to change Field Description property in a Linked Table

    Consider this... Assume I have a linked table, tblMonthlyRevenuesCurrent, with several columns, account_num and amount. I want the descriptions of the columns to be different. On the Data tab of your form properties dialog, select Record Source and click the ellipsis to the right of the field...

Part and Inventory Search

Back
Top