Nauticalgent
Last Activity: 10 hours ago
Joined: Oct 30 '15
Location: South Prince George, VA
-
Pure F-ing Magic. It's an industry term and widely accepted explanation for Access's behavior...... -
I thought of suggesting to remove that, but that would have been spit-balling, I had no idea if it would work, let alone provide a reason to try it....Leave a comment:
-
No clue...PFM is the only explanation that comes to mind....Leave a comment:
-
Also, I think I experienced something similar at one time and resorted to using a parameterized query:...Leave a comment:
-
Sorry, I missed that! The first step it to verify that [TempsVars]![CommunityCode] has a value (add a debug.Print TempVars("Commu nityCode") before you set the RS. If that isnt the problem, does the query run outside of the sub? In other words, can you use the QBE to design the query and run it?...Leave a comment:
-
Can you share the SQL for TestQuery? I suspect the issue is there...Leave a comment:
-
I use PowerShell and Task Scheduler....Leave a comment:
-
Thanks NeoPa, and I totally understand how AI is basically stealing the livelihood of these Forums and others...Leave a comment:
-
New Look
I step away for a minute and someone decides to give the site a new look... -
Excellent contribution, more to come?Leave a comment:
-
anoble1,
Did you ever get this sorted?Leave a comment:
-
I assume you are using MS Access?Leave a comment:
-
Will there be cake and ice cream this time?!?Leave a comment:
-
However, you CAN hold it's head under water until it quits moving....Leave a comment:
-
The OP is referring to MS Access. He/She cross-posted this on AWF and has received some replies but has not responded yet.Leave a comment:
-
Hello there!
Easy to do, but I would suggest NEVER storing concatenated data. It is a better practice to do this for Forms, Reports, and Queries - but not in a table. What if the name changes, or if you make a mistake and have to change it?
Anyway, to answer your question:
[First Name] & " " & [Last Name]
- or -
[Last Name] & ", " & [First...Leave a comment:
-
Here is the code I use:
Code:Public Function DateToJulian(dt As Date) As String DateToJulian = Right(Year(dt), 2) & Format(DateDiff("d", DateSerial(Year(dt), 1, 0), dt), "000") End FunctionLeave a comment:
-
You're very welcome, happy to help.Leave a comment:
-
Try:
...Code:Public Function PrintOut(strTest As String) Select Case strTest Case "aaa" DoCmd.PrintOut acPages, 2, 2, , 1 Case "bbb" DoCmd.PrintOut acPages, 3, 3, , 1 Case "ccc" DoCmd.PrintOut acPages, 4, 4, , 1 Case "ddd" DoCmd.PrintOut acPages, 5, 5, , 1Leave a comment:
-
I noticed that the function you posted is public. Is it in a separate module than the form that has the command button?
If so, you will need to pass an argument to the function, in this case the value of Text28. Depending on your answer, I have some suggestion to make your code more efficient.Leave a comment:
No activity results to display
Leave a comment: