Search results

Got it working. I removed the ItemData. Thanks for the heads up :) rst!MachineModel = List0.Column(0, (i)) rst!SerialNumber = List0.Column(1, (i)) rst.Update

Defo set as "Extended" otherwise wouldn't be able to do multi select in list box.

Hello :) I've just tried it but for some reason If I do a multiple select in my List0 box it only copies the first record to the table, nothing else i.e.If I select 3 unique records, it will copy 3 lots of the first highligted record?

Hello, It is a string made up of 7 characters :)

Hello, I am trying to move a record from Listbox0 on my form (containing 2 columns MachineModel and SerialNumber) into tb_machines1. In the code below, it works for rst!MachineModel but it does not for SerialNumber. Could someone please help me correct the code in bold below so it works ...

Hi, A simple bit of code below, but P1,D1 and A1 are all input textboxes on my form. Problem is my form has a range of P1 to P30. Is there a simpler way of doing a loop with the code below rather than copy / pasting it 30 times... ? Thanks! If P1 = "" Then D1.Enabled = False...

Hello Paul, so the bit of code that does the magic is as below. Now, thanks to your earlier advice this bit works fine now to calculate planned inventory for 1 item number. As can be seen, it's a simple ExpectedQTY decrement or increment counter.. if the TransType is + , the value of 'y' will...

Thankyou Pbaldy. That worked a treat! I still have one more problem. I am looping trough my recordset line by line. I have a recordset column called 'inventory' or (rs!inventory). I want to be able to compare the current inventory value with the count from the previous record. If they don't...

Hi All, In my form, I have a simple equation, but i can't get the output 'y' to work. The TransType will either return + or - in a loop process and values x and PlannedQTY are read from Textboxes on my form. The equation i have so far is y = "" & x & "" & TransType & "" & PlannedQTY ""...

Hi All, I am trying to write a delete query that must have 2 conditions met before it removes the record from the table tblPO. P1 and L1 values are read from textboxes on my form, and only display values if a record in my table contains them. I would select my record from a listbox to populate...

Gotcha... thank-you. will try out tomorrow

Hi bob, thanks for this. Please advise how I call/ use this using a textbox as my input.

Hi there, sorry but that would not work for me. You see i am creating a live Pass through Query in SQL from code in my form , and the only condition that changes would be the range of production orders i put in my WHERE clause. so for e.g. If i entered 111222 in my textbox the output would...

Hi All, I have a textbox called on my form called Prod. A user can enter a string of production orders separated by a comma int this text box for e.g he/she could enter 111222,111223,111224 From this i want to be able to create a string output in a second textbox in the format (prod =...

Hi all, i wonder if you can help me out with a little problem. A table that stores order history on our ERP system at work stores the time as seconds past midnight. On that basis, in VBA code, how would i express the number 60915 as hh:mm:ss thanks.

I sorted it. Dim varItem As Variant Dim strItem As String Dim ctl as object Set ctl = Me!List1 For Each varItem In ctl.ItemsSelected strItem = ctl.Column(1, varItem) (delete routine) Next varItem

Dear all, I have a list box on my form which loads data from a table. The table has a unique autonumber field, let’s call it “refno”, I am trying to get a multiple select and delete to work. I am playing with the code below, assigned to a button. It doesn’t work and I can’t figure out why...

yes you are missing something, but that's my fault. Please let me clarify. Basically, i need to fire off 10 to 20 drawings off in sequence to separate supplier email addresses, and i want to get Access to do the work of fetching the drawing from the server (using a html link), saving the web...

Hi all, Is it possible to automate the saving of a pdf in an open internet explorer webpage using Access Vba? I am using. Dim IE Set IE = CreateObject("internetexplorer.application") With IE .Navigate http://mycompxxx.com/bin/portal_view_doc?DRAWING_NO=1234 Do Until IE.ReadyState = 4...

Hi Guys, i have Access 2007 and 2003 loaded on the same machine, although i do use Acc2007, i still prefer to write my apps using the 2003 version, as i'm old fashioned! But i have a compatibility issue thats doing my head in - In principle both versions work ok, but the function Dim...