Search results

Below is the SQL statement. SELECT tblSKU.SKUID, tblSKU.FY, tblSKU.MainCat, tblSKU.SubCat, tblSKU.Supplier, tblSKU.Brand, tblSKU.Model, tblSKU.SKU, tblSKU.TTLSKU, tblSKU.[Product Description], tblSKU.Market, tblSKU.Handled, tblSKU.Type, tblSKU.Engineer, tblSKU.Active, tblSKU.DoCSigned FROM...

I have a parameter query using a form to collect the data. I put LIKE and wildcard enclosing the parameter to bypass the criteria if the data box is empty. It works well. I have another parameter of date type that uses between two dates. How can I bypass the criteria if I leave the data...

For example Model field of Model Table Model field of Order Table 123456, 234567 123456 As long as the Model field of model table contains 123456, the data in that record cannot selected in the query. Currently these two fields must be 100% matched and...

plog, thanks for your code, it works exactly right. However I cannot change the field of multiple model numbers as it works very well in our simple and efficient search query. Is it possible to select the data in the model table if the model no of list table matching part of model no in...

I have a table of database containing all the model related information. The model field in the table may consist of one or more model nos (same product but with different brand and model no, such as: 123456 234567, 345678 456789, 567890, 234567 Now I received a list of orders that contains...

Oh let me check it out! Thanks!

I would like to create a command button on the header of a form. The button should perform a toggle switch: click once to activate the task and click it again returning original state. I can create the command button to perform a task but do not know how to return to original state. The...

Hi Gemma, The code is working well for my case. Thanks a lot!

Thanks for your advice. Unfortunately it is not applicable to my case. The unbound box is temporarily stored the input data and then twisted before passing onto the field control. I need to auto fill the leading zeros before the twisting.

I have an unbound control in data input form requiring to input a 6-digit number. I have put a validation rule restricting more than 6 digits. Most users prefer to enter, say 123 and the system can help enter the 3 leading zero for them. Any idea to accomplish it? Thanks!

Hi Ypma, Thanks for your demo program which is what I need for the improvement of current data entry. I notice two minor queries. Is the parking box necessary? It looks the same as the result box. The comma and space separator is not consistent in all groups. Normally the second...

Hi RainLover, In simply, I would like to enter a couple of groups into a field such as:- LTH3WH15, STH5, A7HDMI15E The groups may be from 1 to 18 but most of them are 1-3 groups. The result should look: LTH3WH15, STH5, A7HDMI15E Scott

Hi RainLover, Thanks for your explanation the differences between before update and after update. That is to say that I need to enter all groups from before update and use after update at the last group to write the complete result into the table. Scott

Hi Ypma, Thanks for your help and guidance. Could you please attached accede for Access 2007 as I could not open it due to unrecognised database format. Scott

I would like to enter a couple of alphanumeric groups into a field on an input form. After I enter an alphanumeric group, I hit the enter and the data will add into the field and refresh to empty box ready for next entry. If I continue to enter another group and hit enter, the next group will...

Thanks for your advice and I have built the command button to set the filter to false successfully. I will continue to see how to add visual indication if in filter on or off status and have the the on and off cycling function.

I have a search form based on a query. The query has a on/off field and default is on. The criteria of the query is to show the records in on status. I would like to have a command button to show all records including off status records at times. The button should have toggle function: first...

I would like to link a couple of columns of an Excel file with a table in my database for further manipulation. The Excel file is exported from other department manually every day. How can I set this up to accomplish the task? Thanks!

I have two tables: products and orders. I would like to query the products only with orders using the product code and/or model number and join up all product and order information for further manipulation. Can someone advise how to set up this query. Thanks.

As per your advice, I will create a calculated field to extract the first 6 characters and group it to find the max value. Thanks!