Search results

I have a split database and I have one user getting this error. If he tried to put any data into any field on the form this error will pop up. Theres also no vba being ran on this form which is what my googling skills tell me is causing this error. We tried to duplicate this error on my computer...

I did exactly what you said and yet you want to insult me. Alright.

I am getting a null value.

Im confused on what youre trying to say. If I cant use an equal sign hows come it works for EVERY other number in my table except one and if I type in the one that isn't working again it works fine. Im also confused by your code

Trim around the parameters?

Ok now for some reason every other number is working except the on I originally had the problem with. I went into the table and right below the number that wasn't working I typed it in again and it worked. I really don't know why its doing this. Its skipping over just that one and yet saw the...

Sorry I misstyped what I said in my last post. I put 0.05 and 0.04 not 5 and 4. And the 0.05 and 0.04 worked. I checked my tables just to make sure it was Double and they are.

The number for RateNum I want it to look up was 0.05125 and it didn't work. I put 5 in and it worked and then I put 0.04875 and it didn't work and then I put 4 in and then it worked. It seems as though its not looking past that second decimal spot? Now im really confused. The numbers are all in...

I was busy with something else and then I went to lunch. I want to try to avoid uploading this thing if I can. I already tried to hardcode the number that doesn't work into it and it still didn't work. I'll try it again though.

Its pulling the branch name from a field on the form. And yea its a name of a field on the table.

Yea its getting null, I have it vba to begin with. I have also used this many times before... Its weird/frustrating that it doesn't work with just one number when everything else does.

RateNum is a number field and I tried that before I posted and still got the same result, and I just tried it again just to make sure. It just doesn't seem to find that number yet I open the table and its right there. Every other one works.

I have dlookup that is working correct but for some reason when I put in the criteria of a specific number it doesn't seem to find it in the table. I know its in the table and I even hardcoded the number into it. If I use any other number it works except this one. Heres my code...

Any way or how to save it wont work. I try for a while and give up and then come in the next day and try again until it works.

For some reason when I change the order around of the columns in a split form or subform 90% of the time it wont save (right click save, file save, etc..) and have to constantly redo it until it finally works. Am I missing something obvious as to why this is happening?

Thanks for the help but I figured out a better way over the weekend. Instead of one table I split it into 7. With the one variable as the table itself and the other 2 in the table and it's been working fine.

Im having trouble trying to figure out the best way to set up a table that looks at 3 things instead of 2. For example I have a table that has all my branches and the columns are all the programs. Then I use a dlookup using the branch and program to find the number I need. Now I have a third one...

Ones an .accdb and the other is .laccdb. For some reason I didn't notice two different files extensions.

I have a split database with the backend on our server. When I go to my server and look at all the open files on the network everyone who is in the backend shows up twice. One has zero locks and the other has multiple locks. Just wondering why it's doing this and/or if it's a problem.

I managed to get it to work in a roundabout way. It seemed that if I had run whether user is logged on or not it wouldn't open correctly. But run only when user is logged on it ran just fine. I would love to know why it wouldn't work the other way if you guys knew.