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: *

  • Users: haerion
  • Content: Threads
  • Order by date
  1. haerion

    Input new form value on main form

    Hi Guys, I have a vba code which need a value I need to select from another form. What I wanna do is click on a command on my main form that will open a form which have an option group command, then the user select the option he needs, click the ok button then the form close and the code...
  2. haerion

    Error saying my subform is empty when it is not

    Hi guys, I was just wondering if someone could help me on that: I got a form which have a subform on it, and when I click on a command, it take the info on my subform and copy it in another program, problem is sometime, even if I have 1 or more line in my subform, it give me the no entry...
  3. haerion

    Trying to simplify my coding

    Hi all, I'm having difficulty to simplify my coding. It is on a command button which is making a new line in my table then go to this line on my form. This action take 7-8 seconds and I'm trying to reduce that as much as possible. Here is the code: Private Sub cmdNewTicket_Click()...
  4. haerion

    Work on my comp, but not on another computer

    Hi all, I got a query that work on my computer, but when I tried to send the file to a coworker, then the qry was not working. Here is the sql of the query: SELECT INVDFR2.ST, INVDFR2.ITEMNO1, INVDFR2.DESC1, INVDFR2.DESC2, INVDFR2.PRO, INVDFR2.LSTCOST, INVDFR2.AVGCOST, INVDFR2.[$EIGHT] FROM...
  5. haerion

    A simple code that only work 1/2 the time

    Hi all, I am having some weird problem here. i got the following code, but for some reason, sometime it doesn't work and sometime it does. I was unable to find a pathern as to why it doesn't work sometime. Here is the code: Private Sub Itemno_Change() On Error GoTo err_itemnoChange Me.Desc1...
  6. haerion

    Wait on connection to continue macro

    Hi all, Here is my problem: I got a NITERM32 (terminal base program) that I need to open from my form. Once it is open, I need to open a connection, then enter my user/password. If I use wait in the macro it work 50% of the time with a 6s wait. The problem is sometime the connection is REALLY...
  7. haerion

    copy from access to another program

    Hi all, I was wondering if this was possible to control another program from an access form. More exactly, it would be like this: Copy textbox1 from access Go into the other program Paste the textbox1 do enter 3 time (to go to another field in the program) copy textbox2 from access Go into the...
  8. haerion

    STDEV on multiple column from same line

    Hi all, Was wondering if it is possible to do a STDEV on 12 column of the same line instead of doing a group one of the same column. I have 12 column, each of them being a month, from Jan to Dec, and I need to make a STDEV out of this. Thanks for your help! Haerion
  9. haerion

    Aligned text on right in list box?

    Hi all, I'm trying to get my number on the right in my text box since they are money amount, being on the left seem a little weird, by default it is on the left and in the property, I can't seem to find the aligned property. Can it be done through VBA or did I missed something there? Thanks...
  10. haerion

    Max of 12 column on the 13th one

    Hi all, I'm trying to get a query that would give me the max number of the 12 column on the same row. These column are the 12 month and the number are the sold item for each month. Each row representing a different product. I want it like this: Item Jan Feb Mar Apr May Highest...
  11. haerion

    Incorrect iif statement, need some correction

    Hi all, I'm trying to get an iif statement that would give me back all the data that got 1 or 600, if the "1-600" is selected, 299 or 999 if the "désuet" is selected and check in the txtCat if neither is selected to get the number inside the textbox. If i put 600 its work, but if i try 600 or...
  12. haerion

    IIf statement into query criteria problem

    Hi guys, I'm trying to run a query that would take all the data that got > of a txtbox(txtOH) on my form or = of this same txtbox. The > or = are on an option group (chkOH) with value 1 for > and value 2 for =. If I try it like this: IIf([forms]![Main Form Info]![chkOH]=1,>[forms]![Main Form...
  13. haerion

    Message to know that program is updating!

    Hi all, I'm trying to get a message(Updating, please wait!) on my form while access is running a macro on excel that is a on open macro. The macro is working fine for excel, but I don't get anything in access to tell me that the program is doing a macro, and the message only appear at the end...
  14. haerion

    how to stop the parameter from appearing

    Hi all, I'm getting some problem when I try to do a cross reference that need a parameter that is an option group on the form, my sql is like this: PARAMETERS [Forms]![ordersplitting]![chkweekday] Long; TRANSFORM First([Vendor-Store-Status].Status) AS PremierDeStatus SELECT...
  15. haerion

    Error in the code, need some insight!

    Hi all, I'm trying to get a sql to work in code, but there is a mistake somewhere in the code, can't find what i need to change for it to work, here is the code: strsql = "SELECT [PO Header].Vendor, [PO Detail].Part, [PO Detail].Transfert1, [PO Detail].TrsfStore, [PO Detail].Order1, [PO...
  16. haerion

    Concatenate lines in a query to one line

    Hi all, I am trying to figure out how I could put the result of a query into a subject in a concatenate way. Exemple: query1 PO Supplier 1256 46 4587 46 8945 46 So the subject line would be "PO 1256-4587-8945" I don't know enough coding to make this work, but I'm sure it can be...
  17. haerion

    Sent a report showing directly on the mail

    Hi all, I have the following problem, I need to send Purchased Order by mail which take the info from a query named "Query to Mail by Vendor" and containing the following information: PO Address to ship Address to bill line info (qty, item, price) Buyer The thing is that I want it directly on...
  18. haerion

    count at 0 when no value

    Hi all, was wondering if there is a way to get a count of zero to appear in a qeury like this: SELECT [PO Query].VendorNo, Count([PO Query].VendorNo) AS CountOfVendorNo FROM [PO Query] GROUP BY [PO Query].VendorNo, [PO Query].[Store#] HAVING ((([PO...
  19. haerion

    Count number of subgroups in a group

    Hi all, I have a group that is set by Supplier, and a subgroup that bind together all the PO for this supplier, the problem is that i need to put a count on the supplier header of how many PO there is in it, but since the PO are group because the table have all the items in each PO, I want it to...
  20. haerion

    number to start from the last one entered and autonumber the rest

    Hi all, I'm trying to get a column in my query to start from the last number in one of my table do a +1 on each line in the query, that is gonna be append to this same table, here is the code if I just choose the last number for each row: INSERT INTO [PO Header] ( AccessID, Vendor, [Date]...

Part and Inventory Search

Back
Top