Search results

I've made a simple database and I've made a cross tab query to show some statistical results. In my front page, I have where the results are going to show. I simply thought if I associate the control source to those fields, it would work. After I found out that didn't, I'm trying to create a...

I want to create a specific query. here's how the tables are set up I have 2 tables, 1 is general contractor, 1 is project information. they are linked by "gcname" I need to create a filter that will sort all the records in the project information that if a project is marked "inactive it will...

I'm having issues with my database. I have a series of reports that are set up and the filters are not working correctly. The entire code forth e report function is this. Option Compare Database Dim MyFilter As String Dim MyPath As String Dim MyFilename As String Private Sub...

I'm working on some automated emails. I've been using this code: DoCmd.SendObject acSendReport, "Report-Custom", "PDFFormat(*.pdf)", mail, , , "Construction Pipeline Email to GC's", mailText, True how do i change the "*.pdf" into a variable that will pull the name of the company from...

MyFilename = "forms![frmGC]!CompanyName" & "-" & "Forms![frmEditproject]!ProjectName" & ".pdf" I'm trying to auto-generate a file name, I seem to be doing the wrong format, I want to pull from frmGC!CompanyName and frmEditProject!Projectname i'm trying to get a sample report printed...

Ok, This form is breaking more and more that I try to "fix it", Any suggestions will be helpful. Basically, how it's supposed to work is this, You select from the "report" at the top and it will list the counties that is available for it. select the county and it will show you the project...

Ok, I found this code on the internnet. Private Sub CompanyName_AfterUpdate() 'If the textbox contains data run the 'Spell Checker after data is entered. If Len(Me!CompanyName & "") > 0 Then DoCmd.RunCommand acCmdSpelling Else Exit Sub End If End Sub...

Hello, I'm making a report based on selections my users pick from drop down menus and fields. I recently changed the format of one of 2 of the fields (they were check boxes) into a list box. I'm having some issues getting the list box to function and filter what I need. it's a combo box. I...

I'm using Office 2007, I've made a customer service database, I dont want duplicate accounts, and we're going by phone number as the unique Identifier. I want the field that i use to input the number to auto search the records and go to the proper record if the number is already in the...

I'm having some trouble here, I need to be able to sort and search by a list of 40 "Trades" that will be multiple selections. in version 2008, i was able to select multiple items, but not effectively create a search function. How do I set this up so I can actualy add records with multiple values...

Hey, I'm trying to create a Login for my database. I have 3 "ranks" in a table. Admin, Editor, and Sale. I'm designing a home "form" for each of them (dont tell me to do the swichboards, i'm just being difficult and I JUST got the forms finished) When you put in the 2 txt boxes at "login"...

Here's the setup... Table - General Contractor (tblGeneralContractor) Primary key - ID Company Name- txt First Name-txt Last name-txt Address-txt City-txt Use a look up colum directed under tblOregonCity.City so there is no misspellings of citys when inputed, This is a drop down menu...

Hello, i've just signed up and I hope you guys can help a newly promoted database desiger. My boss wants me to set up some fields in a table to do some fancy dancing.. Here's the issue I'm designing a form for data entry where the reps will enter customer information. We dont want typos, so I...