Search results

Directory only, or did it include the file name?

This sounds very familiar to a issue I had encountered a while back. If I remember correctly, the Excel file can be linked in the Access database and can be open in read/write in Excel, but only if the linked file is not "open" in Access. Can't be in an open query, open table, form or report...

But what was printed out on the message box? It should be the file path of the file, but I suspect it is not. Sent from my SM-G900P using Tapatalk

insert this line immediately before the line that errors: msgbox "Directory:" & fn

You have a syntax error in the Nz function. You are trying to pass in 4 arguments, but it only takes 2.

Yes, make them public subs or functions. Good luck!

My 2 cents... Personally, when I started learning VBA, I kept this site bookmarked. Search the forum first. 95% of the time someone has already asked your questions (or something similar). The members here are great and very helpful. I use modules to store code that I will use in other...

Two things: First, I would need to see your query in order to tell you how to modify it. Second, what would be triggering you automation? Has that been built? The modified query would probably need to be somewhere in the automation trigger.

So are you still getting an error message using the VBA function?

Everyone starts as a newbie! The fact that you have been exposed to VBA in Excel is a good first step.

First, much better in describing the issue and desired results. Second, to answer Minty's question: Yes, I believe this is a macro. So while you may get some assistance in debugging your macro, the people in this forum are much better versed in using VBA. I understand that you may not...

Provide some details and I am sure someone would be willing.

So that is exactly what this code does.... StartDate = Nz(Me.[Textbox StartDate],0)The Nz function looks at the value of Me.[Textbox StartDate]. If the value is NULL, then replace that NULL with the value 0 (zero). If the textbox has any non-NULL value then nothing is changed and the value in...

pbaldy seems to be pointing you in the right direction, but it is for the precise problem you are having that I prefer using the NZ function and using an IF statement to test for 0 (zero). Dim StartDate As Date StartDate = Nz(Me.[TextBox Startdate], 0) If StartDate = 0 then Exit Sub Now...

I admit, I never use the macro tool. VBA might have a steeper learning curve, but its flexibility and ability is far superior than anything you can create in a macro. Also it sounds like you are stuck in the first record of a loop scenario. I honestly don't even know if loops are possible in...

try this: Like '*" & [Forms]![frmContactHistory]![Text26] & "*'

While there are exceptions, most people on this site will not have or offer the code that perfectly fits your needs, UNLESS you can show that you have made an honest effort in doing it yourself. Then there are tons of people that are willing help get you past your roadblocks. Think of this...

Replace "SearchResults" with the name of your ListBox. Me.ListBoxName.Requery But your error makes me think that this solution is not quite complete. I believe your listbox is on frmMain, but you want to update the listbox AFTER the new record in frmAddNewAgency is saved. You might have to...

If SearchResults is the name of your listbox, then I do believe that is the correct syntax. As for where to put it, I think you are referring to form frmAddNewAgency's AfterUpdate event. Should work, but I don't know the rest of your solution to know if it "fits" there. Sent from my SM-G900P...

Sounds like you need to requery the listbox recordsource after the new agency record has been saved. Sent from my SM-G900P using Tapatalk