Search results

Oh i see that now thanks for all the help!

Thanks for all the help and the parentheses worked. If Not (Me.ComboBillable = "Yes" Or Me.ComboBillable = "No") Then MsgBox "You must choose an Appropriate Billing Option" Me.ComboBillable.BorderColor = RGB(255, 0, 0) Me.ComboBillable.SetFocus Exit Sub End If Any...

Thanks, I figured it was something like that; however, this doesn't work either. If Me.ComboBillable <> "Yes" Or Me.ComboBillable <> "No" Then MsgBox "You must choose an Appropriate Billing Option" Me.ComboBillable.BorderColor = RGB(255, 0, 0) Me.ComboBillable.SetFocus Exit Sub...

Why don't both of these pieces of code work, when I enter No into the combo box? :banghead: This code works. If Me.ComboBillable = "Yes" Or Me.ComboBillable = "No" Then Else MsgBox "You must choose an Appropriate Billing Option" Me.ComboBillable.BorderColor = RGB(255, 0, 0)...

and thanks for introducing me to the switch function, i used it in that new form i created, to view the vba press Alt F11

Rehanemis, I modified your database, take a look at the new form i created.

Rehanemis, I remember when i was where you are with access, it wasn't that long ago. This is what i have learned: Wait awhile until you start using bound forms, try to make forms with the controls populated by vba code. (Nothing was more frustrating than figuring out bound forms) I tried...

I'm sorry but i don't see an attached file.

I'm not familiar with the Switch Statement. Can you upload your database file?

It seems like you give bonuses for sales in certain tiers, regardless of experience. Everyone gets a bonus for $250 - $349, $350 - $449 ... even though the bonus percentages change based on experience. So, if you have a control, textSalesAmount on a form and a control, textBonusPercent. You...

rehanemis did you mean to write this? Table 1 ID Name Amount 1 a 0 34 b 0 3 ab 0 table 2 ID Name Amount 1 a 400 34 b 900 3 ab 4500 if so try this in SQL view (either way even if they have...

I'm still a n00b so dont trust me but i think you can't store a number like 9.0 as a number data type -- it will drop the .0 after the 9. To store the number as "9.0" i think you need to use short text.

Can anyone tell me why this code didn't work when the iif function is true? IIf(IsNull([Forms]![FormName]![FormControl]),"" Or Is Null,[Forms]![FormName]![FormControl]) Shouldn't the query criteria be read as "" Or Is Null in that case?

Thanks, I can't believe it was that easy. [Forms]![myform]![myControl] OR [Forms]![myForm]![myControl] Is Null

I want the Query Criteria to pull its value from a control on a form. The form control either has data or is null. (My problems occur when the form control is Null) The field in the table either has data, is null or is blank. This is what im trying to get to work...

I fixed it, i dont know why i added an equals sign but once it took it out it worked UpdateSDS.AddNew UpdateSDS.Fields("filedata").LoadFromFile filepathSDS '<--------This line here UpdateSDS.Update

I'm trying to add an attachment to a field "SDS" in my table "ChemicalLibrary" When I'm adding a completely new record to the table it works perfectly (the first half of the code below). My problem arises when I'm trying to update a record in the table and add an attachment. Below I'm trying to...