Search results

Ok I finally figured out what to do For others in the query you would enter something like this: field: [Category]=[forms]![frmIssue]![comboCategory] Or [forms]![frmIssue]![comboCategory] Is Null Criteria: true

I actually have already looked for it in the cascading combos with no luck all the ones that I have found requires data to be entered in order to go to the next combo.

I am having problems with setting up a set of combo boxes. What I am trying to do is if combo Productline is empty then in combo PartNumber would show all products but if combo Productline has a value selected then in the combo partnumber would only be able to select the partnumbers in that...

the data is a string numbers, letters, and dashes

I am setting up some code for a report filter and am having a problem with a between function. I am trying to get it to show partnumbers between a range that is selected by the user this function is at the bottom of the code, when I try to run it ai get the an error message "Syntax error...

I am trying to setup a filtering form in which you have the ability to have multiple reports and from different settings you can have it filter by one or all of the filters. I am slowly getting it setup but I am stuck on the filtering part I have a slight idea of how to do it for just one...

It worked when you mentioned it I couldnt believe I didnt think about it but also I am kind of burnt right now from all the work I have to do (cant wait till 5pm tonight fri!!!) So I can clear my mind for a few days Thanks for your help!!

I am trying to setup a query where all the data related to one item is in line but all I get are sets of blank spaces and shows the main item three different rows with one item that is related to it one three different rows So what I am trying to do is have a column for the part number, front...

Worked like a charm thank you very much !!!!!!!!!!!!!!!!!

Any body???

For me (which I am no expert) I would do something like the DB that I posted before with another form. That would open on the dbl click in which it would show the company and below it the list box of employees.

Next problems 1. Now it wont let me enter info into any of the other text boxes on the form 2. How do I use set the code to do multiple text boxes

Never mind I about my question on setup I figured it out with having the characterlength show up on an not visable text box

Heres my problem I would like to show in the combo the name of the label since most of the people using the db will only know it by the avery label size number. What would you do because also when I change the bound field it works but it wont save because I have the two tables related via the...

Where does the form get what the charactlength is supposed to be? I tried the above code with the characterlength showing and with the label name showing in the combo box but it didnt work.

Ultimately what are you trying to do?? There may be a better way of doing it then two list boxes.

No worries

I set it on the control event in which it said that the macro or function set to the BeforeUpdate or validation property for this field is preventing Access to save the data Ok I see I set the forms event BeforeUpdate and see what you are saying Thanks for the help and insight!!

I had to use the AfterUpdate becuase I had data already entered and when I tried to use the BeforeUpdate it would bring up an error. With the after update it worked without any problems.

I am trying to set up a text box in which if I have a certian item selected in a combo box that it will be able to adjust the amount of characters that can be entered into a text box such as I have a tblLabels In which it has LabelPK LabelSize CharacterLength On the form will have a combo...