Search results

thank you for the best practice tips.

How do you grab a custom Fiscal Year's values based on the system clock's date? I am building a query where I want to see the number of closed cases based on the current custom fiscal year with the system clocks date. The report that it feeds only cares about the current FY. I need the System...

Ah, that was it. Thank you.

It currently is a text field. The one problem I am running into with the Format () option comes from how the field is displayed "RF-ABC-1-FY15", makes it a little challenging.

Thanks. I thought about that prior to posting, thought there might be an easy fix to something I was over looking. I'll stick with your solution.

Hello, I have the below function that works correctly. However, I would like the "Last_Nbr_Assigned" value to start at 0000 and increment by 1. So the very first number assigned would be 0001, then 0002, then 0003, and so on. This number is automatically assigned so I haven't had luck with the...

Curious if anyone has experience building an InfoPath form with a repeating table. Within my repeating table there are unique ID's, say for example social security numbers. Also in that table is the employee name, and some other personal information. Is it possible to reference that...

Take a look at this: https://social.technet.microsoft.com/Forums/sharepoint/en-US/738f6c36-d7fa-48c1-8588-65efd7c7aabe/disable-site-settings-for-nonadministrators

I have tried the select query. When I merge the query source to the word document, it will only display the one product, the first set of values and ignores the others.

Hello All, I was wondering if anyone had a simple working mail merge application with a one to many field filling into the word document. I have no problem with a one to one, but if the subform has 2 or more associated records related to the main form, I cannot pass all the fields. I was...

Can you post a sample database? WinZip so we can take a look.

For a text field it would look like this on the open form: DoCmd.OpenForm "Asset Status", , , "[Project Number] = " & Me.Project_Number For you code, I believe it would look like this if its a text field: rs.FindFirst "[Project Number] = " & lngBookmark

I am trying to break up a single table database into a normalized one. The current table1 [vehicles] has several text fields that I want to append to a new table, table3. I created an example of what I am attempting to do by creating table2 [tblLocations] with two fields, Location and...

You mentioned that it is possible. can you give me a path forward on a sample query where I could use an unbound combo box to search two fields instead of just one in my present query.

You are correct, its not a text box, rather an unbound combo box. The combo's row source is the original query. The vba opens the report after update, nothing fancy. Private Sub Combo2_AfterUpdate() DoCmd.OpenReport "EmployeeHistory", acViewPreview End Sub

The query is the row source for an unbound field on a text box within a form. The after update is triggered by user entry. That selection filters a report. Hope that helps

Is it possible to change this query to search for either a Name or by an employee ID number? The query runs a report on after update. Currently I can only enter the name not the employee ID SELECT DISTINCTROW First(Inventory.Employee) AS FirstOfEmployee, Inventory.[Employee ID] FROM Inventory...

Thanks for the help. My end product. Append INSERT INTO tblMemberProgram ( MemberID, ProgramOffice ) SELECT [Forms]![FRM_Member_Stats].[Text44] AS Expr1, [Forms]![FRM_Member_Stats].[Combo59] AS Expr2; Update UPDATE tblMemberProgram SET tblMemberProgram.ProgramOffice =...

Then it brings me to my next issue on the append side... When I append the current record, it sees that the table has 3 records, and adds 3 of the same current record. So then it has 6 records in the table. If I run it again, it adds 6 records and so on. INSERT INTO tblMemberProgram (...

think I figured it out unless someone has a better response... UPDATE tblMemberProgram SET tblMemberProgram.ProgramOffice = [Forms].[FRM_Member_Stats].[Combo59] WHERE ((([Forms].[FRM_Member_Stats].[Text44])=[tblMemberProgram].[MemberID]));