Search results for query: *

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

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

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()...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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]...