Recent content by anshaik

Easy enough, thank you!

I changed my idea a little bit, and am now attempting to use the allowedits function. Now whenever a user clicks on "Read-Only" it opens a slightly modified main page (a few buttons removed that they would not need). Now, in my main page, where would I insert this allow edits for it to lock the...

Hi everyone, Question for a log in procedure (user end form) in Access 2003. I have a log in form, in which a user is to type in user name/password in order to get to a main page form where they can branch of to do other tasks (editing, viewing, etc of tables through forms). I want to have...

Ok, I will try to implement this tomorrow morning. Thank you for the feedback, I'll get back to you with more questions once I think through this and try to solve my problem with this method.

Not exactly--I didn't elaborate well enough, it's not exactly a "location," it's more of a..pointer, I guess? I'm not sure what it'll be called, but a routing command for that specific location on that number that is being called on. Therefore, each "location" has a series of records associated...

The database is a list of telephone numbers and corresponding information for those numbers, the columns I am right now referencing are locations that the set of numbers are associated with. As of now, there are only six locations each number can be associated with. The reasoning for doing...

I am using unbound text boxes, my goal is to leave one string in that text box, which would ultimately be a header for my table. By what I understood from what you said is that this is not possible, unless I store the information in a new table? So, the there is no function for the text box...

I feel like this should be really simple, but for some reason have not been able to figure out how to do this or where to look: (Using Access 2003, attempting to code a form) I have one table from where I will be pulling my information, and a set of columns I am interested in. I have a form in...

Sorry about that, your comment made me realize my mistake. Edited my earlier post, figured out the issue.

That part is working fine-- I am performing the requery. The form itself does remove the newly archived record, it is no longer displayed in the form. My problem is the query itself--the one that the form is based on. It is not updating itself with that specific record to be checked off as...

Now I have it working like the way you described, I think. I have my form running off a query that hides all the 'archived' data. My form is working perfectly and hides all the archived files and I am able to update the data to hide all the newly checked archives. The new issue I'm having is...

Ok, I have the archive column set up, along with a "delete" box on the form. I'm having some issues with the query--how do I hide the "archived" data from the user? I want all the "archived" data to not be viewed by the user as soon as the form is open, and I also have an "update" button...

That sounds like a better idea for me, how do I add this archived status field? I assume I add a column within my previous "Table1" and add a "Archived" column? Or how does it work? Also, when I have this archived button depressed, or whenever the user deletes a certain record, in the form...

Hi everyone, (Working in Access 2003) Just began thinking about this, hopefully someone can expedite this process for me. I have a set list of data, stored in a table, say called "Table1." Users are able to scan through this data by a form that I have created. I have another table, called...

Yeah, that works. Thanks a lot twoplustwo. I will continue to implement this in the other 4 checkboxes and then see if I have any more questions.