Search results for query: *

thanks much guys, worked like a charm ... :)

sorry, in my previous post I posted the correct error message but the wrong highlited line, it's the following : Set rst = Me.tblINVOICEDETAIL_Subform.Form.RecordsetClone

i commented out the ".Edit" and now I get the following error : run time error 13, type mismatch, with the following line of code highlited : Set rs = db.OpenRecordset("tblINVOICEDETAIL", dbOpenDynaset)

I have a form called : tblINVOICE which contains a field called PRICERATIO. I also have a subform called : tblINVOICEDETAIL Subform with fields called PURCHASEWEIGHT, PRICE, BOATPRICE, and AMOUNT. I have written this code(below) to calculate what the BOATPRICE and AMOUNT's are for each record...

for some reason the nz function still yields an #Error. This error only happens when the field I reference in the subform contains no records. The subform is derived from a query.

thanks much, worked like a charm. I have made an update query which worked ok as well, but it was annoying to have to confirm the update when the update query executed.

I have an order/invoice system which consists of a form with a subform. General information such as client name, date and invoice number are found in the main form, and the subform contains the items ordered along with quantity ordered and quantity shipped. My question is this. I would like...

textbox is on main form. =[qryTRANSFER subform].Form!SumOfWALLEYETRANSFER

Hi Everyone ! Happy Holidays ... I have an access form which has in particular a textbox and subform. The subform is comprised from a query, and the textbox references a field in the subform. Everything works fine, until at which time I have no results in the subform, and the textbox gives me...

I have researched a bit through this forum and others about checksums. From what I gather, a checksum is a summation of bytes using the xor function, and is used as a 'check' so to speak to verify that data is valid. The below lines of code are in hex format and each have a checksum I believe...

I would rather have unfilled orders show up as 0's for quantity shipped until point of shipping. I have been able to have the quantity shipped=quantity ordered when quantity shipped is double clicked. But I have to double click each item in the invoice that needs to be filled. I want to click...

Hi all ! I have on order/invoice dbase in access. Our invoice form has a subform, which contains the quantity ordered and quantity shipped fields. Most of the time there are no changes, and the quatity ordered = quantity shipped. I would like to place a command button on my invoice form...

I'm in a small office with only 5 computers, so i'm using the server for day to day data entry and other activities. I have managed to setup pcanywhere 11.0 on this server as a host behind my smc router without much difficulty. However, I don't like the fact that the remote control feature...

got it figured out... use cdec("&H" & vartoconvertodecimal) thanx anyways

how do you convert back to decimal from hex ? i don't believe there is a Dec function...

I am aware of the ltrim, rtrim and trim functions. But I would like to remove any spaces inside a string. Any ideas ?

thanks, it worked after compiling it.

i have a text box which diplays a result from a function. I would like to copy and paste this result. Trouble is, i need the textbox to be locked, and during run time when result is displayed, if I copy and paste into notepad results in a display of the code for the function instead of the...

why is it that when i copy and paste a textbox which has been locked, all that is pasted is the formula or subroutine which gives the value of the text box instead of just the value of the text box

Sorry about this dumb question, but this is the first time I have used the package and deployment wizard to make insallation files for a program I have devised which uses the com port. Why do I get the following error when trying to run a compiled program on a computer without visual basic ...