Search results

I am having great difficulty trying to resolve this. WCCNF1 should turn to yes for previous dates in 2015 not 2016. I cant get it to work using -1. If Year = 2015 it should turn to Yes. Can anyone help me? If (Year(Nz([WCCClmDt1])) = Year(Date)()) Then WCCNF1 = "Yes" ElseIf...

Run Time Error 2465 cant find the field "fieldname" referred in your expression Anyone know the solution to the following on a field on a form: Once field is clicked, pop up message: Run Time Error 2465 cant find the field review_date 2 referred in your expression. The debug brings you right...

I wrote this validation rule which I will add on all my forms for dates requiring dates meant for only current year. I tested it and only takes dates for 2016 which is correct. I want to confirm from more seasoned developers that this will work year to year so in 2017 will only take 2017 dates...

Im exploring running query and sending emails on a scheduled basis to select recipients. Does anyone have experience with this? Is it difficult? Current procedure is to run it with a button. Looking forward to feedback. Private Sub Command38_Click() ' acFormatHTML, acFormatRTF...

I have to add a step to kill the last import of the file. Essentially, it will replace the existing table in the import. Do I use the kill file code? Code is as follows: DoCmd.TransferSpreadsheet acImport, 10, _ "Portal Mail List", CurrentProject.Path & "\Portal Mail List.xlsx", True MsgBox...

Anyone have a tool tip template I can look at. I have an advanced form with buttons and date fields. The users need to be able to hover over and get a brief overview of what the buttons and fields will deliver. Need some ideas. Thanks

I have users run an append query from a button. Is there anyway I could have the date the query was last run displayed on the form by the button? Or if you know an option or alternative please share. Thanks.

Im getting a message "Database was unable to append all the data table" in a database and cant seem to troubleshoot the problem. Does anyone know the VBA to bypass it after the event is run. I think it is because someone was in the database as the linked table was being updated.

I have a question for you. It is something I havent done before. I have to create an interface for users to be able to run queries which I can do. The trick is the queries will have to populate into a table. The queries will then be run weekly finding new only the new entries since it was...

I typically have buttons and a macro set up which will link to the original form by primary key. Anyone built it with drop down menu? For explanation when on Training Records Form for ID: 007 the admin can then open each year by a button for only ID: 007.

Im having a problem calling up the 4th column from a combo box to auto populate the field. Any restrictions, it is a date field as I can get text into the box? Here is the code added to the event on change of the SQL combo box: Private Sub Combo106_Change() Me.FName.Value =...

I have a query with multiple dates for the same person and ID # so it shows up several times. I have to filter by the most recent date. Tried the max and last but multiple are still showing up. Any suggestions. Thanks

Does anyone know a good foundation for the following?: Allow end user to import a spreadsheet with one column as a table into database Run process from a button to do the following: Strip the last two numbers in the column. The remaining characters in the column link to the main table. Take...

Does anyone know how to delete the duplicates in one column once opening the data query in excel? Here is my code: Private Sub Command56_Click() Dim strFile As String Dim objXL As Object Dim objWB As Object strFile = CurrentProject.Path & "\Test.xlsx" If Len(Dir(strFile)) > 0 Then...

I found this and think it is likely the method to run a query through a multi select combo box on a form and would like to know how to get it to expoert out with the docmd transferspreadsheet. Private Sub cmdPrintLabels_Click() Dim strSelected As String Dim strWhere As String Dim varSelected...

I have to create a report with a list box which a user can select multiple fields which will run on the query. The field is called Category. Category A, B, C, and so on. It is pretty straight forward with a combo box with just one choice. Any one done this before?

I have just one table with more than 300 records with queries set up. The queries are run from form date category and button with drop down to select category. Unfortunately, I keep getting the not responding message and hanging when running it although it completes it. Any suggestions or a way...

Count the number of Months Between two dates Hello Does anybody know a query expression that will enable me to count the number of months between two dates fields. For example [1/1/2015] to [11/2/2015] is 11 months Thanks

In need of help with the building of a query with the following criteria: Find out which members are still active for the entire year of 2015, field is either Active, Cancelled or Disenrolled If members were active**all of 2015 from*1/1/2015*to*12/31/2016*they get full amount which is 215.00...