Search results

Yes. It executes. I just wrote it in shorthand for posting.

Both records are in the same table, trans_tbl. In the before delete confirm event , I currently have: Dim ltiddd As Long ltiddd = Nz(Me.tidd, 0) Me.hidetransid = ltiddd Me.tidd is the name of the bound text box on the form for transID Me.hidetransid is the name of an unbound text box on...

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 agree with your point on the addresses. It's part of the reason why I'm struggling with this design. These clients don't care about people, they only care about premise addresses - they can't do their work until they get authorization to enter the grounds of the address. They don't even care...

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 am tracking work done at particular locations. Sometimes the locations are privately owned residences or buildings or stuctures. I have service requests for employees to do work at the property address of these locations. They can't do the work until we receive a paper form (roe) that...

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...

Yes. I see your point. Right now I just need some people to test it out before I deploy for production. How do I put the package in a place wherethey can install it and test it? We don't have a network and live hundreds of miles away from each other. I really don't want to mail a cd to...

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'm so happy!!!!!!! It worked!! Thank you so much!!!!!!!

I hope I didn't post this twice.... The 2 forms I'm having trouble with is frmAppointments and frmAnnualConvAppt. frmAnnualConvAppt has the parameter query as the control source.