Search results

Yes, I did end up getting the problem worked out...Thank you!

Sorry, I was away for the past week and a half unexpectedly. I will do the update on the text field. I always do it on a back up database before actually doing it on the live version that way if I mess up, nothing is affected. Thank you!

I've been working on the update query, however, it is keeps saying it is updating 0 rows. here is update query in SQL: UPDATE tblLicenseAgency INNER JOIN tblLicensing ON tblLicenseAgency.AgencyID = tblLicensing.LicensingAgencyFK SET tblLicensing.LicensingAgency =...

Right now "Maryland" is currently stored in there from the combo box I put on the form. I am unsure how to link the data that is currently stored in there to the look up table I created.

In the original set up was just a combo box in the form that was not tied to any table. When I came back to write queries and set up search forms, it would not pull the information like I had wanted it to. I realized I set it up incorrectly and should have had a table to link and store...

I think I'm doing it wrong because it's not linking like it should. I have the one-to-many-relationship, but it's not recognizing the information in the original table. :banghead:

That's what I thought, but for some reason was having a hard time trying to figure it out. Thank you!

Thank you!! I use ID's. If I do that, it won't mess up the information that is already in the table? Because all I am doing is just creating that relationship between the new table and current table right? The form shouldn't have anything to do with anything correct since it is just used for...

After completing all aspects of my database, I moved on to creating queries/reports/forms for reporting purposes for my executive team. In creating queries/reports I discovered I made an error in using a combo box on a form for data entry where I should have used a table and based the form on a...

It did work previously when I was using two different forms. But now I've added a combo box with a yes/no option and depending on which one you choose it will run one query or another query. And I've gotten the report to work, as well as the Export to Excel to work and the print button to work...

Ok, Now I've fixed it so the command is on the form but now the email option won't work on the form! Grrrr....it seems I fix one thing only to have another portion of the DB not work!

Always...had to go half way across the country! This where is says it has the problem: Option Compare Database Option Explicit If Me.Combo25 = "Yes" Then DoCmd.OpenQuery ("qryEmpSkillRatingSelf") Else DoCmd.OpenQuery ("qryEmpSkillRating") End If The Me portion of the code keeps...

Sorry it has taken me so long to reply. I had to go out of town. The report is working but when I go to export the report into Excel it is saying "Compile Error: Invalid Outside Procedure." This is the command I used: Option Compare Database Private Sub cmdExptEmp_Click() Dim sQry As String...

I am combining forms and queries to make my DB more user friendly. Everything was working on the forms until I tried the export button. How do figure out what is going wonky on this code? Thanks! Kristen

Ok, I put the combo box on the form and on the wizard had it saved for later use. I put the code in under (General) and (Directions) in Visual Basic and it is not pulling both queries. What am I doing wrong?

THANK YOU!!!! That is exactly what I was looking for!

I would like to revamp some of my queries. On the old front end I have a form that with drop down boxes that gives ranges for the user in order to generate reports. There are two separate queries/forms that I use because I don't know how to set it up so it will choose just one or choose all...

I figured out my issue with the query/form/report. I do have another question. How do I get the form to reset? I did put a button in the form to get it to refresh all data but it still has the previous information in the combo box. Is that normal? DOes something else need to be done...

I have a query that I created that I'm using for a form and a report. The first time I tried it, it did what it was supposed to do. Now, it does not bring up any records. What did I do wrong? Here is the query: SELECT tblEmp.EmployeeID, tblEmp.EmployeeName, tblEmpCert.CertID...

I am trying to use a join query to join two tables in order to create a form. I have done this on two other occasions in my database with no issues. Now it is only pulling the ID and I want it to pull the description. I have looked at the SQL view for the other queries that are similar as...