i have a form with a subform attached. actually the subform does not share data with the same form, but is an independent table. The table on which the subform...

Hello. I have been successful in having field 2 autopopulate based on entry in field 1 combo box based on a query I built. This however, is the only time I...

Good day, I need an expression that groups on data from a sub-form. The form I have tracks car mileage for a given day. The master form has boxes for Date,...

I know the problem is with my Where clause but I am not sure how to fix it. Here is the error. Syntax error in date in query expression '(= 'Athletics' AND ...

Hello; I am working on a Contact database to track psychiatric appointmets. I am new to this, so I am just learning and I need some help. I have a subform...

I have two querries from one table, and each querry create different form. In this table have autonumber, how can I create the form share the autonumber, for...

Hi, I want to open an Excel spreadsheet from an Access form using Call Shell. This is what I have so far: stAppName = "C:\Program Files\Microsoft...

I have a database in Oracle XE with an Access front end. It connects successfully via ODBC without any problem. All the data is accessible but no inserts or...

hi can someone help! pleease! i've created a filter for a date and a text box that contains the phrase "no performance target" however i keep getting an error...

Is it possible to change the level of transparency of a command button? I would like to set some to about 50% transpasency so that both the button and...

I have a table with many fields (columns). I want to compare 3 rows. The best way to do that is to have the 3 rows in columns and then all the field values...

I have the following code which gives me my stock quantity .... Function Onhand(itemCode As Variant, Optional vAsOfDate As Variant) As Long 'Purpose: ...

Hi, I have a form/subform for Bin numbers and activities. On the main form is an unbound search box and a bound combo box for Bin numbers. The subform shows...

I have a table that I have based a form on. This form is used to update and add information to the table. There are three number fields in the form (from...

I have created a form based on a select query. The query has linked tables as well as imported ones. I have been able to input data directly into the form -...

I have my app all ready to use. Problem is when I open it using a shortcut to access with startup as my input form, The form opens up fine but behind it I see...

i have a combo box that is based on a query. PrimaryKeyID, Lastname, Firstname. I want the user to be able to search on the lastname but i need the...

I created a form that takes data entered by users and saves it to a table. I added a "Cancel" button. If a user begins to enter information in the form,...

I have the following code that resides within a Sub Form which is Continous: Private Sub Action_Taken_Click() If Me.Action_Taken.Value = True Then ...

I have 3 tables as follows TblAtty AttyID - Autonumber primary AttyLast AttyFirst AttyOffice TblPayoff AcctNbr - text primary