Search results

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

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

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

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

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

Hello, I am having an issue with my vba while following Dev Ashish's site http://access.mvps.org/access/general/gen0018.htm My Dlookup works correctly, from what I have tested. The issue comes from when I run the update query after, it updates every record instead of the current record. Can...

Hello, I am having an issue with some vba for a change password screen. Below, my Employee ID is a text field and it keeps producing the following error: The expression you entered as a query parameter produced this error: 'Steve' The error pops a msgbox, and doesn't highlight any vba. I...

I am importing an excel text field into a table. I am then appending the data to another table. I am having a hard time with the Cdate function Excel Date Field: YYYY.MM.DD HH:MM:SS Example Value: 2014.04.21 18:24:30 My Query Code: NewDate...

Issue: the code below opens another form (not report) that displays details of a purchase order. The form was created to mirror a gov form that we use, and the 10 line items are hard coded. when the code is run, it will display the first 10 items. If the original form, where I am entering the...

I have having an issue with determining how to use a customized fiscal year with a DCount function. My Code: ThisYear: DCount("*","Open Issues","year([RequestDate]) = " & Year(DateAdd("y",-1,Date()))) The code only does from Jan 1, YYYY TO Dec 31, YYYY I'd like the code to read from Oct 1...

I have a small/simple database, using the attachment field to actually store attachments rather than hyperlinking to a shared location. I know I'll get some slack for that, but the database itself will remain rather small until we move the database to a sharepoint server. In the mean time, my...

How would I add additional criteria to the below. My criteria would be [myfield] = "Complete" Is this even possible? ThisYear: DCount("*","Open Issues","year([RequestDate]) = " & Year(DateAdd("y",-1,Date())))

I am attempting to pull data from an XML file via VBA without doing the import on external data. I created a blank table called "tblHolding". In theory, my code works the way i want which is: User clicks button, file explorer opens for them to select the file, imports data to "tblHolding", and...

In this example, I'm working with concatenated values. CBNOPREF = "No Pref" CBWORD = "Word" CBEXCEL = "Excel" So the if my data had each it would show (No Pref;Word;Excel) That's fine until my data only has excel, and would show (;;Excel) How would I had Nz to the following to eliminate the...

Good evening, I am working with DCount in a query based on a calculated value [MyCalValue] that is a status. The status can be: Complete, On Going, Past Due, Additional Information, No Date. In the DCount, I want to return 0 if null. Sample that works fine Green...

I am running a search function that works, but is limited in one of my fields. If I want to search for "B", and search every title with an "B" in it (regardless of where the B is), it wont show. If I have a title that is labeled "BAC", it will not show if I search "B", unless I type "BAC"...

Through searching, I have seen a lot of post regarding 3rd party downloads to extract pdf data to a table, has anyone developed coding or a sample database that doesn’t require 3rd software? I found a site that does the opposite, but wondering if it could be reversed engineered. In the end, I...

Main question: Would I use an update query or function to complete my task? Task: Automatically update [Status] based on DateDiff calculation of [RequestDate] and [DueDate] Issue: [Status] can be one of 6 values, the user can manually select Review or Completed. [Status] values: Review...

Good morning, I have a question about an Issues template database provided. I’m not sure why I haven’t been able to grasp the idea, but there is a query labeled “Issues Chart Source,” that is referencing two queries and a table. The two queries are “Contacts_OpenedBy” and “Contacts_AssignedTo”...