Search results

gg you can also use instead of DoCmd.Requery "combo_box" the following combo_box.Requery

Thats fast, i edited my post above, see if some of that helps u. Is you combobox bounded? Are you trying to store the same description of other records on new records?

Why are u using DISTINCT for a primary key? If you want to show the Description value but Store the [Primary Key] value you properties must be set like Column Count..... 2 Column Widths.... 0 Bound Column..... 1 Limit to list must be set to Yes Use the NotInList event of your combobox if you...

What i understand from what u r saying is that you want to display the new seminars you added in SeminarsCombo without having to close and reopen. You said u searched for requery, Have you tried this on SeminarsCombo got focus event?? SeminarsCombo.Requery

You can use the Filter Property i.e. Filter.... [Inactive] = 0 ' to show the Active records Remember you must have the FilterOn property True

I just discovered i had stuff in the OrderBy Property, (the missing field). I went to the users machine to edit the program and discovered that: Access 2007 forms has 2 new properties Filter On Load, OrderBy On Load Since by default they are set "Yes" it asked for the parameter. Moral of the...

Well the title pretty much the tittle says what happens. The users using access 2007 will get this "Enter Parameter Value" inputbox, but the 2003 users donut. I know that when you get an "Enter Parameter Value" is a problem in the record source of ur forms or subforms which i couldn't find...

i think you don't need to use a Where clause in ur subform Record source Use the Link Child Fields and Link Master Fields properties of the subform object. Link Child Fields.... ClientID Link Master Fields. ClientID

Thanks again, What i understand from what u r saying using or 'declaring' 100 for a textbox its the same as 255 and better that a Memo field in terms of system resources?

thanks for the replys, i was thinking of using text fields with 100 characters not memo fields. Should i change it them to memo?????

Thanks docman, btw before i posted i've already searched using some of the keywords that u r suggesting but all i found was Topics about if its better to split a table in two because it had lots of records. I don't have any security issues so i wont split it. Thanks

I have several number type fields which i would like them to be equal to 0 each time the user erases (uses BackSpace) to clear it. What im doing is the following: Private Sub txtBurden_AfterUpdate() If IsNull(txtBurden) Then txtBurden = 0 End If End Sub My issue here is that i have to do...

I was thinking in the long run, I don't really know how it works when you pull data from the server in an Access BE, when u run a query even though you are selecting less fields, does it actually Pull all the table to the user pc and only shows u the one u selected? Or does it pull only the...

thanks for the reply! however i would like them to go to the next record if the combo box has the focus. So while the combobox has the focus: if the user presses DownKey then go to next record. If he presses ATl+DownKey then dropdown If it is dropeddown and presses DownKey go to next item in...

I have this on forms keydown event: Select Case KeyCode Case vbKeyDown ' Go to next record End Select But when a combo box has the focus and the user just wants to dropdown it using Alt+DownArrow . It will take him to the next record. And when he wants to go tru the combo box options using...

Hi, I have a well normalized data base with a table with 20 Fields. Since on my queries i will be using most of the time just 5 fields of it, should i split my table into two 1 to 1 tables? since I've never done this, which will be the best way to do so?

I'm sorry if its a bad idea to bump and ages old treat, i don't know either if this was answered someday. I had this problem and i have a kind of solution of this. I created a Module (modFrmRecNav) with these sub procedures Option Compare Database Option Explicit 'Facitlitates the navigations of...

Hi, i had this problem before, I really dont know if theres a way to show the inactive data in the Combo box But i did a workarround to the problem. The idea is to have a textbox on the combobox Add to your form's recordsource the TreatmentName Bound your textbox with the TreatmentName and...

For Problem2: I've never never experienced something like that but looking at how Quick Books works maybe this approach would be better: You will have to have 3 tables, tblItem, tblSellItem, tblGroupItem tblItem fldItemID as PK - fldItem as Text - fldPrice as Currency - ... 1 - Candy - $0.3 -...

Hi there, for Problem 1: From what i see (correct me if I'm wrong) your db is not well normalized. Please take the time to normalize it since it will be a real pain in the future (I've experienced this) to maintain this db. I see that your Orders table has OrdersTable OrderNumber as Number -...