Recent content by theKruser

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