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 derfloh 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. KrissyB

    SendObject will not repeat

    I am developing a macro that creates a table based on certain criteria entered by the user. Then this table is emailed in .xls format. I want to be able to run this macro via a button (I've already made) more then once in a row. HOwever, when I try to run it a second time it gives me an error...
  2. KrissyB

    Macro Will Not Rerun

    I have built a switchboard that contains 4 buttons, each that runs a different query. I want one of the buttons to be rerun as many times as the user needs to utilize it. However, at the current time, I run the macro, it performs, then reverts to switchboard (perfect) but will not let me run it...
  3. KrissyB

    Trouble Opening Form the correct size

    Hi! i was wondering if anyone could lend a hand on how, when the form is opened, to sepcify its size? it keeps maximizing but I want it to leave another application visible. Also, is there a way to open the form while leaving the access backend invisible? It is a simple application for creating...
  4. KrissyB

    'Can anyone tell me why the followi

    The type mismatch error is on the very first line. Could it have something to do with DAO.ADO specifics? Chris
  5. KrissyB

    Type mismatch Error???

    Jeff I am still a bit confused about the ADO DOA business, I know that I believe my version will support both. Is this line ADO or DOA DoCmd.OpenQuery "QUERY_APPENDCHP_LOAD_POA_STATUS", acNormal, acEdit and if I am currently using DOA how would I declare the recordset this way...
  6. KrissyB

    Type mismatch Error???

    ...DoCmd.OpenQuery "copyappending", acNormal, acEdit DoCmd.SendObject acTable, "Publisher Data", "MicrosoftExcel(*.xls)", "cbotham@indigo.ca", "", "", "", "", False, "" End If 'Will...
  7. KrissyB

    'Can anyone tell me why the followi

    Thanks again for your help..still having the hardest time with this but I guess It'll come with time. THANKS
  8. KrissyB

    'Can anyone tell me why the followi

    ...On Error GoTo Proc_MacroModuleQueryTest_DONT_USE_Err Dim RS As New ADODB.Recordset Set RS = CurrentDb.OpenRecordset("SELECT * FROM INVUPC;") ' This Query Clears the Table POATEST, so that we can obtain data from POA reports specific to DBQ DoCmd.OpenQuery...
  9. KrissyB

    'Can anyone tell me why the followi

    Hi again OK so kinda like this? Dim rs as New Recordset(do I have to put ADODB.Recordset?) then Set rs = CurrentDb.OpenRecordSet (Select Supplier, UPC from INVUPC;") Then If rs!Supplier = ..and so on?
  10. KrissyB

    'Can anyone tell me why the followi

    ...DoCmd.OpenQuery "copyappending", acNormal, acEdit DoCmd.SendObject acTable, "Publisher Data", "MicrosoftExcel(*.xls)", "cbotham@indigo.ca", "", "", "", "", False, "" End If 'Will...
  11. KrissyB

    Hi The following code is giving

    Thanks Michael, never even occurred to me! ;)
  12. KrissyB

    SendTo Conditional command??????

    Thanks you Bill for your suggestion. I should have explained that I am trying to generate this conidtion because I have many many Supplier that could possible be dealt with. I was hoping to use an If, Else if format, but was unsure if I could do this with a DoCmd. Thanks
  13. KrissyB

    Hi The following code is giving

    ...Option Explicit Private Sub Command0_Click() DoCmd.SetWarnings False Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("Select * from INVUPC;") If rs!Supplier = 8303 Then DoCmd.OpenQuery ("QUERYVENDOR8303"), acNormal, acEdit DoCmd.SendObject acTable...
  14. KrissyB

    SendTo Conditional command??????

    ..."QUERY_APPENDINGTOPUBLISHERDATA", acNormal, acEdit DoCmd.SendObject acTable, "Publisher Data", "MicrosoftExcel(*.xls)", "cbotham@indigo.ca", "", "", "", "", False, "" MacroModuleQueryTest_Exit...
  15. KrissyB

    Getting a simple condition to work

    Hi, I am trying to build a macro and utilize a condition. I have not used these before but think it would be super helpful to me. I am running a query called QrySUPPLIER thats builds the table tblPRODUCTS with the fields UPC, Retal,....,Supplier. However I want the macro condition to be run...
  16. KrissyB

    Please Help! Make-table loop?

    Sure Jim. I'm at cbotham@indigo.ca Would be fantastic! Thanks for your continued help! Christine
  17. KrissyB

    Please Help! Make-table loop?

    OK here goes. I have a million P.O's and these are the ones that include Invalid UPC's. I need to send each vendors its own UPCs, via a template we have for the vendors. It is not really for me, its a means to gain the information on these UPC's from the vendors. So unfortunately it is...
  18. KrissyB

    Output data that is not null

    Thanks Jim, i was unfamiliar with either of these commands, but will take a look around!
  19. KrissyB

    Please Help! Make-table loop?

    Thanks so much for your help on this thus far... I have been working with this in Access and have had no luck yet but will definitely keep trying. If I could get this to work the user app would be soo much easier! Thanks again!
  20. KrissyB

    Output data that is not null

    Thanks for your help. The problem is I am a dunce when it comes to VBA and cannot expect the user to do a select count for each table. Currently the macro pulls vendors information from a master table of products and splits these into 122 tables. One for each vendor. The macro then sends these...

Part and Inventory Search

Back
Top