Search results

I have a table with two fields that each can have duplicate values but both can't have the same values in other records. The form has the type field as combo box and refNo as combo box and text box. example of data tbl_main, type refNo small W239 large W239 small W250...

I have a unbound form that update the table with vba code by clicking a command button. One field on the table is called location. On the form I have the code field as combo box, once a value selected from the combo box the location text box populated with dlookup function. How can I have the...

I have two fields called stages (8 stages) date ( the format is MM/DD/YYYY hh:mm:ss AM/PM) each stage has corresponding date/time in the same record. I used a query for thse fields and group stages and average the date...thats why my poing is looking for average date/time between stages...

I need help with location query. I have a table of three fields Location Item Qty I want a query or report to display locations of an item in one field instead of multiple records. Data: Loc Item Qty N024 AA77 88 N025 AA77 87 N026 AA77 28 N038 AA77 89 N039 AA77 25 N44 BB77 100 N46...

I have a form that is created based on a table. Three fields on the table are: date Type Recd Used I added another 6 text boxes sub_type1,2,3 and Used1,2,3 into the form. These added boxes have iif statments and forumlas which display a value. I need the value of the sub_type to be stored...

I have a table in Access databse link to excel file in the network, the format of the fields of this file are set to general. When I create a link table wizard the fileds formats changes to numbers for some of them. It's wierd, I spent a lot of time figuring out what is the problem and creating...

I have a table in Access databse link to excel file in the network, the format of the fields of this file are set to general. When I create a link table wizard the fileds formats changes to numbers for some of them. It's wierd, I spent a lot of time figuring out what is the problem and creating...

can anyone help please, I haven't search this forum for function or anything relatated to contain criteria... I want to have criteria search for parts contains specific characters. For example in a query, i have part like QS7000A and another part QS6000A. I want to have creteria to return parts...

I don't know if this is the right place for my post. Since is in regard to queries... I have data that I want to archive from one table to another table within a press of a button in a single form. The append work fine for me, but i tried adding the code to run the delete query to the same...

I have two forms with same fields properties, I select the record and moving it into the other form by using cut and paste. Is there a way where I can have command button to click and just move the record from form 1 to form 2? thanks for the help.