Search results

I have attached a sample database based of my real one. The real one has proprietary information, so I cannot attach it. I am trying to build a crosstab query that will output a count of items per category per month that "takes an item out of stock" when it expires. For example (where the...

Thank you for the suggestion. I toyed around with it, but couldn't figure the Split() function out rapidly and I am under a timeline. For some reason, my original code listed above now works. I have no idea how or why, but it does. Thank you for your time and suggestion! When time permits...

That makes sense. Thank you for your help!

Yes, I have compiled it. I forgot to delete the strM = line, however. I corrected that in my code. It won't compile for you because ErrHandler is a custom function that I wrote years ago that works with my databases specifically. If you comment out the Call ErrorHandler line, it should...

UPDATE: Middle initial does not work fine. In the absence of a middle initial in the field, it grabs the last letter of the first name.

I have a database output that I am trying to import into my database. I do not have access to the other database to create my own output. The database outputs name in format Last, First MI (there are two spaces between the comma and the first name(no idea why) and always a trailing space...

I did try to omit the "Is,", but when my first Case runs with "Null" vice "IsNull," the code errors on the next Case saying "Case without Select Case," so it seems "Case Null" negates the Select Case clause. When I run "Case Is Null," it errors saying it expected an operator (<, >, =, <>, etc.)...

I did try to omit the "IS" keywords, but VBA puts them right back in. And when my first Case runs with "Null" vice "IsNull," the code errors on the next Case saying "Case without Select Case," so it seems "Case Null" negates the Select Case clause. The snippet is only one of 5 snippets that...

Bottom line: Any idea how to handle the "IsNull" process? I have a form in which the user is to input 5 dates. Three of the 5 dates must occur in sequence, meaning date one MUST come before date two, which MUST come before date three. I am building what is in essence a date sequence checker...

@arnelgp You are a genius!! Worked perfectly. Thank you!!

I have a table with many instances of FKs with associated dates. I need to run a query that groups on all FKs and returns the min date for each FK. I tried to build a query that groups by FK, then sorted the dates ascending and set return limit to 1, but as you all already know, that just...

I have a project that I have been developing for the past few years. All of a sudden (today) when I published a new front end, the VBA will not run. I have a loading form that runs a few basic checks (OnLoad), then opens two other forms and closes itself (OnOpen). When I open the .accde...

You, sir, are a genius!! Thank you very much for your help. Have a great day!!

Wow...just looked up the render events. I was WAY off.

Thank you for the help! I have tried placing the following codes (at different times of course) in the OnLoad, OnOpen, AfterRender, and AfterFinalRender events of frm2 and sbf2, but it is not setting the focus back to frm1: DoCmd.SelectObject acForm, "frm1" DoCmd.SelectObject acForm...

@vbaInet I agree, the link is very basic and easy to follow. I understand how to create a totals query and how to tie one query to another for elimination processes. I was just under the assumption that my goal would be easier to accomplish than the way I accomplished it. All-in-all, I now...

My intention was not to be abrasive. I supposed I should have articulated my question a bit better. What I was asking was just for an example of the code structure one would use to achieve the desired result. i don't want anyone to have to build anything at all. I have found that I learn...

No. Looking for frm2 to basically just pop up (without taking focus) and stay open as a reminder. It pops up on the right side of the screen out of the way. It also serves as a verification that the employee was reminded to follow a series of steps required when certain criteria are met.

Yes...I tried both. Couldn't get it to work. I just wound up creating two queries for each table, one that pulled date and PK and the other that called a function to limit responces then count PKs. I then created a query to tie company to each count query. Wound up with 49 queries, but that...

As mentioned, I have frm1 and frm2. When certain criteria are met in frm1, frm2 opens (pop up, non-modal) to remind the employee there are additional steps needed. The problem is, the trigger for the frm2 open event happens as the employee is receiving/transcribing information at a very rapid...