I searched everywhere for code that would work and found almost nothing to help so I am posting this here for posterity.
Background. We are migrating from Goldmine to Microsoft CRM Online. When moving email is very big. CRM Online will only take a file 8meg max. So I had to import the email...
I searched and searched for something that would remove non-standard characters from my data and here is what I came up with. I wanted to post it so someone else looking for similar functionality could find it.
Background. We are migrating from Goldmine to Microsoft CRM Online. When...
I get this error message when running this code and it fails on the DLookup line.
Here is the full code:
fosusername() pulls the windows userid I am logged in with. I simply want the user to click a button and it will log the empid from the employees table into the emp# field in the...
Boy howdy! That is what I get for letting people interupt me when I am programming. I copied it from another function and forgot to remove the rev.
Thanks a bunch.
I am using this function
to parse this string
into this
It works great until I get to a string that looks like this
Which I need to return the word SPECIAL but it gives me #Error in the Query.
It would seem that when there are multiple : it is giving the error but when there is only...
Sorry for the newbie post.
I am just starting to do this again after many years.
Anyway here is how I did it.
I really just copied the refreash button it makes for me automatically.
I have several controls on my form that use Dlookup to get information from another table some are based on the value of a field on the form and others are just looking up the current profit margin from a table I have defined those type of variables in. I then use those amounts to calculate...
My database pulls data from Quickbooks using a make query to create a local table. I then pull item cost data from that table as you can see on the picture I have uploaded. I don't want to store this data because it will change from time to time. Therefore, there are several calculated fields...