Search results

Ah, that one did it :D Thanks for the help Bat17!

I'm getting this error "Expected: =" as soon as i tried StdRow1Enabled (1,False)

I'm actually using a single unbound form, due to some limitations for continuous form.

Ok basically what i want is for a field to be visible or not visible base on a certain condition. I'm able to do this but the problem comes when i'm trying to maintain 6 rows with each row containing 5 textboxes. I'm trying to make it easier to perform any modifications. This is how i call it...

Hi, how do i simplify this function? I tried substituting the value 1 so it becomes like this but i get the "Expected: end of statement" error. Can anyone help? Thanks Function StdRow1Enabled(Value As String) Forms!F_ReceivingStandardParts!subform1.Form!txtBalQty1b.Enabled = Value End...

Yes i tried it with a new data entry, but i think the controlsource is overriding the default value. I just tried something, i created two text boxes on top one another under bal qty, one not visible and one visible so when it's in the 2nd record the 2nd text box which refers to the totalbal...

I'm wondering if it's possible to have two text boxes called Date1 and Date2 and these two box will have the value of two separate records in a single view form. I've tried this SQL limit function which limits the rows that i want but it doesn't seem to be working under access. Basically i need...

That doesn't work either it's still retaining the original value.

Thanks for the help but i'm getting an error that says it can't assign a value to this object. You see my bal qty field auto calculates from rec qty and oqty. The values in balqty and totalbal are not saved in the db. Here are my control source for the two text box [balQty]...

I tried searching the samples forum but i can't find any of your post. By any chance do you still have the samples? I really need to know how to do it. Thanks

Hi, i've attached an image so it would be easier for you guys to understand my problem. I'm currently using continuous form to display my records and my problem is that i would like to have the second field in my "Rec Qty" column to retrieve the value from the first field of the Total Bal column...

Please help me guys, basically i'm having a problem appending a a date value from a subform into a table. My master form "F_ReceivingProcessParts" is running this query "Q_ReceivingDetailSub" from a button command using "DoCmd.OpenQuery "Q_ReceivingDetailSub"". Here is my SQL code for your...