Search results

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.

I think I fixed that problem using OR, instead of AND. Now a syntax of my code problem arises: If I do not check the Exton box, my SQL string would look like: "SELECT * FROM DSO WHERE OR Plano..." A blank where the Exton string is, creating issues. Ideas on how I could overcome that?

Using AND comes back to the problem I was thinking earlier: AND results in narrowing down my filter to return everything that has Plano as " " and Exton as " " Using this code I got that result: 'Checks if exton checkbox is true/fale If extonCheck.Value = 0 Then strExton = " " Else...

Ok, this code works for what I need for one variable, looking at the Exton column: Public Sub searchCmd_Click() Dim db As DAO.Database Dim qDef As DAO.QueryDef Dim sParameter, sSql, strPlano, strExton As String Set db = CurrentDb Set qDef = db.QueryDefs("test") sSql = "SELECT * FROM DSO...

Just to clearify (may have misunderstood the workings of this SQL): Working with one variable would imply that these checkboxes are choices, resulting in all the values with Exton being returned or all the values of Plano being returned..etc etc. But I may need all the data with Plano & Exton...

Ok, I am attempting to work with the code you just posted. Some clearifying questions on how it is to work: (this is how I understand what is happening) - A query is already created, say I call it 'test' - This code is to modify the query and add "SELECT -- " based on my checkboxes So...