Search results

I am using Access 2016. I used the Query Wizard to create an append query that works correctly. I saved the query with the name pendingAdd_qry. In an Event Procedure on one of my forms, I want to run that query, pendingAdd_qry. My code gets an error on the Execute statement and I just can't...

I am using MS Access 2016 I have a database that includes 2 tables: blank_tbl blankID blankYear (number) blankDistrict (number - join on districtID) blankInfo1 blankInfo2 blankInfo3 blankFinanceamt blankTrusteeamt blankClose (yes/no) district_tbl districtID districtName districtDioceseNumber...

I'm using access 2007. I have a mainform and a subform linked properly. I have a button on my mainform that will insert records to the underlying table of my subform when clicked. The records are inserted into the table correctly, but they won't display in the subform until I move off the...

I am using Access 2007. I have a table called auxiliary_tbl. It contains 3 foreign keys (chair, secretary, treasurer) to a table called individual_tbl. I want to make a query on the auxiliary_tbl that includes the corresponding names of the 3 foreign keys in the individual_tbl. Right now I...

I'm using Access 2007 i have a mainform that has 2 page controls. Each page has a subform with a calculated sum of an amount field in the footer. I wrapped each subform calculation in an Nz. All total fields are formatted as currency. the totals display correctly on the main form...

I'm using Access 2007 I have a table that contains transaction records from a bound form. When the user enters a certain type of transaction, I create a corresponding transaction in the after insert event. Example User record - tranId = 1, tranAmt = 10, tranType = DISB, tranAssocID = 0 My...

I'm using Access 2007. I have a form that captures comments (comment table). The form captures the date, the comment, and the employee ID of the person making the comment. I have a combo box on the form that lists employee id and employe name via a query on the employee table. Employee...

I'm using access 2007. I have a table with 2 fields: phtolink - hyperlink phtopath - text I am loading the table with existing data from a spreadsheet. The hyperlink field imported correctly into phtolink. Now I need to convert the hyperlink field to a text field that displays the path to...

I am using Access 2007. I have 2 tables - abatements and materialsused. They are related by abateID. I need to count the number of paint and powerwash abatements by month. You can identify paint and power wash abatements by the materials used (materialcodeID in the materialsused table)...

I'm using access 2007 i have a query that joins 2 tables - 1 table has the FK of the other table in it. Here is the query in sql SELECT address_tbl.*, abatement_tbl.* FROM address_tbl INNER JOIN abatement_tbl ON address_tbl.addressID = abatement_tbl.abateAddrID; When I view it in...

I'm not sure which area to choose for my problem. I’m using Access 2007. I have 4 main tables : Entry-authorization-tbl entryID entryaddressID entrycontactID Address-tbl addressID addressStnumber addressStname addressStprefix addressStsuffix Contact-tbl contactID contactName...

I am using access 2007. I have a form that lists address records. The user can select a record from the form to edt (using address detail form) or click new address command to add a new address. This fuctionality works fine. I have an entry authoriation record that contains the addressID to...

I'm using access 2007 I have 2 unbound form controls that I've assigned values: one is a price field that I assign a value to the control source property using: = DLookup..... The dlookup works correctly. The other field's (cost) control source is calculated: = price * quantity The...

I am using access 2007 i have a materialsUsed tbl that list all the materials used in a job and the quantity of each. (ID Material Code Quantity Unit of Measure) I also have 2 look-up tables - 1 for the material codes and 1 for the units of measure I have another table...

I'm using access 2007 I have 3 tables: entry authorization - roe_tbl, contact -contact_tbl, and address - addr_tbl. the roe_tbl has ID, addrID, contactID and a few other fields. the addr_tbl has ID and the streetno, streetname, addrtype. addrtype is CNT for contact or ROE for...

I am using Access 2007. I have an application for a single user. I don't need to split my database. I packaged the application and tested the installation on my pc. The instructions from MS say to copy the package to a Cd or network. I want to put the package on my website or in google...

I am using Access 2007. I built a macro using the macro builder to import a spreadsheet file. It works fine. Now, I want to alert the user via a message box that the import was successful. How do I determine if there were any errors - even the one you get when it cannot find the xlsx...

I have an unbound text box (in the header) that I want to use to filter records on a split form. I want the user to enter a number in the textbox and have the form return records that match the number. The filtered field is a number in my database. I don't want to use a combo box. I want to...

I have a parameter query that selects a group of records in a table based on the entered year. Let’s call the query – paramYearqry paramYearqry is the control source of a form that puts the group of records on a tab/page on the form. Let’s call this form – yearRecordsfrm. I have a different...

I need some help with the design of a system I'm building to track Position Appointments.... I'm using Access 2007. Some Background: I have 5 tables: Members, positions, appointments, districts, conference schedule My appointments table has foreign keys to members and positions as well as a...