Mind if I add a twist to this... I have searched elsewhere and have not found a solution.
How would I use the code above to replace or should I say place [carriage returns] using the find replace...
I know I want [cr] after every ', ' {comma space} and the ASCII code for [cr]=13
Thanks
Sid...
Same result as before... the value becomes '12/31/1899' when I use the
rsCase("Compliance_FU6MFUDate") = Null
rsCase.Update
My guess is I need to capture the 12/31/1899 date and manipulate it in my records. Funny though empty going into the code and a date has to come out of it no matter...
I think I am on to something... You can not set a date field to a <blank> or NULL. I am finding that when set to Null or vbnull it always gives a value of '12/31/1899'.
Any way to get around this?
Sid from Minnesota
It is nullable in the table. I went in and manually deleted the value in a field with no problem.
By default the value is set to 12/31/1899 to identify a known bad value. I want to remove it when identified as a definate blank field.
Sid from Minnesota
I have...
Dim rsCase As New ADODB.Recordset
Dim dFollowUpDate as Date
strSql="SELECT Compliance_SiteCodeUS, Compliance_RecordNo, Compliance_FU6MFUDate FROM tblCompliance"
rsCase.Open strSql, CurrentProject.Connection, adOpenDynamic, adLockOptimistic
Do Until rsCase.EOF
dFollowUpDate =...
I have a general phylosophy to keep my queries simple in the effect that there is not more than one making the end result. In the case I am working on I have a table that I need to make a crosstab to get the patient on one row instead of numerous records.
Example:
tableFollowUp
PATID...
I am helping myself and others at the same time... I am giving my 2 cents and looking for feedback at the same time.
Kind of a different approach, but helpful (so far).
Does the security wizard change the 'database' owner? because your method leaves the owner as 'admin', right? I don't want...
Okay, this is what I am finding:
Build a private system.mdw (isolated from default Access installed) let's callit PrivateSystem.mdw.
1. Create a few accounts (User1, User2, Admin1, Admin2)
2. Create a new group: (DataEntry)
Building a new secure db using the known good PrivateSystem.mdw.
1...
I have the separate mdw established and am using the shortcut I created to gain access to the mdb. Works great, but if I open the mdb directly (not using the shortcut) it opens fine. What am I doing wrong? I am missing something.
Sid from Minnesota
Is there a tool that will take MS Access generated or manuall generated SQL code and format it neatly for printing? I am finding either I generate SQL code or have Access query do it for me. Once it has been executed as embedded data source in report it all crunches together and looks terrible...
I have a simular issue...
In the code of a form (click event of a command button), I set a breakpoint for debugging purposes. After removing the breakpoint, it still stops there as if the breakpoint still existed. I tried recompiling and compacting/repairing, closing Access completely and...
So would you not recommend a unidirectional antenna?
Would there be any reason not to use one unidirectional antenna and one of the factory?
Thanks for the parabolic reflector info.
Sid from Minnesota
I do receive good signal next to the router. Basement is of a <10yr home... not too thick of walls.
I do pick up another WiFi network, but it is so faint that if I connect to it within a few minutes signal goes from good to non existance.
I did try a few different channels. Is there a better...
I don't have access to any special tools to watch my performance out of my Linksys G router (model 1 below their new marketing faster with proprietary win plug in). I have it located in my basement of my split house with walk out basement). I can be in the room next to the router which puts me...
Yes, my Windows XP does have that calculator and it does contain the 'mod' function. Thanks for directing me to it. snicker... yes my calculator works this way.
Thanks again for shedding light on a newly found function that had no meaning prior to this thread!
Sid from Minnesota
Thank you all for the assistance in this... I am going to look into a reverse polish notation calculator (no saying it will be my primary calculator... seems like a learning curve to get used to that type).
I appreciate the responses on how and when this function is used along with the...
CajunCenturion,
I am not sure of which calculator you are referring to, but I am using two standard calculators and neither return the whole value of a division... they both return 0.5 or 3.3333.
Maybe I have forgotten a scientific calculator feature... do I need to upgrade to a scientific...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.