Search results

Thank you guys, I dint think of that, ill give it a try and let you know on Monday

Hi Adam I figured this is an odd scenario, I apologize this is my 1st DB but to answer your questions My form is saving datat to the cases table The table cases has all of our production and we have 3 guys assigning cases cases numbers are unique to avoid a report showing the same case...

Hi guys, I'm stuck trying to solve this:banghead:, I have a form to entry data for daily production this data goes to a table called Cases, the table cases doesn't allow duplicate case numbers so far so good. Now I have a combobox with values A B and C and I need to be able to save the data...

Re: Conditionally present a Drop down list Hi, I got it working, just added teh other 2 selection posibilities: (((Cases.[Asigned Date]) Between [Forms]![Cases Report]![From] And [Forms]![Cases Report]![to]) AND ((Cases.Severity)=[Forms]![Cases Report]![Combo7]) AND...

Re: Conditionally present a Drop down list Thank you that did it, but it now I have another question sorry, I added the same code to the managers combobox also and It works only when I select "all" on both comboxes If I want to do a search for All severity for a single manager I'm getting a...

Re: Conditionally present a Drop down list Ill scramble the names and upload it on Monday, it wll be a lot easier since I lack the vocabulary. Thanks a lot and enjoy your weekend.

Re: Conditionally present a Drop down list dates Between [Forms]![Cases Report]![From] And [Forms]![Cases Report]![to] Severity [Forms]![Cases Report]![Combo7] manager [Forms]![Cases Report]![Combo9] Is this it? Sorry I'm new at this

Re: Conditionally present a Drop down list By selecting one letter at the time

Hi guys, I have a question with comboboxes I have "combo7" with 3 option A B and C, I added an "All" option with UNION SELECT "<All>" But now I'm stuck on how to process that "all" selection, I got this so far Private Sub YourCombobox_AfterUpdate() If Me.Combo7= "<All>" Then and Im...

How about making it visible instead ? If field1 = "Customer" Then Me.field2.Visible = True Else Me.field2.Visible = False End If

My friend you are a genious, Thank you very much!!!!!!!

Thi is whats happening on the table when I select Other

thanks theDBguy Here is the thing by default the data from topic is saved on the cases table under the topic field. What I need is, when "other" is selected de data from the define textbox is the one saved on the table instead of the one from topic.

Hi guys, I'm trying to create a data entry form based on comboboxes, and Im having a really hard time finding a solution for this, I apologize in advance for my lack of vocabulrry but Im new to access. Here is the situation I have a combobox named "Topic" with 5 values, when I hit save all the...

Hi Guys, I just started working with access with a small case handeling DB for my job hehe For the moment I do have a lot of questions :banghead: and I'll really appreciate any help that you can provide. Hopefully Ill be able to also help others soon. :D