Search results

my bad...I thought you were taking it as the two textboxes were being calculated together.

but...what if the refund amt is left blank? I think it would help. plus if I make a query, I can just use the checkbox, rather than the two textboxes. seems to make things easier for me.

chkbox...to show that it has been received.

Would the code be If intBoxA And intBoxB = 0 Then... ?

there is not calculation. BoxA is a Refund Amt and BoxB is a received date. I was thinking the code would go in the AfterUpdate for the Form. Good spot?

I don't know code very well...go easy on me. How would I code something like this... I have a checkbox that needs to be checked when BoxA and BoxB are not 0 or null. I'm pretty sure how to do it if it was just Box A, but two I'm a little lost. I don't think I need two If statements. Thanks...

everytime i try to tab from my subform, it creates a new record for that subform. Also, about the subform, the control that links the main form and sub form is unique. I have now set my Cycle property on my subforms and forms to Current Record. How can I tab from the subform to the main form...

I've tried the post of godofhell but nothing is happening. textbox - curCLcost chkbox - chkCLrec lagbolt...what is Nz? I'm not very good with code...so please be kind. :) Thanks!

I'm guessing that this will take coding and I don't know coding very well. I have 4 categories...I'll call them A B C D. For each category, there is 3 text boxes, EX: A Cost, A Refund, A Rec Date I will have a checkbox for when each is rec. but not all accounts will have every category(A, B...

All I did was link the spreadsheet to the database, then created the form through the Form Wizard. Also tried through design view but the same thing is happening. I do have relationships with 2 other tables. When I created the relationship (dragging field from one table to the other) it said...

When I create a form, it will not allow me to edit or add or delete. I can only view it. Allow Edits, Additions, Deletions, FIlters are all set to yes. Also Recordset Type is not set to Snapshot. Could someone help with this? Thanks!

windows 2000 here too. when i create one, it comes up with "Output Options" under The datasource name i put the location of my database. perhaps this is an area where i'm possibly doing somehting wrong.

I do use those prefixes (tbl, qry, dap, frm etc etc) It makes it easier to know what is what w/o looking to the left to see if your in tables, query, or whatever. plus i do think it makes it look more professional, but that's just my opinion.

open it with Internet Explorer right click it Open with... browse for internet explorer that should work. did for me.

not really. I did export the query as an ASP(active server page). I was going to make a link to the ASP on the DAP. It did work...sorta. The page came up with a table and the headings that i wanted but it didn't have the results. It was like it wasn't connected to the database. That's the...

can i use a macro on a data access page to find a certain record? or is there another way i can search for a specific record? thanks

i see iis on my computer. how do i place it on a webserver w/iis?

I have over 11489 recs in my table but my dap only shows 10000. coudl someone help? btw...all 11489 were created b4 the dap was created.

sorry...but what is IIS

how can i edit the page? through access?