Search results

I think ive done something like this. I also made a PO db that had a function to see what supplier will be the cheapeast to buy the whole order. But for this the user had to create the purchase Order and enter all the items with some supplier, then press this button that will tell him if that...

Hi Carl, why dont you use a bounded form? It would be really interesting to know why.

In this case yes and use the Table name u used insted of tbl..., you have to use the name you used. If i use those prefix is to diferenciate Controls.

Did you imported the data? or is it linked?, can you please post an image of the table that you have in ms acces, not the one in Excel. All of those you see on Bold are the Name of your control, so they have to be the same depending on what is the name you gave them. Same for fldMealChoice and...

Yes, if you want to have it in the order 1,2,20,30,4001 you will have to have that field (fldNumber) as a Number Type so what boblarson said wont happen. You will have to create a Query of the table and on fldNumber Sort: Ascending and then Link the query to your form insted of the table.

Have you check the Form's module property OrderByOn? if not set it to True

Nice i didnt know that, thx

Lets say your Unique ID (fldID) will be selected from a combo box (cmbID) and the query bounded to the form has fldID in it (SELECT fldID ... ) Have your combo box cmbID Unbounded and on After update event do the following: Private Sub cmbID_AfterUpdate() Me.Recordset.FindFirst "fldID = "...

Whats the idea? so when the user picks lets say from a combo box A0 it will add 10% to the salary?. Or your gradecodes will have value depending a single amount ( x ) gradecode amount A0 = x + 0.1x A1 = x + 0.2x .... B0 = x + 0.1x ..

O i forgot, you have to change txtSearch properties: On Other tab Enter Key Behavior: New Line in Field GL

u can use the KeyPress event. Lets say you press enter when u finished to input data on the search textbox (txtSearch). Having that your button is called cmdSearch, Private Sub txSearch_KeyPress(KeyAscii As Integer) If KeyAscii = 13 Then 'Enter key Call cmdSearch_Click End If...

Hi Sivakis, Theres a solution for this, lets say you Linked Excel Table is named tblMealChoice (Please avoid spaces in field names, you will regret it if u dont) with the fields fldMealType and fldMealChoice, you will have to use VBA and SQL for this. So you have the combo box cmbMealType (the...

Please follow the advice of rainman89 It will save you many headaches in the future, i went trough this and it really does. But i guess sometimes you have to experience it to really realize. If u follow it or not, a solution for this is to make a Combo box with the 3 options you say and on the...

Hi, If ur design is like, tblSubscriber: fldSubscriberID as Pk fldSubscriber .... tblEmail: fldSubscriberID as Fk fldEmail On General properties of fldEmail set Indexed to: Yes (No Duplicates) If its like tblSubscriber: fldSubscriberID as Pk fldSubscriber fldEmail1 fldEmail2 fldEmail3...

If you just have 2 states "Paused" and "NotPaused" you can make it a Boolean field and make something like this SELECT Max(fldPaused), fldAccNumber FROM tbl..... bla bla bla GROUP BY fldAccNumber Having that 0 or False is Not Paused and -1 or True is Paused, you will get the AccNumbers and if...

I have done this, but by looking at your code i can't tell if you really have a User-Password Table. I think it would be better if you create a table (tblUser) with a User (fldUser) Field and Password (fldPassword) using the format that fbsrcchaos says. Then Adding to lagbolt in the custom form...

You can totally make a query like this for the first part SELECT fldText, (fldYesNo1+fldYesNo2+fldYesNo3+...+fldYesNo14)*-1 AS SumOfYes FROM tblTable;

It may be because you didn't wrote the field name correctly on the code. instead of Me.OrderBy = "fldName" maybe you wrote Me.OrderBy = "fdName" You can use on Boolean Types too (True/False, On/Off) if thats what you mean by checkboxes

Hi again, first of all i dont think you should have nulls on your records, please take some time and read this topic: Nulls: Should it ever be meaningful? http://www.access-programmers.co.uk/forums/showthread.php?t=131571 If you don't want to show where the nulls are just add to the filter...

Forms have OrderBy and OrderByOn properties Lets say you want to order by the field: fldName You just need to fill the OrderBy Property to "[fldName]" to sort in acendant order or "[fldName] Desc" to decendant You can also create a button (cmdSort) and on click event: Private Sub...