Search results

I've been struggling several time with this problem and apparently its driving me a little crazy: i have this code Private Sub CodeNumber_DblClick(Cancel As Integer) DoCmd.OpenForm "Products", , , _ "[products.codenumber]=" & "'" & Me.CodeNumber & "'" End Sub I cannot understand why...

quick question: in a criteria i need to set a code than even the slightest amount of letters return a search. for example in the "Description" column: "Dell Inspirion D5000" Lets say a user writes 'pirion' in the criteria. All the records with those letters will return a search. I tried 'like...

In a stock form i have set apart a text box with row source connected to a table/query to display all the 'code numbers' available. I used the following code to display a search: Private Sub cmdsearch_Click() Dim reference As String Dim strSearch As String If IsNull(Me![txtsearch])...

on event of a yes/no button if me.object 1 then unitsection = 0# else if me.object 1 then unitsection.undo end if end if end sub the undo function is not working... any better idea?

is it possible to set a query with the following code on a field: <date()-180 and <date()-365 what i want is to to show records from 6 months to 12 months only. what am i doing wrong?

Got a complicated challenge (better define my last challenge) but don’t have a clue where to start: I’ll try to be accurate as possible. Apologies I might be asking for a lot of coding but this has been bothering my for a lot of weeks trying to do it myself the ‘simple’ way but failed all over...

The scenario is based on 2 data fields: "IN" and "OUT": both are time fields and the main function is to serve as a punch clock. In order to work out calculations and get the total time, both were passed into a query and set out the formula: datediff ("n",[in],[out]) So to convert the raw time...

in the query i got "in" and "out" and both are short time values i wrote this formula to calculate the time between IN and OUT: total: ROUND(datediff("n",[in],[out]/60,2) but the values are not resolving right: eg: between 20:07 and 20:28 is giving me 0.35... what is wrong?

Got form "products" and subform "regstocklog" and... Forms![products].[regstocklog].now = me.qty1 ... but ain't working correctly. What am i doing wrong? Apart, what code is to be done in order to fill blank fields without any connection to any other field like: Want to fill field 'data' in...

is there any method to enable = false a whole row in form/datasheet view with a yes/no check button? Thanks Clara

Table 'Products' consists of 6 fields 'A,B,C,D,E,X' --------------------------------- Field A,B,C,D,E are user input fields Field Y (not bound to the table) is locked and sums together fields A,B,C,D,E My question: Field X is A locked field but needs to be automatically be filled with the...

Table 'Products' consists of 6 fields 'A,B,C,D,E,X' --------------------------------- Field A,B,C,D,E are user input fields Field Y (not bound to the table) is locked and sums together fields A,B,C,D,E My question: Field X is A locked field but needs to be automatically be filled with the...

Got this form named "Stock Dismiss". It is mainly to be used by low privileged users for the sole reason to edit and have limited access to a bigger form named 'Stock'. 'Stock Dismiss' form got a table of its own, however, there is connection with the 'Stock' table. In 'Stock dismiss' form, i...

guys, to be in short - a textbox named (totalsamount) is set with a formula to automatically add and subtract some other field boxes in the form. now here is my question; i have a a text box named (deposit). 'deposit' need to be filled (duplicated) automatically with the result written in...