Search results

I get an error that states - You tried to execute a query that does not include the specified SellerID as part of an aggregate function. I have a query that links 2 table (of course tables are a 1 to many relation) where SellerID is primary in tblseller and is a field in tblitems. I am trying...

I have a table with peoples information and a yes/no check box for volunteer, and then a table for items with a person id. The 2 tables are linked under person id. person table has person id as primary key and items has person id as a field in the table. I am creating a report that will pull...

I am having trouble with a control button on a subform. I have the button set when it is click to view a report based on the current Primary field [ID]. Here is the code I have placed in the on click event. Of course that is between the two bits of code provide when you enter the code builder...

I have a database for an apartment complex that generates all of the legal doucments, etc. when people move in. One of the reports pulls fields from a main form and several subforms. One of the reports pulls info from a subform that conatins rent amount, pro-rated rent amounts and has a check...

Here is what I would like to do. I have two tables. tblGarageUnits and tblGarageUnitInfo PK for GarageUnit is A1, A2,... and this is the only field in the table (GarageID). GarageUnitInfo has PK which is autonumber, and FK which is same as GarageUnit, and has other fields in the table...

Just wondering if there is a way to edit a value from a table and change it in a report. For example, Property is listed on an invoice as Company (WMP) and is stored in the property field of table tblinvoice. I have a report called rptEnvelope that pulls the fields property, contact_person...

Not sure if this is possible, but I was wondering if there is a way to may the records in a form read only after they have intially been saved. My dilema is this. I created a database for an apartment complex that you enter info into. foe apartments, thus rendering all of the paperwork needed...

I have a db that I originally crated in Access 2007, when I created it I used Access 2000 format so I could use it on other versions of Access. I have a report that works fine when using it on Access 2003, but when I view the report in Access 2007 the margins are messed up. I orginally created...

Not sure if this is possible, but Just wandering if it can be done. I have a report Movereport that has a sub report subreportTenants. The data are from tables that are related by movereportid. Well the subreport pulls names from the tenants table and can have up to 4 names with each...

I have a report that is based on a query. It Contains info from 4 queries. It has I Total Due a Total Paid and a Balance field. All are calculated fields. When I get to my report I can format the Total Due and the Balance Textboxes allow me to format to currency, but the Total Due will not...

I have done some searches and found out about creating joins and have almost achieved the results I want. I have 4 tables (Invoices, Labor, Purchases, and Payments). All are linked by Invoice number and all of the data is enter via a form called invoices and has a subform for all of the other...

I have attached a sample of data with the table I am working with. What I am trying to get out of the query is this From the table Invoice I want to get the field InvoiceID, DateofInvoice, Property, and BillingRate. From the table Labor I want to get the total hours for each job tied to the...

Just wondering if anyone new of any books that contain examples of code, functions, syntax, etc. I would like to have a good reference that I could go to instead of searching the internet everytime I need to try something new. Thanks in advance.

I have a billing rate in my main report invoices, and i then have a subreport called labor which can have multiple entries that include hours. I am then wanting to use the billing rate from the main report to get a total sum for the hours times the billing rate. I have tried everything I can...

I have a report with a subreport. The Report is called Invoices and the subReport is called Purchases. In the subreport I have a filed that shows Amount. It can contain several rows if there were more than one purchase. so in the subreport footer I have a text box with control source =Sum...

I have a report that comes from the fields in a form. I created a query which allows me to pull only certain records with in a date range. I then created a form based on the query so I could then create a report for the dates I used. Is there a way to take an existing report and change which...

I have a database that works fine on access 2000. The problem is that when I open it in Access 2007 the switchboard does not display correctly and my command buttons do not work. Also, my field that autofill from a combo box do not fill in. I am assuming that access 2007 does not recognize...

I have a very simple database that allows you to enter a workorder, it auto numers the workorder, select the property (by combobox), select employee (by combo box), date, desription of work, and unit number. I am wanting to add a button to the form that pulls up a report. the problem is not...

I work for a property management compnay and they have put me in charge of coming up with a way to go some what paperless. What they are wanting is a way to enter a work order for a particular client (i.e description of work to be done for maintenance). This would then need to be printed in a...