Search results

Update: Further testing made: removed all code and enabled and unlocked some disabled fields from form Products, changed "'" with "", "#" and tried this code as well: "[products.codenumber]=" & "'" & Forms![search_advancedstock]![search-advancedstock-datasheet]![CodeNumber] & "'" and still...

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...

Kenhigg, i do agree with you: this is the worse of the worse search method possible did this coding around 7 years ago and now I am revamping the database completely. Actually i found the solution to this problem by myself by setting up a new dedicated query for the form and filter the code...

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...

Thanks Adam for your reply... Actually this is all about a punch clock system. On a separate form i designed, a user select his ID and logs in his table of "In" and "Out" time, depends the hour of work he did. The reason of the form is to give me a view of the working hours he did, lets say...

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

... any my sincerest apologies for double posting

Hi John, thanks for your reply. However a new problem arise. Doing so i will destroy the link of 'field X' with the table (yes, in the form view the value is mirrored but table 'products' 'field X' detail is empty. I need the value to be copied from 'field Y' to 'field X' while information is...

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...

ok, i have attached the database i am working hoping for better answers... http://speedy.sh/FCG9c/Database-Example.zip The form is named "stock dismissal". Inside, there is a search box; when i type in a code from the green drop-down menu, the system automatically finds the item and loads...

... anyone please :(

Heyyyy, haven't been able to keep with the conversation because i was abroad on a relaxing vacation - back, i still cant figure out what i should do and im afraid i didnt explain myself correctly - let me re write again the scenario: Got this form named "Stock" with a subform named "Stock...