Search results

I'm having an issue with the form flickering when I update/enter information in a control. I've run through the form many times and there doesn't seem to be much consistency to what updated controls will make the screen flicker. I've tried a bunch of stuff and none of it seems to work, does...

I have this piece of code that works, but for the life of me I can't figure out what event/module to put it under. In my form, a user generates a number by filling out an unbound form and clicking a command button. The command button then sets the value of InsightId through a calculation. This...

I'm new to do loops in access, and I have some code that almost does what I'd like it to do, but it needs some tweaking. I'm not sure if what I'm envisioning is possible though (or if maybe a do loop isn't the right way to do it?). In the event form before update, I want it to look through...

I've been having some trouble with this piece of code with the straightforward task of preventing a user from entering a duplicate ID into the field SurveyID. However, as I've been testing the various ways a user can "break" my database design, I've noticed an issue. If the user is in an old...

Hi all, I have something I'd like to accomplish but I'm not sure if it's possible/advisable. Basically, I have a form for data entry. The database will be split, so each user will have their own front end that they're entering data with. I would like for when they open the database, they're...

Hi all, I'm having a problem that I would think would be quite common but I've had trouble finding the answer I need. I need to accomplish two things: 1) make it so the user can't save a record without entering information in one of two fields 2) allow the user to delete the record if they...

Hi all, Basically I have code that sort of does what I want, but what I want is a little more complicated. The code I found allows you to click a button to generate the next ID number, which is very similar to what I want. However, what I want is to click the button, and it looks at 2 fields...

Hi all, I've written a piece of code that checks a special ID number for duplicates, and makes the user change the ID if it's a duplicate. So far it works, except in this one instance: If a user enters a duplicate ID, deletes the ID, and then clicks elsewhere in the form, it returns this error...