Search results

Hello! I've been having a problem with some Excel charts at my workplace that are shared. For some reason every once in a while when someone tries to open them, they get an error message that it is locked by someone else, but that person is actually not even in the file. That same person gets...

If I already have an Access database open (sometimes I've forgotten about it), when I try to open another one from my desktop, it maximizes the first Access window, and then my computer freezes--I have to CTRL-ALT-DEL and close both of them through Task Manager to continue. I have never seen...

That sounds like it will work. Thank you!!

Or--the form in question shows one big record with lots of fields at a time--is there a way to get a pop-up saying "Do you really want to make these changes" or something before moving to the next record? The users are concerned about someone inadvertently changing data as they're just...

Thanks--but does this mean my idea of requiring a password only for updates isn't feasible? Is the only way to apply a password, to require it for opening the database at all?

Hello, I designed and distributed a database client to a bunch of users. They have asked me to password-protect it so that anyone can open the database and view the forms, but a password is needed to actually make any updates. I am trying to do this, but everything in Tools--Security is...

OK, I see what I was doing wrong. The wizard was bringing it up in Design View, and not being familiar with this type of form, I assumed that's what the regular view would look like. Still feel dumb though ;)

Wow, it worked that time. I have no idea what I was doing wrong, but thank you for telling me I was wrong but doing so politely :)

I tried that--with the wizard, at least--but I only got one row at a time, and the number of fields prevented it from looking like the table. :confused:

I have a simple database (right now it only has one table and one form) that many users are using. Actually the table is on a shared server, and I distributed a separate client (with the form) to a bunch of users. Some of the users here are not very computer literate, especially with Access...

Thanks Gentlemen, Let me make sure I understand you correctly. Let's say I have five locations, and let's say an example number from each looks like this: 1. 12345 2. 12345 (same convention) 3. ABC123 (different convention) 4. ABC1234 (different convention) 5. 23456 (similar convention...

Hello, I maintain an Access database at my workplace, and have been asked to bring in information from other company locations. Unfortunately, there are conflicts; e.g. part number 12345 might be something totally different at another facility than it is here. My first instinct was pretty...

Current query is SELECT USER_DATALOG_MRSI505B_LOG.SUB_NAME, USER_DATALOG_MRSI505B_LOG.SUBSTRATE_ID, USER_DATALOG_MRSI505B_LOG.DIE_NAME, USER_DATALOG_MRSI505B_LOG.DIE_BATCHID, USER_DATALOG_MRSI505B_LOG.PLACEMENT_COMMENT, T_CompLookUp.Reference_Designator FROM USER_DATALOG_MRSI505B_LOG LEFT JOIN...

I suspect that will get me back to the original problem--that the query will want values in those text boxes even though there are none yet--but I will try this now. (that problem happened even when I set the text boxes to null or * default values)

Sigh, I was wrong. What I did stopped the error messages. It also completely stopped my form from working. Does anyone know of an example online in which entry fields and a subform are blank until info is entered and a "Submit" button is clicked? If I just have an example, I can figure it...

I figured out the answer to my own question as I was typing it! Problem with the query--unneeded "F_Form!Value"s

Thanks everyone! Really appreciate the help.

Wayne, I am not sure I understand the code (remember I am a VBA novice). I understand how it adds records for the Partition, Serial, Part and Placement. However I am not sure I understand where/how the one-to-one relationship between Partition and Serial is stored. I don't care about...

I will try something like that and let you know! Thanks!

Hi KernelK, Since I posted this, I have found someone who is knowledgeable about xMII software, and says he can help me out and that this would be an ideal way to handle this. Are you familiar with the software, and if so, do you agree? (As you may have seen in another thread, I am also...