Recent content by markey

Moniker: Thanks, I'm looking at it and trying to figure out how to apply the logic to my db. CPREMO: Thank you as well.... Q1. Will any data be entered or edited in the ODBC tbl1 table? A1: No, tbl1 is autolinked to a SQL database. All fields dump into tbl1. Q2. Does the data in the ODBC tbl1...

Thanks, may I ask for additional help Thanks, this all makes sense. Can I ask for your advice on overall design? I've got a table from an ODBC (tbl1). I created another table with additional fields (tbl2). Both have a common field Employee ID (EmpID). I need to create a form that has combo...

Thanks, may I ask for additional help Thanks, this all makes sense. Can I ask for your advice on overall design? I've got a table from an ODBC (tbl1). I created another table with additional fields (tbl2). Both have a common field Employee ID (EmpID). I need to create a form that has combo...

I've got an issue I can't seem to get around. I've got a linked table from an ODBC (tbl_1). I then have a make-table query (qry_1) that takes the fields, formats them, and creates a static table (tbl_2). I then have a one-to-many relationship between tbl_2 and another table (tbl_3). When I try...

Re: Thread Thanks, this looks like it will work and makes a lot of sense, but it also appears to be pretty in depth. Due to the nature of my data, I'd have to code each individual field to export to excel. I'm looking for more of a quick fix. How about a snapshot? Or, do you know how to print...

Access 2003 Hello. Hope this makes sense. I have an unbound form with unbound fields/values. This form is a calculator created in vb and I have no tables or queries associated with any of the data entered etc. When the user enters data into the various fields, I want them to be able to click a...

A big THANKS to the both of you. Thank you Oklay for cleaning it up, and thank you to ajetrumpet for providing the initial code/logic. It appears to be working 100%, and now I can work on the finishing touches and push this thing out. Thanks Again!!!

This is starting to make sense, but now I'm getting another problem Thank you for the response. It looks like this is going to work, but I get the following error ("Compile Error: Expected Expression"). If I remove the "and" in the Case Statements, it gets rid of the red, but I still get the...

Reply Sorry, the code provided above was just an example and not related to this project. For this project, the attatchment was for illustration purposes as to how the "Potential Payout" is calculated. I've attatched a new illustration. The user enter a value in txtWeeklyPts1 and based on the...

I'm not sure if an "IF or WITH" statement would be best for this situation. If so, can someone get me started on the right foot please. Here is code I used for a similar scenario: With Me.txtA8bonus .Value = IIf(Me.txtA8 <= 69.99, 0, _ IIf(Me.txtA8 <= 79.99, 20, _ IIf(Me.txtA8 <=...

Hello all, I'm stumped on this one. Hoping someone can provide logic and/or code for the attatched grid. I have two text boxes (txtWeeklyPts1 & txtPotentialPayout1) on a form in Access 2003..... all unbound. fyi: The entire calculator is coded in VB This is how the calculator should work: ie...

Thanks!!! Thanks for the response. This makes sense. I'll give it a shot. Thanks for your input!

I have a question..... hopefully a simple one. How do you Sum a series of unbound text boxes on a form without manually having to enter each textbox name etc. Example: I have a series of text boxes::: txtTBASS1bonus, txtTBASS2bonus, txtTBASS3bonus... through 25 txtRTF1bonus, txtRTF2bonus...

Thanks!!!!!!! Thanks!!!!!! This worked like a charm. Thanks to everyone else for all the great responses. I appreciate it

I'll admit I'm a newb.....any help is much appreciated. I'm getting "else without if" errors. I know this is self explanitory, but I'm still not getting it after trying multiple variations. txtTBASS1 is a text box on a form (frmService) txtTBASS1pts is a text box on a form (frmService) Here...