Search results

there 2 ways you can do this. You can create an unbound form and then write a vba code to insert the record using sql when user click on the submit button. or you can use the dirty event. when a record get edit it becomes dirty. what you can do is on unload event which is before close event the...

Would anyone be interested in Table of Contents for reports, with the number of the pages? I have create a VBA module and some table to give you a truly Table of contents. So you can combine multiple reports into a book with the correct page number. I want to get some feedback to see if it worth...

Please keep in mind that no data is loaded during the open form event. this might be the reason why you are not getting any data for the second line. try to put in the on load event instead

It is doable as i do this all the time with my application. I like the frame concept as it allow the user a clearer transition between the function. Here is a sample code i use in my application. SubMenu is the subform control SourceObject is usually another form, i don't know if could be a...

you can create a query that links the parent table with the child table and check if the Child table fields is null. this means you have to have an outer join on parent table(all records) and only matching records in the child. if the record doesn't exist in child it will appear as a null value.

i finally perfected the design by using SQL logic and application logic. the inventory and and ordering process is completed. The thing i ran into trouble now is the transition from demand table into order and then from order back into inventory again. the demand can be satisfied in two ways...

i mean first and last name

use a group by clause on first and last leave out the car model. with a group by it should take care of duplicate

try the filter function me.Filter = "Product Like '*" & me.txtsearch & "*'" me.FilterOn = true that should solve your problem

from what you explain. it seems you need an left or right join depending on which table you want include. you want to include everything in table that has the non matching records and the everything in the lookup table.

Create a query with following criteria, you have to modified to fit your table structure. SELECT ID, Count(ID) AS CountOfID FROM Product GROUP BY ID HAVING Count(ID)>1; this will give you all duplicate records. use this in conjuction with recordset to accomplish what you need to do.

I don't understand your approach. the easiest approach is to use a group by query with a count. group it by the id and count it on the id aswell. if the count on the id is greater than 1 then thats a duplicate. create a query that show all the count greater than 1 then use a recordset to delete...

if all the data is avialable meaning the search field is been shown or in the query all you have to do is use the filter function. give u exact records that contains the value in textbox. 1. me.filter = "[product]=" & me.textbox me.filterOn = true give u anything that start with what in...

what type of data is it your subform 2? is the subform 2 editable meaning that it doesnt contain any group by clause in your query. if it is editable you can use the following command 'Forms!frmMain!container_form.Form.recordset.addNew' to add a new record.

What i figured was that all activity is based on two actions. one is if the user scrap the parts or the life of it actually goes down to 33%. these event occurred both at the individual level. so i just wrote one function to check the total count of the part number when the user click on scrap...

I am looking for sample database that has nice gui and nice transaction between different functions. I have current create db that uses frame so the transition between function is almost transparent but i lack a good gui design. Some suggestion and samples would be great Thanks in advance

Thanks for the suggestion and feedback. I figure away around it.

how do i handle the order of new parts partNumber Table: PartID, Primary Key, Autonumber TypeID, Int PartNumber, Text SafetyStock, Int LifeCycle, Int Inventory Table: InventoryID, Primary Key, AutoNumber PartID, FK to partNumber SerialNr, Text Life, Int needOrder, Yes/No Order Table: OrderID...

I am wondering if there is a easy way to get the control that the mouse i move over. I mean access has it built in with the controltip. It know what control the mouse i hovering over because it shows the controls controltiptext. It should be fairly easy to get the control that the mouse i...

is there a way to be able to determine who the caller of the procedure. on form you have parent but in vba i dont know how to determine the caller of a procedure. This is what i want to accomplish Private sub test call Two() end sub Private sub two me.parent.rowsource = "" end sub i know i...