Search results

Windows 10 works well enough until those people at Microsoft decide what programs are running correctly and remove them. You cannot turn off windows 10 update only defer it. One minute you computer is running at the top and the next it goes haywire. Not only did it shut my system restore to...

WOW!!!!!!!!!! This forum is dead!...no activity at all. Well, I am going to help it along with a strongly controversial subject. Now before I tell you what it is, let me tell you a little about it. It started in the US by two people with good intentions but even now will tell you it does not...

Can I place a criteria in a calculated field? [SellingWgt]*[SellingPrice] is ok but only if [SellingUnits] = "lbs" or [tblSellingUnits].[SellingUnitsID] = 1 Just have a problem finding it in the tutorials Blade

FrmlossRecord cbolossreason on above form By using the 'afterupdate' event of cbolossreason, an if/then statement checks to see if the selected item in the cbolossreason is *ADD*. If it is true, the 'IF'statement opens the FrmLossReason ( which uses the TblLossReason) allowing the user...

Why would a simple query not pick up a record in a table. I have tried everything and get nothing. The record Number is 34 and the AnimalID = 102. Using a simple query that is based upon the animal type, the query will pull up most all animals but like 102 and a few others, it will not pull up...

I have a main table that contains all animals, present past and future (newborns). The trouble is as with any table you wind up with excess files that are no longer used (junk) in it. What I need to know is how to clean the table. Strange question I know but let me take you through this. I have...

I have a form that allows me to sell animals in a group. While some fields, (i.e. buyersname, sellingunits, datesold) are good for all, some fields (i.e. AnimalID, SellingWgt, Sellingprice, Picture) need to be specific. Having said this, Using a query for GroupSales, I filled a list box of all...

I am trying to run a query that among other items checks to see if the Birthdates field of a table Plus 150 Days is less that the present Date(). in the criteria area. All are shortdate format and fields are DateTime. However, it does not seems to be recognizing the Date(). Since I don't...

I have a combo named cbogroup. I have a tblGroup with several records (active, non-active, nursery, etc.). One of the records is *ALL*. Using the CboGroup the user can pick any of the records. Howeverr, if they pick the *ALL* record, I want the query to pull up animalID based on all records...

i know not what I need to ask for so bare with me. I have a tblhealthrecord that has many multiple entries for the same animalID. Would like to pull up all records from this tbl for one animal. I can sort them later but just need to know what to ask for so I can read upon them. I at first...

does anyone know how to address the subform from within the subform. I can address the mainform from the subform and the subform from the main form and the controls when I am in the form itself but to address the subform from within itself escapes me. I have tried...

Main Form = 'NavForm' Using standard Navigation Form in Access 2010 Subform = 'frmanimalSetup' Main form combo = 'defaultcboanimalID' Record source = [tblanimal setup] subform.form.combo = 'cboanimalID' recordsource = [tblanimal setup] Based on type and/or group and/or location the...

I have a navigation form where I use combo boxes to pick an AnimalID and then fill in the subform based for that animals information. The AnimalID ComboBox (cboAnimalID) has a row source like this: SELECT [tblAnimal Setup].AnimalSetupID, [tblAnimal Setup].AnimalID, [tblAnimal...

Can I use combo boxes placed in the detail area of a navigation form, above the sub menus but below the navigation ? I am not able to get one to work properly . I can set it up but when I run the form, and try to pick an item from a list, it will not work Thanks

I tried this last night and though my failure to explain it correctly, I, much less the person who was helping me could not understand it. Let me try again. Am trying to update a check box (s) in one table. Here is the sql of the query: UPDATE tblPurchasingRecord SET...

Have a simple problem that has become not so simple. I am updating a tblpurchasing via a query. The purchasing tbl has a TransferKey (Ckbox) field that only becomes 'true, -1 or Yes' when the newly purchased stock is updated to a master file. To do this I use two queries. One to update (append)...

Have 3 CBO location, group and names. Names I based upon the other two cbos. Instead of writing a query for each possibility how or can I use variables so only one or two queries can be written. Ex. Location.... Front house. Group...active there are five animals that are housed here and...

In a DB I have several small descriptive tables that need to be 'added to or updated' frequently. (i.e. tblColor). I have added an *ADD/EDIT* (color field) to the other data in the tbl. (*) keeps it #1t on the dropdown list. The tblColor is used in entering the color of an animal in the...

I have a parameter that I need to get a table contents between dates. In the query: Birthdate: XXTable: criteria as follows: Between [Enter Start Date] and [Enter End Date:] When run it gives me the Error - ! This expression is type incorrectly, or its too complex to be evaluated. For example...

I have several reports that are in the Report section of Access 2010. Is there any way I can access those reports from a cbo on a form. If so, will this have an effect on the program when it is in .exe format? Thanks in advance Have a nice day :>) Blaerunner