Search results

You will need a custom function to calculate this. Are you familiar with VBA?

For the budget figure to be available to the auditors you need to store it. You have not said clearly whether the report is an annual total report or a weekly total report. If an annual total report you dould use a lookup as the source of the field to grab the budget and then in the report do...

Just a follow up question. Is it possible to work with an unknown line count. Or do I go back to working as a string which is not particularly efficent?

I worked it out changed the line ptr2 = Instr(1, mstgrDataContainer, Chr(13)) This causes the string to drop the last character instead of the first character this will do what I need. Thanks for your help it has been well worthwhile

Thanks Wayne, that is very helpful indeed. It is trimming the first letter off each line. I tried altering the line Lines(ptr1) = Mid(mstgrDataContainer, 1, ptr2 - 1) To ptr2-2,etc but it still trims by one letter???

Wayne the more I think about it the more I see I need to detect the carraige feed and see the numbers immediately after it. I can successfully locate the decimal point and the code I have written returns the numbers I need. However, these numbers can range from 0.00 to 999.99. Therefore...

Chr(10) and Chr(13) is what it is. I must be returning too much data. Trimmed statement up and it returns 1.61 fine, I now need to make sure it can return 10.00 as well.

I am a bit further along now this seems to work, sort of strResult = Trim$(Right$(Left$(mstrDataContainer, intN + 2), 5)) Problem is that it is returning a string that looks like: strResult = 7.25 For example. I have tried Trim and other variations to remove this space...

Here is the working bit of the code. Private Sub Form_Open(Cancel As Integer) 'This event sets the sComm1 as the new Scomm 'Connects to comport 1 'Sets the com settings to those recommended by the manufacturer 'Then enables and opens the port Set sComm1 = New SCommDLL.SComm ' then create it...

Sorry Wayne, "prior opening statement"?

A second thought there is a . in every result there is not anywhere else

I have the other bit complete "the what to do with it", had this done for about a year waiting for this device. I have been playing around with the line input idea and get line overflow errors so I ave converted back to trying to parse the results. The biggest problem I have in this is that...

Wayne Yes it buffers, and it is a serial device. I would like to be able to count the lines and then manipulate the data, is this possible? Sorry to ask six million questions but this area is very new for me, and not really covered in any of the books I have.

Thanks for your input guys. The file is being returned from an instrument, so I really don't want to save it. I am going to have a look at using file system object, as it appears the fastest way to manipulate the data.

I am receiving data from an external device into my access application. Whilst the data changes in some ways it is consistant in that the first line returned contains information I need, and the last line contains information I need. The format returned from the input as a string is similar to...

I have made a form to handle not in list events. It works fantastic until I hit a subform. The procedure works by setting properties in the calling form for the the recordsource of the combobox and the field we are trying to add new data too. The newdata and the formname are passed as...

I am attempting to use a partition query to produce an aged equipment report. I set up a mock up attached that explains the problem better. I can get the query to function fine, but suspect there may be instances where the columns may be omitted due to no values returned. I would like to fix...

Thanks for the suggewstion Chris but it is definitely O not zero. I think I know the fault, but do not understand it. It appears the fault is only replicated by using the default label with the text box. If I replace as an unbound label (not attached to text box)probelm ceases but Why???

I have an unbound report that is populated entirely by code. I have this working but was playing around optimising it to cut the redundant loops out of the code and making it a bit more efficent, for slower machines. The report is structured like: lbl1 txt1 lblO1 tt1 lbl2 txt2 lblO2...

Yes I requery. I had not thought making the form visible first, I have to go to work now, but will try tonight. Attached is a text file of my client class. To use it I would set in the form: Dim objclient as new clsClient with objClient .clientID=me.openargs(or something)...