Search results

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

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

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